# 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. | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/klaviyo-events.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.