Revenue
—
—
บาท
Orders
—
—
ออเดอร์
Customers
—
—
unique
New customers
—
—
share —
AOV
—
—
บาท / order
Repeat Rate
—
—
—
LTV (avg)
—
—
บาท / customer
Units sold
—
—
ชิ้น
Cancel rate
—
—
—
Revenue / day
—
—
บาท / day
Stock at risk
—
—
<14d cover
TMC members ⭐
—
—
ลูกค้าที่ซื้อ · เป็นสมาชิก TMC
Promotions · Social / Direct channel
Promo-tagged orders parsed from factorders.remark (manual FB / LINE / office). Marketplace orders carry no promo tag. Follows the date & page filters. Measures revenue / AOV / acquisition lift — not discount depth.Promo rev share
Promo revenue
—
—
บาท
AOV · promo vs base
—
—
—
New-cust share (promo)
—
—
—
Top promo type
—
—
Active promos
—
in catalogue
| Promo type | Orders | Revenue | Rev share | AOV | Units/order |
|---|
Customer Journey · Acquisition Funnel
From the leads table — follows the date & page filters. FB ad spend follows the page filter (FB pages only). Click a stage or source to drill into the leads.Inbox
—
total leads
—quality›
Quality
—
—
—close (Q)›
Closed
—
—
New leads
—
ลูกค้าใหม่
Return leads
—
ลูกค้าเก่า · win-back
TMC members ⭐
—
membership leads
Source mix
Ad spend (FB)
—
all FB pages
CPL (spend ÷ inbox)
—
บาท / lead
ROAS (FB)
—
purchase value ÷ spend
CPA (FB)
—
บาท / purchase
FACEBOOK · Funnel & CPL per page
Inbox (split by lead source: Ads / Walk-in / BC) → Quality → Closed per FB page, with FB ad spend & CPL. Follows the date & page filters.| Page | Inbox | Ads | Walk-in | BC | Quality | New | Return | TMC | Closed | Conv% | AOV | Spend | CPL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||||||
LINE · Funnel per page
Inbox (split by lead source: Ads / Walk-in / BC) → Quality → Closed per LINE page. No ad spend on LINE.| Page | Inbox | Ads | Walk-in | BC | Quality | New | Return | TMC | Closed | Conv% | AOV |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||||
Marketplace Ads — Lazada + Shopee
Ad spend, Ad GMV & ROAS (Ad GMV ÷ spend) from laz_ad_daily (Sponsored Max + MSA) & shopee_ad_daily (CPC, broad). Orders, Revenue & tROAS (Revenue ÷ spend) are whole-channel actuals from laz_orders / shopee_orders, not ad-attributed. Follows the date filter.| Channel | Ad Spend | Impressions | Clicks | CTR | Ad GMV | ROAS | Orders | Revenue | tROAS |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
—
Channel Mix (period revenue)
Monthly Revenue Trend
Product Category Mix
| Category | Units | Orders | % Share |
|---|---|---|---|
| Loading… | |||
Top Products
by units · top 15| Product | SKU | Units | Orders |
|---|---|---|---|
| Loading… | |||
Year × Month Heatmap (revenue, บาท)
Yearly Performance
| Year | Revenue | Orders | AOV | Customers | Cancel% | Rev/day |
|---|---|---|---|---|---|---|
| Loading… | ||||||
🎫 Latest Incident Updates — click to view details
Loading…
Latest Period
—
—
YoY Revenue
—
vs same month last year
Top Page (Units)
—
—
Top Channel (Units)
—
—
Order Composition
Orders grouped by units per order — share of total orders shown above each bar
📈 Trend & Forecast
Monthly revenue trend, YoY change3-period MA Units
—
moving avg / period
Best / Worst Day
—
in window
Monthly avg/day
—
units / day (current month)
Yearly avg/day
—
units / day (YTD)
All-time avg/day
—
units / day (all history)
Units Trend
YoY Revenue Change (%) — same period vs last year
📄 Page Breakdown
Per-page revenue — each FB / Line / IG / Marketplace pageActive Pages
—
with orders in window
Top 3 Concentration
% of total units
Total Units (pages)
—
across all pages
Units Share by Page
Page × Year Units (stacked)
Units by Page (over time)
All Pages — Detail
| Page | Channel | Revenue | % Share | Orders | AOV | Customers | Units | Cancel |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
📡 Channel Rollup
Facebook · Line · IG · Website · Shopee · Lazada · TikTokActive Channels
—
online channels in window
Marketplace Share
Shopee + Lazada + TikTok (units)
Total Units (channels)
—
across all channels
Units Share by Channel
Channel × Year Units (stacked)
Units by Channel (over time)
All Channels — Detail
| Channel | Revenue | % Share | Orders | AOV | Customers | Units | Cancel |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Customers
—
unique mobile
Repeat Rate
—
—
Avg LTV
—
บาท / customer
VIP (11+ orders)
—
—
RFM Frequency Cohort
LTV Distribution
Top 200 Customers by Spend
| # | Mobile | Name | Orders | Spent | First | Last |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Scope: factorders (FB/Line/IG/Office). Marketplace pure-buyers (Shopee/Lazada API) are excluded — their buyer_id isn't linkable to dimcustomers.
🎫 Ticket
Loading…
— Customer
—
Loading…
Lifetime scope · all channels
Tip: click any mobile in another table to open this view
Quality
Active
Total Leads
—
—
Closed
—
leads
Conversion
—
closed / total
Quality Conv ⭐
—
—
Sales Revenue
—
closed leads (FB+LINE only)
AOV (closed)
—
บาท / sale
เปรียบเทียบ 3 เดือนล่าสุด
x-axis = วันที่ในเดือน · 1 เส้น = 1 เดือน (latest 3)
เปรียบเทียบเทรนด์เดือนล่าสุดกับ 2 เดือนก่อนหน้า ตาม page filter · ● จุดใหญ่ขอบแดง = วันอาทิตย์ · hover ดูชื่อวัน
Lead Status Funnel — click a slice to drill
Source Mix — click a slice to drill
Page Mix — ignores page filter · click to drill
Monthly Leads vs Closed — click a bar to drill that month
🔍 Why leads did not close (reason analysis) — click a bar to drill into leads
Across non-Closed leads matching current filters. Pink overlay = the share that were marked quality. Click any bar to see the actual lead rows behind it.
🕐 When leads come in — day × time — Asia/Bangkok · click a cell to drill
Loading…
Lead volume by weekday and timerange (admin-entered). Darker = more leads. Rows without a timerange are excluded.
📦 Product Waitlist — top 10
Customers blocked by รอสินค้า (หมดสต็อค) — all time · multi-product entries split per item · click a card for names
—
distinct customers
Loading…
Admin Leaderboard — click a row to drill
| Admin | Leads | Closed | Conv | Revenue |
|---|---|---|---|---|
| Loading… | ||||
By Page — click a row to drill
| Page | Leads | Closed | Conv | Revenue |
|---|---|---|---|---|
| Loading… | ||||
By Product (base products) — click a row to drill
| Product | Leads | Closed | Conv | Revenue |
|---|---|---|---|---|
| Loading… | ||||
Multi-product entries are split on commas, so a lead listing 3 products contributes one row to each. Counts and revenue are therefore not mutually exclusive across rows.
Next 30 days
—
forecast P50
Next 90 days
—
forecast P50
vs prior 90d
—
forecast vs recent actuals
Backtest WAPE
—
30-day horizon
P80 coverage
—
actuals inside band
Revenue — Actuals & Forecast
—
Backtest accuracy by horizon
| Horizon | WAPE | MAPE | sMAPE | Bias | P80 cov. | Samples |
|---|---|---|---|---|---|---|
| Forecast pipeline not yet run. | ||||||
WAPE is the headline accuracy metric — weighted absolute % error. P80 coverage = % of actual days that fell inside the P10–P90 band; well-calibrated models hit ~80%.
Events in window
| Date | Type | Name | Intensity | Channel |
|---|---|---|---|---|
| Loading… | ||||
Events are loaded from mc_event_calendar and used by the forecasting model as regressors.
Mega sales (9.9, 10.10, 11.11, 12.12) carry intensity 2.5; mid-month sales carry 1.5; Thai holidays carry 1.0 (Songkran 1.5).
Shopee vs
Lazada head-to-head.
Headline KPIs & Trend revenue uses Shopee's "รวม" formula (item-line subtotal + buyer-paid ship − seller voucher), matching Shopee Seller Center reports. Lazada uses
order_total_amount. Per-SKU & bundle sections use item-level revenue (order totals can't be attributed to specific SKUs).
Cancelled Shopee orders are excluded. Channel & page filters do not apply on this page.
Orders
—
—
Shopee · Lazada
Units
—
—
ชิ้น
Revenue
—
—
บาท
AOV
—
—
บาท / order
Marketplace Trend
—
Category Trend — Shopee vs Lazada
One line per product category, split by marketplace. Uses the same interval and metric as the main trend above.
Shopee
—
Lazada
—
Head-to-Head Matrix
| Category | Shopee | Lazada | Total | Shopee share | Leader |
|---|---|---|---|---|---|
| Loading… | |||||
—
Bundle vs Single (units share)
Top Bundle SKUs
| Bundle SKU | Channel | Units | Orders | Revenue |
|---|---|---|---|---|
| Loading… | ||||
Customer Cohorts
"New" = first-ever order on that level (channel / SKU) fell within the selected window.
Per channel — no cross-channel customer matching.
Shopee — new vs return
—
new
·
—
return
—
Lazada — new vs return
—
new
·
—
return
—
Acquisition Cohort over time
Per-bucket new = customer's first-ever channel order falls in that bucket. Uses the main Trend's interval (Daily / Weekly / Monthly).
Shopee
Lazada
Per-SKU — new vs return customers
Showing top SKUs by customer count
| Product (SKU) | Channel | New | Return | Total customers | % New | New revenue | Return revenue |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Lazada Ads — Sponsored Max + MSA
Daily spend & ROAS from
laz_ad_daily (Open Platform + seller-center). Follows the date range above.Ad Spend
—
บาท
ROAS
—
GMV ÷ spend
Revenue (GMV)
—
บาท
Clicks
—
—
Impressions
—
total
| Solution | Spend | ROAS | Revenue (GMV) | Clicks | Impressions |
|---|---|---|---|---|---|
| Loading… | |||||
Shopee Ads — CPC
Daily spend & ROAS from
shopee_ad_daily (Open API, ~6-month retention). Follows the date range above.Ad Spend
—
บาท
ROAS
—
broad GMV ÷ spend
Ad GMV
—
broad attribution
Clicks
—
—
Impressions
—
—
| Attribution | Ad GMV | ROAS | Orders | Units |
|---|---|---|---|---|
| Loading… | ||||
Broad = sales within attribution window incl. assisted; Direct = clicked-then-bought only. Spend is identical (฿—); only the credited conversions differ.
💰 Spend by FB page
Stacked bars, one per FB page · from
pk_fb_ad_spend. Use the FB-page filter below to drill down to a single page.📈 ROAS by FB page
Revenue ÷ spend, one line per page. Bucket follows the toggle above.
🎯 CPA by FB page
Spend ÷ purchases. Buckets with zero purchases are hidden — CPA is undefined.
📣 Ad Performance
Per-ad spend & ROAS across all FB ad accounts · from Facebook Marketing API (level=ad)
| Ad | FB Page | Campaign | Objective | Status | Spend | Impr | CTR | Purchases | Revenue | ROAS | CPA | Last | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| กำลังโหลด… | |||||||||||||
🚧 Page under construction
This page is in the spec but not yet wired. See multichannel/SPEC.md.