HomeFinanceReturns by channel, six monthsAskMIMaya IyerStudio
One place to manage your company's whole semantic context graph.1 hop2 hops
AllFocus
2D3D
Changelog2,630Add nodeMaya's Workspace0 domains · 0 nodes in all0
79 certified · 23 in review · 0 stale
- orders48
- variants32
- customers25
- channels24
85 certified · 40 in review · 0 stale
- campaign_daily27
- campaigns15
- sessions13
- ad_accounts10
52 certified · 16 in review · 0 stale
- shipments27
- returns18
- warehouses14
- batches11
30 certified · 23 in review · 0 stale
- pnl_monthly14
- FY2627 Q3 targets11
- Month end close checklist10
- settlement_lines9
18 certified · 3 in review · 0 stale
- tickets17
- Customer experience service levels7
- reviews7
- Support backlog after the festive peak6
22 certified · 32 in review · 0 stale
- ingest_files13
- Marketplace order load7
- Own-site order ingestion7
- Nightly data refresh6
5 links5 links5 links1 linkKnowledge8
What was written, happened or was aimed at
Meaning24
What the words, rules and steps say
Metrics7
What the company counts
Data14
Where the numbers come from
AffectsAffectsDefinesDefinesUsesUsesDocumentFY2627 Q3 targets DocumentMonth end close checklist EventGST rate change on hair care and soap GoalQ3 FY2627 CM2 percent
RuleFinance returns zero rows, not an error RuleA settlement date is cash, not revenue ProcessSettlement reconciliation MetricGross margin percent Dataset · financepnl_monthly Dataset · financesettlement_lines Dataset · financesettlements Dataset · financecogs_monthly Dataset · financeledger_export Dataset · financefx_rates - invoice_id
- invoice_number
- order_id
Dataset · salescredit_notes - invoice_id
- credit_note_id
- credit_note_number
Maya's WorkspaceFinanceNet sales0 domains · 0 nodes · 0 links between them Review
214 pending reviews · 6 need a person · 41 tables
208ready to acceptNo blockers · Not stale · Not waitingQuick lookAccept allNothing is ready to accept.
6 need a person6 tables, most asked first
WhyAll6Would break something1Conflicts1Waiting3Low confidence4
WhereNeed a person
Data · earthem
flipkart_settlement_rows1 of 4 Nothing needs a person in the other 35 tables
Every table the company has, and everything every team owns.
Data194Metrics38Definitions112Policies24Knowledge31Activity2,630
MetricWhat it means hereIn the modelTeamUpdated
Net salesInvoices minus credit notes, before GSTnet_salesFFinance2h ago
Return rateTwo definitionsUnits returned over units shippedreturn_rateOOperations1d ago
ROASAttributed revenue over ad spend, last clickroasMMarketing3h ago
Contribution marginNet sales minus COGS, shipping and feescontribution_marginFFinance1d ago
First response timeMedian minutes to the first agent replyfirst_response_minSSupport5h ago
Data freshnessHours since the nightly refresh finishedrefresh_lag_hTTech20m ago
What do you want to know?
Ask questions. Find insights. Build dashboards.
RecentSee all
Creating a sales dashboardyesterday Orders stuck in shippingyesterday Average order value last monthyesterday Top sales channel last quarteryesterday Top products by revenue this yearyesterday How have returns trended across channels over the last six months?
I'll trend monthly return requests by sales channel from March to August 2026 using fulfillment returns and order data.
Find today's date to set the six-month window5 tables read Count return requests by channel and month, March to August 20261,222 return requests in August, down 6.1% from July Chart the monthly trend for the top channelsLine chart added for March to August 2026 Returns rose every month from March to a July peak of 1,304 requests, then fell 6.1% to 1,222 in August 2026.
Returns by ChannelMar to Aug 2026ChartTable View SQLFull traceCSV42 rows Earthem.in carried the most returns in all six months, peaking at 545 in July before easing to 519 in August (down 4.8%). Amazon.in followed the same shape, from 371 to 350 (down 5.7%), while Flipkart fell hardest, down 15.8% to 165. Myntra, the smallest of the four, eased from 90 to 84.
The analysis rests on tracked return requests in fulfillment.returns and item counts from fulfillment.return_items for March to August 2026, excluding undelivered parcel returns (RTOs). Would you like to evaluate the underlying return reason codes for the top channels?
Create a sales dashboard
I will build a comprehensive sales dashboard covering headline metrics, channel performance, product breakdown, and regional distribution for the past 30 days.
Find the latest clock date to define the 30-day reporting window.9 tables read Compute overall headline KPIs including net sales, total orders, and average order value with prior period comparison.Headline KPIs and trend computed Analyze daily net sales trend over the 30-day window.Daily sales trend generated I compiled sales, channel, product, and regional data from 20 Aug to 18 Sep 2026 for the Sales Performance Dashboard, structured across four sections.
Sales Performance Dashboard
PeriodLast 30 daysLast 7 daysLast 30 daysLast 90 daysThis year Compare toPrevious period Updated 9 Oct at 12:29 pmNet Sales₹24.85M+5.3% vs previous period Total Orders26,714+8.8% vs previous period Average Order Value₹892.2+0.4% vs previous period Daily Net Sales Trend
Net SalesPrevious period
sales.credit_notes, sales.invoices Channel Performance2 tiles Net Sales by Channel
Previous period
sales.channels, sales.credit_notes, sales.invoices, sales.orders, sales.qc_purchase_orders Order Volume by Channel
Previous period
sales.channels, sales.orders Top Products by Sales
SalesPrevious period
catalog.products, catalog.variants, sales.order_items, sales.orders Sales by Category
SalesPrevious period
catalog.categories, catalog.products, catalog.variants, sales.order_items, sales.orders Sales Performance Dashboard4 sections · 10 tilesPreviewHere is what it covers:
- Headline Metrics: Key company performance figures showing Net Sales of 24.9M, Total Orders of 26.7K, and Average Order Value of 892, along with daily sales trends.
- Channel Performance: Sales and order volume splits across sales channels, led by the website Earthem.in at 8.29M net sales.
- Product Breakdown: Revenue contributions across product lines and categories, led by Vitamin C Serum (4.58M) and the Serums category (6.97M).
- Regional Breakdown: Geographical distribution of sales across Indian states and cities, led by Maharashtra (4.48M) and Mumbai (2.71M).
What is driving the recurring weekly spikes in net sales on Mondays, and can inventory fulfillment keep up with quick commerce growth on Blinkit and Zepto?