Chapter 3. Google Search Console, Google Tag Manager, Google Data Studio

Google Search Console

This is my favorite tip of all three of my tips. Google Search Console, if you don’t have it, I would highly recommend going to get it. It will give you insight of how Google sees your website, if there’s any errors for example.

The fun part is you can see what keywords that you’re ranking for and which pages are ranking for that keyword. The bad thing about it is you have to do all those manually if looking at it through Google Search Console. If you wanted to go into the report, you’d have to look at a specific page or a specific query, and then if you export the data, it still shows in separate tabs.

With Search Analytics for Sheets add-on, you can see all of it in one place. It will put out a table like you see in the image below of all your pages and all the queries. Not just one query and not just one page, and then all the clicks and impressions.

When you run the add-on, choose to group by page, query.

Data range
Excel sheets

Sort the data above descending by either impressions or clicks. Whichever is relevant to what you want to know. Then use the formula below to find the keyword with the most impressions or clicks for each page.

=ArrayFormula(QUERY({SORT(A2:D,1,false,4,false),IFERROR(row(A2:A)-match(query(SORT(A2:D,1,false,4,false),”Select Col1″),query(SORT(A2:D,1,false,4,false),”Select Col1″),0))},”Select Col1,Col2,Col3,Col4 where Col5<2″))


Put it over in cell H2 or somewhere over there.


This is useful if you’re working on your keyword strategy or looking for some new content ideas, you can see what Google is already recognizing your website for.

Google Tag Manager

I think some people get a little bit scared of this, but it’s a really helpful tool for adding things to your Google Analytics without having to know code. All of the following are found in Events.

One example is, tracking scroll depth of a page. Let’s say you’re seeing a high bounce rate on a specific page. Seeing how far people are scrolling down on your page is a good place to start. If you notice that they’re only going down to 50%, then you can alter your call to action, either add some more at the top or make the content more engaging or something like that.


Go to:

Google Analytics > Behavior > Events > Pages

Choose a page and then choose Event Action as the primary dimension.

Track file downloads with this Google Tag Manager recipe.

Track outbound link clicks with this Google Tag Manager recipe.

Track YouTube views with this Google Tag Manager recipe.

Events in GA

Google Data Studio

I’m recapping what Steph and Christopher talked about in terms of making sure that you’re tracking your macro goals and your micro goals. It’s something that you have to do on a regular basis, rather than just every month or when you see a problem. This is an easy way to pull in all the data from everywhere.

For example, you could have one page with all of your high-level metrics, and then on the sub-pages, you could have some of those metrics that affect those bigger ones. You can pull in Analytics, Search Console, Google Sheets. However, if you have data in a Google Sheets area, you can track, over time, your keywords in a much more friendly interface for your clients or even for yourself. 

Download a sample report here. 


Barb Davids on Tea Time SEO

Barb Davids

SEO Consultant

Barb Davids is a digital marketer, SEO strategist and owner of Compass Digital Strategies. Driven by data and analytics, she works hard to get business-changing results for her clients, such as 256% more website traffic and 22% more leads. As lockdown began and clients lost budget, she continued working on some pro bono for a couple of months. Offering free help to select industries. Her own business as a result has pivoted and begun to offer online courses so that business owners can work to gain more site traffic and leads at a more budget friendly cost.

Watch our Tea Time SEO session here:

Table of Contents

Can we help?

If you are looking for an easy way to automate much of the advice given in this guide, then please book a call with one of our platform experts to explore whether we have what you need.

Continue reading about SEO Reporting