This Analytics Edge report quickly surfaces content that significantly dropped in search performance over the past month.
While this isn’t easy with the GSC web interface, Analytics Edge makes it easy.
Creating the report with Analytics Edge
Download the example workbook: coming soon…
The Macro
Starting with a Google Search Analytics query to get the clicks by page, we set the date range to the most recent month of data (image). You could use the calendar month if preferred.
A Date Comparison is selected to the previous period with the optional % Changed column.
A Filter function is then used to keep only the pages with >100 clicks and a drop of more than 10% (<-0.1). Note that the Filter function (image) selects the columns by position instead of by name. This is because the columns will include the date in the column name, which changes every time you refresh the report. By filtering based on column position, the report continues to work as intended.
The results are then written to the worksheet.
You can customize the date ranges and filter criteria to suit the typical behaviour of your web pages to highlight out-of-the-ordinary drops in search performance.
Analytics Edge makes this easy.