I'm a data-based marketer, so I have done plenty of things with spreadsheets. I make spreadsheets for myself, and I'm sharing this with all of you too!
This Free KPI Metrics Summary for E-commerce template is helpful for e-com marketers or small business owners to analyze their sales and website data.
I use this myself, and it has a bunch of metrics that I track and use to help me understand what's working and what isn't in my campaigns.
The Summary is divided into five categories:
2. Customer Analytics - quick view of the new vs. old customers of your website
3. Sales Acquisition Analytics - from which channels do the sales come from
4. Marketing Spend - quick view of paid media expenses
5. Sales Comparison - comparing last year's vs. this year's sales performance
Every website or brand has its own set KPIs so feel free to modify the sheet based on your needs.
No comments: