Thread by @lazarinastoy

How to filter a column of broad match keywords, using a REGEX match filter formula to return question-type long-tail keywords. 🧵
#seo

Question-type keywords are long-tail keywords that contain the seed keyword in any order, plus a “question word” like “how,” “what,” “where,” “when,” or “why.”

Export a list of keyword recommendations from @semrush Magic Keyword Tool.

In order to fill the Questions column, we use a regex match formula in the filter criteria, referencing the list of keywords exported via the Keyword Magic Tool from SEMrush.

=filter(‘Machine learning’!A:A,regexmatch(‘Machine learning’!A:A, “who|what|where|why|how|which”))

This formula filters the targetted column from the referenced sheet and applies a regex match filter, using a pattern that leaves in question-type keywords.

Read the full tutorial here:
medium.com/bite-sized-mar…