End Result – Pulse Revenue

Screenshots

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.

Home

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.

Product Revenue

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.

Month

This sheet records the Month of a given purchase.

Country

Discover order count, total revenue, and average order total per country.

2016 Orders

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.