Guides

Version V1_5

Version V1_5

Released: <2026-07-01> · 2 changes · 0 breaking changes

V1_5 adds a new join key to Targeted & Excluded Customers and rebuilds the Engagement Activity pipeline for reliable incremental ingestion. All other views receive a version suffix bump only, with no schema change.

📘

Note on V1_4: version V1_4 was never shipped to production. The public versioning moves directly from V1_3 to V1_5.

VW_TARGETED_AND_EXCLUDED_CUSTOMERS_V1_5

Added

  • ACTION_SERIAL (NUMBER) — unique serial of the campaign action, positioned between PLAN_DETAIL_ID and CAMPAIGN_ACTION_ID. Links this view to VW_ENGAGEMENT_ACTIVITY.

VW_ENGAGEMENT_ACTIVITY_V1_5

Pipeline change (column schema unchanged — same 16 columns)

  • The view is now fed by a physical daily delta table, replacing the previous Snowflake Dynamic Table (12-hour refresh).
  • UPDATED_AT is now reliable and can be used as an incremental ingestion watermark.
  • Data accumulates indefinitely after the initial 365-day load.

All other views

Version suffix bump only (_V1_3 → _V1_5), no schema change: Scheduled Campaigns, Campaign Results, Triggered Campaigns, Customer Profiles, Engaged Customers, Streams, Streams Metadata, Streams Results, Campaigns in Streams, Customers in Treatments.

Migration

V1_2 and V1_3 views remain accessible (removed from navigation and search, but still queryable). To migrate, change the view suffix in your queries — all existing columns are preserved. Do not join views from different generations in a single query.