All your key business metrics in one
glance — revenue, orders, ROI, delivery.
Regions:GlobalMENAEUROPENorth AmericaAfricaIndia
Marketplace Sales (30d)
₹28.5L
↗ 5 active channels
Total Ad Spend
₹8.5L
↗ ROI: 3.2x
Blended ROAS
3.2x
↗ Avg across platforms
Shipping OTD
94.2%
↗ On-time delivery rate
Ad Spend vs Marketplace Sales by Platform
Daily OTD % vs Orders — Last 7 Days
ROAS vs On-Time Delivery by Platform
Cross-channel correlation reveals links
between marketing investment and logistical delivery reliability.
Total GMV (30d)
₹32.1L
↑ 10.8% vs last period
Avg Order Value
₹1,247
Across all channels
Blended Return Rate
4.3%
↑ 0.4pp vs last month
Return Rate by Channel — Meesho flagged highest
💡 Meesho's 8.2% return rate is driven primarily by fashion SKUs (78%
of returns). Reverse logistics + restocking cost ~₹82/order. Amazon maintains the lowest
at 2.1%.
Channel Performance Summary
Channel
GMV
Orders
AOV
Returns
NPS
Amazon
₹8.8L
842
₹10,452
2.1%
72
Flipkart
₹6.3L
678
₹9,292
4.8%
64
Myntra
₹4.6L
512
₹8,984
5.1%
58
Meesho
₹3.2L
489
₹6,544
8.2%
41
Meesho flagged automatically — highest
return rate across all channels.
Total Ad Spend (30d)
₹8.5L
Across 4 platforms
Blended ROAS
3.2x
↑ 0.4x vs last month
Total Clicks
1.24L
Avg CPC ₹6.85
Spend by Platform
ROAS by Platform
💡 Optimization Insight: Google Ads continues to deliver the highest
ROAS at 4.1x, driven by Shopping campaigns. YouTube campaigns have high brand awareness
but lower direct conversion. Facebook and LinkedIn campaigns show stable conversion
rates.
Campaign Performance Summary
Campaign Name
Spend
Impressions
Clicks
Conversions
ROAS
Google
Shopping - Apparel
₹1,80,000
2.4M
48,200
2,840
4.5x
Facebook
Retargeting - Cart Abandoners
₹1,20,000
1.8M
35,100
1,650
3.8x
LinkedIn Lead
Gen - Enterprise B2B
₹1,90,000
850K
12,400
410
3.7x
YouTube Brand
Awareness - Video Ads
₹1,70,000
5.2M
65,000
720
2.5x
Track every rupee of ad spend and its
return across all platforms.
On-Time Delivery
94.2%
↑ 1.2pp vs last month
Avg Delivery Days
3.4
Across all partners
Pending Shipments
127
23 past SLA
Delivery Status Breakdown
Partner On-Time Performance
💡 Logistics Insight: Amazon Shipping achieves the highest SLA
compliance at 98%. Xpressbees has slipped by 1.4pp due to regional warehouse delays.
Ekart and Delhivery show stable transit times across key Tier-1 routes.
Courier Partner Performance
Courier Partner
Shipments
Avg Days
On-Time %
Return Rate
Cost / Order
Amazon
Shipping
1,240
2.8 days
98.2%
2.1%
₹48.50
Delhivery
850
3.5 days
95.4%
3.8%
₹52.00
Ecom Express
410
4.1 days
93.1%
4.5%
₹55.50
Xpressbee
182
4.8 days
91.0%
5.2%
₹58.00
Compare transit times and SLA
compliance across multi-carrier networks.
Net Revenue (30d)
₹24.1L
↑ 9.6% vs last period
Gross Margin
32.4%
After returns & logistics
Unreconciled
₹1.8L
3 payouts pending
Revenue by Channel
Payout Reconciliation
Marketplace
Expected
Received
Difference
Status
Amazon
8,82,400
₹8,82,400
₹0
Reconciled
Flipkart
₹6,30,200
₹6,28,100
₹2,100
Under
Review
Myntra
₹4,61,800
₹4,61,800
₹0
Reconciled
Meesho
₹3,21,500
—
₹3,21,500
Pending
Test New Query
Bypass learned patterns & force fresh AI
generation
Meesho: 8.2% return rate — highest across channels
ANALYTICS
Meesho has highest RTO rate at 8.2% driven by fashion SKUs. Amazon at 2.1%
(best). Average across all channels is 4.3%. Returns cost ~₹82/order in reverse
logistics + restocking.
⌨
GENERATED SQL (EDITABLE)
SELECT COUNT(CASE WHEN rto_status IS NOT NULL AND rto_status ≠
'' THEN 1 END) AS rto_count, COUNT(*) AS total, ROUND(100.0 * COUNT(CASE WHEN
rto_status IS NOT NULL AND rto_status ≠ '' THEN 1 END) / NULLIF(COUNT(*), 0), 1)
AS return_rate_pct FROM shipment WHERE booking_date ≥ CURRENT_DATE - INTERVAL
'30 days';
5
RTO Count
15
Total
33.30
Return Rate %
Training Data41 items
MKTWhat is my
blended ROAS across all channels this month?OK
FINShow
unreconciled payouts by marketplaceOK
ANAWhich
channel has the highest return rate and why?OK
LOGCompare
logistics on-time delivery across all partnersOK
FINWhat is my
margin impact from returns by SKU?OK
MKTTop
performing ad creatives by CTR this weekOK
ANACustomer
cohort analysis — repeat vs first-timeOK
ERRTotal Revenue (last 30 days)Fix
Stats
41
Total
38
Working
3
Errors
6
Categories
How AI Learns
You ask a question in plain English
AI finds the best matching pattern from trained data
Generates and runs the query automatically
If it makes a mistake, you correct it once
Next time, it gets it right — permanently
Ask anything — the AI learns from every
correction you make.
Connected
Data Sources
Manage all your connectors. Click Connect to
link a new channel, or Edit to configure active credentials.
Every connector is live-synced. Click to
edit auth credentials or data source.
Active
Accounts
Manage your connected platform accounts and
integrations.
United Commerce
Business Intelligence Platform
Welcome to United Commerce — your unified business intelligence platform.
Sign in to United Commerce
Access your private business intelligence dashboard
Your data stays on your private network
Secure SSO sign-in — your credentials never leave your private network.
Welcome, Rajesh
Let's connect your data sources. United Commerce will unify everything into a single intelligence
layer — private, on your network.
🛒
Sales Channels
Amazon, Flipkart, Myntra, Meesho, Shopify and more
📢
Ad Platforms
Google Ads, Facebook, YouTube, LinkedIn
🏢
ERP & Systems
SAP, Salesforce, Tally, APIs, CSV uploads
Connect sales channels, ad platforms, and ERP systems into one unified intelligence layer.
1
Sales
2
Ads
3
ERP/API
Connect Sales Channels
Select the marketplaces where you sell. You can add more later.
Select marketplaces, ad platforms, and ERP tools. Add or remove connectors any time.
Setting up your workspace
Connecting to your data sources and preparing your dashboard
0%
United Commerce is syncing your data sources. This initial setup only happens once.
ESC
Suggested Queries
What is my blended ROAS across all channels this month?
MARKETING
Show unreconciled payouts by marketplace
FINANCE
Which channel has the highest return rate and why?
ANALYTICS
Compare logistics on-time delivery across all partners
LOGISTICS
What is my margin impact from returns by SKU?
FINANCE
Show revenue trend for last 30 days
ANALYTICS
Total revenue last 30 days
FINANCE
A
Configure Amazon
Marketplace Connector
Choose setup method
🔐
OAuth / API Authentication
Connect via official API credentials. Real-time data sync with automatic token refresh.
Point to Export Dump
Provide a file path or URL to CSV/Excel exports. Good for initial setup or read-only
access.