Most marketing teams learn their CAC doubled on Tuesday by reading the Monday dashboard next week. The 90-day pipeline that catches it within hours: GA4 + Meta + Google Ads into a Sheet, nightly Gemini call with a 14-day baseline and a name-the-cause prompt, red/yellow severity to Slack. Includes the actual prompt, the n8n JSON, and a real Tuesday alert.
Most teams look at a funnel chart, see a drop, and start guessing. This is the 7-step diagnostic I run whenever a funnel underperforms — built around GA4 Funnel Exploration plus a Claude prompt that does the cross-segmentation in minutes. By step 7 you'll have a testable hypothesis, not a vibe.
Most marketing attribution is a $40K/year vendor contract answering a question you can solve in a Google Sheet. Here are the three models I have built for clients since 2014 — last-click, first-click, and time-decay — with the exact formulas, the column layout, and the one trap that catches every team the first time.
Stop building dashboards backwards. 12 chart types, the question to ask before each, and copy-paste Claude prompts to design Looker Studio dashboards that survive a Monday morning executive review.
Most LTV models are either too simple (AOV x N) or need a data team and a Python notebook. This is the 5-input spreadsheet model I have used across DTC, SaaS, and subscription businesses since 2019 — with the exact ChatGPT prompt that builds a custom version for your business in under two minutes.
