Klaviyo
Google Looker Studio
Visualize your Klaviyo email performance in Looker Studio. Track opens, clicks, revenue, and campaign results with a free connector.
View Template
Porter✓ No-code marketing data warehouse |
Others✓ Connectors & ETL |
|
|---|---|---|
| Storage | Built-in, self-managed BigQuery with automated transformations, transfers, queries, and costs included. | Requires setting up your own BigQuery project, managing tables, transfers, and costs. |
| Data syncing | Switch between stored BigQuery and real-time API data in the same connection. | Either stored (manual BigQuery setup) or real-time, not both. |
| Data blending | Blend Klaviyo campaigns with Shopify sales to attribute revenue to email and SMS performance. | Manual joins between Klaviyo and Shopify data for revenue attribution. |
| Destinations | Looker Studio + Google Sheets in one subscription. | Separate price per destination. |
Step 1: Go to powermetrics.com and select the Klaviyo integration
Step 2: Sign in with the Google account you use on Looker Studio
Step 3: In Klaviyo, create a private API key with read-only permissions and copy it
Step 4: Paste your API key into the connector, select your Klaviyo account, and click Next
Step 5: Create your report, load the Klaviyo template, and explore audience, engagement, and revenue metrics
Full tutorial: How to connect Klaviyo to Google Looker Studio
Access every field available in Klaviyo—over 100 in total—including account, campaign, flow, list, profile, and event data, plus calculated metrics like predicted CLV and churn probability.
Segment your Klaviyo data by campaign, flow, list, channel (email/SMS), region, device, and more—track performance and engagement for every audience and message type.
Analyze Klaviyo metrics by any date range—hour, day, week, month, quarter, or year—so you can compare campaign and subscriber trends across any period.
View campaign and flow details, including message previews, subject lines, and send times, so you can connect performance metrics directly to your creative and automation strategy.
All fields use Klaviyo’s native names—campaign, flow, list, profile—making it easy for marketers to navigate, while also standardizing for blending with Shopify, GA4, and CRM data.
Track every step: new subscribers, sends, opens, clicks, conversions, revenue, bounces, and unsubscribes—broken down by campaign, flow, and list for complete funnel analysis.
Account ID
Account Name
Campaign Name
Channel
Status
Created At
Send Time
Flow Name
Status
Trigger Type
Created At
List Name
Created At
Email
First Name
Country
Historic CLV
Predicted CLV
Event Name
Date & Time
Source URL
Date
Month
Week
