Tabellab

Fractional Conversions and CPA by Model: Why 112.8 Orders Is a Valid Number and How Cost per Acquisition Moves

Lesson 15 of 20 Lab 🔒 Locked

Lessons in this course

  1. Last-Click vs First-Click Attribution: Reading Conversion Paths, Finding the Last Touch and Crediting Revenue per ChannelLabFree
  2. Linear Attribution: Equal Credit per Touch, Touch Counts per Channel and the Shift Away from Last-ClickLab Locked
  3. Position-Based (U-Shaped) Attribution: 40 % First, 40 % Last, the Middle Shared, with IFS on a Touch LogLab Locked
  4. Time-Decay Attribution: Half-Life Weights with Powers of 0.5, Normalising per Order and Credit per ChannelLab Locked
  5. One Table, Five Models: a Channel × Model Matrix with Mixed References, Model Shares and the Spread per ChannelLab Locked
  6. Channel ROAS Under Each Model: a ROAS Grid, the Lowest and Highest Reading and a Robust / Model-Dependent VerdictLab Locked
  7. Lookback Windows: Days Between Touch and Order, Touches Inside the Window and Linear Credit That Respects ItLab Locked
  8. Credit Shift Analysis: What Changes When You Leave Last-Click, in Euros, in Percent, in ROAS and in RankLab Locked
  9. Path Length and Time to Convert: How Many Orders Are Multi-Touch, How Long Paths Take and What That Means for the WindowLab Locked
  10. Lookback Window Sensitivity: How Many Touches Each Window Captures, Upper vs Lower Funnel and the Shortest Sufficient WindowLab Locked
  11. Half-Life Sensitivity: One Path, Eight Half-Lives, from Almost Last-Click to Almost LinearLab Locked
  12. Custom Position Weights: a Scenario Grid from 40/20/40 to First-Heavy and Last-Heavy, and Which Channels CareLab Locked
  13. Assists and Channel Roles: Last-Click Conversions, Assisted Conversions and the Assist Ratio per ChannelLab Locked
  14. Path Data Quality Checks: Touches After the Order, Duplicates, Missing Channels and Credit That Does Not Add UpLab Locked
  15. Fractional Conversions and CPA by Model: Why 112.8 Orders Is a Valid Number and How Cost per Acquisition MovesLab Locked
  16. Budget Reallocation What-If: Revenue-Share Budgets, a ±20 % Cap per Channel and a Cautious Revenue ProjectionLab Locked
  17. The Gap Between Models Over Time: Ratio, Trend with SLOPE, Correlation with Spend and a ForecastLab Locked
  18. Do the Models Agree? Ranking Campaigns Under Each Model, Rank Spread and Rank CorrelationLab Locked
  19. Model × Window Scenario Grid: 36 Ways to Measure One Channel, Break-Even ROAS and the Share of Profitable ScenariosLab Locked
  20. Final Project: an Attribution Dashboard from a Raw Touch Log with Four Models, ROAS Range, Verdict and ChartLab Locked