This keyword would then not appear. Or only two out of three competitors rank for a keyword – a missed opportunity because this search term doesn’t appear either. 18,000 subscribers can’t be wrong You don’t want to however there are miss any of our posts and stay up to date? Subscribe to our newsletter now and receive every new Seocracy article by email directly to your inbox! Subscribe now All competitors must rank in the top 20 No result found! Really? Or maybe only one of the competitors ranks at 21 instead of in the top 20….? To solve this problem, a detour, some manual work and Excel magic will help you: You export your rankings and those of your competitors one after the other under the “Keywords” tab.
You summarize them in an Excel folder
With a few if formulas (see picture) you can put together an evaluation. You create a pivot table and get a clear assessment Netherlands Phone Number Data of how you compare to your competitors. Column However there are Your page is ranking”; “Your page is NOT You can refine this evaluation as desired, for example by: Insert topic clusters Do not just insert an “if” ranking, but a “where ranking” (e.g. “ranking between 1 to 3”, “ranking better than competition”, etc.) The only limits here are your imagination (or your Excel skills). keyword gap analysis excel The results can be clearly summarized in a pivot.
Keyword gap analysis with Semrush If the
Previous step was a bit too nerdy for you, I recommend the keyword gap analysis from Semrush. Here you can analyze the Italy Phone Number rankings of up to 5 competitors – also at domain, sub-domain, directory or URL level. It is also possible to include paid and PLA keywords. What excites me most, however, are the diverse filter options, including possible combinations in Semrush’s keyword gap analysis: semrush keyword gap The filter options at Semrush are very well developed, so I can, for example, exclude all keywords that contain the word “cat”. It’s a shame that the “competitor position” filter also applies to all domains with Semrush. So I can’t filter: “At least one competitor in the top 10”, but only “all competitors in the top.
