Members Standard Export Template
This export template is based on the customer_summary fact table. It contains details of members (loyalty and non-loyalty customers) and non-members based on the last updated date or event date (registration date).
Measures
Measure Name | Description |
---|---|
Redeemed Points | Total points redeemed by the customer since registration. |
First Visit Basket Size | Number of items purchased during the customer's first transaction. |
Number Of Visit Days | Total number of different days on which the customer has visited the store, since registration. |
Returned Bill Amount | The total amount corresponding to the items returned by the customer, since registration. |
Loyalty Points | Total number of points that the customer can redeem as of today. |
Expired Points | Total points that have expired for the customer since registration. |
First Visit Bill Amount | Total amount spent by the customer during their first transaction. |
Average Spent Per Visit | Average amount of money a customer spends during each visit they make to the store (total amount spent divided by number of visits). |
Redeemed Voucher Count | Total number of vouchers redeemed by the customer, since registration. |
Lifetime Points | Total points accumulated by the customer since registration. |
Number Of Visits | Total number of transactions made by the customer since registration. |
Lifetime Purchased | Total amount spent by the customer since registration. |
Sku Purchased | Total number of different product types (SKUs) purchased by the customer, since registration. Stock Keeping Unit (SKU) is a unique identifier assigned to each distinct product or item in inventory. |
Average Spent Per Sku | Average amount spent by the customer on each product type (that is, per SKU). Stock Keeping Unit (SKU) is a unique identifier assigned to each distinct product or item in inventory. |
Returned Bill Count | Total number of bills for which the items have been returned by the customer, since registration. |
Total Bill Amount | Total amount spent by the customer across all the bills, since registration. |
Total Line Item Amount | Total amount spent on all line items purchased by the customer across all the bills, since registration. |
Total Returned Line Item Amount | Total amount refunded for all individual line items returned by the customer, since registration. |
Total Bill Count | Total number of transactions made by the customer since registration. |
Skus Returned | Total number of different product types (SKUs) returned by the customer, since registration. |
Line Item Count | Total number of items purchased by the customer, since registration. |
Latency | Average number of days between two successive visits made by the customer. |
Dim Preferred Store Id | Preferred store where the customer performs most of the transactions. |
Auto Update Time Loyalty | Date and time when the corresponding record in the loyalty table available at the source was last updated. It is in the Unix timestamp format. |
Auto Update Time Cps | Date and time when the corresponding record in the customer_point_summary table available at the source was last updated. It is in the Unix timestamp format. |
Auto Update Time Extnd | Date and time when the corresponding record in the extended field table available at the source was last updated. It is in the Unix timestamp format. |
Last Visit Bill Amount | Total amount spent by the customer during their most recent transaction. |
Max Bill Amount | Highest amount spent by the customer in a single transaction, since registration. |
Max Bill Count In Week | Maximum number of transactions made by the customer in a week, since registration. |
Max Bill Count In Day | Maximum number of transactions made by the customer in a single day, since registration. |
Redeemed Visit Days | Total number of days on which the customer redeemed points during visits, since registration. |
Redemption Latency | Average number of days between two successive point redemptions by the customer. |
Redeemed Visits | Total number of visits during which the customer redeemed points, since registration. |
Points Awarded Days | Total number of days on which the customer received points, since registration. |
Redeemed Rate | Ratio of redeemed transactions to the total transactions, since registration. |
Total Points Redeemed | Total points that have been redeemed by the customer, since registration. |
Loyalty Id | Unique identifier for the loyalty source table. |
Last Updated By Till Id | Records the till id (point of sale) where the customer details were last updated. |
Has Spike Bill | Records whether the customer has ever made a purchase that is 10 times greater than their average spending. It is mainly used for detecting fraud. |
Max Zones With Billing On Same Day | Maximum number of zones where the customer made a transaction in a single day, since registration. |
Cancelled Points | Cancelled points are the number of reverted points. That is, issued points that were reverted due to reasons like transaction return. |
Max Bill Hour Count In Day | Maximum number of transactions made by the customer in an hour in a single day, since registration. |
Dimensions
Dimension Name | Description |
---|---|
Source | Source through which the customer got registered, such as in-store, app, WeChat, e-comm, Facebook, campaigns, etc. |
Time | Time attributes. |
Last Purchased Store | Identifier of the point-of-sale (till) where the customer made their most recent purchase. |
Last Purchased Concept Store | Identifier of the concept store where the customer made their most recent purchase. |
Conversion Date | Date when the customer is converted from a non-loyalty customer to a loyalty customer. |
Last Txn Date | Records the date of the most recent transaction. |
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. |
Store Hierarchy | Identifier for the store, till id. |
Concept Hierarchy | Identifier for the concept. |
Ou Hierarchy | Identifier for the organization unit. |
Conversion Time | Time when the customer is converted from a non-loyalty customer to a loyalty customer. |
First Txn Date | Date when the customer did their first transaction or purchase. |
First Redemption Date | Records the date of the first redemption of coupons. |
Loyalty | Provides customer's loyalty status, which can be categorized as: loyalty, non-loyalty, or not registered. |
Date | Date attributes. |
Last Redemption Date | Records the date of the most recent redemption of coupons. |
Lapsation Date | Lapsation date of the customer, calculated as the last bill date plus 90 days. |
Preferred Order Channel | Stores the preferred channel through which the customer places orders, such as online, in-store, mobile app, etc. |
First Purchased Till | The identifier of the store's till where the customer made their first transaction. |
First Purchased Concept Store | Identifier of the concept store where the customer made their first transaction. |
Dob | Denotes the customer's date of birth. |
Wedding Date | Stores the customer's wedding date. |
First Points Redemption Date | The date when the customer first redeemed loyalty points. |
Last Points Redemption Date | The date of the most recent loyalty points redemption. |
Repeat | Indicates if the customer has made repeat purchases or if it was their first transaction. |
First Awarded Date | The date when the customer was first awarded loyalty points. |
Latest Updated Date | Latest date when the data is updated. |
Latest Updated Time | Latest time when the data is updated. |
Joined Date | Records the loyalty registration date for the customer. |
Updated 2 months ago