Delta Audit Tool

Use cases

Analyzing Google algorithm update impacts Identifying sudden traffic changes Comparing performance before/after site changes Quantifying the impact of SEO work

Computes rolling averages (configurable 3-14 day window) using NumPy to smooth daily click data.

Calculates absolute differences to locate maximum deviation point.

Resamples data into Monday-to-Sunday weeks excluding partial weeks.

Generates Plotly charts with marked anomaly dates and colour-coded delta indicators.

Streamlit App

Platform

Browser-based (no installation required)

Input

GSC export CSV with dates

Customisable column names via text inputs

Output

Interactive charts: daily clicks, rolling average with anomaly markers. Week-over-week table with absolute/relative changes. CSV: pre/post metrics with percentage changes.

Launch App View Source

Features

Rolling window slider (3-14 days, default 7)
Automatic significant change detection via max deviation
Monday-to-Sunday week aggregation
Plotly interactive line charts with anomaly markers
Colour-coded delta indicators for clicks/impressions
Custom column name mapping

How to use

1 Export GSC data as CSV
2 Upload and confirm column names (date, clicks, impressions)
3 Set rolling window size (3-14 days)
4 Review detected significant change week
5 Explore interactive Plotly charts
6 Analyse week-over-week comparison table
7 Download CSV with pre/post-change metrics

Want me to run this for you?

I offer this as a managed service. You get the insights without touching the tool.

Google Trends Forecasting

Forecast search trends using NeuralProphet ML.

BCG Matrix Generator

Generate BCG matrix visualisations from GA landing page reports with cascading folder analysis.

Resolution Screenshot Tool

Capture screenshots at GA visitor resolutions using Pyppeteer async browser automation.

Let's work together

Monthly retainers or one-off projects. No lengthy reports that sit in a drawer.