Top Resources: Bike Shop SEO Guide | Bike Shop Cart Abandonment Recovery Guide | Google Data Studio Rank Tracker
Since jumping on board with Google Data Studio, we've always wanted to incorporate a ranktracker into our SEO team's monitoring toolkit.
We don't report on rankings to our bike shop marketing clients - because we think that revenue is the KPI that really matters, but use it internally to help us spot trends and movements in search results.
Take me to the Setup Instructions
Notice that we've highlighted with the big red rectangles the ways you can change the way you can view your data.
Click the dropdown and you can select individual queries or a number of queries to see how they've performed over the period of time that is selected in the date dropdown.
Click the dropdown and you can select individual Landing Pages to see how they've performed. This can be really helpful because it allows you to see all of the search queries that the page is getting traffic for.
Change the time frame and you'll see your metrics change in the line graph and table of search result down below. Keep in Mind that Google does not let you see that past 2 days of data!
Note that the data control is not visible in the above embed due to Google restricting data controls in embeds, you'll have to make a copy of the report in order to see it!
After talking with Lee Hurst, we've upgraded the template so that you can now use it with your own site's Google ranking data right in the report template! Just click the dropdown to pick the website view that you want see how you're ranking.
The query is the search term that Google has tracked that your website has impressions for in search. These will often feature branded search terms, or queries that have the name of your business featured prominently. If these branded search terms are "muddying" your view of the data, you can create a filter that will enable you to remove the branded queries. The folks at Uproer, have built a great data studio tutorial to help filter out mentions of your brand.
This column lists all the pages that Google lists as appearing in search. Is this really all the queries? No the data is filtered and we can only return 5000 results at a time through Google's API, but this is still a ton of data. Remember to use the landing page filter! It can help you optimize a page to appear higher in search. Select a page and then make sure that the queries are all somewhere on the page.
This column shows you the average position that a particular landing page ranks for a search query over the period of time that is selected in the Date range Filter. If you want a more precise position, hover your mouse over the search query's line in the line graph above the results table.
This column shows you how many times a page has been clicked on in Search. Clicks give you a sense of opportunity to grow traffic. We like to look at clicks but use Impressions as a better gauge of what type of traffic potential is possible for a given piece of content.
Impressions are defined as the number of times that a piece of content has appeared in search results as individual users search on their desktop computers, tablets and mobile devices.
We LOVE Impressions, because they represent opportunity. That's why we sort the results table by impressions. If you're looking at which pieces of content to optimize for, impressions are a great place to start.
CTR, or Click Through Rate is the ratio of clicks to impressions. The goal is to improve your click through rates so that a larger percentage of users look at your content versus that of your website's competition. Make the content of your website more compelling and watch your rankings improve! Improve your copy in your page titles and meta descriptions to make your page more clickable and watch traffic increase.
It sure is! The free rank tracker that is built with Google Search Console data has long been the Holy Grail for data geek cheapskates all over the globe. We salute you!
Click the default data filter in the top right of your report. You will now see all of your available properties to choose from. Switch to a different site and check out your rankings.
The reason it looks broken is that the Google Store data breaks when you copy a report. The problems are that data aggregation in the sample data is automaticly set to "sum" for average position and for the average CTR (click through rate). Another issue that is created during the report copy process is a "ghost" invalid dimension that gets added to the left most data source in our data blend. When we switch to our own data we fix all of the issues.
What if you want to track a few keywords or search terms? Then you would blend with the a Google sheet of Search Terms.
We'll cover that in an upcoming blog post. Subsribe to our newsletter (in footer of the site) and we'll let you know when the post has been released.
Bike Shop SEO © 2025