Face Scans iTotal unique customers who did a face scan this month (MTD). Each customer counted once even if they scanned multiple times.
—
MTD Unique Scans
Orders (Direct) iUnique customers who placed an EasyEcom order within 48 hours of their face scan. Multiple orders by the same customer in the same window count as 1 conversion.
—
Scan-Attributed
Total Revenue iNet revenue from scan-attributed orders (ex-GST). Gross selling price ÷ 1.18 to remove 18% GST. Includes all orders placed within 48h of a face scan.
—
MTD Gross Sale
Conv. Rate iConversion rate = Scan-attributed orders ÷ Total face scans. Shows what % of face scan customers placed an order within 48 hours.
—
Orders / Scans
CM1 iContribution Margin 1 = Net Revenue × 50%. Represents gross profit after cost of goods (assumed 50% margin).
—
Gross Margin (50%)
CM2 iContribution Margin 2 = CM1 − Marketing Costs. Currently no marketing costs are tracked, so CM2 = CM1.
—
After Mkt Costs
CM3 iContribution Margin 3 = CM2 − FTE − Tele-calling − WhatsApp broadcast costs. Currently no additional costs tracked, so CM3 = CM2.
—
After All Costs
Website Sale iTotal website revenue MTD pulled from the Secondary sheet (cell D4). This is all website orders, not limited to face scan customers.