Klaviyo Events Data Modeling

this feature is currently in beta for access to this, please reach out to mailto\ help\@chord co ! overview this guide explains how chord models klaviyo engagement data to support campaign analysis, audience segmentation, and activation we highlight the most important attributes, event types, and how we enhance klaviyo’s native data with structure and long term storage for smarter use across your customer journeys who this is for marketing and crm teams using klaviyo to power messaging campaigns and segmentation core event attributes each klaviyo event modeled in chord includes the following key attributes event date when the action occurred—such as an email being opened, a message clicked, or an order placed session sessions help organize activity a session starts when a user opens an email we use this to model session based metrics like order attribution or conversion analysis touch type identifies the origin of the message campaign – one time sends flow – automated messages null – events triggered by external apps or non klaviyo sources measures & metrics we model multiple types of performance measures to support analysis event counts total number of times an event occurred—e g , how many emails were opened or links clicked unique events first time actions for a user within a given campaign or flow for example unique opened emails – used to start sessions unique click rate – calculated as unique clicks divided by unique opens this is especially useful for building performance funnels across flows or campaign types revenue attribution for events like placed order we capture revenue related fields and associate them with the triggering session this allows for clear connection between engagement and revenue outcomes attribution & session modeling chord’s messaging explore supports deeper insights with structured attribution windows and session rules attribution lookback windows channel lookback period email 120 hours (5 days) sms / push 24 hours session defining events ( https //help klaviyo com/hc/en us/articles/115005248128 ) a new session begins when a user engages with one of these events opened email clicked email clicked sms opened push these events are considered eligible for attribution opened email clicked email clicked sms opened push where to find this data in chord once your klaviyo events are ingested by chord, you will be able to further analyze your klaviyo data on chord for assistance with getting klaviyo data ingested on chord, please contact help\@chord co once your klaviyo data has been ingested and synced, follow the steps below to dig into your data log into the chord commerce data platform navigate to explores tab on the analytics page click on the explores dropdown on the left side of the page select one of the following options based on what you’d like to analyze messaging events use this explore to create session funnels and analyze campaign or flow performance messaging lists use this explore to dive into active subscriber counts messaging segments use this explore to analyze behavior based targeting in campaigns filtering & interpretation tips note klaviyo campaigns don’t include a field that explicitly identifies the channel (e g , email vs sms) campaigns rarely mix channels, so we recommend using event types and channel specific metrics for precision use campaign names to filter for one time sends if the campaign name is blank, the event likely came from a flow you can use touch type to distinguish flows from campaigns and external sources clicks and delivery outcomes are modeled separately by channel email and sms clicks are tracked independently rates like click through or bounce are also channel specific push messaging metrics include bounce, send, and open active subscriber modeling chord enhances klaviyo's list data by adding historical depth list membership klaviyo allows you to select lists when building a campaign, but doesn’t retain list membership counts over time chord enhancement we snapshot profile counts per list at regular intervals so you can track how many people were eligible for a campaign at send time; and understand historic list size and growth trends analysis not yet available identifying which users were members of specific lists for downstream activation