Customers In Treatments
Overview
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.
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
SELECT *
FROM VW_CUSTOMERS_IN_TREATMENT_V1_3 LIMIT 10🔑 Primary Keys
- Composite key -
STREAM_ID ****,TREATMENT_ID,CUSTOMER_ID,ALLOCATION_DATE - Watermark column -
ALLOCATION_DATE
Table Description
| Field Name | Description | Data Type | Format |
|---|---|---|---|
STREAM_ID | Identifier of the stream | NUMBER (38,0) | |
TREATMENT_ID | Identifier of the treatment | NUMBER (38,0) | |
CUSTOMER_ID | Internal identifier of the customer | NUMBER (38,0) | |
CLIENT_CUSTOMER_ID | Identifier of the customer as received from client’s systems | TEXT (200) | |
ALLOCATION_DATE | Date which the customer was allocated to streams | DATE |
Updated 1 day ago