Stats Compass
Home Commerce Blog

Did my sale make money?

Check a Black Friday, or any sale, against the sales you'd have had anyway, and see whether the discount paid for itself. It's free, and it uses the same calculations as the Stats Compass app.

Your file never leaves your computer.

The calculator runs in this page. Once it says it's ready, you can disconnect from the internet and it still works. It loads its statistics libraries from jsdelivr, and Cloudflare counts the visit, without cookies; your file is read here and isn't sent anywhere.

Getting the calculator ready…

First visit downloads about 30 MB; on a slow connection this can take a few minutes.

1. Export your daily sales from Shopify

In Shopify, go to Analytics → Reports and open Total sales over time. Set it to show Day, from at least 13 months before your sale to 3 weeks after it, then Export it as a CSV.

Tip: if your report only exports by month, ask Sidekick: "Export Total sales over time by day as a CSV, from start date to end date."

3. The sale

Did you run any other sales in this time? Add their dates, so they aren't counted as normal sales.

4. Your usual margin