Integration Specifications

The Klaviyo Summary Statistics integration pulls aggregated reporting data from Klaviyo for:

• Campaigns & Flows: Contains performance data such as Sends, Opens, Clicks, Conversions, and Conversion values segmented by Campaign and Flow

• Lists & Segments: Contains profile counts by day for lists & segments

List & Segment growth history is not available

We capture List & Segment profile counts by snapshotting each list & segment's profile count at the time of extraction. Since we cannot go back in time using these APIs, we only load list & segment profile count data starting with the date of the first run of your integration.

This means if you set up the integration on February 14, you will only have data from February 14 onward.

Refresh Cadence

By default the Klaviyo Summary Statistics integration loads data once per day.

Availability

This integration is available for:

• Enterprise

• Growth

API Endpoints

This extractor use the Klaviyo Developer API. The following endpoints are used to replicate data into Daasity:

• Query Flow Series

• Query Campaign Values

• Get Campaigns

• Get Flows

• Get List

• Get Segment

KLAVIYO_V2 Schema

The Klaviyo Summary Statistics extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

• Statistics Campaign Values

• Statistics Campaigns

• Statistics Flow Values

• Statistics Flows

• Statistics List Profile Count

• Statistics Lists

• Statistics Segment Profile Count

• Statistics Segments

Statistics Campaign Values

• Endpoint: Query Campaign Values

• Update Method: UPSERT

• Table Name: klaviyo_v2.statistics_campaign_values

JSON Element	Database Column
	report_id
UTC date when the data was extracted	extraction_date
data.attributes.results[].groupings.send_channel	send_channel
data.attributes.results[].groupings.campaign_id	campaign_id
data.attributes.results[].statistics.opens	opens
data.attributes.results[].statistics.bounced	bounced
data.attributes.results[].statistics.delivered	delivered
data.attributes.results[].statistics.clicks	clicks
data.attributes.results[].statistics.opens_unique	opens_unique
data.attributes.results[].statistics.conversion_uniques	conversion_uniques
data.attributes.results[].statistics.conversion_value	conversion_value
data.attributes.results[].statistics.conversions	conversions
data.attributes.results[].statistics.bounced_or_failed	bounced_or_failed
data.attributes.results[].statistics.clicks_unique	clicks_unique
data.attributes.results[].statistics.failed	failed
data.attributes.results[].statistics.recipients	recipients
data.attributes.results[].statistics.spam_complaints	spam_complaints
data.attributes.results[].statistics.unsubscribes	unsubscribes
data.attributes.results[].statistics.unsubscribes_uniques	unsubscribes_uniques
Klaviyo API key used for extraction	__source_id
	__sync_key
Merchant account id from the Daasity app	_account_id
UTC timestamp when the data was extracted	__synced_at

Statistics Campaigns

• Endpoint: Get Campaigns

• Update Method: UPSERT

• Table Name: klaviyo_v2.statistics_campaigns

JSON Element	Database Column
	id
UTC date when the data was extracted	extraction_date
data[].attributes.name	name
data[].attributes.status	status
data[].attributes.archived	archived
data[].attributes.created_at	created_at
data[].attributes.scheduled_at	scheduled_at
data[].attributes.updated_at	updated_at
data[].attributes.send_time	send_time
Klaviyo API key used for extraction	__source_id
	__sync_key
Merchant account id from the Daasity app	_account_id
UTC timestamp when the data was extracted	__synced_at

Statistics Flow Values

• Endpoint: Query Flow Series

• Update Method: UPSERT

• Table Name: klaviyo_v2.statistics_flow_values

JSON Element	Database Column
	report_id
UTC date when the data was extracted	extraction_date
data.attributes.results[].groupings.send_channel	send_channel
data.attributes.results[].groupings.flow_id	flow_id
data.attributes.results[].groupings.flow_message_id	flow_message_id
data.attributes.results[].statistics.opens	opens
data.attributes.results[].statistics.bounced	bounced
data.attributes.results[].statistics.delivered	delivered
data.attributes.results[].statistics.clicks	clicks
data.attributes.results[].statistics.opens_unique	opens_unique
data.attributes.results[].statistics.conversion_uniques	conversion_uniques
data.attributes.results[].statistics.conversion_value	conversion_value
data.attributes.results[].statistics.conversions	conversions
data.attributes.results[].statistics.bounced_or_failed	bounced_or_failed
data.attributes.results[].statistics.clicks_unique	clicks_unique
data.attributes.results[].statistics.failed	failed
data.attributes.results[].statistics.recipients	recipients
data.attributes.results[].statistics.spam_complaints	spam_complaints
data.attributes.results[].statistics.unsubscribes	unsubscribes
data.attributes.results[].statistics.unsubscribes_uniques	unsubscribes_uniques
Klaviyo API key used for extraction	__source_id
	__sync_key
Merchant account id from the Daasity app	_account_id
UTC timestamp when the data was extracted	__synced_at

Statistics Flows

• Endpoint: Get Flows

• Update Method: UPSERT

• Table Name: klaviyo_v2.statistics_flows

JSON Element	Database Column
	id
UTC date when the data was extracted	extraction_date
data[].attributes.name	name
data[].attributes.status	status
data[].attributes.archived	archived
data[].attributes.created	created_at
data[].attributes.updated	updated_at
data[].attributes.trigger_type	trigger_type
Klaviyo API key used for extraction	__source_id
	__sync_key
Merchant account id from the Daasity app	_account_id
UTC timestamp when the data was extracted	__synced_at

Statistics List Profile Count

• Endpoint: Get List

• Update Method: UPSERT

• Table Name: klaviyo_v2.statistics_list_profile_count

JSON Element	Database Column
data[].id	list_id
UTC date when the data was extracted	extraction_date
data[].attributes.profile_count	profile_count
Klaviyo API key used for extraction	__source_id
	__sync_key
Merchant account id from the Daasity app	_account_id
UTC timestamp when the data was extracted	__synced_at

Statistics Lists

• Endpoint: Get List

• Update Method: UPSERT

• Table Name: klaviyo_v2.statistics_lists

JSON Element	Database Column
data[].id	list_id
data[].attributes.name	name
data[].attributes.created	created
data[].attributes.updated	updated
data[].attributes.opt_in_process	opt_in_process
Klaviyo API key used for extraction	__source_id
	__sync_key
Merchant account id from the Daasity app	_account_id
UTC timestamp when the data was extracted	__synced_at

Statistics Segment Profile Count

• Endpoint: Get Segment

• Update Method: UPSERT

• Table Name: klaviyo_v2.statistics_segment_profile_count

JSON Element	Database Column
data[].id	segment_id
UTC date when the data was extracted	extraction_date
data[].attributes.profile_count	profile_count
Klaviyo API key used for extraction	__source_id
	__sync_key
Merchant account id from the Daasity app	_account_id
UTC timestamp when the data was extracted	__synced_at

Statistics Segments

• Endpoint: Get Segment

• Update Method: UPSERT

• Table Name: klaviyo_v2.statistics_segments

JSON Element	Database Column
data[].id	segment_id
data[].attributes.name	name
data[].attributes.created	created
data[].attributes.updated	updated
data[].attributes.is_active	is_active
data[].attributes.is_processing	is_processing
data[].attributes.is_starred	is_starred
Klaviyo API key used for extraction	__source_id
	__sync_key
Merchant account id from the Daasity app	_account_id
UTC timestamp when the data was extracted	__synced_at