💰 Gross Margin & Discount Intelligence
Profitability analysis going beyond revenue: gross margin, discount depth, and return-rate impact — derived from the gap between retail_price, sale_price, and cost in the TheLook dataset.
All monetary amounts are computed from the `price_intelligence` source, which pre-aggregates
item-level data from BigQuery. Only items where `cost < retail_price` are included to exclude
catalogue data anomalies. Cancelled and Returned items are excluded from profit metrics but
included in the return-rate section below.
Financial Summary
Gross Retail Value
$3,624,060
Total Discounts
$0
Net Revenue
$3,624,060
Cost of Goods Sold
$1,742,532
Gross Profit
$1,881,528
Avg Discount Rate %
0.0
GP Margin %
51.9
P&L Waterfall
How revenue transforms from full retail price all the way down to gross profit.
Loading...
Category-Level Profitability
GP Margin % by Category
Loading...
Discount Rate % by Category
Loading...
Category P&L Summary Table
No Results
Page
/
2 15 of 26 records
Price Tier × Category Profitability Heatmap
How does gross margin % vary across price brackets within each category?
Loading...
Monthly Gross Margin Trend
Is our profitability improving or eroding over time?
Loading...
Loading...
If the discount rate rises while GP margin % falls, heavier discounting is compressing profitability.
Watch for months where these two lines diverge significantly.
Return Rate Impact by Category
Returns and cancellations destroy realized revenue. Which categories are most exposed?
Loading...
Loading...
No Results
Page
/
2 15 of 26 records
Interactive Brand Deep-Dive
Select a category to explore which brands have the best gross margins.
Bar Chart
Dataset is empty - query ran successfully, but no data was returned from the database
Scatter Plot
Dataset is empty - query ran successfully, but no data was returned from the database
Data Table
Dataset is empty - query ran successfully, but no data was returned from the database