End Result – Pulse Revenue
Here are screenshots of the end result of each sheet.
I’m only sharing 2 of the month specific sheets, as all months share the same structure.
Color coded areas show whether the trend is positive or negative compared to the previous time period.
Orders By Product By Month
See how much money each product makes per month.
Orders By Category By Month
View total revenue per category per month.
Products By Category
This is where you tell Pulse which Category a product is in.
See value per product over the entire year.
Orders By Recency
While I track just Last 7, Last 30, and Last 90 days, you could create any rolling average you want by using this sheet.
Orders By Product
Another way of viewing revenue per product.
This sheet records the Month of a given purchase.
Discover order count, total revenue, and average order total per country.
This lists all orders during the year and comes from PlusThis. If you have many orders each year (over 10,000), you may want to break this down in to quarters. If you have less than 1,000 orders per year, you may want to combine years.
2016 January Orders
Each month’s order sheet lists all orders for that month.
2016 January Table
Each month’s order table aggregates order data per product for the month.