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.
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.
