How to read your keyword spreadsheet

So you got your keywords, and they came in a spreadsheet that looks something like this:

jeep wrangler niche keywords
Not every column is self-explanatory, but don’t worry. We’ll explain each one below!

Here’s what each column means:

Keyword – the list of keywords we found for you to target. AKA, article topic ideas.

Est. Search Volume – estimated monthly search volume for the keyword according to Ahrefs (or in some cases other tools).

UGC Results on First Page – how many user generated content sites (like Quora, Reddit, StackExchange, forums, etc) rank on the first page for the keyword. These are oftentimes easy to beat with a solid article on the topic, even with a new website. We no longer report this metric, as UGC results do not necessarily indicate an easy keyword ever since Google’s September Helpful Content Update.

Lowest DA (or DR) on First Page – the Moz Domain Authority (DA) or the Ahrefs Domain Rating (DR) of the site with the lowest DA (or DR) ranking on the first page.

Search Intent – if you were to search that keyword as a normal user, would the results be satisfactory? If so, search intent is matched. If none of the results answer the question/cover the topic satisfactorily, the search intent is unmatched. If only a few are satisfactory but the others don’t match the intent, it’s partially matched. It is typically very easy to rank an article for partially matched and unmatched intent keywords.

SERP Feature at Top – this is anything shown at the top of the results such as a featured snippet, a video, an image carousel, a calculator, etc.

Comments – if we notice something about the keyword that’s worth mentioning, we’ll add a comment.