Tabellab

Marketing ROI, ROAS and attribution courses

Marketing budgets are easy to spend and hard to defend.

Marketing ROI, ROAS & Attribution courses (25)

$9.90Advanced

Multi-Touch Attribution with Rule-Based Models: Last-Click, First-Click, Linear, Time-Decay & Position-Based Credit, Channel ROAS by Model and Lookback Windows

Build every rule-based attribution model yourself. You will read conversion paths, credit revenue by last-click and first-click, split it linearly, by position (40/20/40) and by time decay with a half-life, then compare all five models in one channel matrix and turn them into a ROAS range per channel. You apply lookback windows from touch and order dates, measure the credit shift away from last-click, analyse path length and time to convert, test window and half-life sensitivity, try custom position weights, count assists, audit path data, work with fractional conversions and CPA, plan a capped budget shift, track the model gap over time, check whether the models agree on the ranking, build a model × window scenario grid and finish with an attribution dashboard from a raw touch log. 20 hands-on labs, fictional outdoor retailer Lumeridge Outfitters, every cell checked as you go.

20 lessons · 20 labs

$9.90Advanced

Markov Chain Attribution: Channel Paths, Removal Effects & Fair Credit

Turn customer journeys into transition counts and a probability matrix, compute the conversion probability exactly with (I − Q)⁻¹, remove and partially cut channels, credit orders and revenue, compare with last click, linear, first click, position-based, time decay and Shapley, test the memoryless assumption, put confidence intervals on the chain, calibrate with holdout tests and build a ROAS dashboard, in 20 graded labs with MMULT and MINVERSE.

20 lessons · 20 labs

$9.90Intermediate

Influencer Marketing ROI: Creator Selection, CPM, Promo Codes & Incrementality

Measure creator campaigns from the brand side in Excel: shortlist creators by engagement quality and audience fit, compare CPM, CPE and unique reach, price flat vs per-view vs hybrid fees, forecast views, track promo codes, UTM links and attribution windows, calculate ROAS, ROI, CAC and subscription LTV, prove incrementality with holdouts and difference-in-differences, test sensitivity and build a campaign dashboard, in 20 graded labs.

20 lessons · 20 labs

$9.90Intermediate

Marketing Mix Modeling & Attribution in Excel

Explore weekly sales and spend, build adstock and saturation curves, fit the model with LINEST, decompose sales, compare ROI with marginal ROI and apply multi-touch attribution, then go further: choose the decay rate by grid search, fit S-shaped Hill curves, add season and promo controls, read standard errors, spot multicollinearity, test on holdout weeks, calibrate with a geo test, compare burst and always-on schedules, find the optimal budget split, build a due-to waterfall and reconcile attribution with the model in 20 hands-on labs, with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Sponsorship & Event Marketing ROI: Exposure Value, Leads & Pipeline

Measure a sponsorship portfolio the way sponsor-side marketers do: all-in costs, media exposure value, cost per MQL, pipeline attribution, pre/post brand lift, ROI vs ROO, a weighted scorecard and the renewal decision, then rights-delivery audits, budget variances, booth staffing, follow-up speed, net-new accounts, attribution models, payback timing, holdout tests, sensitivity grids and a portfolio dashboard, in 20 graded labs. Fictional brand, illustrative numbers.

20 lessons · 20 labs

$9.90Intermediate

Content Marketing ROI: Cost per Article, Organic Traffic Value, Decay & Refresh

Price every article, model the traffic ramp-up, value organic clicks at the paid CPC, credit pipeline to content, catch decaying articles, compare refresh vs new, rank the portfolio and chart the payback of a content plan, then amortise content cost, cost promotion channels, measure lead capture and gating, compare content-touched deals, adjust for seasonality, forecast decay, fund a refresh backlog, prune the archive, weigh in-house vs freelance and stress-test ROI in a sensitivity grid, ending with a content ROI dashboard. 20 hands-on labs, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Customer Analytics: Lifetime Value, Cohorts & Churn

Calculate AOV, purchase frequency and CLV with margin, retention and discounting, build cohort tables from raw orders, chart retention curves, measure churn and survival, set CAC ceilings by segment and predict repeat purchases, then go further: monthly subscription CLV, retention by tenure and spend growth, hidden segments, contribution after returns and service, promo cohorts, sensitivity grids, lever comparisons, channel CAC, referral value, customer equity, model plausibility checks and a final dashboard: 20 hands-on labs, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Google Shopping & Performance Max for Online Shops: Feed Quality, Product Groups, ROAS vs POAS, Asset Groups, New Customers & Budget Split

Run Shopping and Performance Max campaigns on profit instead of on revenue. You audit a product feed for short titles, missing GTINs and price mismatches, measure approval rates, read the product-group report, derive break-even ROAS from margins and move from ROAS to POAS, then rank campaigns both ways, sort products into heroes, villains, sidekicks and zombies, build margin-based custom labels and ROAS targets, check asset groups, track where Performance Max spends, separate new from returning customers, value a new customer over twelve months, measure incrementality with a regional pause test, split budget by marginal POAS, pace a monthly budget, compare prices with the market, evaluate a title test, build a what-if grid and finish with a profit dashboard. 20 hands-on labs, fictional shop data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Retail Media & Sponsored Listings: Bids, Cost per Click, ROAS vs Incremental ROAS, Halo Sales, Share of Shelf & Budget Pacing

Advertise where people buy. Across 20 hands-on labs you work through sponsored-listing auctions, ROAS and incremental ROAS, halo sales, share of the digital shelf and budget pacing, then go further: search-term mining, target-ROAS bids, placement adjustments, attribution lag, new-to-brand payback, geo tests with confidence intervals, weighted pacing, display ads, stock guardrails, brand defence, a three-network comparison and a quarterly dashboard, with every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Podcast Advertising Math: Downloads, CPM, Promo Codes & ROAS

Model episode download curves, price pre-, mid- and post-roll ads by CPM, compare flat-rate and CPM deals, attribute orders with promo codes, vanity URLs and survey lift, then go further: filter raw downloads, pace impression commitments and make-goods, price the back catalog, cost code leakage, spot ad wear-out, judge profit ROAS, net rate cards, run a show's P&L, decide test flights and reconcile invoices, in 20 hands-on labs, every cell checked. Fictional shows, illustrative CPMs.

20 lessons · 20 labs

$9.90Intermediate

Referral Program Economics: Reward Design, Viral Loops & Referral CAC

Run the referral numbers of a fictional subscription app in 20 hands-on labs: participation and invite funnels, viral loops with and without decay, referral CAC and holdout incrementality, reward ladders and delayed rewards, LTV by channel, fraud and data checks and a Q3 dashboard, every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Marketing Budget Planning: Top-Down vs Objective-Based Budgets, CAC Targets, Diminishing Returns, Channel Allocation & Monthly Phasing

Plan next year's marketing budget so you can defend it, in 20 hands-on labs. You will compare %-of-revenue and objective-based budgets, derive target CAC from customer value, work back from customer targets to spend, fit response curves to your own data, allocate across channels and markets with diminishing returns and equal marginal CAC, correct platform numbers for incrementality, compare scenarios, phase the money by month and payment terms, keep a test reserve, reforecast the year and build a dashboard for the approval meeting, with every cell checked instantly.

20 lessons · 20 labs

$9.90Intermediate

Channel Partner Programmes: Partner Tiers, Margins & Rebates, Deal Registration, Marketing Development Funds, Partner Pipeline & Programme ROI

Run a reseller and partner programme by the numbers in 20 hands-on labs. You will place partners in tiers, compute discounts, rebates and deal-registration margins, accrue and pay marketing development funds, track partner pipeline, compare direct and partner margins, then follow new partners to their first deal, forecast tiers mid-year, price two-tier distribution and special pricing requests, build a pocket price waterfall, budget rebates by scenario, measure MDF results, partner credit, renewals and health scores, age incentive claims and finish with an annual review dashboard, with every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Connected TV & Streaming Ads: Household Reach & Frequency, Cost per Completed View, Co-Viewing, Incremental Reach, QR Response & Attribution Windows

Plan and judge streaming TV campaigns with real arithmetic. You start with household reach and frequency, compare CPM with cost per completed view, convert household impressions into viewer impressions, read a frequency distribution and separate the households that only streaming reached from linear TV. Then you measure publisher overlap and effective reach, check flight pacing and verified impressions, follow QR codes and second-screen response, choose attribution windows, run holdout and matched-market tests, test whether a lift is real, read a brand lift survey, forecast reach with diminishing returns, compare budget scenarios and finish with a campaign dashboard in 20 hands-on labs, fictional data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Marketing Dashboards & KPI Reporting: Blended CAC and MER, Channel Roll-Ups, Targets and Pacing, Sparklines & the Weekly Report Narrative

