Dec 16th, 2017
KPI’s that can help improve your e-commerce.
Measure the effectiveness of channels pay comparing revenue to marketing spend.
\[\text{ROI} = \frac{\text{Net Profit}}{\text{Total Investments}} \times 100\]Measure and compare variations for revenue, conversion rates, average order size, customer lifetime value and more.
\[\text{YOY} = \frac{\text{Sales this year}-\text{Sales last year}}{\text{Sales last year}}\]Understand the average value of a customer by using total profits, number of customers, and average number of years you retain a customer.
\[\text{CLV} = \text{AVG order value} \times \text{Net profit \%} \times \text{AVG customer retention} \times \text{AVG purchases per year} \times \text{AVG customer lifecycle in years}\]Determine the AOV overall and for each important channel.
\[\text{AOV} = \frac{\text{Total revenue}}{\text{Total number of orders}}\]Proportion of visits that result in purchases both overall and per channel.
\[\text{CR} = \frac{\text{Transactions}}{\text{Visits}} \times 100\]How much overall are you paying to get customers. This is not cost or conversion
\[\text{CAC} = \frac{\text{MCC} + \text{W} + \text{S} + \text{PS} + \text{O}}{\text{CA}}\]MCC: Total marketing campaign costs related to acquisition
W: Wages associated with marketing and sales
S: The cost of all marketing and sales software
PS: Any additional professional services used in marketing and sales
O: Other overheads realted to marketing and sales
CA: Total customers acquired
Per each important channel & per total
\[\text{CAR} = 1 - \frac{\text{the total number of people who start checkout}}{\text{the total number of add to cart clicks}}\]How many visits are you getting from all search volume.
\[\text{SPI} = \frac{\text{number of visitors}}{\text{number of searches}}\]How many users are on your website to buy a product.
\[\text{PI} = \frac{\text{visitors that want to buy}}{\text{all visitors}}\]Determined with post purchase surveys.
\[\text{Customer satisfaction scale} \rightarrow \text{scale 1-5}\]How many customers are willing to recommend you to their friends
\[\text{Net promoter score} \rightarrow \text{scale 1-10}\]