End Result – Pulse Revenue

Topic Progress:

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.
home

Orders By Product By Month

See how much money each product makes per month.
orders-by-product-by-month

Orders By Category By Month

View total revenue per category per month.
orders-by-category-by-month

Products By Category

This is where you tell Pulse which Category a product is in.
products-by-category

Product Revenue

See value per product over the entire year.
product-revenue

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-recency

Orders By Product

Another way of viewing revenue per product.
orders-by-product

Month

This sheet records the Month of a given purchase.
month

Country

Discover order count, total revenue, and average order total per country.
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-orders

2016 January Orders

Each month’s order sheet lists all orders for that month.
2016-january-orders

2016 January Table

Each month’s order table aggregates order data per product for the month.
2016-january-table

>