E-commerce Analytics in India: Marketplace, CAC & LTV

India's e-commerce market has crossed $80 billion in GMV and is expected to reach $200 billion by 2030, driven by smartphone penetration, UPI payments, affordable data, and expanding delivery networks. For sellers and brands operating in this market, analytics is the difference between profitable growth and cash-burning scale.

Why E-commerce Analytics Matters in India

India's e-commerce landscape has unique analytics requirements:

• Multi-marketplace selling: Most sellers operate across Amazon, Flipkart, Meesho, JioMart, and their own D2C website — requiring cross-channel analytics
• Price-sensitive consumers: Indian shoppers are highly price-comparative, making pricing analytics and competitive monitoring essential
• High return rates: COD (Cash on Delivery) still accounts for 40–50% of orders in many categories, with return rates of 25–40% in fashion
• Marketplace fee complexity: Each marketplace has different commission structures, logistics charges, and penalty mechanisms — unit economics must be tracked per SKU per marketplace
• Quick-commerce disruption: Blinkit, Zepto, and Swiggy Instamart are creating new analytics requirements for grocery, personal care, and impulse categories

Core E-commerce Metrics for Indian Sellers

Revenue and Sales Metrics

• GMV (Gross Merchandise Value): Total order value before returns and cancellations
• Net revenue: GMV minus returns, cancellations, and marketplace fees
• Average order value (AOV): Differs significantly by marketplace — Flipkart/Amazon: ₹800–₹1,500, Meesho: ₹300–₹600
• Orders per day/month: Volume metric tracked against capacity and fulfilment capability
• Channel-wise revenue split: Percentage from each marketplace, D2C website, and offline

Unit Economics

• Revenue per order (after marketplace fees): The actual amount realised per order after commissions, logistics, and penalties
• COGS per unit: Including manufacturing/procurement, packaging, and labelling
• Marketplace fee breakdown: Commission + fixed fee + logistics + payment gateway — tracked per SKU per marketplace
• Contribution margin per order: Revenue minus COGS minus marketplace fees minus logistics — the most important profitability metric
• Return cost per unit: Reverse logistics + restocking + damaged goods write-off

Customer Acquisition Metrics

• Customer Acquisition Cost (CAC): Total marketing spend divided by new customers acquired
• CAC by channel: Amazon PPC, Flipkart ads, Google Ads, Meta ads, influencer marketing — each tracked separately
• ROAS (Return on Ad Spend): Revenue generated per rupee spent on advertising
• ACoS (Advertising Cost of Sale): Ad spend as percentage of ad-attributed sales — the primary Amazon/Flipkart PPC metric
• Organic vs paid traffic split: For D2C websites, measures brand strength and SEO effectiveness

Customer Retention and LTV

• Customer Lifetime Value (LTV): Total revenue from a customer over their relationship — critical for D2C brands
• Repeat purchase rate: Percentage of customers who make a second purchase
• LTV-to-CAC ratio: Must be >3x for sustainable D2C businesses — Indian D2C brands often struggle to reach this threshold
• Cohort retention curves: Month-over-month retention by acquisition cohort — the most honest indicator of product-market fit
• Time between purchases: Average interval between orders — helps set re-engagement timing

Returns and Operational Metrics

• Return rate by category and SKU: Fashion: 25–40%, electronics: 5–10%, grocery: 2–5%
• RTO (Return to Origin) rate: Orders returned before delivery — a major cost issue for COD orders in India
• Cancellation rate: Pre-dispatch cancellations indicate listing or pricing issues
• Delivery success rate: First attempt delivery success — affected by address quality in Tier 2–3 cities
• Inventory days on hand: Stock levels vs sales velocity — critical for marketplace fulfilment (FBA, Flipkart Assured)

E-commerce Analytics Dashboards

Seller Performance Dashboard

• Channel-wise daily orders and revenue
• SKU-wise sales velocity and stock status
• Marketplace fee breakdown and net margin per SKU
• Return rate trend with reason analysis
• Account health metrics (SLA compliance, customer feedback scores)

Marketing Analytics Dashboard

• Campaign-wise ROAS across channels
• ACoS trend for marketplace PPC
• Keyword performance (impression, click, conversion by keyword)
• Customer acquisition cost by channel
• New vs returning customer revenue split

