How To Bulk Export GSC Efficiency Information For A Particular Checklist Of URLs Utilizing The Google Search Console API, Analytics Edge, and Excel – ewebgod

Analytics Edge Url List.jpg

Bulk Export Data via the GSC API for a specific list of urls

As I’ve been analyzing the influence from the August broad core replace (I’ll have extra to share on that quickly…), I’ve been digging into drops and surges throughout websites. For larger-scale websites, I usually come throughout pockets of content material that I wish to take a more in-depth take a look at from a high quality standpoint. And as a part of that evaluation, I usually wish to cross-reference GSC knowledge to raised perceive if Google is surfacing that content material within the SERPs, what number of clicks that content material is receiving, how that appears throughout cell and desktop, and extra.

For instance, possibly there’s a massive group of articles you wish to discover in better element, quite a few product pages you wish to analyze, or a bunch of critiques from throughout a website. And possibly there are lots of, and even hundreds, of these urls that you simply wish to pull GSC knowledge for. For conditions like that, you don’t wish to merely export ALL knowledge for a GSC property and dig by means of it. You simply need GSC knowledge for the group of urls you might be analyzing.

I’ve already written several articles about bulk exporting GSC knowledge utilizing Analytics Edge, together with the way to automate delta reports, however I by no means coated the way to export knowledge for a particular set of urls. It was only for exporting that knowledge by property. That’s why I got here up with an answer for exporting knowledge only for the urls I wish to examine. And past that, the system I created can export knowledge throughout Google surfaces like photographs, video, information, Uncover, and many others. This course of may be very useful after main algorithm updates roll out like broad core updates, useful content material updates, and critiques updates.

What we’re going to obtain through the GSC API and Analytics Edge:
First, we’ll create a listing of urls that we wish to export GSC knowledge for. That record can comprise as many urls as you need (dozens, lots of, and even hundreds). Then we’ll use Analytics Edge to bulk export efficiency knowledge through the GSC API after which use the worksheet of urls as a lookup desk. In different phrases, we’ll match the exported knowledge with the worksheet we create containing urls we wish to examine, after which export the information that matches these pages.

And later on this put up, I’ll rapidly clarify how one can broaden this technique to string a number of macros collectively to examine a number of Google surfaces in a single shot (information, Uncover, search, photographs, and many others.)

Step-by-step: The right way to bulk export GSC knowledge for a particular set of URLs:

1. Collect your record of urls:
First, create a worksheet of urls you wish to export GSC knowledge for. This may be based mostly on an audit you might be conducting, a latest crawl you accomplished, an xml sitemap you might have, and many others. Mainly, you want to view clicks, impressions, click on by means of price, and place for a set of urls. Identify the worksheet “Pages” and you may identify the column “web page”.

Pages worksheet in Excel

2. Export touchdown pages through the GSC API for a property:
The following step is to export all touchdown web page knowledge for the GSC property you wish to analyze. Observe, you’ll not be filtering knowledge at this stage, so simply export the entire knowledge through the API. We’ll filter the information within the subsequent step based mostly on the worksheet you created. You possibly can view my other tutorial for exporting touchdown web page knowledge through Analytics Edge or you possibly can view the abbreviated steps under. It’s very straightforward to do.

3. Export touchdown web page knowledge through the GSC API and Analytics Edge:
When exporting the information, choose “web page” because the dimension and ensure the chosen metrics embody clicks, impressions, ctr, and place.

Export landing pages via the GSC API

4. Export Net Search knowledge:
Within the filters tab, choose “internet” beneath Sort (for Net Search knowledge). I’ll clarify extra about exporting different varieties of knowledge later within the tutorial.

Exporting Web Search data via the GSC API

5. Choose a timeframe:
For the dates tab, choose the timeframe you wish to examine. You possibly can select a preselected timeframe or set a customized timeframe. For this tutorial, choose “Final 3 Months”.

Set a timeframe for the export

6. Kind by clicks or impressions:
Within the Kind/Depend tab, use the dropdown to pick “Clicks” and the clicking the button for “Descending”. It will kind the exported knowledge by pages with probably the most clicks first. It’s also possible to kind by impressions if you’re simply trying to see if the pages ranked within the SERPs. Both means, you possibly can simply kind the export through Analytics Edge.

Sort the exported data

7. Export the information:
Click on “OK” within the backside of the Analytics Edge modal window to export the information through the GSC API.

8. It’s lookup desk time! Filter based mostly on the Pages worksheet:
Earlier than we write this knowledge to a worksheet, we wish to filter the export to solely present knowledge for the urls we listed in our Pages worksheet. Keep in mind, we don’t need all the information, we simply wish to analyze the information for the pages we included in that worksheet.

9. Use the Match perform to examine the Pages worksheet:
By utilizing the Match perform, we will use the Pages worksheet as a lookup desk and solely write the information for these urls to a brand new worksheet. Click on the dropdown within the Analytics Edge menu labeled “A number of” and click on “Match”. Then use the “Match with” dropdown to pick “Worksheet Pages” after which preserve the chosen column as “A web page”. And ensure the radio button for “Dealing with Matches” is ready to “Hold matching rows”. Click on “OK” to execute the match.

Using the Match function in Analytics Edge
Match settings in Analytics Edge

10. Write to worksheet:
The ultimate step is to write down the filtered knowledge to a worksheet. Click on the dropdown labeled “File” within the Analytics Edge menu and click on “Write to Worksheet”. Within the “Worksheet subject”, enter a reputation for the worksheet that can comprise the filtered knowledge. You possibly can identify it “Search Information” for this tutorial. Then click on “OK”.

The final exported data via the GSC API based on a lookup table of URLs

Congratulations, you might have efficiently exported GSC knowledge for a particular record of urls! If you’re ever searching for a fast approach to view GSC knowledge for a set group of urls (irrespective of the scale), you now have a template for engaging in that process. Once more, Analytics Edge is sort of a Swiss Military Knife for working with APIs.

Bonus: It’s Analytics Edge, Be Inventive, Go Nuts:
In earlier tutorials, I defined the way to string a number of macros collectively to automate much more actions. Nicely, for this tutorial you would simply create new macros for exporting extra knowledge from throughout Google surfaces like Uncover, photographs, the information tab in Search, Google Information, and many others. When you arrange a number of macros, you should have a system prepared for exporting knowledge by Google floor for a particular set of urls (and by clicking a single button in Excel).

Exporting data across Google surfaces

Abstract – Exporting knowledge for a set of urls through Analytics Edge.
There are occasions you wish to rapidly perceive how sure urls are performing throughout a website (like after main algorithm updates) with out having to sift by means of the entire knowledge from that website. By utilizing the strategy I mapped out on this tutorial, you possibly can leverage Analytics Edge and the GSC API to just do that (and throughout Google surfaces). It shouldn’t take lengthy to arrange, and also you’ll at all times have that template for future initiatives. I believe you’ll dig it. 🙂


#Bulk #Export #GSC #Efficiency #Information #Particular #Checklist #URLs #Google #Search #Console #API #Analytics #Edge #Excel

Leave a Reply

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