Campaign Results

Data and metrics of completed campaigns

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 occurrence, on each KPI tracked by Optimove, on each lifecycle stage. 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_6.

📘

Same across all versions: the schema of this view is identical in V1.3, V1.5, and V1.6 — only the view-name suffix changes. To migrate, change the suffix in your query.

Query

-- FOR V1.6
SELECT *
FROM [SHARED_DB].[BI].[VW_CAMPAIGN_RESULTS_V1_6]

-- FOR V1.5
SELECT *
FROM [SHARED_DB].[BI].[VW_CAMPAIGN_RESULTS_V1_5]

-- FOR V1.3
SELECT *
FROM [SHARED_DB].[BI].[VW_CAMPAIGN_RESULTS_V1_3]

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 this campaign

Primary Key

• Primary Key: PLAN_ID, LIFECYCLE_STAGE_ID, PLAN_DETAIL_ID, KPI, EXECUTION_DATE
• Watermark: Not available

Table Description