Campaign Results

Explore Optimove's campaign results using this dataset, updated daily with metrics about campaigns that have been completed. In Optimove, this type of data is accessible by Mission Control and Campaign Analysis pages, providing data about the performance of a single campaign and aggregative data of several campaigns.

This table presents a row for each campaign occurance, on each KPI tracked by Optimove, on each lifecyclestage. Viewing a certain campaign occurrence performance can be achieved by summing [INCREASE_IN] for a selected KPI, from all lifecycle stages involved.

Notes:

• On different versions, a campaign's ID may appear as PLAN_ID. This value relates to a campaign ID, containing several PLAN_DETAIL_ID , representing campaign occurrences.
• It is recommended to stay up to date with the different VIEWS available for this data. Learn more about additional views on this data

📘

Latest version available: BI.VW_CAMPAIGN_RESULTS_V1_3. Learn more about versions

Glossary -

• CAMPAIGN_TYPE values -
  • 1 - Test / Control
  • 2 - A/B/n
  • 3 - A/B
  • 4 - No Control
  • 5 - Self - Optimizing
• TARGET_GROUP_PRIORITY - Represents the target group priority as set in Manage Target Groups in Optimove. The value 1000000 relates to Auto-Priority target groups.
• PLAN_DETAIL_ID - A campaign's action ID. Each action in a campaign is represented by an ID. e,g In Test / Control campaigns two different PLAN_DETAIL_ID will appear.
• PLAN_GROUPSIZE - The overall number of customers in a campaign in this campaign

V1_3

SELECT *
FROM [SHARED_DB].[BI].[VW_CAMPAIGN_RESULTS_V1_3]

Table Description