Klaviyo to BigQuery

Campaign and flow performance in your own dataset, refreshed on a schedule. You connect it with a Klaviyo key with read access.

Add to Google Sheets

30 days of Plus, free, no card. Then one report keeps refreshing weekly.

Klaviyo

06:00

Written to fs_campaign_performance

Klaviyo

06:01

Written to fs_flow_performance

Klaviyo

06:02

Written to fs_campaigns_by_tag

What lands in BigQuery

Campaign or flow reports: recipients, delivered, opens, clicks and conversions, with their rates.
Each report counts conversions against the event you choose.
Klaviyo's figures have no date column, so each run replaces the whole table. It's a current view, not a history.
Up to 1,000 rows a report.

Google lists a Klaviyo connector in preview in its BigQuery Data Transfer Service, free while it's in preview.

Create a private API key in Klaviyo with read access, and paste it on the Sources page of your Fresh Sheets account.

Which plans send to BigQuery

Pro and Max, and the free 30 days. Sending to BigQuery uses no extra refreshes: one run counts once, wherever it lands.

FAQ

Questions

Why doesn't history build up?

Klaviyo's campaign and flow figures aren't split by day, so there's no date to keep. Each run gives the totals for its date range and replaces the table.

Can Fresh Sheets send emails from my account?

No. You choose the key's permissions, we ask for read access only, and our code refuses anything that isn't a read before it's sent.