May 2026

Schema changes

Rokt

Effective May 11, 2026 we use a new May 2026 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to align with source changes.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

172 total changes • 112 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ACCOUNT_CAMPAIGN_BREAKDOWN`
column	Discontinued Column	`acquisitions_by_conversion_date`
column	Discontinued Column	`acquisitions_by_referral_date`
column	Discontinued Column	`audiences`
column	Discontinued Column	`campaign_countries`
column	Discontinued Column	`campaigns`
column	Discontinued Column	`creatives`
column	Discontinued Column	`date_end`
column	Discontinued Column	`date_start`
column	Discontinued Column	`group_by_value` 🔑		No longer primary key
column	Discontinued Column	`impressions`
column	Discontinued Column	`referrals`
column	New Column		`acquisitions_by_conversion_time`
column	Primary Key Change		`campaign_id` 🔑	New primary key
column	Primary Key Change		`datetime` 🔑	New primary key
column	New Column		`device`
column	New Column		`impression`
column	New Column		`referral`
column	New Column		`unique_audience`
column	New Column		`unique_campaign`
column	New Column		`unique_campaign_country`
column	New Column		`unique_creative`
`ACCOUNT_SUMMARY`
column	Discontinued Column	`campaign_summary_acquisitions_by_conversion_date`
column	Discontinued Column	`campaign_summary_acquisitions_by_referral_date`
column	Discontinued Column	`campaign_summary_audiences`
column	Discontinued Column	`campaign_summary_campaign_countries`
column	Discontinued Column	`campaign_summary_campaigns`
column	Discontinued Column	`campaign_summary_creatives`
column	Discontinued Column	`campaign_summary_gross_cost`
column	Discontinued Column	`campaign_summary_impressions`
column	Discontinued Column	`campaign_summary_net_cost`
column	Discontinued Column	`campaign_summary_referrals`
column	Primary Key Change	`date_end` 🔑	`date_end`	No longer primary key
column	Primary Key Change	`date_start` 🔑	`date_start`	No longer primary key
column	Discontinued Column	`transaction_summary_impressions`
column	Discontinued Column	`transaction_summary_placement_impressions`
column	Discontinued Column	`transaction_summary_positive_placement_engagements`
column	Discontinued Column	`transaction_summary_purchases`
column	Discontinued Column	`transaction_summary_referrals`
column	Discontinued Column	`transaction_summary_revenue`
column	Discontinued Column	`transaction_summary_rpm`
column	Discontinued Column	`transaction_summary_rpt`
column	Discontinued Column	`transaction_summary_transactions`
column	New Column		`acquisitions_by_conversion_time`
column	Primary Key Change		`campaign_country` 🔑	New primary key
column	Primary Key Change		`campaign_id` 🔑	New primary key
column	New Column		`click_thru_acquisitions`
column	New Column		`click_thru_acquisitions_by_conversion_time`
column	Primary Key Change		`datetime` 🔑	New primary key
column	New Column		`gross_cost`
column	New Column		`impressions`
column	New Column		`net_cost`
column	New Column		`referrals`
column	New Column		`unique_audiences`
column	New Column		`unique_campaign_countries`
column	New Column		`unique_campaigns`
column	New Column		`unique_creatives`
`ACCOUNT_TRANSACTION_BREAKDOWN`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	Calculation Change
column	Discontinued Column	`group_by_value`
column	Discontinued Column	`placement_impressions`
column	Discontinued Column	`positive_placement_engagements`
column	New Column		`age_range`
column	New Column		`datetime`
column	New Column		`gender`
column	New Column		`layout_impressions`
column	New Column		`page_type`
column	New Column		`partner_id`
column	New Column		`positive_layout_engagements`
`ACCOUNT_TRANSACTION_OVERVIEW`
column	Primary Key Change	`date_end` 🔑	`date_end`	No longer primary key
column	Primary Key Change	`date_start` 🔑	`date_start`	No longer primary key
column	Discontinued Column	`placement_impression`
column	Discontinued Column	`positive_placement_engagement`
column	Primary Key Change		`datetime` 🔑	New primary key
column	New Column		`layout_impressions`
column	New Column		`positive_layout_engagements`
`CAMPAIGN_BREAKDOWN_AUDIENCE`
column	Discontinued Column	`account_campaign_breakdown_value` 🔑		No longer primary key
column	Discontinued Column	`acquisitions_by_conversion_date`
column	Discontinued Column	`acquisitions_by_referral_date`
column	Discontinued Column	`audiences`
column	Discontinued Column	`campaign_countries`
column	Discontinued Column	`campaigns`
column	Discontinued Column	`creative_name`
column	Discontinued Column	`creatives`
column	Discontinued Column	`date_end`
column	Discontinued Column	`date_start`
column	Discontinued Column	`group_by_value` 🔑		No longer primary key
column	Discontinued Column	`impressions`
column	Discontinued Column	`referrals`
column	New Column		`acquisitions_by_conversion_time`
column	Primary Key Change		`audience_name` 🔑	New primary key
column	Primary Key Change		`campaign_id` 🔑	New primary key
column	Primary Key Change		`datetime` 🔑	New primary key
column	New Column		`device`
column	New Column		`impression`
column	New Column		`referral`
column	New Column		`unique_audience`
column	New Column		`unique_campaign`
column	New Column		`unique_campaign_country`
column	New Column		`unique_creative`
`CAMPAIGN_BREAKDOWN_COUNTRY`
column	Discontinued Column	`account_campaign_breakdown_value` 🔑		No longer primary key
column	Discontinued Column	`acquisitions_by_conversion_date`
column	Discontinued Column	`acquisitions_by_referral_date`
column	Discontinued Column	`audiences`
column	Discontinued Column	`campaign_countries`
column	Discontinued Column	`campaigns`
column	Discontinued Column	`creative_name`
column	Discontinued Column	`creatives`
column	Discontinued Column	`date_end`
column	Discontinued Column	`date_start`
column	Discontinued Column	`group_by_value` 🔑		No longer primary key
column	Discontinued Column	`impressions`
column	Discontinued Column	`referrals`
column	Discontinued Column	`results_grouped_by`
column	New Column		`acquisitions_by_conversion_time`
column	Primary Key Change		`campaign_country` 🔑	New primary key
column	Primary Key Change		`campaign_id` 🔑	New primary key
column	Primary Key Change		`datetime` 🔑	New primary key
column	New Column		`device`
column	New Column		`impression`
column	New Column		`referral`
column	New Column		`unique_audience`
column	New Column		`unique_campaign`
column	New Column		`unique_campaign_country`
column	New Column		`unique_creative`
`CAMPAIGN_BREAKDOWN_CREATIVE`
column	Discontinued Column	`account_campaign_breakdown_value` 🔑		No longer primary key
column	Discontinued Column	`acquisitions_by_conversion_date`
column	Discontinued Column	`acquisitions_by_referral_date`
column	Discontinued Column	`audiences`
column	Discontinued Column	`campaign_countries`
column	Discontinued Column	`campaigns`
column	Discontinued Column	`creatives`
column	Discontinued Column	`date_end`
column	Discontinued Column	`date_start`
column	Discontinued Column	`group_by_value` 🔑		No longer primary key
column	Discontinued Column	`impressions`
column	Discontinued Column	`referrals`
column	Discontinued Column	`results_grouped_by`
column	New Column		`acquisitions_by_conversion_time`
column	Primary Key Change		`campaign_id` 🔑	New primary key
column	Primary Key Change		`creative_id` 🔑	New primary key
column	Primary Key Change		`datetime` 🔑	New primary key
column	New Column		`device`
column	New Column		`impression`
column	New Column		`referral`
column	New Column		`unique_audience`
column	New Column		`unique_campaign`
column	New Column		`unique_campaign_country`
column	New Column		`unique_creative`
`CAMPAIGN_BREAKDOWN_SUBVERTICAL`
column	Discontinued Column	`account_campaign_breakdown_value` 🔑		No longer primary key
column	Discontinued Column	`acquisitions_by_conversion_date`
column	Discontinued Column	`acquisitions_by_referral_date`
column	Discontinued Column	`audiences`
column	Discontinued Column	`campaign_countries`
column	Discontinued Column	`campaigns`
column	Discontinued Column	`creatives`
column	Discontinued Column	`date_end`
column	Discontinued Column	`date_start`
column	Discontinued Column	`group_by_value` 🔑		No longer primary key
column	Discontinued Column	`impressions`
column	Discontinued Column	`referrals`
column	Discontinued Column	`results_grouped_by`
column	New Column		`acquisitions_by_conversion_time`
column	Primary Key Change		`campaign_id` 🔑	New primary key
column	Primary Key Change		`datetime` 🔑	New primary key
column	New Column		`device`
column	New Column		`impression`
column	Primary Key Change		`partner_sub_vertical` 🔑	New primary key
column	New Column		`referral`
column	New Column		`unique_audience`
column	New Column		`unique_campaign`
column	New Column		`unique_campaign_country`
column	New Column		`unique_creative`
`CAMPAIGN_HISTOGRAM`
table	Discontinued Table	`CAMPAIGN_HISTOGRAM`