Connect Klaviyo to Google BigQuery with Windsor.ai

klaviyo

+

bigquery

Stream all your email marketing data from Klaviyo to Google BigQuery

About Klaviyo

Klaviyo is a marketing automation tool with a strong focus on email. It’s features are helping ecommerce store owners to increase the customer lifetime value of their existing clients. It allow user to segmet list based website behaviour, email open rates, location,.. Klaviyo has a deep integration with Shopify.

About Google BigQuery

Google BigQuery is a cloud based data warehouse. It allows flexible scaling and is a commonly used Platform as a Service solution.

First step:

You need to select Klaviyo as a Data Source and Grant Access to Windsor.ai.

Second Step:

you will need to go to Select  Destination to choose where do you want to send your data.

Third Step:

In this case Select Google BigQuery As A Data Destination

 (Don’t forget to grant access to bq-upload@windsor-ai-bigquery.iam.gserviceaccount.com)

Make sure you follow the instructions on the screen. Once you complete the setup your data will start streaming in the interval you specify. You can always come back and change the settings at a later stage.

Fourth Step:

  1. As a connector URL you can use any URL providing a JSON. Either from the connectors or for example a URL with cached and transformed data from charts.windsor.ai

You should also read:

Stream Your Data to Google BigQuery

Accessing any fields from your marketing platforms for your data pipelines

How to link Google Campaign Manager (DCM) to Windsor.ai

Klaviyo metrics and dimensions available for streaming into Google BigQuery

NameTypeDescription
Address Line 1TEXTThe primary address line of the object
Address Line 2TEXTThe secondary address line of the object
CityTEXTThe city of the object
CountryTEXTThe country of the object
Created Date/TimeTIMESTAMPThe time stamp of the object creation
Email addressTEXTThe email address of the object
First NameTEXTThe first name of the object
IDTEXTThe ID of the object
Last NameTEXTThe last name of the object
LatitudeTEXTThe latitude of the object
LongitudeTEXTThe longitude of the object
Object TypeTEXTThe type of the object (e.g. Person)
Organization NameTEXTThe organization of the object
Phone NumberTEXTThe phone number of the object
RegionTEXTThe region of the object
Time ZoneTEXTThe time zone of the object
TitleTEXTThe title of the object
ZIP CodeTEXTThe zip code of the object

Windsor.ai: Easily connect Klaviyo to Google BigQuery

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.