Column
Description
user_idDenotes user identifier set by Capillary System
sku_purchasedDenotes total quantity of products purchased by customer so far
sku_returnedThe total quantity of products returned by customer so far
average_spent_per_skuThis is average amount of money a customer spends on a single quantity of product purchased in its lifetime with the brand
average_spent_per_visitThis is average amount of money a customer spends on a single visit to the store calculated over lifetime data with the brand
expired_pointsStands for the total number of un-redeemed points which got expired till date after its respective due date
first_visit_basket_sizeStands for the average quantity of products purchased on the first day of purchase by the customer
first_visit_bill_amountDenotes amount of money spent by the customer on his/her first visit
latencyDenotes average number of days between two successive visits on a customers
lifetime_pointsThe total points earned by the customers till date
lifetime_purchasedThe total purchase made by the customer till date
loyalty_pointsThe total amount of redeemable points available with the customer as on today
number_of_visitsTotal count of transactions made by customer till date. This counts date with time stamp
number_of_visit_daysTotal count of different dates where customer visited the store so far
redeemed_pointsTotal points burned by customer till date
redeemed_voucher_countTotal voucher redeemed by the customer till date
returned_bill_amountTotal count of bills returned by the customer till date
returned_bill_countTotal amount of bills returned by the customer till date
total_bill_countTotal purchase made by the customer till date
total_bill_amountTotal purchase made by the customer till date
total_line_item_amountTotal amount of products purchased by customer before tax and discount at bill level
total_returned_line_item_amountTotal amount of product amount returned by customer till date
conversion_dateDenotes the date in which a customer becomes loyal from non loyal
last_bill_dateLast date of customer purchase
first_bill_dateFirst date of customer purchase
first_redeemption_dateFirst date of customer points redemption
event_dateDate of registration
last_redeemption_dateLast date of customer points redemption
lapsation_dateStands for the date when customer will be called a lapsed customer
line_item_countSame as customer summary