Step 6

Add GA Data to Google Sheet

In your Google Sheet, you will be using the Google Analytics add-on to import traffic data. You’ll need to (1) install the add-on, (2) enter your View ID into the Google Sheet, and (3) run reports.

→ Install the Google Analytics Add On

In your Google Sheet, go to Add-Ons >> Get Add-Ons. Search for “Google Analytics” and install the Google Analytics add-on.

⁠

Loading…⁠

⁠

→ Enter Your View ID

To find your View ID, go to the Admin area in Google Analytics. Click on “View Settings” and take note of the View ID. Enter this ID in the “Getting Started” tab of the Google Sheet.

⁠

Loading…⁠

⁠

→ Run GA reports

In your Google Sheet, go to Add-Ons >> Google Analytics >> Run Reports

⁠

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.