[Script Idea] Content Decay

I am currently trying my best to build a script that allows us to analyze content decay in bulk in a much easier and more productive way but I am reaching a point where I am stuck and can´t make any progress so, I am sharing my idea so hopefully someone else can take on this and share it with the community.

Here´s what I plan the script to do:

Connect to GSC
Input the site´s sitemap
An option to exclude any subfolder and/or collections from the analysis (if we only want to focus the analysis on the /blog/ subfolder for example or exclude /category/)
Fetched the Clicks and Impression data for each URL for the last 3 months comparing MoM (check the attached image below)
Highlight with a particular color any and all URLs with a clear downward trend in consecutive months (maybe yellow) and another color for a downward trend in back to back to back months (maybe red - we would prioritize these) - Maybe not color code this and just add a column at the end with a number indicating the number of consecutive months
Export it to a CSV

Have you found something like this? Thoughts?

8 comments