Unit Economics Dashboard

• Contribution margin per order by channel and category
• Fee comparison across marketplaces for same SKU
• Return cost analysis (outbound + reverse logistics + product loss)
• COD vs prepaid profitability comparison
• Break-even analysis per SKU per marketplace

Inventory and Fulfilment Dashboard

• Stock levels across warehouses and FBA centres
• Days of inventory remaining by SKU
• Reorder point alerts
• Fulfilment SLA compliance (dispatch time, delivery time)
• Stranded inventory and long-tail SKU analysis

Data Sources for Indian E-commerce Analytics

• Marketplace seller panels: Amazon Seller Central, Flipkart Seller Hub, Meesho Supplier Hub, JioMart Partner Portal
• Multi-channel OMS: Unicommerce, Vinculum, Eshopbox — order and inventory management
• Shipping aggregators: Shiprocket, Delhivery, Ecom Express, Shadowfax — logistics and delivery data
• Ad platforms: Amazon PPC, Flipkart PLA, Google Ads, Meta Ads Manager
• D2C platform analytics: Shopify Analytics, WooCommerce, Magento
• Payment gateways: Razorpay, Cashfree, PayU — transaction and COD reconciliation data

Challenges in Indian E-commerce Analytics

COD Reconciliation

Cash-on-delivery creates a complex reconciliation problem. The seller ships the product, the logistics partner collects cash, remits to the marketplace or directly to the seller after deductions — all with varying timelines. Analytics must track COD receivables, delays, and leakages.

Multi-Marketplace Data Unification

Each marketplace reports data differently — different date formats, fee structures, return policies, and reporting timelines. Building a unified view across Amazon, Flipkart, and Meesho requires significant data normalisation.

Quick-Commerce Analytics

Blinkit, Zepto, and Swiggy Instamart require different analytics: dark store-level stock management, 10-minute delivery SLA tracking, and impulse purchase conversion metrics. Data access from these platforms is still limited for brands.

Profitability Visibility

Many Indian e-commerce sellers track GMV but don't have visibility into true per-order profitability after accounting for all marketplace fees, return costs, and marketing spend. Building this visibility is the most impactful analytics win.

How FireAI Helps Indian E-commerce Businesses

FireAI unifies the fragmented data landscape of Indian e-commerce sellers:

• Tally + marketplace integration: Connect Tally (COGS, vendor payments, GST) with Amazon Seller Central, Flipkart Seller Hub, and Meesho to calculate true per-order profitability — not just GMV vanity metrics
• 250+ connectors: Pull data from Unicommerce, Shiprocket, Razorpay, Google Ads, Meta Ads, and Shopify into one unified dashboard
• Ask in Hindi or English: A seller can type "Flipkart पर कौन से SKU negative margin दे रहे हैं?" and get instant contribution margin analysis — no SQL, no data team
• ₹4,999/month flat pricing: A D2C brand with 5 team members or 50 pays the same. No per-user fees that eat into already-thin e-commerce margins
• Pre-built e-commerce dashboards: Channel-wise profitability, SKU-level unit economics, return rate analysis, ACoS tracking, and COD reconciliation — live in days
• Zero-code alerts: Get notified when ACoS exceeds 25%, when return rate spikes above category average, or when contribution margin turns negative on any SKU

Real Indian E-commerce Scenario

A Surat-based fashion seller doing ₹12 crore annual GMV across Amazon, Flipkart, and Meesho discovered through FireAI that 35% of their SKUs were contribution-margin-negative after accounting for marketplace fees and returns. By de-listing unprofitable SKUs and doubling down on profitable ones, they went from ₹8 lakh/month losses to ₹15 lakh/month profit — while GMV dropped only 12%.

E-commerce KPIs You Can Track from Day One

KPI	Source	Indian Benchmark
Contribution margin/order	Tally + marketplace	Must be positive per SKU
ACoS	Marketplace PPC	15–25% target
Return rate	Marketplace + OMS	Fashion: 25–40%, electronics: 5–10%
COD vs prepaid ratio	Payment gateway	Trend towards <40% COD
LTV:CAC ratio	Multi-source	>3x for sustainable D2C