Track Keywords for FREE! Custom Built in Google Sheets

Track Keywords for FREE! Custom Built in Google Sheets

Table of Contents:

1. Introduction
2. Getting Started 2.1. Setting up SCM Rush 2.2. Setting up Google Analytics 2.3. Installing Supermetrics
3. Using the Data Studio Template 3.1. Importing Data from SCM Rush and Google Analytics 3.2. Aggregating Data 3.3. Entering Target Pages 3.4. Generating Reports
4. Analyzing the Visibility Report
5. Analyzing the Top Landing Pages Report
6. Conclusion

Introduction

In this article, we will explore a powerful reporting solution that combines data from SCM Rush and Google Analytics. This solution allows You to crosswalk organic traffic data with keyword ranking data, providing insights that are not available in any other report. We will guide you through the process of setting up SCM Rush, Google Analytics, and Supermetrics, and then Show you how to use the data studio template to generate comprehensive reports. By the end of this article, you will have a clear understanding of how to effectively analyze organic traffic and keyword rankings to improve your SEO strategies.

Getting Started

Before we dive into the details of using the data studio template, there are a few initial setup steps that need to be completed. These steps include setting up SCM Rush, Google Analytics, and installing Supermetrics. Let's discuss each of these steps in detail.

2.1 Setting up SCM Rush

To begin, you will need to have access to SCM Rush. If you don't have an SCM Rush account, we strongly recommend getting one through the provided link. SCM Rush is an incredible tool that will greatly enhance your SEO analysis capabilities. Once you have SCM Rush set up, you can proceed to the next step.

2.2 Setting up Google Analytics

Having Google Analytics set up is crucial for this reporting solution. If you don't have Google Analytics already set up, make sure to Create an account. We will be pulling data from Google Analytics to incorporate into our reports.

2.3 Installing Supermetrics

Supermetrics is a free add-on for Google Sheets that allows us to automatically pull data from SCM Rush and Google Analytics APIs. It simplifies the data collection process and saves a considerable amount of time. Install Supermetrics by navigating to the "Add-ons" menu in Google Sheets, selecting "Supermetrics," and clicking on "Launch the sidebar." This will enable us to easily fetch data from both SCM Rush and Google Analytics APIs.

Using the Data Studio Template

Now that you have SCM Rush, Google Analytics, and Supermetrics set up, let's start utilizing the data studio template to generate comprehensive reports. The data studio template will aggregate data from SCM Rush and Google Analytics, providing valuable insights into organic traffic and keyword rankings. Follow the steps below to make the most of this reporting solution.

3.1 Importing Data from SCM Rush and Google Analytics

To import data into the data studio template, you need to ensure that you have the necessary API access. If you have the API access, simply click on "Import SCM Rush" in the data studio template, and wait until all the data is pulled through. If you don't have the API access, follow the manual data import process, which involves exporting data from SCM Rush and copying it into the template.

3.2 Aggregating Data

After importing data from SCM Rush and Google Analytics, proceed to aggregate the data. Click on the "Aggregate Data" button in the data studio template, and let the script run its course. This step will compile all the necessary data to generate the various reports.

3.3 Entering Target Pages

Now, it's time to define your target pages. These are the pages that you want to focus on for SEO purposes, as they are crucial for driving traffic and improving keyword rankings. Enter the page paths of your target pages in the designated section of the template. You can enter as many target pages as you want.

3.4 Generating Reports

Once you have entered your target pages, select the month you want the reports to be generated for. The data studio template will automatically calculate all the key metrics and generate reports. The reports include the visibility report, top landing pages report, and the month-over-month and year-over-year changes for target pages. Analyze these reports to gain insights into the performance of your target pages and your overall SEO strategy.

Analyzing the Visibility Report

The visibility report provides a comprehensive overview of keyword rankings for your target pages. It includes data on the top three and top ten keyword rankings, as well as the total keyword rankings for the selected month, last month, and the start of the campaign. Use this report to evaluate the visibility of your target pages and identify areas of improvement.

Analyzing the Top Landing Pages Report

The top landing pages report focuses on the performance of your target pages in terms of organic traffic and keyword rankings. It crosswalks the data from SCM Rush with the data from Google Analytics, providing valuable insights into the impact of SEO efforts on specific landing pages. Use this report to track the progress of your target pages and optimize your SEO strategy accordingly.

Conclusion

In conclusion, the combination of SCM Rush, Google Analytics, and Supermetrics, along with the data studio template, offers a powerful reporting solution for analyzing organic traffic and keyword rankings. By effectively utilizing this solution, you can gain valuable insights into the performance of your target pages and make data-driven decisions to improve your SEO strategies. Incorporate this reporting solution into your SEO analysis process and take your optimization efforts to the next level.

Highlights:

• Powerful reporting solution combining SCM Rush and Google Analytics data
• Crosswalk organic traffic data with keyword ranking data
• Automate data collection using Supermetrics
• Generate comprehensive reports using the data studio template
• Analyze visibility and top landing pages for improved SEO strategies

FAQ:

Q: How do I set up SCM Rush? A: To set up SCM Rush, you need to create an account and ensure you have access to the SCM Rush API.

Q: Do I need to install Supermetrics? A: Yes, Supermetrics is a crucial tool for automating data collection from SCM Rush and Google Analytics.

Q: Can I import data into the data studio template manually? A: Yes, if you don't have API access, you can manually export data from SCM Rush and copy it into the template.

Q: What reports can I generate using the data studio template? A: The template allows you to generate visibility reports and top landing pages reports.

Q: How can I optimize my SEO strategy using these reports? A: The reports provide insights into keyword rankings, organic traffic, and the performance of target pages, allowing you to make data-driven decisions and improve your SEO strategy.