With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I need 3 years of transaction data.
The main sheet there will be 100 customers with the cells that hold
3.Total Spend ($ purchase amount ranging from $100- $250,000)
4.Frequency (# of reservations)
5.Recency (day of last visit)
One the second sheet the cells will hold their respective transaction data.
the data must match from the first to second sheet. i.e
Customer Mike Smith total spend is $18,000 and has 7 reservations with the last reservation a month ago.
His transaction record should indicate 7 transactions all totaling $18,000 with the last transaction be the one that brings the total to $18,000.
We are building an RFM model and need 3 years of transaction data to get a good probability model.
This needs to be submitted as one excel file with the two sheets within them.
Sign in or Register to see more