I not too long ago observed that 10 pages on our website accounted for over 61.2% of our whole clicks reported in Google Search Console (GSC) over the past three months!

This can be a website with round 300 classes and 20,000 product SKUs.

10 pages!

Equally surprising, nearly 74.8% of all pages reported in GSC weren’t clicked in any respect.

As we speak I will share a Python script that pulls this info from Google Search Console and exports batch-ready charts and a Microsoft Excel spreadsheet prepared for motion.

Screenshot from Google Collaboratory, August 2022

The Excel spreadsheet could be very actionable as high and low visitors areas are separated into their very own motion tabs.

Screenshot from Microsoft Excel, August 2022

The issuance is absolutely automated and works for any account for which you may have GSC entry.

What we’ll be taught in the present day

• The right way to run the script.
• Key elements and ideas of the script.
• Optimization concepts.

Began

Operating the script is simple, however requires a little bit of preparation to arrange entry to the Google Search Console API and obtain a credentials file.

The excellent news is that this file can all the time be reused for different Python initiatives, so it is price doing and holding secure.

It should not take greater than 5 to 10 minutes.

There is a wonderful information right here that I like to recommend the next.

After you have this file, reserve it someplace secure, able to add.

Now the enjoyable half: operating the script!

Operating the script

Operating the script is easy.

The thought is to run all cells without delay and add the credentials file when prompted.

The script routinely generates and saves the bar charts, statistics and Excel doc with none additional immediate.

Step 1: Open the Google Collaboratory sheet.

step 2: On the prime of the web page, choose Runtime > Run All (or press Ctrl + F9).

step 3: When prompted, add the credentials file downloaded after enabling the Search Console API.

Screenshot from Google Collaboratory, August 2022

After the file has been uploaded, the following cell will ask you to go to a URL to authorize the appliance and enter the authorization code.

Screenshot from Google Collaboratory, August 2022

Click on on it and choose the account related to the GSC account you need to get information from.

Screenshot from Google.com, August 2022

Subsequent we have to set the variables.

It ought to be self-explanatory, however I am going to undergo every setting and provides an instance.

URL

The URL should precisely match what’s represented in GSC.

If there are issues, it is as a result of a trailing slash is often lacking!

Additionally word that the syntax for domain-level accounts is as follows:

sc-domain:instance.com

I’ve added an choice to print the accessible GSC accounts in case you may have hassle.

Screenshot from Google Collaboratory, August 2022

Simply remark out the road:

#print(account.webproperties)

… to view the checklist of obtainable accounts accessible to you.

Copy the account identify and paste it precisely within the cell above.

nation filter

A easy variable to filter visitors by nation. To set worldwide, simply remark this line:

df_gsc = df_gsc[df_gsc[“country”].str.incorporates(country_filter)]# remark out this line for worldwide information

An inventory of nation codes could be discovered right here.

search sort

Accessible choices listed below are Net, Information, Video, Picture, Uncover & GoogleNews.

Begin/Finish Date

Enter the beginning and finish dates for which to retrieve GSC information. I like to recommend at the least three months if attainable. The date format is:

YYYY-MM-DD

Listed here are my settings for retrieving the final three months of information from the GSC property for Search Engine Journal.

url=”https://www.searchenginejournal.com/”

country_filter = “usa”

search_type = “internet” # accessible choices are: internet, information, video, picture, uncover & googleNews

start_date = “2022-05-01”

end_date = “2022-08-01”

The info is pulled from GSC. This will take some time relying on the scale of the positioning and the variety of months requested.

As soon as the info retrieval is full, the following cell creates the info body from the GSC information.

The primary 10 rows are previewed so you possibly can confirm that the info is appropriate.

For those who scroll down the web page, you will note {that a} bar chart has been created.

This chart teams pages into sections based on the variety of clicks attributed to them.

This reveals the clicking distribution of the clicks between the pages at a look.

Screenshot from Google Collaboratory, August 2022

The bar chart could be copied into displays if wanted and often tells a powerful story with the info.

In testing, I’ve discovered that the majority web sites have the identical sort of visitors breakdown.

Figuring out which pages are chargeable for a high share of visitors makes it straightforward to prioritize optimization duties.

Just under the bar chart, some statistics are generated and displayed.

• The proportion of pages in GSC with no clicks.
• The proportion of clicks generated on the highest 10 pages in GSC.

Screenshot from Google Collaboratory, August 2022

Screenshot from Google Collaboratory, August 2022

Lastly, a Microsoft Excel doc is saved for modifying.

This doc gives every little thing you have to create an motion plan for optimizing pages on the prime and backside of the size.

How can this information be used?

There are a lot of artistic methods to translate these insights into motion.

High Pages

Test the looks of every web page within the SERPs

• Is the related schema being triggered accurately?
• Are web page titles/meta descriptions being truncated?
• Are the web page titles/meta descriptions lacking key phrases?
• May web page titles/meta descriptions be improved with higher messaging, further key phrases, higher CTAs, and so forth.?
• Are the best sitelinks firing?

Conversion Fee Optimization

• Excessive visitors pages are supreme candidates for A/B testing – get statistically important information quicker!
• Overview and replace content material.

evaluation

Pages with zero visitors

Test pages in Search Console

• Test Found Not Listed/Crawled Not Listed for technical blockers.
• Are pages in sitemaps?

contents

• Test the content material. Is the content material skinny or absent?
• Is there a sample for the pages not getting visitors?

Conclusion

These are just some concepts of how somebody might take motion utilizing the info, however I am positive there are lots of extra approaches that may very well be adopted.

Extra assets:

Featured picture: CG_dmitriy/Shutterstock