Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm working on the classic new/lost customer problem using set analysis. I've found a few examples on the forum, but they don't seem to fit exactly what I'm after. I'm using the AsOf table approach with a "MonthsBack" field. Attached is a simple example of where I'm getting stuck.
I expected that the set
{ <MonthsBack={'0'}> - <MonthsBack={'>0<4'}>}
would give me Customers who ordered in the current month and did not order in the prior three months. It's not working. Any idea where I'm going wrong?
Thanks,
Rob
Hi,
This post is very singular, is refered to customers, is refered to set analysis, with partipation of 3 big referents.
Thanks Rob, John y Oleg.
Yes is very very singular and very useful
Thank's for sharing
Saludos
EC
Yes, this is a great post, quite surprised there aren't many more New Customer analysis threads. This works well but takes an unsurprisingly long amount of time and consumes a large amount of resources when trying to calculate from a dataset with circa 10 million records over 15 months, and I will be required to expand this data set. Is this the most efficient way of doing this?
How do I set/get the 'MonthsBack' and 'AsOfYearMonth' ?