Members Standard Export Template

Suggest Edits

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 25 days ago