Phuc Loc Nguyen — Workspace
Formula Library

Quick reference

ROAS (Return on Ad Spend)

Measures gross revenue attributed by an ad platform (or analytics model) per unit of direct media spend on that channel.

ROAS = Attributed Revenue / Advertising Spend

Variables & units

  • Attributed Revenue (Same currency as spend (e.g., VND or USD)): Revenue credited to the ad channel within a defined attribution window (e.g., 7-day click, 1-day view).
  • Advertising Spend (Currency (VND or USD)): Media cost charged by the ad platform over the matching time window (excluding agency fees unless specified).

Revenue basis & attribution distinction

Platform-attributed revenue is NOT identical to net recognized revenue or cash collected. For marketplaces like TikTok Shop, confirm whether the platform reports GMV (gross checkout value before cancellations/returns/subsidies) or net settled revenue.

Assumptions & guardrails

  • Revenue and spend cover the exact same date range and currency.
  • Conversion tracking (Pixel + CAPI / Events API) deduplicates browser and server events.
  • Attribution window is stated explicitly when comparing Meta, Google, and TikTok.

When this formula misleads

  • Comparing sum of platform-reported ROAS across channels directly against total store revenue (platforms overlap and double-count conversions).
  • Evaluating profitability when gross margins, shipping, returns, or marketplace commissions vary widely across SKUs.
  • Lead-generation funnels with long offline sales cycles where closed revenue is not fed back via offline conversions.
Illustrative hypothetical scenario (not client performance): Direct-to-consumer campaign over 30 days.

Inputs: Ad Spend = 100,000,000 VND; Platform-attributed net order value = 400,000,000 VND.

Calculation: ROAS = 400,000,000 / 100,000,000 = 4.0x (or 400%).

Decision insight: Every 1 VND spent on media generated 4.0 VND of platform-attributed revenue; whether 4.0x is profitable depends on Break-Even ROAS.

MER (Marketing Efficiency Ratio / Blended ROAS)

Measures overall top-line business efficiency across all paid and organic channels without relying on platform attribution models.

MER = Total Revenue / Total Marketing Spend

Variables & units

  • Total Revenue (Currency (VND or USD)): Total net store/business revenue across all channels (paid + organic + direct + CRM) in the period.
  • Total Marketing Spend (Currency (VND or USD)): Sum of all paid media spend (plus variable creator commissions or creative/agency marketing costs if defined consistently).

Revenue basis & attribution distinction

Blended metric anchored to actual accounting or backend order revenue (net of cancellations, discounts, and refunds where available), eliminating cross-platform attribution inflation.

Assumptions & guardrails

  • Consistent definition of Total Marketing Spend (document whether creator commissions, KOC samples, and retainers are included).
  • Measured over stable cycles long enough to absorb conversion lag (typically weekly or monthly).

When this formula misleads

  • Isolating which specific ad set, campaign, or creative caused a lift (use MER alongside channel diagnostics and incrementality tests).
  • Businesses where repeat purchases from older cohorts dominate short-term revenue (pair total MER with New-Customer MER / aMER).
Illustrative hypothetical scenario: Multi-channel brand running Meta, Google, TikTok, and organic email.

Inputs: Total net monthly revenue = 1,200,000,000 VND; Total marketing spend (Meta + Google + TikTok + affiliate fees) = 240,000,000 VND.

Calculation: MER = 1,200,000,000 / 240,000,000 = 5.0x.

Decision insight: Even if individual ad managers report higher combined attributed revenue due to overlap, actual blended efficiency is 5.0x.

CAC (Customer Acquisition Cost)

Measures the true cost required to acquire one brand-new customer (distinct from CPA, which can count repeat orders or leads).

CAC = Acquisition Cost / New Customers Acquired

Variables & units

  • Acquisition Cost (Currency (VND or USD)): Marketing (and sales, if B2B/high-ticket) expenditure allocated to acquiring new customers in the period.
  • New Customers Acquired (Integer count (customers)): Count of first-time unique buyers (excluding repeat purchases by existing customers).

Revenue basis & attribution distinction

Blended business metric. Distinguish clearly between Paid CAC (paid media spend / new customers from paid), Blended CAC (total marketing cost / all new customers), and CPA (cost per action/order including repeat buyers).

Assumptions & guardrails

  • Order database deduplicates returning customers accurately by phone, email, or customer ID.
  • Time lag between click/lead and first purchase is accounted for in cohort windows.

