Klaviyo: Flows

Description

• Table of unique flow versions. A flow with 2 variations will have 2 distinct rows. Counts of the unique users and 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_, unique_count_, and sum_revenue_.

Supported Data Sources

• Klaviyo

Columns

Type	Name	Description
DATETIME	created_at	Timestamp of when the flow was first created.
STRING	flow_id	Unique ID of the flow.
STRING	flow_name	Name of the flow.
STRING	status	Current status of the flow. Either 'manual', 'live', or 'draft'. Read more here.
DATETIME	updated_at	Timestamp of when the flow was last updated.
BOOLEAN	is_archived	Boolean of whether this record has been archived
STRING	trigger_type	Corresponds to the object which triggered the flow.
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.
STRING	variation_id	Unique ID of the attributed flow variation group. This does not map onto another table.
INTEGER	total_count_unique_people	The count of the distinct people that have interacted with this flow.
DATETIME	first_event_at	Timestamp of the first ever interaction between this flow and a person.
DATETIME	last_event_at	Timestamp of the most recent interaction between this flow and a person.
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	unique_count_active_on_site
INTEGER	count_viewed_product
INTEGER	unique_count_viewed_product
INTEGER	count_ordered_product
INTEGER	unique_count_ordered_product
INTEGER	count_placed_order
INTEGER	unique_count_placed_order
INTEGER	count_refunded_order
INTEGER	unique_count_refunded_order
INTEGER	count_received_email
INTEGER	unique_count_received_email
INTEGER	count_clicked_email
INTEGER	unique_count_clicked_email
INTEGER	count_opened_email
INTEGER	unique_count_opened_email
INTEGER	count_marked_email_as_spam
INTEGER	unique_count_marked_email_as_spam
INTEGER	count_unsubscribed
INTEGER	unique_count_unsubscribed
INTEGER	count_received_sms
INTEGER	unique_count_received_sms
INTEGER	count_clicked_sms
INTEGER	unique_count_clicked_sms
INTEGER	count_sent_sms
INTEGER	unique_count_sent_sms
INTEGER	count_unsubscribed_from_sms
INTEGER	unique_count_unsubscribed_from_sms
STRING	flow_variation_key	Unique key hashed on the flow and variation IDs.