[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?