BigQuery Connector

Sync Klaviyo Data to BigQuery

Detrics loads Klaviyo into Google BigQuery on the schedule you set. The tables arrive clean, the history keeps growing, and you can query everything from SQL, Looker Studio, or Claude. We run the pipeline so you don't have to.

Book a Demo

*Free 30-minute consultation

SELECT
  campaign_name,
  SUM(total_recipients) AS total_recipients,
  SUM(opened_email) AS opened_email,
  SUM(opened_email_unique) AS opened_email_unique
FROM `your_project.marketing_data.klaviyo_daily_engagement_time_series_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY campaign_name
ORDER BY total_recipients DESC
LIMIT 10

Why send Klaviyo data to BigQuery?

See which emails sell

Join email campaigns with sales and traffic to see which sends actually drive revenue.

History without limits

Platform APIs cap how far back you can query. In BigQuery every Klaviyo sync is stored across its 7 tables, so you accumulate years of your own history.

One warehouse for everything

Join Klaviyo with the rest of your platforms in one place, no copy-pasting between sheets.

Ask Claude about it

With your data in BigQuery, Claude can answer business questions about Klaviyo in plain language.

Klaviyo tables in BigQuery

This is what Detrics creates for Klaviyo: 7 preset tables with scheduled syncs, plus any custom one you define.

Campaign Analytics

campaign_performance_overview

Key campaign metrics including opens, clicks, and engagement rates

campaign IDcampaign namecampaign statustotal recipientsopened emailopened email unique+4

campaign_details_with_subject

Campaign details including subject line and send timing

campaign namecampaign subjectcampaign preview texttotal recipientsopen rateclick rate+1

spam_and_unsubscribe_tracking

Track spam complaints and unsubscribe rates

campaign namecampaign send datetimetotal recipientsmarked email as spamspam rateunsubscribed+1

+2 more tables in this group

Flow Performance

flow_performance_overview

Track automated email flow engagement and delivery

flow nameflow statusflow trigger typetotal recipientsopened email uniqueopen rate+2

flow_message_details

Analyze individual message performance within flows

flow nameflow message nametotal recipientsopen rateclick rateunsubscribe rate

HOW IT WORKS

From Klaviyo to your warehouse

Connect your account once. Detrics handles schemas, syncs, and backfills.

First step

Connect your first datasource

Link any of 32+ marketing and ecommerce platforms in a couple of clicks.

Connect a source

Second step

Set up your destination

Point Detrics at your BigQuery project and dataset. We write the SQL and handle the setup for you.

Set up destination

Third step

Create your transfer

Choose what to sync and how often. Detrics builds and runs the pipeline for you.

Create a transfer

And that's it

Real-time data, forever

Your data lands in the warehouse and stays fresh automatically. We handle the syncing, the maintenance, and every API update for you.

Book a demo

In the demo we set everything up for you and save you hours.

Then ask Claude about it

With Klaviyo in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.

How did my Klaviyo campaigns perform this month?

Which Klaviyo campaign had the best open rate?

Compare my Klaviyo total recipients against last month

Explore the Klaviyo MCP server

Every Klaviyo field, on demand

Preset tables curated by our team
Custom tables with any field combination
Incremental syncs that only load new data
Automatic backfill of up to 12 months of history

33 metrics

22 dimensions

View Klaviyo Fields

Get Klaviyo into your warehouse this week