Dashboard Blueprint: CRM Performance
Data Sources (2):
1. Google Sheets ← Klaviyo API (flows, campaigns, revenue)
2. Google Sheets ← Shopify API (orders, customers, LTV)
Page 1: Executive Summary
Scorecards: Total Revenue, Email Revenue %, LTV:CAC, Active Subscribers
Time series: Revenue by channel (Klaviyo vs Shopify direct)
Blended metric: Email-attributed revenue vs total revenue
Page 2: Flow Performance
Table: Flow name, send volume, open rate, click rate, revenue
Bar chart: Revenue per recipient by flow
Calculated field: RPR = SUM(revenue) / COUNT(recipients)
Page 3: Customer Lifecycle
Doughnut: New vs Returning vs Lapsed (Shopify cohorts)
Stacked bar: Purchase frequency distribution
Blended: Klaviyo segment ↔ Shopify purchase behavior
Pushing data to Google Sheets...
Klaviyo flow data → Sheet "klaviyo_flows" (24 rows)
Klaviyo campaign data → Sheet "klaviyo_campaigns" (156 rows)
Shopify order data → Sheet "shopify_orders" (2,340 rows)
Shopify customer data → Sheet "shopify_customers" (1,892 rows)
Next: Open Looker Studio, add these 4 sheets as data sources,
then connect with the calculated fields I've documented above.