Tabellab
Marketing Analytics Intermediate

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

Measure creator campaigns from the brand side in Excel: shortlist creators by engagement and audience fit, compare CPM and CPE, price flat vs per-view vs hybrid fees, track promo codes and UTM links, calculate ROAS and ROI with seeding costs, prove incrementality with holdout regions, allocate a budget and report it, in 8 graded labs.

8 lessons 8 labs 2.2 h Certificate

The first lesson is free โ€” no account needed.

About this course

An influencer marketing ROI course that measures creator campaigns from the brand side for one fictional coffee brand, Fernhill Coffee Co., in a spreadsheet, for marketing managers, influencer and social media specialists, agency staff and e-commerce founders. You shortlist creators by engagement rate, audience fit and a fake-follower discount, compare quotes by CPM and cost per engagement, price flat, per-view and hybrid fees for six view outcomes in a chart, credit orders through promo codes and UTM links without leaked codes, calculate ROAS and ROI including product seeding costs, measure incremental sales and lift with holdout regions, allocate a budget to creators ranked by incremental ROAS under caps, and build a campaign report with rebook verdicts. Fictional brand and creators, with no affiliation with any social media platform. The first lab is free.

Lessons

  1. Creator Shortlist: Engagement Rate, Audience Fit & the Fake-Follower DiscountLab15 minFree
  2. Cost per Thousand (CPM) & Cost per Engagement (CPE) by CreatorLab14 min Pro
  3. Fee Benchmarking: Flat Fee vs Per-View vs Hybrid (Line Chart)Lab16 min Pro
  4. Tracking with Promo Codes & UTM Links: Conversions, Revenue & Code LeakageLab16 min Pro
  5. ROAS & ROI per Creator, Including Product Seeding CostsLab16 min Pro
  6. Incrementality: Holdout Regions, Lift & Incremental ROASLab18 min Pro
  7. Creator Portfolio: Ranking by Efficiency & Allocating a Budget under ConstraintsLab20 min Pro
  8. The Campaign Report: Incremental Revenue, iROAS, Rebook Verdicts & a ChartLab16 min Pro