Contacted Standard Export Template
The Contacted template is based on the Contact Info fact table.
This template consists of details of customers that were contacted for a specific campaign, except for timeline campaigns.
Measures
| Measure | Description |
|---|---|
| auto_update_time_comm_details | Date and time (in Unix timestamp) when communication details table is updated. |
| auto_update_time_contact | Date and time (in Unix timestamp) when the contact table is updated. |
| message_body | Template of the campaign message. |
| msg_id | This is the template id generated for each message template of a campaign. For example, if there are 5 types of messages sent in a campaign, it will have 5 msg_ids. |
| nsadmin_id | Communication id corresponding to a specific communication to a customer. This represents a granular level view of a specific communication. |
| open_count | Number of times the email message has been opened. |
| total_link_click_count | Total number of times the links within an email have been clicked by the customer. |
| unsubscribed | Captures the subscription status of the customer. If the customer has unsubscribed, it will be marked as "Yes"; if not, it will be marked as "Not yet". |
| year | Year of the communication. |
Dimensions
| Dimension Name | Description |
|---|---|
| Communication Type | Identifier for the type of communication received by the customer. |
| User | Unique identifier assigned to the customer by Capillary. |
| Campaign Group | Unique identifier assigned to the campaign group. Possible values are - Test, and Control. |
| Store Hierarchy (zone till) | Identifier assigned to the point-of-sale (POS) terminal within a store. |
| Concept Hierarchy | Identifier for the concept. |
| Ou Hierarchy | Identifier for the organization unit. |
| Communication Channel | Indicates the channel used for communicating with the customer. Possible values are - SMS, email, voicemail, etc. |
| Date | Date when the communication with the customer was done. |
| Time | Time when the communication with the customer was done. |
| Campaign Contact Date | Date when the customer was contacted. |
| Campaign Contact Time | Time when the customer was contacted. |
| Unsubscription Status | Unique ID for the unsubscription status, indicating whether the customer has opted to unsubscribe or not. |
| Link Open Date | Date when the email within a campaign was accessed. |
| Link Open Time | Time when the email within a campaign was accessed. |
| Campaign | Unique identifier assigned to the campaign. |
| Campaign Message | Unique identifier assigned to the message sent for the campaign. |
| Campaign Delivery Status | Unique identifier assigned to the campaign delivery status. Possible values: Sent, Delivered, Not Delivered, Failed. |
| Latest Updated Date | Latest date when the data is updated. |
| Latest Updated Time | Latest time when the data is updated. |
| Journey Block | Identifier of the journey block. It is the combination of journeyMetaId - journeyVersion - blockId. |
Updated 3 months ago