Triggered Campaigns

Campaigns plan for triggered campaigns

Overview

This table holds metadata and details of triggered campaigns. This table holds details about campaigns that are set in Optimove and their details

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

Data is updated daily on an update method, updated with any data that is being edited campaign configuration.

Read more about terminology in Data Share Glossary


V1.3

--- For V1.3
SELECT *
  FROM [SHARED_DB].[BI].[VW_TRIGGERED_CAMPAIGNS_V1_3]

🔑 Primary Key

  • Primary KeyCAMPAIGN_IDCAMPAIGN_DETAILID
  • Watermark ColumnLAST_UPDATED_TIME

Table Description

Column NameDescriptionTypeFormat
**CAMPAIGN_ID**ID of triggered campaignNUMBER(38,0)
**CAMPAIGN_DETAILID**ID of the triggered campaign, parallel to PLAN_DETAIL_ID in scheduled campaignsNUMBER(38,0)
**CAMPAIGN_ACTION_ID**ID of the action within a campaign or 1 for control groupNUMBER(38,0)
**CAMPAIGN_ACTION_NAME**Name of the campaign action or DN for control groupTEXT(16777216)
**CAMPAIGN_TYPE**Type of the campaign (e.g., event-triggered, transactional, etc.)NUMBER(38,0)
**CAMPAIGN_TYPE_NAME**Name of the campaign typeTEXT(16777216)
**ISOLATION_VOLUME**Volume of isolation for the campaignNUMBER(38,0)
**TARGET_GROUP_ID**Unique ID of the target group used in the campaignNUMBER(38,0)
**TARGET_GROUP_NAME**Name of the target groupTEXT(1700)
**EVENT_ID**Unique ID of the event that triggered the campaignTEXT(510)
**START_DATE**First day when the campaign became activeDATEyyyy-mm-dd
**END_DATE**Last day when the campaign was active; may be NULL if the campaign runs indefinitelyDATEyyyy-mm-dd
**IS_ACTIVE**Indicates if the campaign is currently activeNUMBER(38,0)
**PRIORITY**Priority level of the target group or sub-campaignNUMBER(38,0)
**IS_CONTROL_ENABLED**Indicates if a control group is enabled for the campaignNUMBER(38,0)
**EXCLUSION_TYPE**Indicates if certain groups or segments are excluded from the campaign (target group or campaign level)NUMBER(38,0)
**LAST_UPDATED_TIME**Timestamp of the last update to the campaign recordTIMESTAMP_TZyyyy-mm-dd HH:MM:SS