Column
Description
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 total number of unredeemed points which got expired till date after its respective due date
first_visit_basket_sizeStands for 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
latencyStands for average number of days between two successive visits on a customers
lifetime_pointsStands for total points earned by the customers till date
lifetime_purchasedStands for total purchase made by the customer till date
line_item_countSands for total amount of different products bought by the customers till date
loyalty_pointsThe total amount of redeemable points available with the customer as on today
number_of_visit_daysThe total count of different dates where customer visited the store so far
number_of_visitsThe total count of transactions made by customer till date. This counts date with time stamp
redeemed_pointsStands for total points burned by customer till date
redeemed_voucher_countStands for the total voucher redeemed by the customer till date
returned_bill_amountThe total amount of bills returned by the customer till date
returned_bill_countThe total count of bills returned by the customer till date
sku_purchasedThe total quantity of products purchased by customer so far
skus_returnedThe total quantity of products returned by customer so far
total_bill_amountStands for total purchase made by the customer till date
total_bill_countThe total transactions made by customer same as number of visits
total_line_item_amountThe total amount of products purchased by customer before tax and discount at bill level
total_returned_line_item_amountThe total amount of product amount returned by customer till date