Klaviyo: Events

Description

• Table of Klaviyo events, enriched with attribution data (see int_klaviyo__event_attribution for details), and information regarding the event's associated user, flow, campaign, and platform/integration. Note: this model has an incremental materialization. Custom event-columns specified by the klaviyo__event_pass_through_columns variable will appear here as well.

Supported Data Sources

• Klaviyo

Columns

Type	Name	Description
STRING	variation_id	Unique ID of the attributed flow or campaign variation group. This does not map onto another table.
STRING	campaign_id	Foreign key referencing the CAMPAIGN that the event is attributed to.
DATETIME	occurred_at	Timestamp of when the event was triggered.
STRING	flow_id	Foreign key referencing the FLOW that the event is attributed to.
STRING	flow_message_id	Unique ID of the FLOW_MESSAGE that the event is attributed to. This does not map onto another table.
STRING	event_id	Unique ID of the event.
STRING	metric_id	Foreign key referencing the metric being captured.
STRING	person_id	Foreign key referencing the PERSON who triggered the event.
STRING	uuid	Universally Unique Identifier of the event.
STRING	numeric_value	Numeric value associated with the event (ie the dollars associated with a purchase).
DATETIME	_fivetran_synced	UTC Timestamp that indicates the start time of the Fivetran job that synced this event row.
STRING	source_relation	The source where this data was pulled from. If you are making use of the union_schemas variable, this will be the source schema. If you are making use of the union_databases variable, this will be the source database. If you are not unioining together multiple sources, this will be an empty string.
DATE	occurred_on	Calendar date (UTC) on which the event occurred.
STRING	unique_event_id	The unique identifier for the combination of event_id and source_relation columns.
STRING	touch_id	Coalescing of the Klaviyo-attributed campaign_id and flow_id.
STRING	touch_type	Type of touch/message that the event itself is already attributed to in Klaviyo. Either 'flow', 'campaign', or null. Note that the package will refer to campaign and flow interactions as "touches".
STRING	type	Type of event that was triggered. This is the same as the METRIC name.
STRING	last_touch_campaign_id	Foreign key referencing the CAMPAIGN that the event is attributed to by the package.
STRING	last_touch_flow_id	Foreign key referencing the FLOW that the event is attributed to by the package.
DATETIME	last_touch_at	Timestamp of when, relative to the current event, this person last interacted with a campaign or flow according to Klaviyo. This will be null if the event is not attributed to any flow or campaign.
STRING	last_touch_event_type	The type of event through which, relative to the current event, the person last interacted with a campaign or flow. This information is used to determine which lookback window to use (email vs sms). This will be null if the event is not attributed to any flow or campaign.
STRING	last_touch_type	What kind of touch the event was attributed to by the package -- 'campaign', 'flow', or null.
STRING	campaign_name	A name for this campaign. If not specified, this will default to the subject of the campaign.
STRING	campaign_type	Type of campaign.
STRING	campaign_subject_line	Type of campaign.
STRING	flow_name	Name of the flow.
STRING	person_city	City that the person who triggered this event lives in.
STRING	person_country	Country that the person who triggered this event lives in.
STRING	person_region	Region or state that the person who triggered this event lives in.
STRING	person_email	The email address and the unique identifier for the person who triggered the event.
STRING	person_timezone	Timezone that the person who triggered this event is situated in.
STRING	integration_id	Foreign key referencing the integration.
STRING	integration_name	Name of the platform that triggered the event (either Klaviyo, the API, or another integration).
STRING	integration_category	Use-case category of the platform that sent the event.