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.
One morning, five dashboards requested, zero patience. I wrote 10 base SQL queries against the GA4 BigQuery export, fed them to Claude with a Looker Studio schema, and shipped 10 working dashboards before close of day. Here are the SQL, the prompt, and the traps I hit.
Two free Google tools give you the rawest data on what your site is doing. Pair them with Claude and you get content decisions in 90 minutes that would take a week in spreadsheets. Here's the exact workflow, the prompt template, and the three questions it reliably answers.
