Triggered Campaigns
Campaigns plan for 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 |
Updated 7 months ago