Metrics and reporting

How the same ASIN can be growing and losing momentum

An ASIN can be up year over year and down against the previous period. Learn what each comparison means and how to report both honestly.

Collins Paris2 min read

An ASIN generated $70,000 over the last four weeks. The previous four weeks produced $100,000. The same four weeks last year produced $50,000.

The ASIN is down 30 percent against the previous period and up 40 percent year over year.

Both statements are accurate. Alone, each tells an incomplete story.

Every comparison has a job

Previous period shows momentum

Comparing the last four weeks with the four weeks immediately before them answers a near-term question: is the product accelerating or slowing down?

This view is good at finding recent breaks. It is also vulnerable to promotions, stockouts, launch spikes, holidays, and differences in weekday mix.

Year over year controls for seasonality

Comparing a period with the same period last year helps when demand follows a seasonal pattern. It answers whether the business is larger or smaller at a similar point in the calendar.

It can still flatter a recent decline. A product that doubled early in the year and then gave back part of the gain may remain well ahead of last year.

A trailing window shows persistence

A longer rolling view helps distinguish a rough week from a change in direction. Four, eight, or twelve weeks can each be useful depending on the product's volume and sales cycle.

The right window is long enough to reduce ordinary noise and short enough to catch the problem while it can still be acted on.

Match the comparison to the decision

DecisionComparison to start with
Did something break recently?Previous complete period, with matching weekdays
Are we growing through a seasonal cycle?Same period last year
Is this a durable trend?Longer trailing windows
Did a promotion work?A comparable promoted period and a normal baseline
Is a new product progressing?Since-launch cohorts or planned launch milestones

No single window deserves to become the permanent headline for every question.

Remove obvious distortions

Before interpreting the percentage, mark anything that changed the opportunity to sell:

  • Prime Day or another event landed in only one period
  • A coupon, deal, or price change began or ended
  • The product was unavailable for part of a period
  • A child ASIN entered or left the variation family
  • Advertising spend changed sharply
  • The current period is incomplete

Sometimes the right answer is to keep the event in the comparison and explain it. Sometimes the event makes the comparison useless. Hiding it is the only clearly wrong choice.

Report the tension

For the example above, the honest headline is simple:

The ASIN remains 40 percent ahead of last year, but revenue has fallen 30 percent over the last four weeks. Most of the decline began after the promotion ended, and sessions have not recovered.

That sentence gives the reader scale, direction, timing, and a lead to investigate. "Up 40 percent year over year" sounds better. "Down 30 percent" sounds more urgent. The combined version is more useful.

The purpose of a comparison is to understand the business. Pick the window after deciding what you need to know.

  • Business Reports