Forum Discussion
Tracking Customers Year Over Year
Hello I was wondering if anyone had any suggestions as to how I could track a customer ID#, date, and product type, to put together a list of which customer's are returning year after year, and how many items they are purchasing? I have the data captured but do not know how to display this visually... Thanks for the help!
Hi,
You have to go to Modelling > New Table and then write that formula in the formula bar.
22 Replies
Can you share some example data?
Hi CIWEB,
Could you post your table structures with some sample/mock data and the expected result, so that we can better assist on this issue? Do mask sensitive data before posting. :smileyhappy:
Regards
MAIL # Purchase Date Product Type 354 10/7/2016 Day Pass 214 10/8/2017 Night Pass 215 11/1/2017 Day Pass 789 11/1/2017 Day Pass 485 11/1/2017 Night Pass 784 2/6/2015 Day Pass 784 2/6/2015 Day Pass 784 2/6/2015 Day Pass 354 10/7/2017 Day Pass 215 10/9/2015 Day Pass 789 10/1/2014 Night Pass 354 10/7/2018 Day Pass 214 10/8/2015 Night Pass
Thank you for the responses. Above is the data that I would like to have analyzed...I am hoping to get results that look something like this...Year Total Customers by Mail # Number of Products Purchased New Customers Returning Customers 2015 15 33 15 0 2016 20 30 16 4 2017 30 55 15 15 2018 100 350 75 25
I would also be interested in Identifying specific customers by Mail# that held a pass in one given year, did not return the following year, but still returned at a later date.
Hopefully that makes sense. Please let me know if you have any futher questions!
