A one-page Google Sheets dashboard with 8 marketing KPIs and a Gemini =AI() cell that writes the week-over-week narrative for each metric. Built in 90 minutes, fits in a Slack screenshot, kills the 20-minute Monday meeting.
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.
