Connect Klaviyo to Azure with Windsor.ai

klaviyo Field Reference logo

+

azure logo 2

Stream all your email marketing data from Klaviyo to Azure

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 Azure

Azure or Microsoft Azure is a cloud computing offering which allows management and hosting on Microsoft Managed data centers. It is used for business critical applications. In combination with Windsor.ai it allows joining marketing, analytics and CRM data to gain deeper insights.

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 and select Azur Blog Storage As A Data Destination.

Instruction

Create an Azure Blob Storage (or an Azure Synapse Analytics) resource on your Azure Portal and provide a connection string for it. Also, you may choose different container and blob names.

Visit Wiki page for details: https://wiki.windsor.ai/azure_blob_storage

You should also read:

Stream Your Data to Azure

Accessing any fields from your marketing platforms for your data pipelines

Connect Klaviyo to Google BigQuery

klaviyo google data studio

Klaviyo metrics and dimensions available for streaming into Azure

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 Azure

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.