01 — The Gap
Launch is easy. Day 30 is hard.
Agencies hand over a live store and walk away. Brands drown in 13 different dashboards — Amazon settlements,
Meta ads, Flipkart returns, Shiprocket invoices.
Which marketplace has the best ROAS?
Cross-source analysis
Myntra at 4.8x, followed by Amazon at 3.2x. Flipkart is below threshold at 2.1x.
📊 View Data
Marketplace
ROAS
Myntra
4.8x
Amazon
3.2x
Flipkart
2.1x
Shift $1k from Flipkart to Myntra
Show ad spend breakdown
Analyze Flipkart returns
Send
p. 1
02 — The Dashboard
One view. Every source.
Q2 2024 data unified from 13 sources into a single operational view.
Overview
Correlation
Marketplaces
Ads & Marketing
Logistics
Total Revenue (30d)
₹28.5L
↑ 12.3% from last period
Orders Shipped
2,847
Avg value: ₹10,022
Ad Spend ROI
3.2x
₹85.4L total spend
On-Time Delivery
94.2%
2,680 delivered on time
Revenue by Marketplace (Last 7 Days)
Top 5 Products
Wireless Bluetooth Headphones
SKU: WBH-001-BLK
Yoga Mat Premium 6mm
SKU: YMP-6MM-BLU
Smart Watch Pro
SKU: SWP-2024-SLV
Organic Green Tea 100g
SKU: OGT-100-GRN
Laptop Stand Adjustable
SKU: LSA-ALU-GRY
Flipkart
₹7.4L
142 orders
Sales by Fulfillment Channel
Sales by State Distribution
Google Ads
₹24.5L
ROAS: 3.8x
Facebook/Instagram
₹18.2L
ROAS: 2.9x
YouTube
₹15.8L
ROAS: 3.4x
LinkedIn + Other
₹26.9L
ROAS: 2.4x
Total Shipments
2,847
All time
Avg Delivery Time
2.3
Days
Return Rate
2.8%
Below industry avg
Total Shipping Cost
₹22.2L
Avg: ₹780/order
Logistics Partner Performance
EKart
964 shipments delivered
BlueDart
856 shipments delivered
Shiprocket (Multi-courier)
1,027 shipments delivered
Sales (Marketplaces)
View Details →
₹28.5L
5 active channels
Ad Spend
View Details →
₹85.4L
ROI: 3.2x
Marketing (ROAS)
View Details →
3.1 avg
Highest: Google Ads (3.8x)
Shipping (Logistics)
View Details →
94.2%
2,847 total shipments
Cross-Faceted Correlation: Sales vs. Spend (₹L)
Cross-Faceted Coverage: Spend, Sales & Shipping Performance
Correlation: Marketing Efficiency (ROAS) vs. Logistics (On-Time %)
Correlation: Orders Shipped vs. Marketplace Share (%)
p. 2
03 — The Interface
Ask anything. Get answers.
No filters. No SQL. Type questions naturally. The system routes to the right source and cites where data came
from.
All
Revenue
Ad Spend
Logistics
Returns
Which marketplace has the highest ROAS?
Cross-source analysis · 4 data sources
Answer
Myntra at 4.8x, followed by Amazon at 3.2x. Flipkart at 2.1x is below your 2.5x
threshold.
Recommendation: Shift 15% of Flipkart budget to Myntra for estimated +$3,200 revenue.
Sources: Meta Ads API, Amazon Advertising Console, Flipkart Seller Hub
What's the revenue trend for the last 6 months?
Trend analysis · Jan-Jun 2024
Answer
Revenue grew from $15.2k (Jan) to $84.3k (Jun) — 454% increase. Month-over-month growth averaged
12.4%.
Projection: At current trajectory, July revenue will hit ~$94k.
Sources: Amazon.in, Flipkart, Myntra, Shopify settlements
Which ad channel is underperforming?
Performance analysis · 90-day window
Answer
LinkedIn at 15% of spend has 3.2x lower conversion rate than Meta. CAC: $47 vs $18 on
Meta.
Action: Shift 10% of LinkedIn budget to Meta → +70 orders, +$2,240 profit.
Sources: LinkedIn Campaign Manager, Meta Ads Manager, Razorpay
Which logistics partner has the worst delivery time?
Performance comparison · May 2024
Answer
Bluedart at 4.1 days average vs 3.2 days overall. 14.2% return rate (3x your 5.1%
baseline).
Impact: ~$2,100 in lost margin from returns.
Sources: Bluedart API, Shiprocket dashboard, marketplace return logs
Why did returns spike in May?
Anomaly detection · Root cause analysis
Answer
Returns spiked 18.3% in May (167 → 198 units). Two drivers:
1.
Bluedart delivery delays → 14.2% return rate
2.
SKU-2847 (linen shirt, size M) → 41 returns, sizing issue in 23 reviews
Action: Update SKU-2847 size chart, reduce Bluedart volume.
Sources: Bluedart API, marketplace returns, review scraper
What happens if we shift 10% of LinkedIn budget to Meta?
Scenario modeling · 82% confidence
Answer
Based on 90-day data:
• Shift $1,265 from LinkedIn to Meta
• Generate ~70 additional orders
• Revenue impact: +$5,880
• Profit impact: +$2,240
Confidence: 82% based on historical conversion patterns.
Sources: Meta Ads Manager, LinkedIn Campaign Manager, Razorpay
Watch the demo: typing "whi" triggers autocomplete with matching queries
p. 3