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
Last Purchased Store; Last Purchased Concept Store; Conversion Date; Last Txn Date; User; User Segments; User Attributes; Store Hierarchy; Concept Hierarchy; Ou Hierarchy; Conversion Time; First Txn Date; First Redemption Date; Loyalty; Date; Last Redemption Date; Lapsation Date; Preferred Order Channel; First Purchased Till; First Purchased Concept Store; Dob; Wedding Date; First Points Redemption Date; Last Points Redemption Date; Repeat; First Awarded Date; Voucher Redemption Status; Points Redemption Status; Latest Updated Date; Latest Updated Time; Joined Date; Source; Time
Updated 7 days ago