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