Step 8

Copy the Data Studio Template

Make a copy of this Google Data Studio template:

⁠

https://datastudio.google.com/reporting/9bc2a264-a4df-445f-880e-4d7776fb4686⁠

⁠

You'll see the sources as "Unknown." The following is the order in which you should add sources:

1. data source_Featured Snippets

2. data source_All Organic Positions

3. data source_GA Comparisons

4. data source_Keyword Gap

5. data source_Competitor Pages

6. data source_Screaming Frog

⁠

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.