Campaign Results

V1.0 -

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

Learn more about additional views on this data

Overview

This table describes the campaign entity and its properties. Each campaign has its results in all different KPIs

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