Automate Multi-Site Reporting With Google Sheets And GSC API

Automate Multi-Site Reporting With Google Sheets And GSC API

Working in SEO leads to interesting challenges that I’m sure you’ve all faced at one point. You’re a master of flexibility and managing tedious tasks. I’ve recently found myself dealing with 100+ top-tier sites. Working with global companies, it’s quite the puzzle to: Wrangle data for 100+ sites. Keep tabs on every site’s performance. And, … Read more

Get Started With GSC Queries In BigQuery

Get Started With GSC Queries In BigQuery

BigQuery has a number of advantages not found with other tools when it comes to analyzing large volumes of Google Search Console (GSC) data. It lets you process billions of rows in seconds, enabling deep analysis across massive datasets. This is a step up from Google Search Console, which only allows you to export 1,000 … Read more

How To Bulk Export GSC Performance Data For A Specific List Of URLs Using The Google Search Console API, Analytics Edge, and Excel

How To Bulk Export GSC Performance Data For A Specific List Of URLs Using The Google Search Console API, Analytics Edge, and Excel

As I’ve been analyzing the impact from the August broad core update (I’ll have more to share on that soon…), I’ve been digging into drops and surges across sites. For larger-scale sites, I often come across pockets of content that I want to take a closer look at from a quality standpoint. And as part … Read more

GSC is showing an unusual increase in canonicals (appears resolved now)

GSC is showing an unusual increase in canonicals (appears resolved now)

Starting in July, some sites are seeing an increase in canonical pages errors shown in Google Search Console, with Google choosing different canonical pages than the ones declared by the website. In most cases, Google’s chosen canonical pages don’t make sense. It does look like this issue has resolved, but I thought it was worth … Read more

Why Google Search Console (GSC) reports redirects as other categories in the coverage reporting like ‘blocked by robots.txt’, ‘404s’, ‘soft 404s’, ‘noindexed pages’, and more.

Why Google Search Console (GSC) reports redirects as other categories in the coverage reporting like ‘blocked by robots.txt’, ‘404s’, ‘soft 404s’, ‘noindexed pages’, and more.

If you are confused when Google reports redirects as other categories, like “blocked by robots.txt”, “soft 404s”, “noindexed”, “404s”, and others, it could be Google silently following the redirect and reporting the status of the true destination url instead. My post covers the situation in detail, and provides examples of this happening in the wild. … Read more

How to analyze the impact of continuous scroll in Google’s desktop search results using Analytics Edge and the GSC API

How to analyze the impact of continuous scroll in Google’s desktop search results using Analytics Edge and the GSC API

Google rolled out continuous scroll in the desktop search results in the U.S. on December 5, 2022, which follows a rollout in the mobile search results in October of 2021. It’s basically like infinite scroll for the search results. When you approach the bottom of page one, the second page of results seamlessly load, enabling … Read more

Social media & sharing icons powered by UltimatelySocial
error

Enjoy Our Website? Please share :) Thank you!