When this formula misleads

  • Replacing CAC with platform CPA in retention-heavy stores—retargeting existing buyers lowers CPA artificially while hiding rising new-customer CAC.
Illustrative hypothetical scenario: E-commerce store tracking first-time vs. returning buyers.

Inputs: Total acquisition spend = 150,000,000 VND; Total orders = 1,000 (600 new customers, 400 returning).

Calculation: Blended CAC = 150,000,000 / 600 = 250,000 VND per new customer (whereas CPA per order would look like 150,000 VND).

Decision insight: Scaling budget safely requires comparing 250,000 VND CAC against first-order contribution margin and LTV payback.

CVR (Conversion Rate)

Measures the percentage of website or storefront sessions that result in a completed order (or qualified conversion action in lead funnels).

CVR = Orders / Sessions

Variables & units

  • Orders (Integer count (orders or leads)): Completed checkout orders (or qualified lead submissions) within the reporting period.
  • Sessions (Integer count (sessions)): Tracked visits/sessions on the storefront or landing page (do not mix Sessions with Ad Clicks without stating so).

Revenue basis & attribution distinction

Funnel efficiency ratio. Clarify denominator (GA4 sessions vs. landing-page views vs. ad clicks) and numerator (placed orders vs. paid/delivered orders).

Assumptions & guardrails

  • Session deduplication and checkout completion events fire reliably across devices and payment redirects.

When this formula misleads

  • Judging traffic quality on CVR alone—cold prospecting traffic naturally converts lower than branded search or retargeting.
Illustrative hypothetical scenario: Landing page CRO test.

Inputs: Sessions = 20,000; Completed orders = 640.

Calculation: CVR = 640 / 20,000 = 0.032 (3.2%).

Decision insight: Improving CVR from 2.4% to 3.2% lifts revenue by 33.3% at identical traffic volume and CPC.

AOV (Average Order Value)

Measures the average monetary value generated per order, used to diagnose bundle pricing, upsells, and shipping thresholds.

AOV = Revenue / Number of Orders

Variables & units

  • Revenue (Currency (VND or USD)): Total order revenue over the same basis (explicitly specify net merchandise revenue vs. gross checkout including shipping/tax).
  • Number of Orders (Integer count (orders)): Count of completed orders corresponding to that revenue figure.

Revenue basis & attribution distinction

State clearly whether discounts, shipping fees, and platform vouchers are included or excluded; never compare GMV-based AOV with net-revenue AOV without adjustment.

Assumptions & guardrails

  • Order distribution is not overly skewed by rare wholesale outliers (pair mean AOV with median order value when skewed).

When this formula misleads

  • Subscription or B2B retainer models where multi-month contract value matters more than single-checkout AOV.
Illustrative hypothetical scenario: Bundle offer launch.

Inputs: Net order revenue = 450,000,000 VND across 1,000 orders.

Calculation: AOV = 450,000,000 / 1,000 = 450,000 VND.

Decision insight: Raising AOV via bundles increases allowable CAC/CPA for the same unit margin.

Revenue Decomposition

Decomposes top-line revenue into three independently measurable levers: qualified traffic volume, conversion efficiency, and basket size.

Revenue = Sessions × Conversion Rate × Average Order Value

Variables & units

  • Sessions (Count (sessions)): Qualified traffic reaching the storefront or landing page.
  • Conversion Rate (CVR) (Decimal ratio (e.g., 0.03 for 3%)): Orders / Sessions.
  • Average Order Value (AOV) (Currency per order): Revenue / Orders.

Revenue basis & attribution distinction

Algebraically exact when CVR = Orders / Sessions and AOV = Revenue / Orders on the same revenue definition (net revenue or GMV).

Assumptions & guardrails

  • All three terms are measured over the exact same cohort window and revenue definition.

When this formula misleads

  • Treating the levers as fully independent in practice—buying lower-intent traffic can increase Sessions while simultaneously depressing CVR.
Illustrative hypothetical scenario: Diagnosing why monthly revenue grew or stalled.

Inputs: Sessions = 25,000; CVR = 3.0% (0.03); AOV = 400,000 VND.

Calculation: Revenue = 25,000 × 0.03 × 400,000 = 300,000,000 VND.

Decision insight: A 10% gain in Sessions plus a 10% gain in CVR and 10% gain in AOV compounds to 1.1 × 1.1 × 1.1 = +33.1% revenue.

