D2C / Profitability
D2C Profit Visibility System
Uncovered hidden cost leaks and established true profitability across channels.
30.4%
Net Margin
₹5.96L
Profit Identified
7.2%
Return Rate Impact
Business Problem
What was unclear
The business was scaling revenue aggressively through paid channels, but had no clear understanding of actual profitability. Revenue data lived in Shopify, ad spend was split across platforms, and cost data sat in disconnected files. Weekly reporting required manual consolidation and only reflected top-line performance. Growth was visible. Profitability was not.
Data & System Built
From sources to structure
Data sources
- Shopify orders and refunds
- Meta Ads and Google Ads spend
- Product cost sheets and COGS
- Fulfilment, payment fees, and returns
System built
- 01Consolidated all sources into a single financial model.
- 02Computed order-level profitability across all cost layers.
- 03Linked revenue, acquisition cost, and operational expenses in one structure.
- 04Enabled order-level P&L, channel profitability, and executive KPI views.
Key Insights
What the data revealed
INSIGHT 01
Revenue does not equal profit
High-revenue channels were not the most profitable once costs were fully accounted for.
INSIGHT 02
Meta drove volume, not efficiency
Highest revenue contribution but operated at significantly lower margins.
INSIGHT 03
Organic and email were high-margin drivers
Lower revenue contribution, stronger profitability.
INSIGHT 04
Returns were a hidden cost driver
Refunds created a consistent margin drag that was previously untracked.
INSIGHT 05
CAC was misleading
Blended CAC looked healthy, then dropped sharply once full cost allocation was applied.
Impact / Outcome
What decisions it enabled
- →Established true net profitability across the business.
- →Identified inefficient ad spend and reallocation opportunities.
- →Replaced manual reporting with a structured system.
- →Reduced a multi-hour weekly process into a quick, decision-focused review.
Visual Layer
Where the system surfaces clarity
VIEW 01
Revenue vs Cost vs Profit trend
VIEW 02
Channel profitability comparison
VIEW 03
Cost breakdown (COGS, ads, fulfilment, returns)
Want this level of clarity for your business?
Get in TouchMore case studies