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.
- 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
- The Channel Landscape: Sessions, Orders and Revenue by Channel, Share of Traffic, Conversion Rate and Revenue per SessionFree
- Owned, Earned and Paid Media: Sorting Touchpoints and Summing Sessions and Revenue by Type with COUNTIF and SUMIF Locked
- The Marketing Funnel: Stages from Awareness to Loyalty, Step Conversion, Share of Visits and Where People Drop Out Locked
- Paying for Attention: Impressions, Reach, Frequency, CPM and CTR Across Ten Ad Sets Locked
- From Click to Customer: CPC, Conversion Rate and CPA, How They Multiply and a Target CPA Check Locked
- The Revenue Side: Average Order Value, ROAS, Break-Even ROAS from the Gross Margin and Profit After Ad Spend Locked
- Customer Acquisition Cost: New Customers, Paid CAC, Blended CAC and a Year of Monthly Figures Locked
- Lifetime Value: Margin per Year, a Simple LTV, the LTV:CAC Ratio, Payback Months and a Verdict with IFS Locked
- Segments: Sessions and Orders by Channel and Device with SUMIFS, Mixed References and COUNTIFS Locked
- Campaign Tags: Source and Medium, Channel Grouping with XLOOKUP and the Unassigned Share Locked
- A First Budget Plan: Splitting a Monthly Budget by Channel into Expected Visits, Orders and Revenue Locked
- Working Backwards from a Revenue Target: Orders, Visits, Paid Visits and the Budget It Takes Locked
- Reading a Trend: Week-over-Week Change, a 4-Week Moving Average, SLOPE and FORECAST.LINEAR Locked
- A First Test: Two Page Versions, Conversion Rates, Lift and Simple Rules for a Decision Locked
- A What-If Grid: CPA for Every Combination of CPC and Conversion Rate, Break-Even CPC and a Coloured Target Zone Locked
- Quality Checks Before the Report: Impossible Numbers, a Check Flag with IF and OR, and a Highlighted Export Locked
- A Campaign Calendar: Durations from Dates, Budget per Day, Status on a Check Date and What Is Live Locked
- A Channel Scorecard: ROAS and CPA per Channel, Ranking with RANK.EQ, the Winner with INDEX and MATCH, and LARGE Locked
- Three Scenarios: Cautious, Expected and Optimistic Orders, Revenue with SUMPRODUCT, ROAS and Blended CPA Locked
- Final Project: A One-Page First Marketing Plan with Expected Orders and Revenue, Media-Type Summary, Blended CAC, LTV:CAC and a Chart Locked
Learner reviews
Be the first to review this course.