Skip to main content

Industry Comparison dashboard

Benchmark your week-over-week performance against the full Papaya merchant cohort: percentile gauge, revenue/orders/AOV % change lines, and waterfall driver decomposition.

Written by HB

What this dashboard is for

The Industry Comparison dashboard answers one question: "How is my outlet doing versus everyone else on Papaya?"

Every other dashboard compares you against yourself — last week, last year, your other outlets. This one compares you against the rest of the Papaya merchant base.

Open it when you want to know whether a soft week is your problem or a broader market trend. If the whole industry is down 10% and you're down 8%, you're actually beating the market.

The core concept: the active-outlet cohort

"Industry" here means every outlet on Papaya that did meaningful trade last week — specifically, an outlet whose revenue last week exceeded 5,000 (a low bar designed to exclude testing accounts, paused outlets, and never-launched outlets that would otherwise drag the median to nothing). Outlets failing that bar are not in the cohort.

Comparisons are relative — we compare your week-over-week percentage change against the distribution of every cohort outlet's WoW percentage change, not absolute revenue numbers. A small outlet and a large outlet on similar trajectories will look the same here. This makes the comparison fair regardless of outlet size.

The two "weeks" used everywhere

  • Last week (LW) — the most recent full week (Monday-to-Sunday in Bangkok time).

  • Prior week (PW) — the week before that.

All week boundaries are computed in Asia/Bangkok time.


1. Revenue | WoW Percentile vs Industry

Revenue WoW Percentile gauge

A gauge showing where your week-over-week revenue change ranks against every other active outlet on Papaya. A reading of 0.85 means you outperformed 85% of outlets last week (you're in the top 15%); 0.20 means 80% of outlets did better than you.

How it's calculated:

  1. Compute every active outlet's week-over-week revenue change: (LW revenue − PW revenue) / PW revenue.

  2. Rank-percentile that distribution: PERCENT_RANK() OVER (ORDER BY wow_pct).

  3. Read off your outlet's percentile.

Outlets that did less than 5,000 in LW are excluded from the cohort.

2. You | Revenue Change Drivers

Your revenue change drivers waterfall

A waterfall that decomposes your week-over-week revenue change into two contributors: # orders (volume) and AOV (average ticket size). The bars add up to the total WoW % change.

How it's calculated: we split revenue change into two effects using a symmetric-average decomposition:

  • Orders effect = (LW orders − PW orders) × ((LW AOV + PW AOV)/2) ÷ PW revenue

  • AOV effect = (LW AOV − PW AOV) × ((LW orders + PW orders)/2) ÷ PW revenue

So if your revenue grew 20% week-over-week and the chart shows 15% from "# orders" and 5% from "AOV", most of the growth came from selling more cheques.

3. Industry | Revenue Change Drivers

Industry revenue change drivers waterfall

The same waterfall, but for the entire active-outlet cohort instead of just you. Use it to read the market.

Reading it: if your waterfall is dominated by AOV and the industry's is dominated by orders, the broader market is being driven by traffic while you're being driven by ticket size — useful context for whatever you do next.

4. Revenue | Weekly % Change vs Industry

Revenue Weekly % Change vs Industry

A combo chart with the last ~13 weeks on the x-axis. Four lines:

  • You — your week-over-week % change in revenue.

  • Top Performers (25th %ile) — the cohort's 75th percentile (top quarter of outlets).

  • Avg Performers (Median) — the cohort's 50th percentile.

  • Bottom Performers (75th %ile) — the cohort's 25th percentile (bottom quarter).

Reading it: when your line is above the median, you outperformed the typical outlet that week. When you're above the top performers' line you're in the top quarter.

How it's calculated: for each of the last ~14 weeks, compute every cohort outlet's WoW revenue change. The percentiles are drawn from that distribution. The "You" line plots your own WoW number on top.

5. Orders | Weekly % Change vs Industry

Orders Weekly % Change vs Industry

Same chart as above, but the metric is order count rather than revenue.

6. AOV | Weekly % Change vs Industry

AOV Weekly % Change vs Industry

Same chart, metric is AOV (revenue ÷ orders).

Together with the two above this lets you triangulate: if your revenue is up but the industry's revenue is up more, look at orders and AOV — which lever is the rest of the market pulling that you're not?


How the comparison is defined

  • Cohort — every Papaya outlet whose revenue in the most recent full week exceeded 5,000. Same definition used across all charts.

  • Status filter — closed orders only (status = 'complete') with total > 0.

  • Comparison metric — week-over-week percentage change, not absolute values. This means a small outlet and a large outlet are treated equivalently.

  • Date fieldreportingDate.

  • Week boundaries — Monday-to-Sunday, Bangkok time.

  • Percentile direction — higher percentile = better performance. 0.99 is best, 0.01 is worst.

  • Privacy — no individual outlet, merchant, or competitor is identified anywhere. You only see your own number against the aggregate distribution.

Filters

  • Outlet — pinned to your outlet in the merchant portal. The whole dashboard is anchored on the one outlet whose performance you want to benchmark.

There is no date filter — the charts are anchored to the most recent full Bangkok-time week, and the time-series cards show a fixed ~14-week rolling window.

What this dashboard does NOT show

  • Your own historical trend — use the Trends dashboard.

  • Multi-outlet comparison within your merchant — use Outlets or Group KPIs.

  • Channel-level industry comparison — not currently broken out.

  • The identity of any other outlet or merchant — by design.

  • Margin or cost comparisons — see the Inventory module for your own data.

Did this answer your question?