Get to know your e-commerce client’s customers
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.
Co-owner of the PPC agency Lynt. Writes at jakubkasparu.com.
Comments 2
BoeliK
Jakub Kasparu
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.
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.