Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Customer Stickiness - Last Purchase analysis

I wish to create a matrix that shows the number of customers that made purchases in a month while segmenting it against the last purchase date.   April May June July August Sept 0-30 day...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Please share some sample data so that we could test the formula.

 

Best Regards,

Jay

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    please find demo table as requested

    Billing Doc NoBilling DateSales OrderSales Order DateCustomer Name
    2912.04.20222116.03.2022am
    3007.05.20222221.03.2022am
    3116.04.20222221.03.2022am
    3116.04.20222221.04.2022am
    3214.04.20222330.03.2022ch
    3305.04.20222431.03.2022ch
    3305.04.20222431.03.2022ch
    3305.04.20222431.03.2022ar
    3412.04.20222431.03.2022ar
    3412.04.20222531.04.2022ar
    3412.04.20222531.04.2022ar
    3412.04.20222531.04.2022ar
    3412.04.20222531.04.2022ar
    3412.04.20222531.04.2022ar
    3412.04.20222631.05.2022ar
    3412.04.20222631.05.2022ar
    3412.04.20222631.05.2022ar
    3412.04.20222631.05.2022ar