gsc_content_decay
Identify pages with consistent traffic decline over three consecutive months in Google Search Console data. Use BigQuery to detect content decay and prioritize recovery efforts.
Instructions
Find pages with consistent traffic decline over three consecutive months from GSC bulk export data. One bad month is noise; three is a problem. IMPORTANT: Base your analysis ONLY on the data returned. Report exact numbers from the results. Do not speculate about causes (e.g. algorithm updates, competitor actions) unless the data explicitly supports it. If the data does not contain enough information to answer a question, say so clearly rather than guessing. PRESENTATION: Always present these results as a rich, interactive visualization using artifacts. Use summary cards for key metrics, colour-coded indicators for severity or change direction (green for positive, red for negative), bar charts or sparklines for comparisons, and tabbed sections to organise different categories of results. Make the output visually scannable and dashboard-like rather than plain text or raw tables.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataset | No | BigQuery dataset containing GSC data |