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?
Sorry we couldn't be helpful. Help us improve this article with your feedback.