Klaviyo Raw Data Guide

This guide shows you how to use the raw data coming from this specific data source APIs, so we can support you achieve your reporting needs. In this guide, some recommendations are provided as well as examples of use cases for the most commonly used fields. If you’d like to dig deeper into the raw data from each API, we recommend you to refer to our integrations documentation which provides links to each API documentation. For more guidance on how to build your reports and BI metrics, please inquire us about the Beginners Journey, Data Modelling Guide, Marketing Attribution and/or BI Metrics Guide.

Note: There may be several ways to achieve the use cases that has been indicated below, but these columns are the ones commonly used for most of the use cases we've encountered.

 

Most Used Tables

Table Name

Description

receive

Returns a list of all received emails by the recipient.

open

Returns a list of all opened emails by the recipient.

campaigns

Returns a list of all the campaigns you've created. The campaigns are returned in reverse sorted order by the time they were created.

 

Most Used Fields

Column Name

Description

Use Cases

Table Name

id The ID of the email event or campaign It can be used for joining information from different tables All tables
uuid universally unique identifier It can be used to count unique examples, for instance Receive, Open
person object where you can extract customer email to match with orders It allows to perform more advanced analysis based on the receiver characteristics, for instance a open rate breakdown by country or cities. Receive, Open
datetime/ sent_at A datetime value that indicates when the event ocurred It can be used by breaking down metrics by a time period or create weekly or month averages, for instance All tables
timestamp A timestamp that indicates when an email has been received or opened It can be used by breaking down metrics by a time when the event occurred All tables
event_name Indicate the type of event It can be used for segmenting the events to generate metrics such as bounce rates, open rate, conversion, etc. Receive, Open
event_properties object where you extract info like url or klavyio flow name JSON extraction node can be used here to extract more information on each event, such as email domain, OS, email subject, and so on. Receive, Open
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.