No data loaded. Upload your CSV files to populate the dashboard.
Returns Dashboard
Upload data to begin
All time
Return Rate (Units)?Returns ÷ demand units for orders placed in the selected period. A December order returned in February still counts in December — returns are attributed to the original order date, not when the return arrived back.
—
vs prior
Return Rate ($)?Return value ÷ demand sales $ for orders placed in the selected period. Dollar rate can differ from unit rate due to price mix — high-value items returning at lower rates still move the dollar rate. Click the card to open Variance Analysis.
—
vs prior
Total Returns?Count of returned units (Returns + Exchanges) for orders placed in the selected period. Cancellations are excluded — those are orders that never shipped. The delta shows % change vs the prior period.
—
vs prior
Return Value?Total dollar value of returned merchandise (Returns + Exchanges) for orders placed in the selected period. Sourced from the Net Sales column in your Returns file. Cancellations excluded.
—
vs prior
Return Rate Trend?Monthly return rate by order cohort — each bar represents orders placed that month and the % that were returned. Recent months may appear lower because some returns are still incoming. All returns are attributed to the original order month. Months shown in calendar order (Jan–Dec) per Ring Concierge's fiscal calendar.
This year vs last year · monthly cohort
Order Outcomes
Per 100 orders
By Product Type
View all →| Category | Rate |
|---|---|
| No data | |
By Channel
View all →| Channel | Rate |
|---|---|
| No data | |
By Customer Type
View all →| Type | Rate |
|---|---|
| No data | |
Top Returned Products
Ranked by return volume · vs category avg
| Product | Type | Returns | Unit Rate | vs Cat Avg |
|---|---|---|---|---|
| No data | ||||
Return Speed
Average days at each stage of the return journey · requires return portal data
Upload return portal files to see return speed reporting
Explorer
Select a dimension to explore
PERIOD
All time
GROUP BY
|
Demand Units
—
Return Units
—
Unit Return Rate
—
Return Value
—
Results
| Select a dimension above |
No data loaded. Upload your CSV files to populate the heat map.
Returns Heat Map
Category & product return performance at a glance
All time
Synced from dashboard
Return Rate: loading…
Upload data to view heat map
Upload Narvar return portal files to populate Voice of Customer analysis. Upload data
Voice of Customer
Return reasons & customer comment themes from your returns data
The "Recent" window splits comments into recent vs historical for the theme tracker and shift chart. Days are counted back from the latest return date in your uploaded data — not from today. Upload return portal data to see the active date window.
Return Reason Codes
Structured return reasons · ranked by volume
No return reason data loaded
Comment Theme Tracker
Theme counts reflect the Recent window only (configurable top-right) — not the date pills above
Themes:
Stable
↑ Emerging
↓ Fading
No comment data
Recent vs Historical Theme Shift
Theme share of comments — recent period vs prior baseline
| Theme | Historical % | Recent % | Change | Signal | Count (recent) |
|---|---|---|---|---|---|
| No data | |||||
Customer Comment Browser
All comments
No comments loaded
Products Needing Attention
High return rate + below-average review rating — click any product to open in Explorer
Upload a Product Reviews CSV to enable this analysis
No data loaded. Upload CSV files to detect outliers.
Outlier Alerts
Sorted by return value · products above category average
Upload data to detect outliers
Action Tracker
Assigned outliers, logged interventions, outcome tracking
No actions yet. Assign outliers from the Outliers tab.
Upload Data
Upload your Returns and Demand/Sales CSV files
File structure
- Returns file: One row per returned/exchanged item. Must have: Order Name, Product title, Return Type, Net sales
- Demand file: One row per sold item. Must have: Order Name, Product title, Demand U, Demand Sls $
- Narvar file (optional): Return portal data. Adds customer comments and return reasons. Joined on Order Number — Shopify data always takes precedence where both exist.
- Product Reviews file (optional): Customer review data. Adds star ratings and review text to Explorer product detail cards. Must have a rating column (e.g. Star Rating) and product title.
- Multiple years of each file can be uploaded at once.
Click to upload CSV files
Upload Returns and Demand files — multiple years OK
Processing...
The Returns Guy™ Insights
AI analysis trained and informed by The Returns Guy™ Reduce · Profit · Delight framework
Anthropic API Key
Not configured
Your key is used only to call Anthropic's API directly from your browser and is never stored or transmitted elsewhere. It is cleared when you close this tab. Get an API key →
Goal
Output
Best used when
Running analysis...
Data Specifications
Required fields and format requirements
Returns file
RequiredOrder name · Key/Product Key · Return Type (Returns/Exchanges) · Net sales · Product title · Product variant · Product type · Subbrand · Channel · Customer ID · Fiscal Month · New or returning customer · Original Order Year
Demand / Sales file
RequiredKey/Product Key · Order name · Customer email · Demand Sls $ · Demand U · Product title · Product variant · Product type · Fiscal Month · Channel · New or returning customer
Product reviews
Recommendedproduct_id · review_date · star_rating · review_text · size_feedback · fit_feedback · quality_feedback
Promotions data
Recommendedorder_id · promo_code · discount_type · discount_pct · promo_start · promo_end · urgency_flag
Format requirements
- Separate CSV files per year — Returns and Demand separately
- Filter Include? = X before exporting
- Return Type: include Returns + Exchanges only, exclude Cancellations
- Minimum 12 months — 24+ enables YOY analysis
- Row-level data only, not monthly summaries
- Remove PII — normalized Customer ID is sufficient
Client Request Letter
Generate a professional data request for your client's team
Drafting letter...