Competitor Keyword Research (SEMrush)
This template allows you to build a map of potential target keywords, based on keywords your site is already ranking for.
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.