Profiles Standard Export Template
This template is based on the profile_users fact.
A customer can register with the brand through multiple sources. For example, InStore , WeChat, Tmall , Mobile app or any other source. This template lets you export customer details from various sources. It currently does not capture InStore registrations.
Measures
Measure | Description |
---|---|
Auto Update Time Profile Users | Date and time when the corresponding record in the communications table available at the source was last updated. It is in the Unix timestamp format. |
Comm Channel Android | Unique identifier if the customer's profile was created using an Android app. |
Comm Channel Email | Email address associated with the customer's profile, specifically if the profile was created through an Android or iOS app. |
Comm Channel Ios | Unique identifier if the customer's profile was created using an iOS app. |
Comm Channel Mobile | Mobile number of the customer registered for communication. |
Comm Channel Wechat | WeChat id of a customer registered for communication. |
First Name | First name of the customer. |
Id Email | Email ID of the customer |
Id External | External ID of the customer. |
Id Mobile | Mobile number of the customer. |
Id Unique | Unique id of the customer generated internally. |
Last Name | Last name of the customer. |
Dimensions
Dimension Name | Description |
---|---|
User | User details such as user id, source, slab name, external id, fraud status, mobile, email, etc. |
User Segments | Segment details of the customers such as valued customer, lapsed customer. |
User Attributes | User attributes such as total visits, recent view. |
Date | Date attributes of the registration. |
Time | Time attributes of the registration. |
Store Hierarchy | Identifier for the store, till id. |
Concept Hierarchy | Identifier for the concept. |
Ou Hierarchy | Identifier for the organization unit. |
Channel Account | Identifier for the channel where the customer's profile was created. These include WhatsApp, Web_engage, Mobile_app, Line, and WeChat. |
Latest Updated Date | Latest date when the data is updated. |
Latest Updated Time | Latest time when the data is updated. |
Source Profile Type | Identifier for the source where the customer's profile was created. If the customer's profile was created in-store, the value will be 'Instore', and if not, the value will be 'Not-instore'. |
Updated 2 months ago