Build marketing dashboards that people trust and reports that get read, in 20 hands-on labs. You will calculate MER, blended CAC and acquisition MER from business totals, roll raw campaign exports up into a channel table with SUMIFS, clean and map messy source names, compare KPIs with targets in the right direction, pace a month against its target and separate real change from weekly noise. Then you add sparklines, heat maps and highlight rules, drive a scorecard from one selector cell, calibrate over-claiming platform numbers, read MER against the break-even level, fix total lines that average averages, forecast a quarter, flag unusual days, find the top movers, remove duplicates and reconcile with finance, check CAC payback by cohort, test budget scenarios and reallocations, let the sheet write the weekly narrative and finish with a complete four-week dashboard. 20 hands-on labs, fictional outdoor-gear shop, every cell checked as you go.

20 lessons · 20 labs

$9.90Advanced

Incrementality Testing: Geo Holdouts, Matched Markets, Pre-Period Fit, Lift & Confidence, Incremental ROAS, Test Sizing & Attribution Calibration

Measure what advertising really causes. You will compare test and holdout markets, set platform ROAS beside incremental ROAS, choose matched control markets, check the pre-period fit, use difference-in-differences and a regression counterfactual, read weekly and cumulative lift, value it as iROAS and incremental profit against break-even, build confidence intervals, p-values and placebo tests, size test duration, budget and holdout, correct for spillover, split results by market type, read a spend response curve, calibrate attribution with test results and pool several tests, and finish with a complete test readout for Halvern Living, with 20 hands-on labs, fictional data and every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

PPC Bidding & Budget Pacing: Break-Even Bids, Manual CPC vs Target CPA vs Target ROAS, Bid Modifiers, Monthly Pacing & Spend Forecasts

Set bids and budgets you can defend. You will calculate break-even CPC, CPA and ROAS, turn a target CPA into capped manual bids, compare manual CPC, target CPA and target ROAS campaigns, derive the max CPC a ROAS target implies, build day-parting, device and geo modifiers and see how they stack, then pace a monthly budget day by day, forecast month-end spend, weight the plan by weekday, read impression share lost to budget and rank, move money by marginal CPA, find the most profitable bid on a bid landscape, check whether campaigns have enough data for automated bidding, build a target ROAS what-if grid, plan a seasonal annual budget, test a bid strategy change and finish with a bidding and pacing dashboard. 20 hands-on labs, fictional bike-parts shop Fernwick Cycle Supply, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

SEO Forecasting & Business Cases: CTR Curves, Rank-Gain Scenarios, Seasonality, Time to Rank, Revenue Forecasts & Payback vs Paid Search

Turn SEO ideas into a forecast you can defend. You will look up the expected CTR for each position, build your own curve from search data, size rank-gain scenarios, interpolate fractional positions, adjust for results-page features, separate brand from non-brand queries, build a seasonality index and a seasonal run-rate, fit the baseline without the project, model the time to rank with ramp-up curves, weight gains by the chance of success, compare conservative, base and optimistic scenarios, convert clicks into orders, revenue and gross profit, plan the investment, find the payback month and ROI, compare SEO with paid search, run a sensitivity grid, back-test the forecast against actuals and finish with a 24-month business case, in 20 hands-on labs, fictional data, every cell checked as you go.

20 lessons · 20 labs

$9.90Advanced

Server-Side Conversion API Quality: Event Match Rates, Deduplication, Parameter Completeness, Delays, Recovered Conversions & Attribution Impact

Check that your server-side conversion events are good enough to trust. You will calculate event match rates, measure identifier coverage, track delivery and retries, separate browser and server events, deduplicate by event ID and by time window, test parameter completeness and value accuracy, study delay distributions and late uploads, quantify the conversions recovered and their attribution impact, audit consent-respecting measurement, find weak segments, build a weighted quality score, test whether an improvement is real, monitor with control limits, run what-if grids, reconcile with the order system and finish with a quarterly scorecard, in 20 hands-on labs, fictional data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Online Store Marketing & Growth: Traffic Mix, Conversion by Channel, AOV Levers, Repeat Purchases, Blended ROAS & Contribution Margin

Work through the marketing arithmetic of an independent online store, such as one run on a Shopify-style platform. You split traffic by source and compare session and revenue shares, follow the shopping funnel by channel, and measure revenue per session. You test the two classic AOV levers, bundles and a free-shipping threshold, then measure repeat purchase rate and a cohort retention curve. You calculate contribution margin per order, compare blended ROAS with the ROAS the ad platforms report, work out CAC and payback, and set break-even and target ROAS. Further labs cover discount codes, returns and net revenue, category margin, email flows, a dated marketing calendar, a bundle what-if table, marginal ROAS with SLOPE and FORECAST.LINEAR, and a tracking-gap check, and you finish with a half-year dashboard. 20 hands-on labs, fictional data, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

