Skip to content

No account required

Start a project

5 min · 4 sections

Analysis for people who sell things online.

Store platforms report revenue well and profit badly. The gap between the two is where most of the useful analysis lives.

By Data Analysis App team

How do I work out which of my products actually make money?

Store platforms report revenue accurately and profit badly, because margin needs cost data the platform does not hold and shipping cost often sits in a third place. Work out contribution per unit after discounts, channel and payment fees, shipping and returns. The common result is a bestseller that loses money on every order and is invisible in every revenue chart.

Section 01

Revenue is the number your platform is best at, and least useful

Every store dashboard shows revenue, because revenue is the one figure the platform holds completely. Margin needs cost data the platform does not have, and shipping cost is often in a third place entirely.

That is why the most common surprise in ecommerce analysis is a bestseller that loses money on every order: it is highly visible in the revenue chart and invisible in every margin chart, because there is no margin chart.

In the worked example, the product carrying 68% of the growth had a gross margin nine points below the portfolio.

Section 02

Repeat rate moves slowly and matters more than it looks

Growth from new customers and growth from returning customers look identical in a revenue chart and behave completely differently over a year. A store growing on new customers alone has to keep buying them.

The number to watch is what share of orders come from people who bought before, tracked monthly. It moves slowly enough that a single month tells you nothing and a six-month trend tells you a great deal.

Section 03

Refunds concentrate, and concentration is the signal

A portfolio refund rate is nearly useless: it averages a fine product with a broken one. The useful version is refund rate by product, compared against the catalogue average, with the products that stand out named.

A product refunding at three times the average is usually a listing problem, a sizing problem or a quality problem, and which one it is can normally be read off the returns data itself.

Section 04

What you need to upload

An orders export first. Every figure in the report is computed from one table, and with an orders export that is the one holding revenue, order volume and repeat purchasing. A returns export and a product cost sheet can go up alongside it: each is read, converted and handed back as a download, and the report names any relationship it can see between them, but nothing is computed across two files.

It does not need to be tidy. Merged cells, several tables on one sheet and four date formats are the normal case.

See it on a real project

Product A produced 68% of total growth while repeat purchasing fell from 31% to 24%.

What is making this store's growth less durable?

Keep reading

Put the checks to work on your file.

Upload an export to get checked findings, then use the definitions and review steps in this guide to assess the result. Your business context still matters.

  • Review findings and their supporting evidence
  • Inspect the repairs made to your data
  • See the results before buying downloadable outputs

No account needed to start. You only pay when you like what you see.