Connect Klaviyo to Snowflake

klaviyo Field Reference logo
+
snowflake

Stream your marketing data from Klaviyo to Snowflake

Connect Klaviyo to Snowflake in 2023

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

 

First Step

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. Snowflake Integration 1
  2. Create the WINDSOR_UPLOAD role (name has no importance) Snowflake Integration 2
  3. Create a user and add the previously created role to that user Snowflake Integration 3
  4. Grant rights to the DATABASE to the created user Snowflake Integration 4
  5. Grand the rights to the destination table Snowflake Integration 5
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form

 

  • Get the username Import Snowflake 1

 

  • Get the password Import Snowflake 2

 

  • Get the account Import Snowflake 3

 

  • Get the warehouse Import Snowflake 4

 

  • Get the database Import Snowflake 5

 

  • Get the schema Import Snowflake 6

 

  • Get the table name Import Snowflake 7

 

Second step

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

power bi klaviyo connector

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3.Enter all the credentials required and click Save
Snowflake connector

 

4.Your data will now be streamed to Snowflake. In case there is an error you will be notified.

Klaviyo metrics and dimensions available for streaming into Snowflake

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 ratePERCENTClick rate of e-mails
ClicksNUMERICNumber of unique e-mail clicks
ConversionsNUMERICTotal Value of placed orders
Average Conversion ValuePERCENTAverage 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 ratePERCENTOpen rate of E-mails
OpensNUMERICNumber of unique e-mail opens
Ordered ProductNUMERICTotal amount of Ordered product
Ordered Product Average ValuePERCENTOrdered 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
RegionREGIONThe 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

Easily connect Klaviyo to Snowflake

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 marketers, whenever they want.

insights

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

Build your Klaviyo and Snowflake Integrations