United Commerce
E-Commerce/Business Dashboard
Search with AI⌘K
Using cached data
Demo Mode
Overview
Correlation
Marketplaces
Ads
Logistics
Finance
Total Revenue (30d)
₹28.5L
↑ 12.3% vs last period
Orders Shipped
2,847
Avg ₹10.0K/order
Ad Spend ROI
3.2x
₹8.5L total spend
On-Time Delivery
94.2%
Across all partners
Revenue by Marketplace — Last 7 Days
₹160K₹120K₹80K₹40K Mon Tue Wed Thu Fri Sat Amazon Flipkart Myntra
Marketplace Share
₹28.5LTotal● Amazon 31%● Flipkart 22%● Myntra 16%● Others 31%
Ad Spend by Platform
Google Ads Facebook YouTube LinkedIn
Delivery Status
94.2%On-Time● Delivered● Shipped● Pending
All your key business metrics in one glance — revenue, orders, ROI, delivery.
Regions: Global MENA EUROPE North America Africa India
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
₹10.0L ₹5.0L ₹0.0L amazon flipkart myntra nykaa meesho Ad Spend Mkt Sales
Daily OTD % vs Orders — Last 7 Days
100% 93% 85% 600 300 0 Mon Tue Wed Thu Fri Sat Sun OTD % Orders
ROAS vs On-Time Delivery by Platform
5.0x / 100% 2.5x / 90% 0.0x / 80% Google Facebook YouTube LinkedIn ROAS OTD %
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
10%7%4%1% Avg 4.3% 8.2%Meesho 5.1%Myntra 4.8%Flipkart 3.9%Nykaa 3.1%Shopify 2.1%Amazon
💡 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
₹2.8LGoogle ₹2.1LFacebook ₹1.7LYouTube 1.9LLinkedIn
ROAS by Platform
5x4x3x2x1x 4.1xGoogle 3.2xFacebook 2.5xYouTube 3.7xLinkedIn
💡 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
2,682Shipped● Delivered 73%● In Transit 16%● Pending 8%● RTO 3%
Partner On-Time Performance
100%95%90%85% 98%Amazon 95%Delhivery 93%Ecom 91%Xpressbee
💡 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
8.8LAmazon ₹6.3LFlipkart 4.6LMyntra ₹3.2LMeesho ₹1.2LOthers
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.

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.