Engagement Activity

Overview

The VW_ENGAGEMENT_ACTIVITY_V1_2 view provides detailed data on customer engagements with campaigns they were targeted with, updated daily alongside other datasets. This view tracks interactions at the channel level, represented by PLAN_DETAIL_CHANNEL_ID, allowing for granular insights into how customers engage with each communication channel within a campaign.

Each row represents an engagement of a customer with a certain campaign, capturing key performance metrics such as message opens, clicks, and unsubscribes, along with timestamps for each interaction.

This data is essential for analyzing campaign and content effectiveness and customer behavior across different channels.

SELECT * 
FROM [SHARED_DB].BI.VW_ENGAGEMENT_ACTIVITY_V1_2

Notes:

View name - VW_ENGAGEMENT_ACTIVITY_V1_2
Data is shared daily, together with rest of the data.
Table contains each customer engagements with each campaign they were targeted with.
Engagements are measured against a PLAN_DETAIL_CHANNEL_ID , represents a communication on a single channel of a campaign.
All timestamps are in UTC

Table Description

Field Name	Description	Data Type	Format
`CUSTOMER_ID`	Unique identifier for the customer	String
`CLIENT_CUSTOMER_ID`	Unique identifier for the client’s customer	String
`SEND_ID`	Unique identifier for the send action	String
`ACTION_SERIAL`	Sequence number for the action	Integer
`PLAN_DETAIL_ID`	Campaign action ID	String
`PLAN_DETAIL_CHANNEL_ID`	Unique identifier for the channel used in the plan detail	String
`CHANNEL_ID`	Unique identifier for the communication channel	String
`CHANNEL_NAME`	Name of the communication channel	String
`IS_DELIVERED`	Timestamp of campaign delivery, in UTC	DateTime	yyyy-mm-dd HH:MM:SS
`IS_OPENED`	Timestamp of the first time a customer opened a message, in UTC	DateTime	yyyy-mm-dd HH:MM:SS
`IS_CLICKED`	Timestamp of the first time a customer clicked a message, in UTC	DateTime	yyyy-mm-dd HH:MM:SS
`IS_UNSUBSCRIBED`	Timestamp of the first time a customer unsubscribed, in UTC	DateTime	yyyy-mm-dd HH:MM:SS
`IS_DROPPED`	Timestamp of the first time a customer's message was dropped, in UTC	DateTime	yyyy-mm-dd HH:MM:SS
`IS_SPAM_REPORT`	Timestamp of the first time a customer reported as spam, in UTC	DateTime	yyyy-mm-dd HH:MM:SS
`IS_BOUNCED`	Timestamp of the first time a customer's message bounced, in UTC	DateTime	yyyy-mm-dd HH:MM:SS
`UPDATED_AT`	Timestamp when the record was last updated	DateTime	yyyy-mm-dd HH:MM:SS

Use cases

Analyze customers’ engagement by their demographic details
Analyze templates and channels that created the most engagement.
Cross with VW_TRANSACTIONS to analyze relations b/w engagement and purchases.