Views - Engaged Customers
Targeting History under real time campaigns
Views are out-of-the-box data queries on top of the base structure of the data, providing easy access to common use cases required datasets and additional data useful to exploit the data lakes product fully.
Using views, Data lakes evolve while providing you with data contracts that will be kept and enable stable integrations with your internal platforms.
Overview
This view provides a snapshot of targeting history by triggered campaigns for Customers. Use this data to query monitor and analyses what triggered campaigns your customers are being targeted by and identify most engaging campaigns and templates.
-- FOR V1.1
SELECT *
FROM [SHARED_DB].[BI].[ENGAGED_CUSTOMERSS]
Column Name | Description | Data Type | Format |
---|---|---|---|
ID | Unique identifier for engagement record | Integer | |
CUSTOMERID | Unique identifier for the customer | String | |
ENGAGEDDATE | Date of engagement | Date | YYYY-MM-DD |
ACTIONSERIAL | ID of a campaign occurrence on a specific day | Integer | |
CAMPAIGNDETAILID | Unique identifier for the campaign detail | Integer | |
ISVISITOR | Flag indicating if the customer is a visitor | Boolean | |
OPTIMOVEID | Unique identifier assigned by Optimove | String | |
TEMPLATEID | Identifier for the engagement template | String |
Updated 7 months ago