{"id":1409,"date":"2022-08-31T12:09:28","date_gmt":"2022-08-31T12:09:28","guid":{"rendered":"https:\/\/afreeurl.com\/automate-the-discovery-of-gsc-optimization-opportunities\/"},"modified":"2022-08-31T12:09:30","modified_gmt":"2022-08-31T12:09:30","slug":"automate-the-discovery-of-gsc-optimization-opportunities","status":"publish","type":"post","link":"https:\/\/afreeurl.com\/?p=1409","title":{"rendered":"Automate the discovery of GSC optimization opportunities"},"content":{"rendered":"

<\/p>\n

I recently discovered that 10 pages on our website accounted for over 61.2% of our total clicks reported in Google Search Console (GSC) over the past three months.<\/p>\n

This is a site with about 300 categories and 20,000 product SKUs.<\/p>\n

10 pages!<\/p>\n

So amazingly, almost 74.8% of all pages reported to GSC received no clicks.<\/p>\n

Today, I’ll share a Python script that pulls this information from Google Search Console, exporting platform-ready charts and an action-ready Microsoft Excel sheet.<\/p>\n

Screenshot from Google Colaboratory, August 2022<\/span><\/p>\n

The Excel sheet is very useful, with high and low traffic ranges split into their own tabs for action.<\/p>\n

\"ExcelMicrosoft Excel screenshot, August 2022<\/span><\/p>\n

Checkout is fully automated and works for any account you have access to in GSC.<\/p>\n

What will we learn today?<\/h2>\n

How to run the script. Key components and concepts of the screenplay. Ideas for optimization.<\/p>\n

Starting<\/h2>\n

Running the script is easy, but there is a little preparation involved in setting up access to the Google Search Console API and downloading a credentials file.<\/p>\n

The good news is that this file can be used over and over again for other Python projects, so it’s worth doing and keeping it safe.<\/p>\n

It shouldn’t take more than 5-10 minutes.<\/p>\n

There is a excellent guide here<\/a> I recommend following.<\/p>\n

Once you have this file, save it somewhere safe, ready to upload.<\/p>\n

Now for the fun part: running the script!<\/p>\n

Running the script<\/h3>\n

Running the script is simple.<\/p>\n

The idea is to run all cells simultaneously and load the credentials file when prompted.<\/p>\n

The script will automatically generate and save the bar charts, statistics and Excel document without further prompting.<\/p>\n

Step 1<\/strong>: Open the Google Collaboratory sheet<\/a>.<\/p>\n

Step 2<\/strong>: At the top of the page, select Runtime > Run All (or press the shortcut keys Control + F9).<\/p>\n

Step 3<\/strong>: When prompted, upload the credentials file that was downloaded after enabling the Search Console API.<\/p>\n

\"UploadScreenshot from Google Colaboratory, August 2022<\/span><\/p>\n

After the file is loaded, the next cell will ask you to visit a URL to authorize the application and enter the authorization code.<\/p>\n

\"GoogleScreenshot from Google Colaboratory, August 2022<\/span><\/p>\n

Click on it and choose the account associated with the GSC account you want to receive data from.<\/p>\n

\"GoogleScreenshot from Google.com, August 2022<\/span><\/p>\n

Next, we need to set the variables.<\/p>\n

It should be self-explanatory, but I’ll talk about each scenario and share an example.<\/p>\n

url<\/strong><\/p>\n

The URL must exactly match how it appears in GSC.<\/p>\n

If there are problems, it’s because it’s usually missing a bar!<\/p>\n

Also note that for domain-level accounts, the syntax is:<\/p>\n

sc-domain:example.com<\/p>\n

I’ve included an option to print the available GSC accounts if you’re having trouble.<\/p>\n

\"GoogleScreenshot from Google Colaboratory, August 2022<\/span><\/p>\n

Just uncomment the line:<\/p>\n

#print(account.webproperties)<\/p>\n

\u2026 to see the list of accounts available to you.<\/p>\n

Copy and paste the account name exactly into the cell above.<\/p>\n

Country filter<\/strong><\/p>\n

A simple variable to filter traffic by country. To configure worldwide, just comment out this line:<\/p>\n

df_gsc = df_gsc[df_gsc[\u201ccountry\u201d].str.contains(country_filter)]# comment out this line for worldwide data<\/p>\n

A list of country codes can be found here.<\/a><\/p>\n

Search Type<\/strong><\/p>\n

The options available here are Web, News, Video, Image, Discover and GoogleNews.<\/p>\n

Start\/end date<\/strong><\/p>\n

Enter the start and end dates for which you want to extract the GSC data. I recommend at least three months if possible. The date format is:<\/p>\n

YYYY-MM-DD<\/p>\n

Here is my setup to pull the last three months of data from the GSC property for Search Engine Journal.<\/p>\n

url=”<\/p>\n

country_filter = “USA”<\/p>\n

search_type = \u201cweb\u201d # available options are: web, news, video, image, discover and googleNews<\/p>\n

start_date = “2022-05-01”<\/p>\n

end_date = “2022-08-01”<\/p>\n

The data will be taken from GSC. This may take some time, depending on the size of the site and the number of months requested.<\/p>\n

After the data extraction is complete, the next cell will create the data frame from the GSC data.<\/p>\n

The first 10 rows will be previewed so you can check that the data is correct.<\/p>\n

Scrolling down the page, you will notice that a bar chart has been created.<\/p>\n

This graph groups pages into ranges based on the number of clicks attributed to them.<\/p>\n

This makes it easy to see the distribution of clicks between pages at a glance.<\/p>\n

\"BarScreenshot from Google Colaboratory, August 2022<\/span><\/p>\n

The bar chart can be copied into presentations as needed and usually tells a powerful story with the data.<\/p>\n

In testing, I’ve found that most sites experience the same kind of traffic breakdown.<\/p>\n

Knowing which pages are responsible for a high percentage of traffic makes it easier to prioritize tasks for optimization.<\/p>\n

Just below the bar chart, some statistics are created and displayed.<\/p>\n

The percentage of pages on GSC without clicks. The percentage of clicks generated on GSC’s top 10 pages.<\/p>\n

\"statisticsScreenshot from Google Colaboratory, August 2022<\/span><\/p>\n

\"statisticsScreenshot from Google Colaboratory, August 2022<\/span><\/p>\n

Finally, a Microsoft Excel document is saved for the action.<\/p>\n

This document contains everything you need to create an action plan to optimize pages at the top and bottom end of the scale.<\/p>\n

How can this data be used?<\/h2>\n

There are many creative ways to turn these ideas into action.<\/p>\n

Main pages<\/h3>\n

Check how each page looks in the SERPs<\/strong><\/p>\n

Does the relevant schema activate correctly? Are page titles\/meta descriptions truncated? Are keywords missing from page titles\/meta descriptions? Could page titles\/meta descriptions be improved with better messaging, additional keywords, better CTAs, etc.? Are the correct sitelinks enabled?<\/p>\n

Conversion rate optimization<\/strong><\/p>\n

Pages with high traffic are ideal candidates for A\/B testing \u2013 get statistically significant data faster! Review and update content.<\/p>\n

analysis<\/strong><\/p>\n

Pages with zero traffic<\/h3>\n

Review the pages in Search Console<\/strong><\/p>\n

Unindexed\/Tracked Unindexed review for technical blockers. Are the pages in the sitemaps?<\/p>\n

content<\/strong><\/p>\n

Review the content. Is the content thin or lacking? Is there a pattern to the pages that are not getting traffic?<\/p>\n

Conclusion<\/h2>\n

These are just a few ideas of how someone could take action using the data, but I’m sure there are many more approaches that could be taken.<\/p>\n

More resources:<\/strong><\/p>\n

Featured image: CG_dmitriy\/Shutterstock<\/p>\n

[ad_2]
\n
Source link <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Screenshot from Google Colaboratory, August 2022 Microsoft Excel screenshot, August 2022 What will we learn today? How to run the Key components and concepts of the Ideas for Starting Running the script Screenshot from Google Colaboratory, August…<\/p>\n","protected":false},"author":1,"featured_media":1410,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1409","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-seo-news"],"_links":{"self":[{"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/posts\/1409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afreeurl.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1409"}],"version-history":[{"count":1,"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/posts\/1409\/revisions"}],"predecessor-version":[{"id":1411,"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/posts\/1409\/revisions\/1411"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/media\/1410"}],"wp:attachment":[{"href":"https:\/\/afreeurl.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afreeurl.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afreeurl.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}