KPI Dictionary
A plain-language glossary for the executive dashboards in this portfolio.
5 min read
Executive summary
Dashboards in this portfolio translate booking data into executive language. Use this glossary when reading Product Performance, Revenue Dashboard, or Profitability Dashboard.
Profitability Dashboard
- Gross Sales - SUM(TongTienBan + TongTienVTUTBan) before discounts.
- Net Sales - SUM(TongBanSauGGBS / 1.1), sell side ex-VAT.
- Purchase Cost - SUM(TongMuaSauGGBS / 1.1), buy side ex-VAT.
- Commission - SUM(TongHoaHong).
- Profit (LoiNhuan) - legacy row profit, summed for the period.
- Margin % - Profit / Net Sales x 100.
Product & revenue analytics
- Bookings - COUNT(DISTINCT LichBook_Id) in period.
- Spots (legacy) - SUM(TongPost) on schedule lines.
- Broadcast Airings - COUNT(KyTu rows) - confirmed TV spots.
- Revenue - SUM(GiaBan) on aired rows for efficiency metrics.
- Revenue / Airing - aired revenue / KyTu occurrences (corrected spot economics).
Operational counts
- Customers - distinct advertisers with bookings in period.
- Channels - distinct broadcasters / networks used.
- Products - distinct advertised brands (demo-masked in public views).
- Duration - SUM(ThoiLuong) seconds of commercial material.
For analysts
Always check whether a KPI uses all schedule rows or KyTu aired rows - mixing them inflates per-spot economics.