Competitor Keyword Research (SEMrush)

By David Krevitt from CIFL

This template allows you to build a map of potential target keywords, based on keywords your site is already ranking for.

Subscribe to RankTank Pro!
Step 1:
Step 2:
Get the Pro Sheet SEO tool!
Subscribe and get access to this Google Sheet as well as many other Pro Sheet SEO tools!

Current Version: 1

Not sure where to start your keyword research?

How it works?

It does this in a few steps, ending in the ‘Keyword Opportunities by Page’ tab:

1) Find keywords your site is currently ranking for

2) See who’s competing with you for traffic on your top 5 keywords

3) Finds keywords your competitors are dominating

And presents a long list of keywords to target with new content.

It uses Google Apps Script to pull Google Analytics and SEMrush data into the sheet, so there’s no need to use any other tools.

10 Million Marketers Can't Be Wrong!

When you join the RankTank mailing list, you'll be better than 9.9 million of them. You'll also get first access to cool new tools, tutorials and other neat stuff.

SPAM? Naw. Ain't nobody got time for that.