Klaviyo: Person Campaign Flow

Description

  • Table that aggregates event metrics to the person-campaign or -flow grain (but note that if a user interacts with 2 different variations of a flow/campaign somehow, they will have 2 records). Also note that organic interactions (someone with null campaign_id/flow_id) are included in this table. Counts of the instances of the events, as well as sums of the numeric value associated with events (i.e. revenue) will be pivoted out into columns, as configured by the klaviyo__count_metrics and klaviyo__sum_revenue_metrics variables, respectively. See the dbt_project.yml file for the default metrics used. These columns will be prefixed with count_ and sum_revenue_.

Supported Data Sources

  • Klaviyo

Columns

Type
Name
Description

STRING

person_id

Foreign key referencing the PERSON who interacted with the flow/message.

STRING

last_touch_campaign_id

Foreign key referencing the CAMPAIGN attributed with these metrics (by the package's attribution model).

STRING

last_touch_flow_id

Foreign key referencing the FLOW attributed with these metrics (by the package's attribution model).

STRING

campaign_name

A name for this campaign. If not specified, this will default to the subject of the campaign.

STRING

flow_name

Name of the flow.

STRING

variation_id

Unique ID of the attributed flow or campaign variation group. This does not map onto another table.

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.

DATETIME

first_event_at

Timestamp of the first ever interaction between this campaign/flow and a person. In other words, the first event trigger attributed to the campaign/flow.

DATETIME

last_event_at

Timestamp of the most recent interaction between this campaign/flow and a person. In other words, the last event trigger attributed to the campaign/flow.

INTEGER

sum_revenue_refunded_order

INTEGER

sum_revenue_placed_order

INTEGER

sum_revenue_ordered_product

INTEGER

sum_revenue_checkout_started

INTEGER

sum_revenue_cancelled_order

INTEGER

count_active_on_site

INTEGER

count_viewed_product

INTEGER

count_ordered_product

INTEGER

count_placed_order

INTEGER

count_refunded_order

INTEGER

count_received_email

INTEGER

count_clicked_email

INTEGER

count_opened_email

INTEGER

count_marked_email_as_spam

INTEGER

count_unsubscribed

INTEGER

count_received_sms

INTEGER

count_clicked_sms

INTEGER

count_sent_sms

INTEGER

count_unsubscribed_from_sms

Last updated

Was this helpful?