Modern Trade Sale-Out
Filtered sale-out performance
Account, brand, and store performance for the current filter selection.
-
-
Avg/mo -
Qty -
Brands -
SKUs -
Stores -
Coverage -
Leading Account
-
-
Leading Brand
-
-
Leading Store
-
-
Latest Monthly Change
-
-
-
Avg / Month by Mall
Same selected filter scope, split by mall account
Annual Sales Trend
Always shows every year side-by-side to compare growth — respects mall, brand, month, and category filters
Monthly Performance
Switch between net sales and quantity in the same monthly view
Top Store Value Ranking
All stores ranked by sales — click header to sort
| Rank | Store | Mall | Sales (฿) | QTY (pcs) | % Share |
|---|
Brand Ranking
Top brands by sales amount (all data in current filter)
| Rank | Brand | Sales Amount (฿) | Avg/Month (฿) | Quantity | % Share |
|---|
▼ Show all brands
II.
Sales by Brand
Brand command view
Brand contribution at a glance
Top-brand value, concentration, active brand count, and SKU depth in the current filter scope.
-
-
Top Brand
-
-
-
Active Brands
-
-
-
Momentum Month
-
-
-
Brand Sales Mix
Share of sale-out — donut + ranked share, top 8 brands
Brand Sales / Quantity by Month
Switch between net sales and QTY in the same monthly view
Brand × Mall Matrix
Sales per brand per mall (฿) — top 8 brands
Products by Sales
All products — click header to sort
| # | Brand | Barcode | Product Name | Sales (฿) | QTY (pcs) | Qty/Month | Avg/Month (฿) |
|---|
Brand Comparison
Monthly Sales Trend
One line per brand — all months aggregated
Total Sales by Brand
Ranked bar for selected brands
Brand Metrics Summary
Key KPIs for compared brands
Side-by-Side Comparison
Compare net sales between two independently-filtered groups
Side A
Total Net Sales
—
Avg / Month
—
—
VS
Total
—
—
—
—
Avg/Mo
—
—
—
—
Side B
Total Net Sales
—
Avg / Month
—
III.
Sales by Store
Store command view
Store contribution at a glance
Top-store value, sales concentration, active store count, and latest-month movement for the selected scope.
-
-
Top Store
-
-
-
Active Stores
-
-
-
Momentum Month
-
-
-
Store Sales by Month
100% stacked column (top stores) + line
Store Quantity by Month
Stacked column (top stores) + line
Store × Brand × SKU
Breakdown table for selected filters
| Brand | SKU | Product Name | Sales (฿) | QTY (pcs) |
|---|
Full Store Rankings
All stores ranked by sales — largest to smallest
| Rank | Store Name | Mall | Sales (฿) | QTY (pcs) | Avg/Month | % Share |
|---|
IV
Compensation
Total Compensation
—
Products Affected
—
distinct SKUs
Customers
—
with compensation
Avg / Month
—
active months
Best Promotions
Top by avg compensation per month
* Avg Comp/Month = total compensation ÷ active months · * Avg Qty/Month = total qty ÷ promo days × 30
Best Period
Monthly compensation — peak month highlighted in gold
Monthly Compensation Trend
Total deduction amount by month
Deduction by Brand
Share of total compensation
Top Accounts by Compensation
Ranked by total deduction — all matching accounts
| # | Account | Brands | Total Compensate | Share | Share w/ Sales In | Promotions | SKUs |
|---|
Avg Qty / Month by Mall · Vendor
Bars show avg qty/month; total pcs and compensation details are in each cell
* Avg Comp/Month = total compensation ÷ active months · * Avg Qty/Month = total qty ÷ promo days × 30
SKU Performance
Toggle between avg/month summary and top deduction ranking
| # | Product | Brand | Promotion | Mall / Account | Avg Comp/Month | Avg Qty/Month | Avg Diff/Unit (฿) |
|---|
* Avg Comp/Month = total compensation ÷ active months · * Avg Qty/Month = total qty ÷ promo days × 30
Promotion Performance
Duration and total deduction per promotion × account
| Promo Type | Promotion | Mall / Account | Promo Period | Total Compensate | # Products | Diff/Unit (฿) |
|---|
Period Performance
Peak month by brand × account × promotion × product
| Brand | Mall / Account | Promo Type | Promotion | Product | Promo Period | Peak (฿) | Avg/Month (฿) | Diff/Unit (฿) |
|---|
V
Promotion Intelligence
ⓘ Attribution: a sale is counted as promotional when its product matches a promotion and the sale date falls within the promotion window (inferred — direct FK coverage <0.1%).
Promo Sales
—
฿ in promo windows
% of Total Sales
—
Share of all revenue
Transactions
—
Sales rows in promo windows
Active Promos
—
of — in catalog
Avg Discount
—
Weighted by sales
Promo Velocity
—
฿ per active promo-day
Monthly Promo Sales
฿ attributed to promotion windows per month · line = % of total sales
Promo Type Breakdown
Sales share by type
Promo Sales by Brand
Ranked by total sales within promotion windows
Customer Breakdown
Top customers buying within promotion windows
| # | Customer Name | Channel | Sales (฿) | Txns | ฿/Txn | % Share |
|---|
Promotion Performance
Promotion Performance
Promos with at least one inferred sale — filtered by Brand / Customer / Type above
| Promo Name | Type | Status | Start | End | Days | Discount % | Sales (฿) | ฿/day | Txns | Brands Hit |
|---|
Products in Promo Windows
Top Products in Promo Windows
Highest revenue during active promotions
Category Mix
Promo sales by product category
Product Detail
All products sold within at least one promotion window — filtered by Brand / Customer above
| # | Product Name | Brand | Category | Promos | Txns | ฿/Txn | Sales (฿) |
|---|