Step 3

Export all keywords from SEMrush

In SEMRush, go to Organic Research. Enter your 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 all rankings.

⁠

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.