EXECUTIVE COMMERCE INTELLIGENCE
5,000 ORDERS · JAN 2023 – MAR 2025 · ALL METRICS COMPUTED FROM DATASET · ZERO HARDCODED VALUES
LIVE ANALYTICS
🔍
■ BUSINESS PROBLEM STATEMENT
AN E-COMMERCE BUSINESS OPERATING ACROSS 5 REGIONS, 5 CATEGORIES, AND 3 SALES CHANNELS IS STRUGGLING TO IDENTIFY WHERE REVENUE IS LEAKING, WHICH DISCOUNTS ARE DESTROYING MARGINS, AND WHICH REGION-CHANNEL COMBINATIONS DRIVE THE MOST PROFITABLE GROWTH — ACROSS 5,000 ORDERS FROM JAN 2023 TO MAR 2025.
📈 REVENUE OPTIMISATION 📉 MARGIN LEAKAGE 🌎 REGIONAL PERFORMANCE 🏷 DISCOUNT IMPACT 🔁 CHANNEL EFFICIENCY
01 — PROBLEM
WHERE IS THE MONEY LEAKING?
DESPITE STRONG REVENUE PERFORMANCE, THE BUSINESS IS EXPERIENCING MARGIN PRESSURE, WITH AN OVERALL PROFIT MARGIN OF JUST 17.82%. SIGNIFICANT VARIATION ACROSS REGIONS, SALES CHANNELS, AND DISCOUNT LEVELS SUGGESTS THAT CERTAIN SEGMENTS ARE DISPROPORTIONATELY IMPACTING PROFITABILITY — BUT THESE DRIVERS ARE NOT CLEARLY VISIBLE TO MANAGEMENT.
02 — APPROACH
Full-Data Analysis. No Sampling.
ANALYSED ALL 5,000 ORDERS FROM JAN 2023 TO MAR 2025. COMPUTED REVENUE, PROFIT, MARGIN, COGS AND MARKETING ROI ACROSS EVERY REGION, CATEGORY, CHANNEL AND DISCOUNT BAND — WITH ZERO HARDCODED VALUES. EVERY NUMBER IS DERIVED DIRECTLY FROM THE DATASET.
03 — INSIGHTS
Five Signals That Matter.
DISCOUNTS ABOVE 20% COLLAPSE MARGIN TO 2.05%. ONLINE CHANNEL LAGS RETAIL BY 4.4 POINTS. EUROPE LEADS ALL REGIONS AT 18.62% MARGIN. SPORTS IS THE STRONGEST CATEGORY. DECEMBER IS A RECURRING MARGIN TRAP AT 14.25%.
04 — IMPACT
$307K+ Recoverable Profit.
CAPPING DISCOUNTS AT 20% RECOVERS $138,720 IN ANNUAL PROFIT. FIXING THE ONLINE CHANNEL GAP ADDS $81,084. SCALING MARKETPLACE 20% CONTRIBUTES ANOTHER $70,030. COMBINED, THESE THREE ACTIONS ALONE REPRESENT A +31% PROFIT UPLIFT ON CURRENT BASELINE.
⚡ LIVE INSIGHTS
📈
DISCOUNT RISK
ORDERS WITH >20% DISCOUNT YIELD ONLY 2.05% MARGIN — VS 27.47% AT ZERO DISCOUNT. HEAVY DISCOUNTING IS DESTROYING PROFITABILITY.
🔌
CHANNEL GAP
RETAIL DELIVERS THE HIGHEST MARGIN AT 19.73%. ONLINE LAGS AT 15.32% — A 4.4 PT GAP ON $1.84M REVENUE. WORTH INVESTIGATING.
🏆
TOP PERFORMER
SPORTS LEADS ALL CATEGORIES WITH 18.35% MARGIN AND $1.16M REVENUE. ELECTRONICS TRAILS AT 17.27% — LOWEST DESPITE COMPARABLE REVENUE.
🌎
REGION SIGNAL
EUROPE LEADS IN BOTH REVENUE ($1.16M) AND MARGIN (18.62%). ASIA HAS THE LOWEST MARGIN (17.07%) — LARGEST EFFICIENCY GAP TO CLOSE.
🕑
SEASONAL DIP
DEC 2024 POSTED THE LOWEST MARGIN OF ANY MONTH AT 14.25% ON $178K REVENUE — A KEY OUTLIER VS THE 20.61% PEAK SEEN IN JAN 2025.
💰
TOTAL REVENUE
—
—
📈
TOTAL PROFIT
—
—
%
PROFIT MARGIN
—
PROFIT ÷ REVENUE
📦
TOTAL ORDERS
—
—
🎯
AVG ORDER VALUE
—
REVENUE ÷ ORDERS
📣
MARKETING SPEND
—
—
REVENUE & PROFIT — MONTHLY TREND 27 MONTHS
💡 WHAT THIS SHOWS: HOW MUCH MONEY CAME IN (REVENUE) AND HOW MUCH WAS KEPT AS PROFIT EACH MONTH. A RISING GREEN LINE = BUSINESS GROWING. GAP BETWEEN LINES = COSTS EATING INTO PROFIT.
REVENUE BY SALES CHANNEL SPLIT
💡 WHAT THIS SHOWS: WHICH SELLING PLATFORM (MARKETPLACE, ONLINE, RETAIL) BRINGS IN THE MOST MONEY. BIGGER SLICE = MORE SALES FROM THAT CHANNEL.
REVENUE BY CATEGORY
💡 WHAT THIS SHOWS: WHICH PRODUCT TYPE EARNS THE MOST. TALLER BAR = MORE REVENUE. DARK COLOUR = TOTAL SALES. LIGHT COLOUR = PROFIT KEPT.
REVENUE BY REGION
💡 WHAT THIS SHOWS: WHICH PART OF THE WORLD EARNS THE MOST. LONGER BAR = MORE REVENUE FROM THAT REGION.
PROFIT MARGIN % BY REGION
💡 WHAT THIS SHOWS: OUT OF EVERY $100 EARNED, HOW MANY DOLLARS ARE ACTUAL PROFIT. HIGHER BAR = MORE EFFICIENT REGION. 20% MEANS $20 PROFIT PER $100 SOLD.
CATEGORY × CHANNEL (STACKED REVENUE)
💡 WHAT THIS SHOWS: FOR EACH PRODUCT TYPE, WHICH SALES CHANNEL CONTRIBUTES THE MOST. EACH COLOUR IN A BAR = A DIFFERENT CHANNEL (MARKETPLACE, ONLINE, RETAIL).
ORDERS & REVENUE BY DISCOUNT BAND
💡 WHAT THIS SHOWS: HOW HEAVY DISCOUNTING AFFECTS SALES. MORE ORDERS WITH BIG DISCOUNTS BUT REVENUE DROPS — MEANING THE BUSINESS IS GIVING AWAY TOO MUCH.
MARKETING SPEND VS PROFIT (BY CATEGORY)
💡 WHAT THIS SHOWS: IS MARKETING SPEND TURNING INTO PROFIT? BUBBLE RIGHT = SPENT MORE ON MARKETING. BUBBLE UP = EARNED MORE PROFIT. BIGGER BUBBLE = HIGHER REVENUE SHARE.
REGION PERFORMANCE SUMMARY
💡 HOW TO READ: EACH ROW = ONE REGION. MARGIN BAR SHOWS PROFIT EFFICIENCY — LONGER GREEN BAR = MORE PROFITABLE PER DOLLAR EARNED.
REGIONREVENUEPROFITMARGINORDERSUNITS
CATEGORY PERFORMANCE SUMMARY
💡 HOW TO READ: EACH ROW = ONE PRODUCT CATEGORY. COMPARE REVENUE VS PROFIT — A HIGH REVENUE BUT LOW PROFIT ROW SIGNALS A COST OR DISCOUNT PROBLEM.
CATEGORYREVENUEPROFITMARGINORDERSUNITS
📈 BUSINESS IMPACT — WHAT FIXING THESE ISSUES IS WORTH IN REAL DOLLARS.
🚫 DISCOUNT REFORM
$138,720 / YR
CAPPING ALL DISCOUNTS AT A MAXIMUM OF 20% WOULD RECOVER $138,720 IN ANNUAL PROFIT. CURRENTLY, 853 ORDERS (17.1% OF ALL ORDERS) CARRY DISCOUNTS ABOVE 20% — EARNING ONLY 2.05% MARGIN VERSUS 20.31% FOR ORDERS BELOW 20% DISCOUNT. THIS IS THE SINGLE HIGHEST-IMPACT FIX IN THE ENTIRE DATASET.
📊 SOURCE: 853 ORDERS · $759,681 REVENUE AT RISK · MARGIN GAP: 18.26 PTS.
🔌 ONLINE CHANNEL FIX
$81,084 / YR
THE ONLINE CHANNEL EARNS 15.32% MARGIN VERSUS 19.73% FOR RETAIL — A GAP OF 4.40 PERCENTAGE POINTS ON $1.84M IN REVENUE. IF ONLINE PRICING, FULFILMENT COSTS AND RETURN RATES ARE OPTIMISED TO MATCH RETAIL EFFICIENCY, THE BUSINESS RECOVERS $81,084 IN ADDITIONAL ANNUAL PROFIT.
📊 SOURCE: ONLINE REVENUE $1.84M · RETAIL MARGIN BENCHMARK 19.73%.
🔥 MARKETPLACE SCALE
$70,030 / YR
MARKETPLACE IS THE HIGHEST-REVENUE CHANNEL AT $1.90M WITH A SOLID 18.41% MARGIN. A TARGETED 20% GROWTH IN MARKETPLACE VOLUME — THROUGH EXPANDED LISTINGS AND AD SPEND — WOULD GENERATE AN ADDITIONAL $380,328 IN REVENUE AND $70,030 IN PROFIT.
📊 SOURCE: MARKETPLACE REVENUE $1.90M · MARGIN 18.41% · 20% GROWTH SCENARIO.
⚡ COMBINED IMPACT
$289,804 TOTAL
EXECUTING ALL THREE ACTIONS — DISCOUNT REFORM, ONLINE CHANNEL OPTIMISATION AND MARKETPLACE SCALING — DELIVERS A COMBINED $289,804 IN RECOVERABLE OR INCREMENTAL ANNUAL PROFIT. AGAINST A CURRENT PROFIT BASE OF $993,107, THIS REPRESENTS A +29.2% PROFIT UPLIFT WITHOUT ACQUIRING A SINGLE NEW CUSTOMER.
📊 SOURCE: ALL FIGURES COMPUTED FROM 5,000-ORDER DATASET. ZERO ASSUMPTIONS.
⚡ STRATEGIC RECOMMENDATIONS — WHAT THE BUSINESS SHOULD DO NEXT
🚫
🔴 HIGH PRIORITY · IMMEDIATE ACTION
CAP DISCOUNTS AT 20%
ORDERS WITH >20% DISCOUNT EARN ONLY 2.05% MARGIN COMPARED TO 27.47% AT ZERO DISCOUNT. THE BUSINESS IS ESSENTIALLY GIVING PRODUCTS AWAY. SET A HARD CAP AT 20% AND USE TARGETED DISCOUNTS ONLY FOR HIGH-VALUE OR REPEAT CUSTOMERS.
🎯 EXPECTED IMPACT: +8–12% OVERALL MARGIN RECOVERY.
📈
🔴 HIGH PRIORITY · REVENUE FOCUS
DOUBLE DOWN ON EUROPE & SPORTS
EUROPE LEADS IN BOTH REVENUE ($1.16M) AND MARGIN (18.62%). SPORTS IS THE TOP CATEGORY AT 18.35% MARGIN. THESE ARE THE TWO HEALTHIEST COMBINATIONS IN THE DATASET. INCREASING MARKETING SPEND HERE WILL YIELD THE HIGHEST RETURN ON INVESTMENT.
🌎 FOCUS: EUROPE × SPORTS CHANNEL INVESTMENT.
🔌
🟠 MEDIUM PRIORITY · CHANNEL STRATEGY
FIX THE ONLINE CHANNEL GAP
ONLINE LAGS RETAIL BY 4.4 MARGIN POINTS ON $1.84M IN REVENUE. THAT GAP COSTS ROUGHLY $81K IN LOST PROFIT ANNUALLY. AUDIT ONLINE PRICING, FULFILMENT COSTS, AND RETURN RATES — SMALL FIXES HERE HAVE OUTSIZED PROFIT IMPACT.
🔍 ACTION: ONLINE COST AUDIT + PRICING REVIEW.
📉
🟠 MEDIUM PRIORITY · COST CONTROL
INVESTIGATE ASIA'S LOW EFFICIENCY
ASIA HAS THE LOWEST PROFIT MARGIN (17.07%) DESPITE $1.07M IN REVENUE — THE BIGGEST EFFICIENCY GAP ACROSS ALL REGIONS. HIGH COGS OR EXCESSIVE DISCOUNTING IN ASIA IS LIKELY THE CULPRIT. A REGIONAL PRICING AND COST REVIEW IS OVERDUE.
🌎 ACTION: ASIA COGS + DISCOUNT AUDIT BY CATEGORY.
🕑
🟡 MONITOR · SEASONAL PLANNING
PREPARE FOR DEC MARGIN DIP
DECEMBER 2024 POSTED THE LOWEST MARGIN AT 14.25% — LIKELY FROM HOLIDAY DISCOUNTING. JANUARY 2025 REBOUNDED TO 20.61%. PLAN Q4 PROMOTIONS WITH MARGIN FLOORS SET IN ADVANCE SO THE HOLIDAY SEASON DOES NOT ERODE ANNUAL PROFITABILITY.
📅 ACTION: SET Q4 DISCOUNT GUARDRAILS BEFORE OCTOBER.
🚀
🟢 LONG TERM · GROWTH PLAY
SCALE MARKETPLACE CHANNEL
MARKETPLACE LEADS ALL CHANNELS IN REVENUE AT $1.9M AND HOLDS A COMPETITIVE MARGIN. IT ALREADY ATTRACTS THE MOST ORDERS. INVESTING IN MARKETPLACE LISTINGS, ADS, AND FULFILMENT OPTIMISATION CAN PUSH THIS CHANNEL TO 40%+ OF TOTAL REVENUE.
🔥 ACTION: MARKETPLACE AD SPEND + CATALOGUE EXPANSION.