Advanced Keyword Tracking Tool
5(100%)1vote



CHECK OUT OUR AGENCY AUTOMATION BUNDLE

SHOW ME!

  • Auto pull KW rankings (SEM Rush) and crosswalk with organic traffic data (Google Analytics).
  • Sync GSC for SERP impressions, clicks and KW tracking.
  • Generate powerful organic traffic reports from Google Analytics with a single click.
  • Beautiful reporting layout, fully customizable to your brand using Google Data Studio.

GET THE TOOL, FREE.

We don’t charge for these tools, but we don’t like them on the open web. If you give us your email, we’ll send it to you, free of charge.









The Google Sheets file crosswalks data.

  • Pulls organic traffic data from Google Analytics based on the time period you give it. Compares that data to month over month and year over year changes for “target” sections of your website.
  • Scrapes keyword data from SEM Rush and builds ranking progress reports, looking at improvements, losses and overall campaign progress.
  • Crosswalks organic traffic data from GA with keyword data from SEM Rush. Tells you true the impact of your “rankings” on organic traffic at a page level.

Breaking down the details of the report.

Enter your information, connect your data sources.

  • The report requires inputs from SEM Rush and Google Analytics. Instead of manually pulling that data, a Sheets plugin called Supermetrics connects via API to grab it all for you.
seo report keywords

Follow step by step prompts to populate the report.

  • Along with a step by step instructional video, we also built out a text version of the file. This easy to use formula allows us to push our reporting to our offshore team to increase local productivity.
automate keyword reporting

Using powerful scripts and formula, it crunches the data.

  • Sheets shows it’s true power not with pulling data, but aggregating and formatting. A few clicks runs powerful data crosswalks between Google Analytics and SEM Rush.
track keyword progress

Track keyword progress over periods of time.

  • The template scrapes ranking data from SEM Rush’s index and calculates progress using a number of KPIs, including keyword movements and progress of top landing pages on your site.
custom keyword seo tool google sheets file for keyword tracking

Crosswalk KW rankings and organic traffic numbers.

  • The template allows you to enter a set of “target” pages, aka the pages on your site that mean the most to your top line. Using advanced lookups, the template calculates organic traffic changes (Google Analytics data) and keyword movements (SEM Rush) in an easy to understand set of reports.
how to track keyword rankings
  • Auto pull KW rankings (SEM Rush) and crosswalk with organic traffic data (Google Analytics).
  • Sync GSC for SERP impressions, clicks and KW tracking.
  • Generate powerful organic traffic reports from Google Analytics with a single click.
  • Beautiful reporting layout, fully customizable to your brand using Google Data Studio.

GET THE TOOL, FREE.

We don’t charge for these tools, but we don’t like them on the open web. If you give us your email, we’ll send it to you, free of charge.









5 Comments

  1. We’ve been using this tool for the last few weeks. It’s a little tricky at first, but it’s incredibly powerful and gives us access to insights we never would have had with other keyword rank tracking tools. Kudos to Ryan and the WEBRIS team for always pushing amazing stuff!

    5

  2. I think the problem is that you have to have a Guru or Business level SEMRush account to retrieve historical data. Unfortunately, I only pay for access to API. So, I’m screwed.

    0

Leave a review

Your email address will not be published. Required fields are marked *