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 am looking for someone that can take an excel spreadsheet with approximately 55,000 data lines and create formulas to determine our lifetime customer values. In other words, we need to take the data and determine how many times someone has ordered, how much they ordered, what products they ordered, and the total dollar amount spent. Every customer is unique by email address. We offer monthly recurring billing that some customers stay on for years and others may drop off in the first month. We really need to determine what our customer value really is so we can better decide how much we can spend to acquire a customer. In addition to some of the recurring customers dropping off the service, some will discontinue the automatic monthly billing, but will buy product every few months as needed. We need to be able to account for that as well. In addition to the lifetime value of the customer, we are interested in figures that should be determined in the process such as, median values, m...
Sign in or Register to see more