Triggered Campaigns

FKA "RT_CAMPAIGNS"

SELECT *
  FROM [SHARED_DB].BI.VW_TRIGGERED_CAMPAIGNS

Overview

This table holds the details of triggered campaigns. Triggered campaigns are parallel to scheduled campaigns, but the target groups they run on are the same target groups.

Triggered campaigns are documented to the data only a day later.

Use Cases and Examples

Which campaign were executed on a specific target group?
Which campaign were executed on a specific event?

Column Name	Description	Type	Format
`CAMPAIGN_DETAILID`	ID of campaign, parallel to PLAN_ID	String
``ACTION_ID`	Action ID, convert to name	String
`ISOLATION_VOLUME`	Isolation volume	Float
`TARGET_GROUP_SERIAL`	Target Group ID	String
`EVENT_ID`	Event ID	String
`START_DATE`	First day of this camapign being active	Date	yyyy-mm-dd
`END_DATE`	Last day of this campaign. this might be null, and then a campaign runs forever.	Date	yyyy-mm-dd
`IS_ACTIVE`	Is active	Boolean
`PRIORITY`	Priority of a target group? or a campaign priority? Priority of a sub campaign?	Integer
`IS_CONTROL_ENABLED`	is there a control group?	Boolean
`CAMPAIGN_TYPE`	TBD
`EXCLUSION_TYPE`	Include all / exclude? is it from Tg or campaign level?	String
`LAST_UPDATED_TIME`	Timestamp of the record	Date