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

V1.0 -

-- FOR V1.0 (FKA ACTION_SERIAL_CAMPAIGNS)
SELECT *  
FROM [SHARED_DB].[BI].[CAMPAIGN_RESULTS]

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

Use Cases & Examples

• Which are my top performing campaign, by KPI X, on timeframe Y?
• SQL

  SELECT PLAN_ID, SUM(INCREASE_IN) as TotalKPIIncrease
  FROM [SHARED_DB].BI.VW_CAMPAIGN_RESULTS
  WHERE KPI = 'Net Revenue' AND 
        EXECUTION_DATE >= '2023-06-11' AND 
        END_TEST_DATE <= '2023-12-31'
  GROUP BY PLAN_ID
  ORDER BY TotalKPIIncrease DESC
  LIMIT 10;
  

• How many campaigns do I have with campaign property X (reevaluate, run now, run anyway, conditional exec, recurrence type) in timeframe Y?
• Which and How many campaigns were targeted on TG X?
• Which and How many campaigns were targeted on Action Y?
• SQL

  SELECT PLAN_ID, COUNT(*) AS ActionYCount
  FROM VW_CAMPAIGN_RESULTS
  WHERE ACTION_TYPE = 'Action Y'
  GROUP BY PLAN_ID
  ORDER BY ActionYCount DESC;
  

• Which and How many campaigns were targeted on Channel W?
• Which and How many test types (SOC, test / control, A/B/N) were launched on timeframe X?
• Performance by test types (SOC, test / control, A/B/N) were launched on timeframe X?
• Which and How many ad-hoc campaigns and recurring campaigns were out on timeframe X?

Table Columns