Performance Marketer | Meta & Google Ads | AI Automation
Performance Marketer | Meta & Google Ads | AI Automation
Revenue Leak Radar: AI Analyst That Caught Broken Tracking on Day 1
šø Real build, real screenshots, not mock-ups.
I built an AI analyst that checks a store's GA4 data every morning, spots revenue drops, funnel leaks and broken tracking, and explains each issue in plain English with a cost, an action and an owner.
The result: when revenue showed $0 but 19 customers had actually paid, the radar flagged it as a tracking problem on the first day, not a sales crash.
What it does:
ā¢ GA4 ā BigQuery: 10 business metrics every day
ā¢ Compares each day to the same weekday over 28 days
ā¢ Catches orders recorded without revenue
ā¢ Gemini writes the diagnosis, action and owner
ā¢ Sends a visual report and an alert email
ā¢ "Ask your data" box: type a question, it writes and runs the SQL
Tools: Google Apps Script, BigQuery, GA4, Gemini API, Google Sheets
Cost: $0 (free tiers only)
Tested on Google's public GA4 demo dataset (Google Merchandise Store).
Full case study: https://claude.ai/artifact/KjLpN5RTwNLKTt3Ng77ssV
1
248
Expert Flutter Developer for MVPs & Market Analysis
Expert Flutter Developer for MVPs & Market Analysis
View more ā