Step 7

Add Other Data to Google Sheet

In your Google Sheet, there are 4 other tabs where you'll need to import your data:

import_screaming frog_internal crawl

import_semrush_all organic positions

import_semrush_featured snippets

import_semrush_competitor keywords

To import data, go to the appropriate tab and select cell A1. Go to File >> Import. Find the appropriate file on your computer, then select "Replace data at selected cell"

→ Importing Screaming Frog Data

Import into the import_screaming frog_internal crawl tab

⁠

→ Importing SEMrush All Organic Positions

Import into the import_semrush_all organic positions tab

⁠

→ Importing SEMrush Featured Snippets

Import into the import_semrush_featured snippets tab

⁠

→ Importing Competitor Keywords

Import into the import_semrush_competitor keywords tab. You can add data from multiple competitors into this tab.

⁠

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.