Targeted and Excluded Customers

Overview

Describes relation between a campaign and the customer who received it. This table also contains the relation between a campaign and customers that were eligible to receive it but were excluded for a different campaign, on a higher prioritized target group.

This table includes customers that are targeted only scheduled campaigns.

All different entities are described in the Glossary

📣

Latest version available: BI.VW_TARGETED_AND_EXCLUDED_CUSTOMERS_V1_2. Learn more

(FKA ACTION_SERIALS_CUSTOMER)

-- FOR V1.1 
SELECT *
  FROM [SHARED_DB].VW_TARGETED_AND_EXCLUDED_CUSTOMERS

Use Cases & Examples

• Which and How many customers were included in test / control group in campaign X, in timeframe Y?

-- Customer level view
SELECT * FROM VW_TARGETED_AND_EXCLUDED_CUSTOMER
WHERE PLAN+ID = [CAMPAIGN ID] and EXECUTION_DATE < '2023-02-16'

-- Aggregated Campaign View
SELECT PLAN_ID,COUNT(*) FROM VW_TARGETED_AND_EXCLUDED_CUSTOMER
WHERE PLAN+ID = [CAMPAIGN ID] and EXECUTION_DATE < '2023-02-16'
GROUP BY PLAN_ID

-- Campaign Actions view (Test/Control)
SELECT PLAN_ID,COUNT(*) FROM VW_TARGETED_AND_EXCLUDED_CUSTOMER
WHERE PLAN_ID = [CAMPAIGN ID] and EXECUTION_DATE < '2023-02-16'
GROUP BY PLAN_ID, PLAN_DETAIL_ID