TikTok Ads & Short-Video Advertising: Hook Rate, Hold Rate, CPV, CPA, Creative Rotation, Bidding & Attribution Windows

The arithmetic behind TikTok ads and boosted creator posts, one spreadsheet at a time. You measure hook rate and hold rate, read quartile views and completion, price attention with CPM, CPV and cost per 6-second view, follow the funnel from view to purchase and set break-even and target CPAs. After that you score creatives against format benchmarks, catch creative fatigue with a trend line, cost boosted creator posts all-in, check bid strategies and delivery, size budgets for the learning phase, pace a monthly budget, compare attribution windows, correct recent days for conversion lag, judge split tests with a z-score, run a test lane with kill rules, plan creative rotation with dates, summarise audiences with SUMIFS, link frequency to CTR, build a CPA what-if grid and finish with an account dashboard: 20 hands-on labs, fictional tea brand Tindlewick Tea Co., every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Video Marketing Funnel Metrics: Play Rate, Retention & Drop-Off Points, CTA Click-Through, Video-Assisted Conversions, Production Budgets & Library ROI

Measure video across the whole funnel in Excel. You calculate play rate by funnel stage, build retention curves, find the scenes where viewers leave, compare watch time by video length, split CTA click-through into reach and clicks, follow plays to orders and count video-assisted conversions. Then you cost every video from shoot days and edit hours, price a play, a completed view and a watched minute, test thumbnails and product page videos for real uplift, forecast evergreen plays, write videos down over their useful life, audit the library, measure its concentration, build a what-if grid, allocate a production budget and finish with a library ROI dashboard: 20 hands-on labs, fictional retailer Quillmoor Espresso, every cell checked as you go.

20 lessons · 20 labs

$9.90Intermediate

Trade Promotion Analytics for CPG: Baseline, Lift, Trade Spend ROI & Deductions

Work as a consumer-goods brand analyst in 20 hands-on labs: build clean and velocity baselines from scan data, measure lift by tactic, cost off-invoice, scan-back and display deals, calculate trade spend ROI net of cannibalisation and pull-forward, check pass-through, forward buying and the retailer's own profit, model growth rebates, gross-to-net, Hi-Lo vs EDLP, accruals and deductions aging, and finish with an annual trade spend review, with every cell checked instantly.

20 lessons · 20 labs

$9.90Beginner

Vending Machine Business by the Numbers: Machine Payback, Location Commissions, Product Mix, Restock Routes & Cash vs Card

Decide if a vending route pays: machine cost and payback, location commissions, slot-by-slot product mix, restock routes and payment fees, then price increases, collections audits, seasonality, stock-outs and telemetry, energy, service contracts, stock purchasing, the storeroom, site scouting, a sensitivity grid, a micro market and an annual dashboard. 20 hands-on labs, every cell checked as you go.

20 lessons · 20 labs

Marketing budgets are easy to spend and hard to defend. This hub collects the courses that turn spend into defensible numbers: return on ad spend, customer acquisition cost against lifetime value, payback periods, and the attribution models that decide which channel gets the credit. You build rule-based and Markov-chain attribution by hand, model media mix, and check ROI for channels as different as influencers, events, content and retail media, always in a spreadsheet you can adapt to your own data.

This topic hub gathers 25 Marketing ROI, ROAS & Attribution courses from Marketing, E-Commerce, Business: 2 beginner, 19 intermediate, 4 advanced. Most courses have about 20 hands-on labs, a final exam and a certificate, and the first lesson of every course is free. Searches this hub is built for: roas formula excel; marketing roi calculation; cac payback period; multi touch attribution excel.

Frequently asked questions

Which Marketing ROI, ROAS & Attribution course should I start with?

Start with “Marketing Budget Planning”. It is the most central course in this topic at intermediate level. Then move on to the more specialised courses in the list above.

How much do the Marketing ROI, ROAS & Attribution courses cost?

Every course costs a one-time $9.90, with no subscription, and the first lesson of each course is free so you can try it before buying. Each course ends with a final exam and a certificate.

How are the Marketing ROI, ROAS & Attribution courses taught?

Each course is a series of hands-on labs in a built-in spreadsheet that checks your formulas as you type, with short explanations alongside. You need only a web browser; nothing to install. Examples use fictional data and are for learning, not professional advice.

Open your first lab in under a minute

Pick a course, pay once and start right away. Your progress is saved in your account.

Browse the courses