→

Klaviyo for Power BI: sync to Excel & BigQuery

Build Power BI reports from Klaviyo data by syncing profiles, events, campaigns, and flows into Excel or BigQuery first. SyncRange handles refreshes so reports stay up to date without repeated Klaviyo CSV exports.

Google Sheets Microsoft Excel BigQuery Looker Studio Power BI

Start free Watch demo

Free plan · No credit card · From $19/mo

Overview: all destinations for Klaviyo

How it works

Connect, choose data, open the report

Connect Klaviyo securely with OAuth so SyncRange can read only the access your team approves.
Pick the fields your model needs and map them to Power BI, including deep store data basic extractors skip when available.
Open the report in a destination on the schedule you set, from daily to as often as every 15 minutes by plan.

Power BI reports read from connectors such as Microsoft Excel and BigQuery. SyncRange focuses on keeping Klaviyo accurate inside those destinations. Think of us as the sync layer, not a charting substitute.

After data lands on a schedule, you build Power BI visuals and data models the same way you would for any other business data. Power BI stays fast because the heavy lifting happens in Excel or BigQuery.

Power BI and your data warehouse

Power BI connects natively to BigQuery and Microsoft Excel. SyncRange does not build visuals inside Power BI. We keep Klaviyo synchronized into those destinations so your reports and data models stay fast and auditable.

Read how Power BI fits with BigQuery and Excel

Export schema

What we can export, and how it lands

Each row is a field you can include or omit in the app before export. Column headers match the labels below; SyncRange writes them as the first row in your destination(worksheets in Google Sheets or Excel, or BigQuery columns) when you choose Power BI.

Accounts

Authenticated Klaviyo account metadata

Columns
Account ID
Type
Test Account
Public API Key
Locale
Currency
Timezone
Preferred Currency
Contact Information
Industry
Date Exported

Profiles

Customer profiles (email, phone, location, properties)

Columns
Profile ID
Type
Email
Phone Number
External ID
Anonymous ID
First Name
Last Name
Organization
Title
Image
Created
Updated
Last Event Date
Location Address 1
Location Address 2
Location City
Location Region
Location Country
Location Zip
Location Timezone
Location Latitude
Location Longitude
Location IP
Properties
Subscriptions
Predictive Analytics
Relationships
Date Exported

Lists

Static lists of profiles

Columns
List ID
Type
Name
Created
Updated
Opt-In Process
Profile Count
Relationships
Date Exported

Segments

Dynamic profile segments

Columns
Segment ID
Type
Name
Created
Updated
Is Active
Is Processing
Is Starred
Definition
Relationships
Date Exported

Email Campaigns

Email campaigns (channel filter applied)

Columns
Campaign ID
Type
Name
Status
Archived
Audiences
Send Options
Tracking Options
Send Strategy
Created At
Scheduled At
Updated At
Send Time
Relationships
Date Exported

SMS Campaigns

SMS campaigns (channel filter applied)

Columns
Campaign ID
Type
Name
Status
Archived
Audiences
Send Options
Tracking Options
Send Strategy
Created At
Scheduled At
Updated At
Send Time
Relationships
Date Exported

Flows

Automated flows

Columns
Flow ID
Type
Name
Status
Archived
Created
Updated
Trigger Type
Relationships
Date Exported

Metrics

Event metrics available in the account

Columns
Metric ID
Type
Name
Created
Updated
Integration
Relationships
Date Exported

Events

Tracked events (date-filtered by datetime)

Columns
Event ID
Type
Timestamp
Datetime
UUID
Event Properties
Profile ID
Metric ID
Relationships
Date Exported

Catalog Items

Catalog products / items

Columns
Item ID
Type
External ID
Title
Description
Price
URL
Image URL
Published
Created
Updated
Custom Metadata
Relationships
Date Exported

Catalog Variants

Catalog item variants

Columns
Variant ID
Type
External ID
Title
Description
SKU
Inventory Policy
Inventory Quantity
Price
URL
Image URL
Published
Created
Updated
Custom Metadata
Relationships
Date Exported

Catalog Categories

Catalog categories

Columns
Category ID
Type
External ID
Name
Updated
Relationships
Date Exported

Coupons

Coupon definitions

Columns
Coupon ID
Type
External ID
Description
Relationships
Date Exported

Coupon Codes

Individual coupon codes

Columns
Coupon Code ID
Type
Unique Code
Expires At
Status
Relationships
Date Exported

Forms

Signup / embeddable forms

Columns
Form ID
Type
Name
Status
A/B Test
Created At
Updated At
Relationships
Date Exported

Images

Uploaded images

Columns
Image ID
Type
Name
Image URL
Format
Size
Hidden
Updated At
Date Exported

Columns
Tag ID
Type
Name
Relationships
Date Exported

Columns
Template ID
Type
Name
Editor Type
HTML
Text
Created
Updated
Date Exported

Columns
Review ID
Type
Email
Status
Verified
Created
Updated
Rating
Title
Content
Product
Author
Relationships
Date Exported

Built for ecommerce teams and multi-brand operators

See how teams export clean ecommerce and marketing data to BigQuery, Google Sheets, or Excel without manual work.

SML Cakes

Shopify Store and Food delivery

★★★★★

Super easy to use and has been extremely useful in getting the real time data we need from our Shopify store. Ryan was super helpful in getting started, and responded to questions within minutes. Highly recommend.

Emma L.

Multi-brand Shopify Plus Operator

★★★★★

We run multiple Shopify stores and needed brand-level exports into BigQuery without custom pipeline maintenance. SyncRange gave us reliable scheduled exports and removed hours of manual QA.

UPlay

Large marketplace

★★★★★

We struggled to find a Shopify extraction tool that went beyond basic product, order, and customer data until we found SyncRange. It effortlessly pulls everything we require, including metaobjects and custom fields. SyncRange's hands-on guidance has given us complete confidence.

Hydro Power

Large Shopify Store

★★★★★

SyncRange was very helpful setting up Report Automation for my store. Highly recommend, Ryan made it as simple as possible and was very easy to work with. I recommend.