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.
Use Claude to write a self-documenting SQL cohort retention query for Klaviyo or Shopify data, then read the M1, curve-flattening, and cohort-over-cohort trend signals yourself — no analyst required.
