How It Works
This automated solution takes the guesswork out of measuring content impact. By connecting directly to the Google Search Console API, it builds a detailed timeline of performance for every URL in your list.
17-Week Timeline Analysis
Unlike simple "before and after" snapshots, this script generates a comprehensive 17-week view centered around a target date. It automatically calculates 8 weeks of historical data leading up to the event and tracks 8 weeks of performance following it.
Smart Visualization
The script formats your spreadsheet for instant clarity. It automatically highlights the "Target Week" column in green, creating a clear visual anchor.
Analyse Weekly Post-Effect
Measures the impact of content updates by comparing traffic 7 days before vs. 7 days after a specific date. Automatically builds a 17-week trend timeline to visualize long-term performance shifts.
Script Capabilities
- Platform: Google Apps Script
- Source: GSC API (OAuth2)
- Analysis: 17-Week Trend (8 Pre / 8 Post)
- Visuals: Auto-Highlight Target Week
- Smart Fetch: Skips Existing Data
More SEO Scripts