Break-Even ROAS

Defines the minimum ROAS required so that variable contribution from attributed revenue exactly covers advertising spend (zero profit, zero loss).

Break-even ROAS = 1 / Pre-ad Contribution Margin Rate

Variables & units

  • Pre-ad Contribution Margin Rate (Decimal ratio (0 < m ≤ 1, e.g., 0.40 for 40%)): (Net Revenue − Variable COGS − Payment/Shipping/Platform Fees − Return Allowance) / Net Revenue, strictly BEFORE deducting ad spend.

Revenue basis & attribution distinction

Applies ONLY when contribution margin is defined strictly after all non-ad variable costs and BEFORE advertising spend, AND when attributed revenue uses the same basis (net revenue vs. GMV) as the margin calculation.

Assumptions & guardrails

  • No double-counting: advertising spend MUST NOT already be subtracted inside Pre-ad Contribution Margin Rate.
  • If platform ROAS reports GMV while margin is computed on net revenue (post-discount/returns), adjust Break-even ROAS upward by (GMV / Net Revenue).
  • Does not include fixed overhead (office rent, full-time salaries, software retainers), which must still be covered by total Contribution Profit.

When this formula misleads

  • High-repeat subscription/consumable brands intentionally acquiring first orders below break-even based on verified 60–90 day LTV payback.
  • When marketplace commissions, affiliate fees, or COD return rates vary significantly across campaigns.
Illustrative hypothetical scenario: E-commerce SKU economics check before scaling Meta/TikTok spend.

Inputs: Net selling price = 500,000 VND; COGS = 175,000 VND; Shipping + Payment + Marketplace fees + Return reserve = 125,000 VND. Pre-ad variable margin = 200,000 VND (40%, or 0.40).

Calculation: Break-even ROAS = 1 / 0.40 = 2.5x.

Decision insight: At 2.5x ROAS on net revenue, every 100 VND of ad spend generates 250 VND revenue × 40% = 100 VND pre-ad margin (0 contribution profit). Scaling safely requires targeting above 2.5x—e.g., 3.5x–4.0x—so contribution profit covers fixed overhead and net profit.

Contribution Profit (Post-Ad)

Measures the actual cash dollars/VND left over after variable product/fulfillment costs AND paid advertising spend to fund fixed overhead and net profit.

Contribution Profit = (Revenue × Pre-ad Contribution Margin Rate) − Advertising Spend

Variables & units

  • Revenue (Currency (VND or USD)): Net recognized revenue (post-discounts, post-cancellations/returns) for the period or channel.
  • Pre-ad Contribution Margin Rate (Decimal ratio (e.g., 0.40)): Variable margin rate excluding advertising spend but including COGS, fulfillment, shipping, payment fees, and variable marketplace/affiliate commissions.
  • Advertising Spend (Currency (VND or USD)): Total paid advertising spend for the matching period.

Revenue basis & attribution distinction

Finance/economics ground-truth metric. Always align Revenue and Pre-ad Contribution Margin Rate on net revenue rather than unadjusted GMV.

Assumptions & guardrails

  • Pre-ad Contribution Margin Rate excludes advertising spend (preventing double-counting) and captures all other variable costs.
  • Fixed costs (payroll, rent, fixed tools) are subtracted afterward to arrive at operating profit (EBITDA).

When this formula misleads

  • Evaluating contribution profit on unverified platform-attributed revenue without cross-checking total blended net revenue and MER.
Illustrative hypothetical scenario: Comparing two scaling options (high ROAS low volume vs. moderate ROAS higher volume).

Inputs: Option A: Revenue = 600M VND, Spend = 100M VND (6.0x). Option B: Revenue = 1,000M VND, Spend = 220M VND (4.55x). Pre-ad Contribution Margin Rate = 40% (0.40).

Calculation: Option A: (600M × 0.40) − 100M = 140M VND. Option B: (1,000M × 0.40) − 220M = 180M VND.

Decision insight: Even though Option B has a lower ROAS (4.55x vs. 6.0x), Option B produces +40M VND more Contribution Profit because marginal ROAS (400M incremental revenue / 120M incremental spend = 3.33x) exceeds Break-Even ROAS (2.5x).

See these economics in practice

All worked numbers above are illustrative hypothetical examples. For documented real-world engagements, review the published case studies and service retainers below: