🧬$9.90Advanced
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
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
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
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
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
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
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
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
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
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
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.90Beginner
Price products you never stock in 20 hands-on labs: base cost per variant, shipping by zone, fees, ad cost per order and refunds, then target prices, free-shipping thresholds, creator codes, ad scaling, partner routing, cash timing and holiday cut-offs, with every cell checked instantly.
20 lessons · 20 labs
💰$9.90Intermediate
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
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
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
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
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
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
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
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
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
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
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
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
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