The Members template is based on the fact Customer_summary.
It contains details of members (loyalty and non-loyalty customers) and non-members based on the last updated date or event date (registration date). You can export other customer details such as
- Custom fields
- Extended fields
- User segments
- Current slab
- Audience group
- Customers registered in a specific duration (up to one year)
Measures
| Measure | Description |
| auto_update_time_loyalty | Date and time (in Unix timestamp) when the loyalty table is updated |
| average_spent_per_sku | This is average amount spent by a customer on a single quantity over lifetime |
| average_spent_per_visit | The average amount spent by a customer per visit over lifetime. Total purchase amount ÷ Number of visits |
| cancelled_points | -NA- |
| expired_points | Number of points of a loyalty customer that are expired as per the expiry strategy set |
| first_visit_basket_size | The quantity of items purchased at the first time of shopping |
| first_visit_bill_amount | The purchase amount of a customer at the first time of shopping |
| first_redemption_date | Date when the customer first redeemed a coupon |
| has_spike_bill | Whether there is a sudden increase in the bill amount of a customer. This is used to observe any suspicious behavior in a customer's transaction |
| last_updated_by_till_id | Till id at which a member customer details are recently updates. It could be profile information, transactions, points, or any other details |
| last_visit_bill_amount | Transaction amount of the recent bill of a customer |
| last_redemption_date | Recent date when the customer redeemed a coupon |
| latency | Duration from a customer's recent transaction |
| lifetime_points | Total number points earned by the customers till date |
| lifetime_purchases | Total purchases amount of a customer customers till date |
| line_item_count | Total number of lineitems purchased by a customer |
| loyalty_points | Total points available for redemption in a customer's loyalty account. Again these points can be redeemed based on the redemption condition such as minimum number of points that can be redeemed and redemption allowed only in multiples of X |
| max_bill_amount | Maximum transaction amount of single bill of a customer |
| max_bill_count_in_day | Maximum transaction amount of a customer in one day |
| max_bill_count_in_week | Maximum transaction amount of a customer in one week |
| max_bill_hour_count_in_day | Hour of a day in which maximum transaction amount has been recorded for a customer |
| max_zones_with_billing_on_same_day | Maximum number of transactions made by a customer in different stores of a zone on a single day. Used for fraud detection |
| number_of_visit_days | Unique number of days when a customer made transactions |
| number_of_visits | Total number of times a customer made transactions. So, this value could be same as transaction count of a customer. |
| points_awarded_days | Number of days when points are awarded to a customer |
| redeemed_points | Number of points redeemed by a customer |
| redeemed_rate | Percentage of points redemption, that is, the percentage ratio of the total number of customers that earned points to the total number of customers that redeemed points |
| redeemed_visits | Unique number of days a customer visited the stores and redeemed points |
| redeemed_voucher_count | Number of coupons redeemed by a customer |
| redemption_latency | Average gap in number of days between two consecutive redemption |
| returned_bill_amount | Total amount of return transactions |
| returned_bill_count | Total number of transactions or bills returned |
| sku_purchased | Total number of items purchased by a customer excluding the item quantity |
| skus_returned | Total number of items returned by a customer excluding the item quantity |
| total_bill_amount | Total purchase amount of a customer |
| total_bill_count | Total number of bills or transactions made by a customer |
| total_line_item_amount | Sum of individual purchase prices of each total line-item |
| total_points_redeemed | Total number of points redeemed by a customer |
| total_returned_line_item_amount | Total amount of returned lineitems. A lineitem return amount is same as the purchase amount |
Dimensions
Conversion_date, conversion_time, dob, date, time, user, store hierarchy, concept hierarchy, first_awarded_date, first_txn_date, first_points_redemption_date, first_purchased_store, first_purchased_concept_store, last_purchased_concept_store, first_redemption_date, lapsation_date, last_txn_date, last_points_redemption_date, last_purchased_store, last_redemption_date, latest_updated_date, latest_updated_time, loyalty_type, points_redemption_status, preferred_store, repeat, source, voucher_redemption_status, user segments (optional), wedding date