Customers in Treatments

Describes allocation of customers into different stream treatments by the date of allocation. Customers are being allocated to a "stream reference group" every day based on the conditions that are set in Stream creation tool in Optimove.

📘

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.

How to use it with other datasets

Join to customer profiles on CLIENT_CUSTOMER_ID and ALLOCATION_DATE & PROFILE_DATE to analyze customers distribution across streams and get insights from high performing campaigns

Query

-- FOR V1.6
SELECT *
FROM [SHARED_DB].BI.VW_CUSTOMERS_IN_TREATMENT_V1_6
LIMIT 10

🔑 Primary Keys

• Composite key - STREAM_ID, TREATMENT_ID, CUSTOMER_ID, ALLOCATION_DATE
• Watermark column - ALLOCATION_DATE

Table Description