Klaviyo: Persons

Description

• Table of unique person profiles, enhanced with event, campaign, flow, and revenue metrics. Counts of instances of triggered events and sums of the numeric value (i.e. revenue) associated with events (total vs organic/not attributed to flows or campaigns) will be pivoted out into columns, as configured by the klaviyo__count_metrics and klaviyo__sum_revenue_metricsvariables, respectively. See the dbt_project.yml file for the default metrics used. These columns will be prefixed with total_count_, total_sum_revenue_ (organic + attributed), and organic_sum_revenue_ (not attributed to a campaign or flow).

Supported Data Sources

• Klaviyo

Columns

Type	Name	Description
STRING	person_id	Unique ID of the user if you use your own unique identifier. Otherwise, Klaviyo recommends using the email as the primary key.
STRING	address_1	First line of the person's address.
STRING	address_2	Second line of the person's address.
STRING	city	City they live in.
STRING	country	Country they live in.
STRING	zip	Postal code where they live.
DATETIME	created_at	Timestamp of when the person's profile was created.
STRING	email	The email address for a profile.
STRING	full_name	Person's full name.
STRING	latitude	Latitude of the person's location.
STRING	longitude	Longitude of the person's location.
STRING	organization	Business organization they belong to.
STRING	phone_number	Associated phone number.
STRING	region	Region or state they live in.
STRING	timezone	Timezone they are situated in.
STRING	title	Title at their business or organization.
DATETIME	updated_at	Timestamp of when the person profile was last updated.
DATETIME	last_event_date
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.
INTEGER	count_total_campaigns	Count of the number of campaigns this person has interacted with.
INTEGER	count_total_flows	Count of the number of flows this person has interacted with.
DATETIME	first_event_at	Timestamp of when the user first triggered an event (not limited to campaign and flow interactions).
DATETIME	last_event_at	Timestamp of when the user last triggered an event (not limited to campaign and flow interactions).
DATETIME	first_campaign_touch_at	Timestamp of when the user first interacted with a campaign.
DATETIME	last_campaign_touch_at	Timestamp of when the user last interacted with a campaign.
DATETIME	first_flow_touch_at	Timestamp of when the user first interacted with a flow.
DATETIME	last_flow_touch_at	Timestamp of when the user last interacted with a flow.
INTEGER	total_sum_revenue_refunded_order
INTEGER	organic_sum_revenue_refunded_order
INTEGER	total_sum_revenue_placed_order
INTEGER	organic_sum_revenue_placed_order
INTEGER	total_sum_revenue_ordered_product
INTEGER	organic_sum_revenue_ordered_product
INTEGER	total_sum_revenue_checkout_started
INTEGER	organic_sum_revenue_checkout_started
INTEGER	total_sum_revenue_cancelled_order
INTEGER	organic_sum_revenue_cancelled_order
INTEGER	total_count_active_on_site
INTEGER	total_count_viewed_product
INTEGER	total_count_ordered_product
INTEGER	total_count_placed_order
INTEGER	total_count_refunded_order
INTEGER	total_count_received_email
INTEGER	total_count_clicked_email
INTEGER	total_count_opened_email
INTEGER	total_count_marked_email_as_spam
INTEGER	total_count_unsubscribed
INTEGER	total_count_received_sms
INTEGER	total_count_clicked_sms
INTEGER	total_count_sent_sms
INTEGER	total_count_unsubscribed_from_sms