All-time performance snapshot · Dec 2024 – Apr 2026
₹3.35 Cr Revenue
Total Revenue
₹3.35Cr
33,546,231 INR total
Total Orders
39,255
Paid & fulfilled
Avg Order Value
₹854
Per paid order
Unique Customers
30,965
Unique email IDs
Repeat Customers
4,736
15.3% of base
Top State
MH
₹84.3L · 9,687 orders
💡 Key Business Alert
84.7% of customers (26,229) bought only once. This is your biggest growth lever. If you convert just 20% of recent one-time buyers into repeat customers, you add ~₹45L revenue without any new customer acquisition. The data shows repeat customers spend on average ₹2,820 vs ₹854 for one-time buyers — that's a 3.3× LTV multiplier.
📈
Revenue Trend (Monthly)
Jan 2025 – Apr 2026
🧩
Customer Mix
One-time26,22984.7%
Repeat (2+)4,34914.0%
Loyal (5+)3741.2%
Champions (10+)310.1%
🏙️
Top Cities
#
City
Revenue
Orders
1
Mumbai
₹42.99L
4,676
2
Bangalore
₹22.05L
2,611
3
Pune
₹14.80L
1,758
4
Hyderabad
₹13.10L
1,393
5
Chennai
₹10.12L
1,171
6
Thane
₹9.02L
1,100
🗺️
Top States
#
State
Revenue
Orders
1
Maharashtra
₹84.29L
9,687
2
Delhi
₹32.64L
3,595
3
Karnataka
₹31.92L
3,782
4
Uttar Pradesh
₹25.83L
3,115
5
Tamil Nadu
₹23.08L
2,575
6
Telangana
₹19.10L
2,165
🧬
Top Categories
Monthly Trends
Month-on-month revenue, orders & average order value
16 Months of Data
Best Revenue Month
Feb 2026
₹29.64L revenue
Best Orders Month
Feb 2026
3,724 orders
MoM Growth (Peak)
+34.5%
Jul→Aug 2025
Avg Monthly Rev
₹20.9L
Across 16 months
📊
Monthly Revenue (INR)
Bars = Revenue · Line = Orders
📋
Monthly Breakdown
Month
Orders
Revenue
Avg/Order
MoM
📈
Avg Order Value Trend
Highest AOV MonthFeb 2025 — ₹1,386
Lowest AOV MonthApr 2025 — ₹882
Overall Average AOV₹854
Discount Orders30,656 (78.1%)
Non-Discount AOV₹940 (+13.2%)
📌 Analyst Observation
Strong growth trajectory visible — orders tripled from Jan 2025 (1,222) to Feb 2026 (3,724). Aug 2025 spike (+45% orders vs Jul) likely driven by Independence Day / mid-year promotions. Q1 2026 is your strongest quarter. Discount orders (78%) show heavy reliance on promotions — non-discount customers have 13% higher AOV (₹940 vs ₹830). Consider building more organic purchase intent.
Category Analysis
Revenue, volume & order share by product category
21 Categories
#1 Category
Magnesium
₹59.4L · 8,771 orders
Fastest Growing
Detox
Consistent 2026 demand
Highest AOV Category
Protein
₹1,440 avg/order
Most Repeat Category
Gut Health
High subscription potential
🏆
Revenue by Category
Top 12 shown
🥧
Revenue Share
📅
Category Revenue Trend (Monthly)
Top 6 categories
📋
Full Category Table
#
Category
Revenue
Orders
Units Sold
Avg/Order
Revenue Share
💡 Category Insights
Magnesium is your star — ₹59.4L across 8,771 orders. "Other Supplements" category (₹72.5L) is uncategorised — tagging these clearly could reveal a hidden #1 category. Protein (₹11L) has the highest AOV at ~₹1,440 per order. Gut Health & Omega have strong repeat buyer overlap — these are natural subscription candidates. Brain & Cognitive is a premium niche worth developing with bundles.
Customer Segments
Loyalty tiers, LTV analysis & top buyer profiles
30,965 Customers
👑
Champions
31
10+ orders each
StrategyExclusive beta access, VIP loyalty rewards, personal thank-you calls, early product launches, referral commissions.
StrategyCross-sell complementary categories. E.g. if bought Magnesium → suggest Vitamin D, Omega. Show order history in emails.
⏳
One-time Buyers
26,229
84.7% of customer base
StrategyWin-back email sequences, "Did you run out?" push notifications, first-reorder discount (10–15%). See Re-Engage tab.
🏆
Top 15 Customers by Lifetime Value
All-time spend
#
Customer
Orders
Total Spent
Avg/Order
City
📊
Purchase Frequency
Most orders by 1 customer30 orders
Avg orders (repeat cust.)2.8 orders
Avg spend (repeat cust.)₹2,820
LTV uplift vs one-time+3.3×
📅
New Customers Acquired Per Month
First-time buyers by cohort
Retention & Re-Engagement
One-time buyer breakdown · Strategies to drive second purchase
26,229 One-Time Buyers
🎯 The Single Biggest Opportunity
26,229 customers bought once and never came back. If you convert just 10% → 2nd purchase, that's 2,623 new repeat customers adding approximately ₹74L additional revenue (at ₹2,820 avg repeat spend). Your one-time buyers are split into 3 actionable buckets below.
Pincode-based local WhatsApp broadcasts for top zones
Location Intelligence
City, state & regional revenue breakdown
Pan-India Sales
🏙️
Top 15 Cities by Revenue
🗺️
Top 15 States by Revenue
📋
State-Wise Performance Detail
#
State
Code
Orders
Revenue
Revenue Share
Avg/Order
💡 Location Opportunity
Maharashtra alone contributes 25.1% of revenue. Top 5 states (MH, DL, KA, UP, TN) = 67% of all revenue. Strong metro bias — Mumbai, Bangalore, Pune, Hyderabad, Chennai are your core markets. UP + Gurgaon showing strong Noida/GBN performance — target these pincodes specifically. South India (TN + TS + KL + AP) = ₹63L combined — high potential market with loyalty focus.
Top Pincodes
Highest revenue delivery zones — hyperlocal targeting map
Top 25 Zones
#1 Pincode
201301
Noida/GBN · ₹3.23L
#2 Pincode
400053
Mumbai · ₹3.21L
Mumbai Zones
13 pins
In top 25 list
Gurgaon Zones
3 pins
122001/02/18
Top 25 Combined
₹31.2L
9.3% of total revenue
📊
Top 20 Pincodes by Revenue
📍
Pincode Revenue Heatmap
Hover for details · Intensity = Revenue
🎯 Hyperlocal Marketing Strategy
Use your top 25 pincodes for targeted campaigns: Run WhatsApp broadcasts segmented by pincode. Enable "same-day delivery" badge for these zones to boost conversion. Partner with gyms/wellness centres in 400053, 201301, 122001-122018 for offline activations. Run geo-targeted Meta/Instagram ads in these exact zones. For Gurgaon (3 pincodes, ₹4.58L combined) — consider a corporate wellness outreach in the DLF/Cyber City offices.
Magnesium variants (3 SKUs) combine to ₹15.1L — your #1 franchise. Bundle the 60T + 120T as a "value pack" to increase basket size. Lung Detox Pack of 1 vs Pack of 2 — push the pack of 2 (₹10.5/unit vs ₹9.8/unit) with a "save more" upsell at cart. Sea Buckthorn & Pea Protein are premium high-ticket items — use these as loyalty rewards for Champions tier. Cross-sell: Lung Detox buyers → suggest Vitamin C. B12 buyers → suggest Omega 3-6-9.
City & State — Top Products
Which products sell best in each city and state
10 Cities · 10 States
Click a city/state to highlight · Revenue shown per location
🏙️ Top Cities
🗺️ Top States
💡 Geo-Product Insight
Chennai is unique — Pea Protein is the #1 product (₹95K), unlike every other city where Magnesium dominates. Suggests a strong fitness/sports nutrition audience there worth targeting with protein bundles.
Bangalore & Hyderabad heavily favour Magnesium Glycinate 60T — opportunity for subscription push here.
Mumbai loves Gut Health (Progut ranks #1) — metro health-consciousness driving probiotic demand.
Delhi/Kolkata lead in Lung Detox — respiratory health concern driving demand, consider seasonal campaigns.
Gurgaon is your most premium market — Berberine, Glucosamine, Omega rank higher than cheaper SKUs.
💡 Timing Insight — Use This For Campaign Scheduling
Peak order hours are 5–8 AM IST (early morning, people browsing before work) and 4–6 PM (post-work). Tuesday is your highest order day. Schedule WhatsApp broadcasts, email campaigns and push notifications at 6:30 AM or 5:00 PM IST for maximum open rates.
🕐
Orders by Hour of Day
IST · All orders
📅
Orders by Day of Week
Revenue & orders
📈 New vs Returning Customers
Avg Returning Orders/Month
710
Growing steadily
Avg New Orders/Month
2,356
Good acquisition
Returning Revenue Share
~23%
Room to grow
Returning AOV Premium
+18%
₹1,007 vs ₹854
📊
New vs Returning Customers — Monthly
Stacked bar
💳 Prepaid vs COD Analysis
💳
Prepaid vs COD — Monthly Trend
📊
Payment Mix Summary
💳
Prepaid Orders
36,330 92.5%
₹30.73Cr · Avg ₹845
💵
COD Orders
2,925 7.5%
₹2.82Cr · Avg ₹962
💡 COD Insight
COD customers have 14% higher AOV (₹962 vs ₹845) — they are high-value buyers. Offer a prepaid incentive (5% discount) to shift them: reduces RTO risk and improves cash flow.
🏷️ Discount & Coupon Analysis
Discount Order Share
78.1%
30,656 of 39,255 orders
Total Discount Given
₹39.4L
3,940,669 INR
Non-Discount AOV
₹940
vs ₹830 with discount
Top Code Uses
24,319
PREPAID-DISCOUNT
🏷️
Top Discount Codes by Usage
📋
Code Performance
#
Code
Uses
Revenue
Avg/Order
Disc Given
🎯 Discount Strategy Recommendations
PREPAID-DISCOUNT used 24,319 times — it's your default checkout incentive. AOV is low (₹727) suggesting it attracts price-sensitive buyers. Consider minimum cart value to apply this (e.g. ₹999+).
Free Gift code has highest AOV (₹1,790) — bundle deals are working well.
Order Discount (₹1,643 AOV) = likely bulk/B2B orders.
REPUBLIC15 & 10% Off are working well — maintain for seasonal campaigns.
Non-discount customers spend 13% more — invest in organic trust-building (reviews, content) to reduce coupon dependency.
💎 Revenue Concentration (Pareto Analysis)
📊
Revenue Pareto Chart
Cumulative %
💎
80/20 Breakdown
Top 5%
1,548 customers generate 26.3% of all revenue
Top 10%
3,096 customers generate 37.2% of all revenue
Top 20%
6,193 customers generate 51.7% of all revenue
Bottom 80%
24,772 customers generate remaining 48.3% of revenue
💡 Action
Your top 10% (3,096 customers) drive 37% of revenue. Create a VIP tier for these customers — early access, dedicated support, exclusive bundles. Losing 100 of these = losing same revenue as losing 1,000+ bottom-tier customers.
🚚 Shipping Method Analysis
🚚
Shipping Method Performance
#
Shipping Method
Orders
Revenue
Avg Order
Share
One-Time Buyer Intelligence
26,229 customers who bought once · segmented by recency · ready to re-engage
26,229 Customers
All One-Time
26,229
₹19.54L total value
🔥 Last 0–30 Days
2,606
₹19.29L · Avg ₹740
⚡ 31–60 Days
2,571
₹18.08L · Avg ₹703
🌡️ 61–90 Days
2,705
₹19.31L · Avg ₹714
🌤️ 91–180 Days
5,531
₹41.35L · Avg ₹748
❄️ 181–365 Days
9,889
₹73.05L · Avg ₹739
⬇ Download by Recency Bucket
Each CSV includes: Name · Email · Phone · City · State · Pincode · Total Spent · Last Order Date · Product Bought
🔥
0–30 Days
2,606 customers · ₹19.3L
Hot leads — just bought, highest intent to reorder
⚡
31–60 Days
2,571 customers · ₹18.1L
Warm window — send restock reminder now
🌡️
61–90 Days
2,705 customers · ₹19.3L
Last chance hot window — offer 10% discount
🌤️
91–180 Days
5,531 customers · ₹41.3L
Win-back campaign with stronger incentive
❄️
181–365 Days
9,889 customers · ₹73.1L
Lapsed — use social proof + free shipping offer
🧊
365+ Days
2,927 customers · ₹24.3L
Long lapsed — re-introduce brand, show new products
✅ Strong Performance — Your Return Rate is Excellent
At 0.80%, your return rate is far below the e-commerce industry average of 2–5% for health supplements. August 2025 spike (1.5%) coincided with your highest order month — likely some quality batch issue or new customers with wrong expectations. Top return reasons (from order tags): Duplicate orders (7), Fake orders (1), Address issues (17) — suggesting most returns are logistics/ops driven, not product quality issues. Action: Resolve GoKwik COD verification to cut duplicate orders.
📅 Monthly Return Trend
📊
Returns vs Orders — Monthly
Bar = Returns · Line = Return Rate %
💰
Monthly Breakdown
Month
Returns
Refunded
Return Rate
📍 Returns by Location
🏙️
City-wise Returns
Count + Rate
🗺️
State-wise Returns
📍
Top Pincode Returns
#
Pincode
City
Returns
Refunded
📋
State-wise Return Detail
Rate = returns ÷ paid orders
#
State
Returns
Refunded
Paid Orders
Return Rate
Avg Refund
🧬 Returns by Product Category
🧬
Category Return Count & Refund Value
📋
Category Detail
#
Category
Returns
Refunded
Avg/Return
👤 Top Returning Customers
💡 Repeat Returner Watch
Only 13 customers (4%) have returned more than once — this is very healthy. Top refund by value is Jugnu Verma (Ludhiana, ₹6,290 — 2 returns) and Dipika Belapurkar (Mumbai, ₹3,204 — 1 return). Consider flagging customers with 2+ returns for manual review before auto-approving future refunds.
👤
Customers with Highest Return Value
#
Customer
Email
Return Orders
Total Refunded
City
State
Risk
🔍 Return Reason Intelligence
🔍
Return Signals from Tags
💳
Payment Method of Returners
🎯
Action Plan to Reduce Returns
✅ Duplicate Orders (7 cases)
Enable GoKwik duplicate detection. Add order confirmation page with "already placed" check.
⚠️ Address Issues (17 cases)
Add address verification at checkout. Send delivery address confirmation SMS after order.
📦 Product Expectations
Add better product images, usage instructions, and "what to expect" section to product pages.
🚩 High-Rate Cities
Lucknow (1.8%), Vadodara (1.9%), Ludhiana (1.8%) have above-avg rates. Review logistics partners in these cities.
Email Campaign
Send personalised emails to any customer segment directly from the dashboard