YOptima · Commerce Intelligence

Commerce Intelligence

Ten thousand retail transactions, one calendar year, five questions a CEO actually asks - answered live from the database, not a slide.

● Live from Supabase · portfolio.yoptima_sales10,000 rows2024-01-01 → 2024-12-31

Revenue

₹6.02 Cr

10,000 transactions

Gross Profit

₹2.72 Cr

45.1% margin

Avg Order Value

₹6,023

12,401 units sold

Return Rate

6.2%

share of orders returned

Avg Rating

3.84

post-purchase (1-5)

Online Delivery

3.6 days

online only

The 60-second CEO read · Q5

You give away ₹58.43 L a year in discounts - for zero extra sales.

That's ≈22% of annual profit, yet discount depth has no link to volume (correlation -0.02). Electronics-Online is the revenue base - leadership already knows that; the discount leak is the number that's actually movable.

Bank the certain recovery first: pull back the deepest discounts (the 21-30% band sells the fewest units) → ≈₹9.52 L-₹14.27 L/yr, almost all to profit, in 1-2 quarters. Full range in Q4.

Which sales channel is performing better - Online or In-Store?

Online is the growth engine

Revenue by channel

Online

₹4.41 Cr

In-Store

₹1.61 Cr

Online is 73% of revenue on near-equal order counts (4,986 vs 5,014).

AOV

₹8,849 on

₹3,213 in-store

Margin

45.1% on

45.2% in-store

Return rate

7.9% on

4.5% in-store

Avg rating

3.84 on

3.84 in-store

Read: Online wins on top line, not efficiency - margins are identical (~45%); the lever is the 2.8× basket (Electronics skews online). Watch the higher online return rate.

The business wants to cut its lowest-revenue region. Is that the right call?

No - don't cut it

West

₹1.54 Cr

North

₹1.52 Cr

South

₹1.50 Cr

East

₹1.46 Cr

Read: All four regions sit in a 5.5% band - East is "lowest" by noise, yet earns ₹65.68 L profit at 45% margin. Cut weak cities, not a region.

Which marketing channel delivers the best results - what to double down on, what to cut?

Scale Social + Email

Marketing channel	Revenue	Share	AOV	Return rate	Rating
Social Media	₹1.76 Cr	29%	₹5,993	5.9%	3.83
Search Ads	₹1.54 Cr	26%	₹6,055	6.2%	3.85
Email	₹1.26 Cr	21%	₹6,259	5.8%	3.83
Direct / Walk-in	₹87.14 L	14%	₹5,821	7.1%	3.89
Referral	₹58.28 L	10%	₹5,852	6.2%	3.78

Read: Social = volume (29% of revenue) - double down. Email = efficiency (top AOV ₹6,259, lowest returns 5.8%), under-scaled - fund it. Nothing here is unprofitable. No spend data → instrument CAC next.

"Our highest-discount transactions have the most units sold - discounts are working!" Agree?

Claim is FALSE

Avg units per transaction, by discount depth

1.25

1-10%

1.24

11-20%

1.22

21-30%

1.23

Correlation(discount %, units) = -0.019 - statistically zero.

What discounting actually does

Discount	Txns	Total units	Profit
0%	3,004	3,752	₹91.03 L
1-10%	3,992	4,969	₹1.10 Cr
11-20%	2,173	2,655	₹53.10 L
21-30%	831	1,025	₹17.51 L

Read: Units/order are flat (~1.2) at every tier; the 21-30% band sells the fewest. Discounts buy no volume - they hand back margin: ₹58.43 L/yr given away (22% of profit). Cap markdowns at ~15% → recover ≈₹9.52 L-₹14.27 L, ~all to profit.

Where the money is - category concentration

Electronics

₹4.72 Cr · 78%

Home & Kitchen

₹58.34 L · 10%

Clothing

₹46.85 L · 8%

Sports & Fitness

₹25.35 L · 4%

Electronics carries 78% of revenue - a known concentration; monitor, don't chase.

Monthly revenue - CY2024

JFMAMJJASOND

Demand is steady (~₹50.19 L/mo) with a December lift. Naive next-quarter run-rate ≈ ₹49.67 L/mo.

Agentic layer

Ask the data

Grounded only on the live aggregates above - cites real numbers, abstains otherwise.

Every figure computed from all 10,000 rows in portfolio.yoptima_sales · aggregates are re-read from Supabase hourly; this set was computed 2026-09-13 10:56 UTC · Profit = Revenue - Cost · returns = mean(return_flag) · delivery days are Online-only.