Hello Everyone,
I need some help with an analysis on customer spending patterns. I have several years of data that shows by customer, what products they have purchased and what they paid for those products. What I would like to show is if customer bought product A in a given month, over the next 12 months, they also bought products D, E and G. In the same month, another customer bought product B from us and in the next 12 months, they also bought products D and E.
What is the best way to summarize the data? Ideally, I would like it to look something like this.
Initial Product Purchase Month of Initial Purchase Additional Products Purchased Over Next 12 Months
Basic Bundle August 2020 A, C, D, H
Executive Bundle August 2020 A, D, D, R
The initial product purchase would be one of our 4 bundled products. The additional products purchased over the next 12 months from the month of initial purchase would be any other products that were purchased after the initial sale.
Hopefully I've given enough details in my question.
Thank you in advance.
I need some help with an analysis on customer spending patterns. I have several years of data that shows by customer, what products they have purchased and what they paid for those products. What I would like to show is if customer bought product A in a given month, over the next 12 months, they also bought products D, E and G. In the same month, another customer bought product B from us and in the next 12 months, they also bought products D and E.
What is the best way to summarize the data? Ideally, I would like it to look something like this.
Initial Product Purchase Month of Initial Purchase Additional Products Purchased Over Next 12 Months
Basic Bundle August 2020 A, C, D, H
Executive Bundle August 2020 A, D, D, R
The initial product purchase would be one of our 4 bundled products. The additional products purchased over the next 12 months from the month of initial purchase would be any other products that were purchased after the initial sale.
Hopefully I've given enough details in my question.
Thank you in advance.
