Before you start your new e-commerce campaign you should have a look at your client’s customers behavior. You might not have much experience with RFM analysis, but you can certainly answer the following questions quite easily:
- What’s the time between orders?
- What’s the average profit per customer?
- What percent of customers return?
How to do it:
- Just copy this spreadsheet template to your Google Drive.
- Insert some data from your e-commerce system:
- Email address.
- Date of the order.
- Value of the order.
- Then find answers on second sheet within spreadsheet.
this is a great idea, thanks for sharing!
however, i can’t seem to get it working ; in the copy the report is not updated if i change the input. The hidden sheets are not updates either.
Jakub Kasparu says
Do you make a copy in google docs, or you downloaded it as excel spreadsheet? You have to work in in google spreadsheet. Be careful about formats of three columns there, date, email, and price.
Hello. magnificent job. I did not anticipate this. This is a fantastic story. Thanks!
movie download sites says
Hey! This is my very first comment on your website so I really wanted to give a fast shout out and tell you I truly enjoy reading your blog posts. Can you suggest other sites that go over free hd movies online? I am as well really keen on that thing! Many thanks!