𝗜 𝗦𝘁𝗼𝗽𝗽𝗲𝗱 𝗘𝘅𝗽𝗼𝗿𝘁𝗶𝗻𝗴 𝗚𝗦𝗖 𝗖𝗦𝗩𝘀 𝗘𝘃𝗲𝗿𝘆 𝗠𝗼𝗻𝗱𝗮𝘆
I spent two years doing the same task every Monday.
I opened Search Console. I clicked export. I waited for a CSV. I dumped data into a spreadsheet. I compared it to last week.
It took 47 minutes. All I wanted to know was if something broke.
Now, I use the Search Console API. It takes 4 seconds.
The web interface is good for quick looks. It is bad for tracking change over time. You have to manually change date ranges. You have to squint at tables. Exports also limit you to 1,000 rows.
The API gives you more data. You get query, page, and device metrics in one call.
Here is how to build your own automation:
- Install the library: npm install googleapis
- Create a service account and a key file.
- Add the service account email as a user in Search Console. Give it at least Restricted access.
The real value is comparing periods. Do not just look at one week. Compare this week to last week.
Build your script to flag regressions. If a page drops clicks by more than 20 percent, alert yourself.
Ignore low volume noise. A drop from 2 clicks to 1 click is a 50 percent drop, but it does not matter. Set a minimum threshold.
Most SEO drops come from technical errors. Check these three things in your script:
- Is the page still indexed?
- Is the canonical tag correct?
- Is the HTTP status code 200?
The UI is for spot-checking. The API is for monitoring. If you do a task every week, write a script.