Connect Klaviyo to Google BigQuery

klaviyo to bigquery

Analyze your Klaviyo data with Google BigQuery

Connect Klaviyo to Google BigQuery in 2023

It is very simple to connect Klaviyo to Google BigQuery, it can be done in a fast and easy manner with Windsor.ai.

 

First Step:

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

Klaviyo Integration

 

Second Step:

You will need to go to Google BigQuery as a Destination.

BigQuery Integration

 

Third Step:

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.

BigQuery Integration

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

 

Fourth Step:

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

Klaviyo metrics and dimensions available for streaming into Google BigQuery

Connect your data

 

NameTypeDescription
Account IDTEXTKlaviyo account ID
Address Line 1TEXTThe primary address line of the object
Address Line 2TEXTThe secondary address line of the object
Campaign NameTEXTCampaign name
Campaign IdTEXTCampaign id
CityTEXTThe city of the object
Click rateNUMERICClick rate of e-mails
ClicksNUMERICNumber of unique e-mail clicks
ConversionsNUMERICTotal Value of placed orders
Average Conversion ValueNUMERICAverage value of placed orders
CountryCOUNTRYThe country of the object
Created atTEXTCampaign creation time
Created Date/TimeDATEThe time stamp of the object creation
DateDATEDate of metric type data
Email addressTEXTThe email address of the object
First NameTEXTThe first name of the object
From E-mailTEXTFrom e-mail
From NameTEXTFrom name
IDTEXTThe ID of the object
Last NameTEXTThe last name of the object
LatitudeTEXTThe latitude of the object
LongitudeTEXTThe longitude of the object
MembersNUMERICTotal number of members in lists for the period
Object TypeTEXTThe type of the object (e.g. Person)
Open rateNUMERICOpen rate of E-mails
OpensNUMERICNumber of unique e-mail opens
Ordered ProductNUMERICTotal amount of Ordered product
Ordered Product Average ValueNUMERICOrdered product average value
Ordered Product ValueNUMERICOrdered product value
Organization NameTEXTThe organization of the object
Phone NumberTEXTThe phone number of the object
Received e-mailsNUMERICNumber of e-mails received
RegionTEXTThe region of the object
Sent atTEXTCampaign sent time
StatusTEXTCampaign status
SubjectTEXTCampaign subject
Time ZoneTEXTThe time zone of the object
TitleTEXTThe title of the object
Total ClicksNUMERICTotal number of e-mail clicks
Total ConversionsNUMERICTotal amount of placed orders
Total OpensNUMERICTotal number of e-mail opens
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.

Build your Klaviyo and Google BigQuery Integrations