Tabellab

Digital Marketing Fundamentals: Channels, the Funnel, Core Metrics (CPM, CTR, CPC, CVR, CPA, ROAS, CAC, LTV), Owned, Earned & Paid Media & a First Plan

Learn the foundations of digital marketing by calculating them yourself. You will compare channels by traffic share, conversion rate and revenue per session, sort touchpoints into owned, earned and paid media, build a funnel and find its biggest drop, and work through the core metrics one family at a time: CPM and CTR, CPC, conversion rate and CPA, average order value and ROAS, customer acquisition cost and lifetime value. Then you segment by channel and device, group campaign tags into channels, split a first budget, work backwards from a revenue target, read a trend and a simple A/B test, build a what-if grid, check an export for impossible numbers, manage a campaign calendar, rank channels on a scorecard, compare three scenarios and finish with a one-page marketing plan. 20 hands-on labs, a fictional candle shop, every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This beginner course teaches the foundations of digital marketing through 20 interactive spreadsheet labs. You work with the data of Larkhaven Candle Co., a small online shop, and calculate every concept yourself: traffic share and conversion rate by channel, owned, earned and paid media, the marketing funnel and its drop-off points, and the core metrics CPM, CTR, CPC, CVR, CPA, ROAS, CAC and LTV. In the second half you segment traffic by channel and device, turn campaign tags into channels, split a first budget, work backwards from a revenue target, read a trend and a simple A/B test, build a what-if grid, check an export for impossible numbers, keep a campaign calendar, rank channels on a scorecard and compare three scenarios. The final project is a one-page marketing plan with a chart. Each spreadsheet function is explained when it first appears, and every cell is checked as you type. The company, its campaigns and all numbers are fictional.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. The Channel Landscape: Sessions, Orders and Revenue by Channel, Share of Traffic, Conversion Rate and Revenue per SessionLabFree
  2. Owned, Earned and Paid Media: Sorting Touchpoints and Summing Sessions and Revenue by Type with COUNTIF and SUMIFLab Locked
  3. The Marketing Funnel: Stages from Awareness to Loyalty, Step Conversion, Share of Visits and Where People Drop OutLab Locked
  4. Paying for Attention: Impressions, Reach, Frequency, CPM and CTR Across Ten Ad SetsLab Locked
  5. From Click to Customer: CPC, Conversion Rate and CPA, How They Multiply and a Target CPA CheckLab Locked
  6. The Revenue Side: Average Order Value, ROAS, Break-Even ROAS from the Gross Margin and Profit After Ad SpendLab Locked
  7. Customer Acquisition Cost: New Customers, Paid CAC, Blended CAC and a Year of Monthly FiguresLab Locked
  8. Lifetime Value: Margin per Year, a Simple LTV, the LTV:CAC Ratio, Payback Months and a Verdict with IFSLab Locked
  9. Segments: Sessions and Orders by Channel and Device with SUMIFS, Mixed References and COUNTIFSLab Locked
  10. Campaign Tags: Source and Medium, Channel Grouping with XLOOKUP and the Unassigned ShareLab Locked
  11. A First Budget Plan: Splitting a Monthly Budget by Channel into Expected Visits, Orders and RevenueLab Locked
  12. Working Backwards from a Revenue Target: Orders, Visits, Paid Visits and the Budget It TakesLab Locked
  13. Reading a Trend: Week-over-Week Change, a 4-Week Moving Average, SLOPE and FORECAST.LINEARLab Locked
  14. A First Test: Two Page Versions, Conversion Rates, Lift and Simple Rules for a DecisionLab Locked
  15. A What-If Grid: CPA for Every Combination of CPC and Conversion Rate, Break-Even CPC and a Coloured Target ZoneLab Locked
  16. Quality Checks Before the Report: Impossible Numbers, a Check Flag with IF and OR, and a Highlighted ExportLab Locked
  17. A Campaign Calendar: Durations from Dates, Budget per Day, Status on a Check Date and What Is LiveLab Locked
  18. A Channel Scorecard: ROAS and CPA per Channel, Ranking with RANK.EQ, the Winner with INDEX and MATCH, and LARGELab Locked
  19. Three Scenarios: Cautious, Expected and Optimistic Orders, Revenue with SUMPRODUCT, ROAS and Blended CPALab Locked
  20. Final Project: A One-Page First Marketing Plan with Expected Orders and Revenue, Media-Type Summary, Blended CAC, LTV:CAC and a ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy