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.
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.
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.