Connect Klaviyo to Snowflake

klaviyo Field Reference logo
+
snowflake

Stream 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. 
  2. Create the WINDSOR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username 
  • Get the password 
  • Get the account 
  • Get the warehouse 
  • Get the database 
  • Get the schema 
  • Get the table name 

 

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

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
Bounced EmailNUMERICBounced Email
Bounced Email RateNUMERICBounced Email Rate
Campaign NameTEXTCampaign name
Campaign ChannelTEXTCampaign Channel
Campaign IDTEXTCampaign id
Cancelled OrderNUMERICTotal amount of Cancelled Order
Cancelled Order ValueNUMERICCancelled Order value
Checkout CompletedNUMERICCheckout Completed
Checkout Start to Order RateNUMERICCompleted checkouts as ratio of checkout starts
Checkout StartedNUMERICTotal amount of Checkout Started
Checkout Started ValueNUMERICCheckout Started value
CityCITYThe 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
Flow dimensionsTEXTFlow dimensions
Email addressTEXTThe email address of the object
First NameTEXTThe first name of the object
Flow IDTEXTFlow ID
Flow NameTEXTFlow Name
Flow URLTEXTFlow Url
From E-mailTEXTFrom e-mail
From NameTEXTFrom name
Fulfilled OrderNUMERICTotal amount of Fulfilled Order
Fulfilled Order ValueNUMERICFulfilled Order value
Fulfilled Partial OrderNUMERICTotal amount of Fulfilled Partial Order
Fulfilled Partial Order ValueNUMERICFulfilled Order value
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
Message ChannelTEXTMessage Channel
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
Refunded OrderNUMERICTotal amount of Refunded Order
Refunded Order ValueNUMERICRefunded Order value
RegionREGIONThe region of the object
RevenueNUMERICTotal Value of placed orders
Revenue per RecipientNUMERICThe amount of revenue attributed to a campaign divided by the number of recipients
Sent atTEXTCampaign sent time
Sent EmailsNUMERICThe number of recipients the email was sent to
Shopify Cancelled OrderNUMERICThis event is tracked when a customer creates an order in your Shopify store but then cancels the order before fulfillment
Shopify Checkout StartedNUMERICShopify checkout completed
Shopify Confirmed ShipmentNUMERICShopify Confirmed Shipment
Shopify Delivered ShipmentNUMERICShopify Delivered Shipment
Shopify Fulfilled OrderNUMERICThis event is tracked when an order is marked as 'fulfilled' in your Shopify store
Shopify Fulfilled Partial OrderNUMERICThis event is tracked when an order is marked as 'fulfilled' in your Shopify store
Shopify Marked Out for DeliveryNUMERICShopify Marked Out for Delivery
Shopify Ordered ProductNUMERICThe total quantity ordered of the product
Shopify Placed OrderNUMERICThis event is tracked when a customer completes the checkout process and creates an order in your Shopify store
Shopify Refunded OrderNUMERICThis event is tracked when a customer completes the checkout process in your Shopify store and a payment is made, but the customer requests the payment to be returned. Klaviyo only receives events from fully refunded orders (not partially refunded orders)
Shopify RevenueNUMERICThis event is tracked when a customer completes the checkout process and creates an order in your Shopify store
StatusTEXTCampaign status
SubjectTEXTCampaign subject
SubscribedNUMERICSubscribed to List
Subscription statusTEXTEmail subscriptions status
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
UnsubscribedNUMERICUnsubscribed from list
Unsubscribed RateNUMERICUnsubscribed from list Rate
ZIP CodeTEXTThe zip code of the object
TodayDATEToday's date

Easily connect Klaviyo to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 70+ 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