V1.2 - Triggered Campaigns

VW_TRIGGERED_CAMPAIGNS (Updated)

FKA "RT_CAMPAIGNS"

SELECT *
  FROM [SHARED_DB].BI.VW_TRIGGERED_CAMPAIGNS_V1_2

Overview

This table holds the details of triggered campaigns. Triggered campaigns function similarly to scheduled campaigns but are executed based on specific events rather than schedules. The target groups they run on are the same as the target groups for scheduled campaigns. One key difference is that triggered campaigns are documented in the data only a day later.

Use Cases and Examples

Which campaigns were executed on a specific target group?
- This use case allows users to track which triggered campaigns were executed for a given target group across different events.
Which campaigns were executed based on a specific event?
- This use case is useful for understanding how specific events trigger campaigns and their outcomes.

Table Description (Updated)

Column Name	Description	Type	Format
`CAMPAIGN_DETAIL_ID`	ID of the triggered campaign, parallel to `PLAN_DETAIL_ID` in scheduled campaigns	String
`CAMPAIGN_ACTION_ID`	Action ID associated with the triggered campaign action	String
`ISOLATION_VOLUME`	Volume of isolation for the campaign	Float
`TARGET_GROUP_ID`	Unique ID of the target group used in the campaign	String
`EVENT_ID`	Unique ID of the event that triggered the campaign	String
`START_DATE`	First day when the campaign became active	Date	yyyy-mm-dd
`END_DATE`	Last day when the campaign was active; may be `NULL` if the campaign runs indefinitely	Date	yyyy-mm-dd
`IS_ACTIVE`	Indicates if the campaign is currently active	Boolean
`PRIORITY`	Priority level of the target group or sub-campaign	Integer
`IS_CONTROL_ENABLED`	Indicates if a control group is enabled for the campaign	Boolean
`CAMPAIGN_TYPE`	Type of the campaign (e.g., event-triggered, transactional, etc.)	String
`EXCLUSION_TYPE`	Indicates if certain groups or segments are excluded from the campaign (target group or campaign level)	String
`LAST_UPDATED_TIME`	Timestamp of the last update to the campaign record	Date	yyyy-mm-dd HH:MM:SS

Key Changes (Version Update):

CAMPAIGN_DETAILID is now CAMPAIGN_DETAIL_ID
ACTION_ID is now CAMPAIGN_ACTION_ID
TARGET_GROUP_SERIAL is now TARGET_GROUP_ID
Several column names were retained, while some formatting changes were applied to improve clarity.