Customer Point Summary Fact Table
Modified on: Fri, 16 Oct, 2020 at 6:49 PM
Points are a type of incentives issued to customers as a part of loyalty or promotion. This table summarizes loyalty-related KPIs of customers enrolled as part of Multi-Loyalty Programs (MLP).
Each row in the table represents a customer enrollment into MLP. A customer can have multiple enrollments (as a result, the table will have multiple rows with the same field name) as this table is relevant to Multi-Loyalty Programs. For example. if a customer enrolled into sub-programs A, B, and C of an MLP, there will be three rows in this table with the same field name related to A, B, and C respectively
|
Column Name | Field Name | Description |
Auto Update Time ce | auto_update_time_ce
| Date and time when the customer enrolment table is recently updated (Unix timestamp) |
Auto Update Time cps | auto_update_time_cps
| Date and time when the customer point summary table is recently updated (Unix timestamp) |
Customer Enrollment ID | customer_enrollment_ID
| Unique ID of each customer enrollment entry for the corresponding event program. |
Customer Slab | customer_slab
| Current loyalty slab of the customer based on the enrolled program. For each enrolled program, the customer will have a separate row in the table.
|
Event Date
| event_date
| Date of customer’s enrollment for the specific program. (Unix timestamp).
|
Event Program
| event_program
| Name of the program in which the customer is enrolled.
|
Event User ID
| event_user_ID
| User ID of the customer who gets enrolled by event program.
|
Event Zone Till
| event_zone_till
| It shows the Till from which the customer is enrolled in the MLP.
|
Last Tier Date Change
| last_tier_date_change
| Most recent date when the customer changed their slab from one tier to another. (Unix timestamp)
|
Latest Updated Date
| latest_updated_date
| Most recent date when the customer point summary table is updated. (Unix timestamp)
|
Latest Updated Time
| latest_updated_time
| Most recent time when the customer point summary table is updated. (Unix timestamp)
|
Tier Expiry Date
| tier_expiry_date
| The date on which the customer’s current loyalty slab expires.
|
Expired Points
| expired_points
| Total points expired for the customers till date.
|
Lifetime Points
| lifetime_points
| Stands for total points earned by the customers till date.
|
Loyalty Points
| loyalty_points
| The total points available for redemption till date
|
Redeemed Points
| redeemed_points
| The total points redeemed by the customers till date.
|
Year | year
| Year in which the customer is enrolled in MLP (year corresponding to event date).
|
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.