Step 5

Export Competitor Keywords from SEMrush

In SEMRush, go to Organic Research. Enter your a domain, then go to the Positions tab. Depending on the export limit in your SEMrush account, you may need to set additional filters, such as search volume > 100 or only top 20 rankings. Export CSV and repeat for other competitors.

⁠

Loading…⁠

⁠

Jump to a step:

⁠

Step 1 - Build the Data Source Google Sheet⁠

⁠

Step 2 - Crawl Your Site with Screaming Frog and Export Your Crawl⁠

⁠

Step 3 - Export all keywords from SEMrush⁠

⁠

Step 4 - Export Featured Snippets from SEMrush⁠

⁠

Step 5 - Export Competitor Keywords from SEMrush⁠

⁠

Step 6 - Add GA Data to Google Sheet⁠

⁠

Step 7 - Add Other Data to Google Sheet⁠

⁠

Step 8 - Copy the Data Studio Template⁠

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.