Tabellab

The Channel Landscape: Sessions, Orders and Revenue by Channel, Share of Traffic, Conversion Rate and Revenue per Session

Lesson 1 of 20Lab

All 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

You are not signed in — the lab works, but your progress is not saved. Sign up

Lesson 1 of 20 is free. Unlock all 20 hands-on labs, the final exam and your certificate.

Buy course — $9.90
Loading the spreadsheet…

What digital marketing is, and why channels come first

Digital marketing is the work of being found online, winning customers there and keeping them. That sounds broad, and it is: a search result, a newsletter, a short video, a product review and a banner on a news site all belong to it. What turns this collection of activities into something you can manage is one simple idea. Every visit to a website arrives through a channel, and each channel can be counted, compared and improved separately.

If you are new to the field, the vocabulary is the first hurdle. People talk about organic and paid, about sessions and conversions, about CPM, CTR, CPC, CVR, CPA, ROAS, CAC and LTV as if everyone had learned them at school. Nobody did. Each of these terms is either a count or one number divided by another, and once you have calculated them yourself in a spreadsheet they stop being jargon. This free lesson starts at the very beginning: the channel landscape, and the first three ratios that make channels comparable.

The example is Larkhaven Candle Co., a fictional online shop that sells scented candles, wax melts and diffusers. The company, its channels and every number on this page are invented for learning; any benchmark you see is illustrative and not an official figure from any platform. You will use the same ten channels and the same month, May 2026, as in the lab at the top of the page.

The channel landscape in plain words

A web analytics tool records where each visit came from. The raw information is technical, so the tool groups it into a short list of channels. The names differ a little from tool to tool, but the idea is always the same. These are the ten channels in the example:

  • Organic search: someone typed a query into a search engine and clicked an unpaid result. The shop did not pay for the click; it earned the position with useful pages.
  • Paid search: the click came from an advert shown next to the search results. The shop pays for each click.
  • Direct: the visitor typed the address, used a bookmark or came in a way the tool could not identify. Much of it is people who already know the shop.
  • Email newsletter: a click on a link in an email the shop sent to people who agreed to receive it.
  • Organic social: clicks from the shop's own unpaid posts and profile on social networks such as Instagram, Pinterest or TikTok.
  • Paid social: clicks from adverts bought on those networks.
  • Referral: a click on a link on someone else's website, for example a blog article or a press piece.
  • Affiliate partners: partner sites that recommend products and receive a commission for each sale they send.
  • Creator posts: sponsored posts by people with an audience of their own, paid by the shop and labelled as advertising.
  • Display ads: banners and image adverts shown on other websites.

Marketers also sort channels into three media types. Owned media is what the business controls itself: its website, its email list, its own social profiles. Paid media is attention it buys. Earned media is attention that others give it without payment, such as press articles, links and unpaid search results. Sources differ on a few borderline cases; this course files unpaid search under earned, because the ranking is granted by the search engine and cannot be bought. Lesson 2 works with these three types in detail.

From channels to orders: May 2026Owned mediaDirect, Email newsletter, Organic social12,100 sessions, 357 ordersEarned mediaOrganic search, Referral9,900 sessions, 201 ordersPaid mediaPaid search, Paid social, Affiliate partnersCreator posts, Display ads18,000 sessions, 277 ordersWebsite40,000sessions2.09% convertOrders835$37,962 revenue$0.95 per sessionFictional data. A session is one visit to the shop.
Figure 1: The channel landscape of Larkhaven Candle Co. Ten channels in three media types send 40,000 sessions to the website; 835 of them end in an order.

A word on fairness and privacy, because it belongs to the fundamentals. Channels and audiences are described by behaviour and context: what someone searched for, which page they visited, whether they subscribed. Decisions about whom to reach should not rest on protected personal characteristics. Email and messaging need consent, and a visitor's choice about tracking is to be respected. Good measurement works within those limits.

Three numbers that make channels comparable

A raw channel report has three counts per channel: sessions (visits), orders and revenue. Counts alone are hard to compare. Organic search brings 8,400 sessions and affiliate partners 1,200; of course the bigger channel has more orders. To compare channels of different size you turn counts into ratios.

  • Share of sessions = channel sessions ÷ total sessions. It tells you how much of the traffic a channel is responsible for.
  • Conversion rate = orders ÷ sessions. It tells you what share of the visits ended in an order. In later lessons you will meet it under its abbreviation, CVR.
  • Revenue per session = revenue ÷ sessions. It tells you what one visit from this channel is worth on average. It combines the conversion rate with the size of the orders.

None of the three needs anything beyond a division. What needs care is choosing the right numerator and denominator, and keeping the total fixed when a formula is copied. Those two skills, more than any function, are what the first lessons of the course train.

A fully worked example: Larkhaven Candle Co. in May 2026

Here is the complete channel report with the three calculated columns from the lab. In May the shop had 40,000 sessions, 835 orders and $37,962 of revenue.

ChannelMedia typeSessionsOrdersRevenue $Share of sessionsConversion rateRevenue per session
Organic searchEarned8,400168$7,89621.0%2.0%$0.94
DirectOwned5,200156$7,64413.0%3.0%$1.47
Email newsletterOwned3,100155$7,1307.8%5.0%$2.30
Paid searchPaid4,600138$6,07211.5%3.0%$1.32
Paid socialPaid7,90079$3,31819.8%1.0%$0.42
Organic socialOwned3,80046$1,8869.5%1.2%$0.50
Referral (blogs & press)Earned1,50033$1,4853.8%2.2%$0.99
Affiliate partnersPaid1,20030$1,2903.0%2.5%$1.08
Creator postsPaid2,10019$7795.3%0.9%$0.37
Display adsPaid2,20011$4625.5%0.5%$0.21
Total40,000835$37,962100.0%2.09%$0.95

The formulas behind the calculated cells, written for row 4 and copied down to row 13, are:

  • Totals (C14, D14, E14): =SUM(C4:C13), copied to the right. SUM adds every number in the range.
  • Share of sessions (F4): =C4/$C$14. The dollar signs lock the total, so every row divides by the same cell.
  • Conversion rate (G4): =D4/C4.
  • Revenue per session (H4): =E4/C4.
  • Overall conversion rate (G14): =D14/C14, total orders divided by total sessions.

Walk through two rows to see what the ratios reveal. Paid social is the second-largest source of traffic with 7,900 sessions, 19.8% of all visits. Only 79 of them ordered, a conversion rate of 1.0%, and a session is worth $0.42. The email newsletter is less than half that size, 3,100 sessions or 7.8%, yet 155 of those visits ordered. Its conversion rate is 5.0%, and a session is worth $2.30.

That difference is not a verdict on the two channels. It reflects who the visitors are. Newsletter readers already know the shop and asked to hear from it; many have bought before. People who tap a social advert are often seeing the brand for the first time. One channel harvests existing interest, the other creates new interest. A business needs both, and the ratios help you see which job each channel is doing.

Share of sessions vs share of orders by channelShare of sessionsShare of ordersOrganic search21.0%20.1%Direct13.0%18.7%Email newsletter7.8%18.6%Paid search11.5%16.5%Paid social19.8%9.5%Organic social9.5%5.5%Referral (blogs & press)3.8%4.0%Affiliate partners3.0%3.6%Creator posts5.3%2.3%Display ads5.5%1.3%May 2026, 40,000 sessions and 835 orders in total (fictional)
Figure 2: Share of sessions against share of orders. Email brings 7.8% of the sessions but 18.6% of the orders; paid social brings 19.8% of the sessions and 9.5% of the orders.

Figure 2 puts the two shares side by side. Where the orange bar is longer than the blue one, a channel delivers more orders than its traffic alone would suggest, most clearly direct, email and paid search. Where the blue bar is longer, the channel brings many visits and comparatively few orders: paid social, organic social, creator posts and display. Organic search sits close to balance with 21.0% of the sessions and 20.1% of the orders.

The same data by media type

Group the ten channels by media type and a pattern appears that you will meet again and again in this course.

Media typeChannelsSessionsShare of sessionsOrdersShare of ordersConversion rate
Owned312,10030.3%35742.8%2.95%
Earned29,90024.8%20124.1%2.03%
Paid518,00045.0%27733.2%1.54%

Paid media brings 45% of the sessions but only 33.2% of the orders, and it is the only type with a media bill. Owned media converts best, at 2.95%. That does not make paid media a poor choice. An email list has to be filled with subscribers first, and paid channels are one of the ways new people discover a shop. In a spreadsheet you would get these group totals with SUMIF, which is exactly what lesson 2 teaches.

Why the overall rate is not the average of the channel rates

The overall conversion rate of the shop is 835 ÷ 40,000 = 2.09%. A tempting shortcut is to take the average of the ten channel rates with =AVERAGE(G4:G13). That gives 2.13%. The two numbers are close here, but only by coincidence, and the second one is wrong.

The average of the rates treats every channel as equally important. Display ads with 2,200 sessions count as much as organic search with 8,400. A shop is not a collection of ten equal parts, though. The true overall rate weighs every channel by its traffic, and the simplest way to get that is to divide the totals. An extreme case makes the point: if one channel has 10,000 sessions at 1% and another has 100 sessions at 9%, the average of the rates is 5%, while the shop really converts 109 of 10,100 visits, about 1.1%. The rule holds for every ratio in this course: calculate totals first, then divide.

Absolute references: one pair of dollar signs

When you copy a formula down a column, the spreadsheet moves every reference along. =D4/C4 becomes =D5/C5 in the next row, which is what you want for the conversion rate. For the share of sessions it is only half right. =C4/C14 would become =C5/C15, then =C6/C16, and C15 and C16 are empty. The result is a column of division errors.

The fix is an absolute reference. Written as $C$14, the reference stays on that cell wherever the formula is copied. The dollar sign before the letter locks the column, the one before the number locks the row. In =C4/$C$14 the first reference is relative and moves from row to row, the second is absolute and always points at the total.

You do not have to type the dollar signs. Click the reference in the formula and press F4 (on a Mac: Cmd + T). The key cycles through $C$14, C$14, $C14 and back to C14. The two half-locked forms are called mixed references; they become useful in lesson 9.

Step by step in the spreadsheet

  1. Click C14 and type =SUM(C4:C13). Press Enter. The cell shows 40,000.
  2. Copy C14 to D14 and E14, either by dragging the fill handle to the right or with Ctrl + R after selecting C14:E14. You get 835 orders and 37,962 dollars of revenue.
  3. Click F4 and type =C4/$C$14. Press F4 after clicking C14 to add the dollar signs. The result is 0.21; with the percent format it shows 21.0%.
  4. Click G4 and type =D4/C4. Organic search converts 2.0% of its sessions.
  5. Click H4 and type =E4/C4. One organic search session is worth $0.94.
  6. Select F4:H13 and press Ctrl + D to fill the three formulas down to the last channel.
  7. Click G14 and type =D14/C14 for the overall conversion rate of 2.09%.
  8. Check your work: the shares in F4:F13 must add up to 100%. Type =SUM(F4:F13) in an empty cell to confirm, then delete it again.

Common mistakes and how to spot them

  • Missing dollar signs. =C4/C14 works in the first row and breaks in every row below. If F5 shows a division error, the total was not locked.
  • Numerator and denominator swapped. =C4/D4 gives 50 instead of 2%. It is sessions per order, a real measure, but not the conversion rate. A rate above 100% is the warning sign.
  • Dividing by the wrong total. =D4/$C$14 divides a channel's orders by all sessions of the shop. The numbers look plausibly small, which makes this one hard to notice. Say the formula aloud: orders of this channel divided by sessions of this channel.
  • Order value instead of revenue per session. =E4/D4 is revenue per order, the average order value. Revenue per session divides by sessions.
  • Averaging rates. =AVERAGE(G4:G13) is not the shop's conversion rate. Divide total orders by total sessions.
  • A range that stops too early. =SUM(C4:C12) leaves out the last channel. Compare the total with a quick mental estimate, or check that the shares add up to 100%.
  • Typing percentages as whole numbers. A spreadsheet stores 21% as 0.21. Multiplying by 100 inside the formula and then applying the percent format shows 2,100%.

How to read the result

Start with size, then look at quality. Organic search, paid social and direct together bring more than half of the sessions. In terms of orders the picture changes: organic search, direct, email and paid search each deliver between 138 and 168 orders, while paid social follows with 79. Then look at the value of a visit. An email session is worth $2.30 and a display session $0.21, a factor of about 11.

Revenue per session by channelEmail newsletter$2.30Direct$1.47Paid search$1.32Affiliate partners$1.08Referral (blogs & press)$0.99Organic search$0.94Organic social$0.50Paid social$0.42Creator posts$0.37Display ads$0.21Shop average $0.95OwnedEarnedPaidFictional data
Figure 3: Revenue per session. A visit from the newsletter is worth $2.30, a visit from a display ad about $0.21; the dashed line marks the shop average of $0.95.

Good questions come out of a table like this. Why does paid social convert so much less than paid search: is it the audience, the landing page, or the fact that people on a social network were not looking for candles at that moment? Could the newsletter list grow? Is the display budget buying anything beyond impressions? The report does not answer these questions. It tells you where to look, which is what a report is for.

One caution for beginners. A channel report usually credits an order to the last channel the visitor used before buying. Someone may discover the shop through a social advert, come back a week later by typing the address, and the order is then counted as direct. Channels that introduce new people look weaker in such a report than they are, and channels that close the sale look stronger. Read the numbers as evidence, not as a complete account.

Quick reference: functions and shortcuts in this lesson

Function or shortcutWhat it does hereExample
SUMAdds the sessions, orders or revenue of all channels=SUM(C4:C13)
DivisionTurns two counts into a ratio=D4/C4
Absolute referenceKeeps the total fixed while the formula is copied=C4/$C$14
AVERAGEMean of a range; not suitable for combining rates=AVERAGE(G4:G13)
F4 / Cmd + TAdds or removes the dollar signs of a reference$C$14
Ctrl + DFills the top formula down the selected rangeF4:H13
Ctrl + RFills the left formula to the rightC14:E14
Percent formatShows 0.21 as 21.0% without changing the valueColumns F and G

Where you can use this straight away

  • Your own shop or website. Export the channel or acquisition report from your analytics tool for one month, paste it into a sheet and add the three ratio columns. It takes ten minutes and usually changes how you see your traffic.
  • A monthly report. Share of sessions, conversion rate and revenue per session by channel make a sound first page of any marketing report.
  • Job interviews and first weeks in a marketing role. Being able to say what a session, a channel and a conversion rate are, and to calculate them without help, covers a good part of what entry-level roles ask for.
  • Conversations with agencies and freelancers. When someone reports a conversion rate, you can ask the right follow-up: orders divided by what, for which channel, in which period?

What the rest of the course covers

Lesson 1 is free. Lessons 2 to 20 each have their own live lab with a new data set from the same fictional shop, and every cell you fill in is checked as you go. The course follows the path a beginner takes in a first marketing role, from reading reports to writing a plan.

Lessons 2 to 8: the core vocabulary. You sort touchpoints into owned, earned and paid media with COUNTIF and SUMIF, build a marketing funnel from impressions to repeat orders and find the step where most people drop out. Then come the metrics, one family at a time: impressions, reach, frequency, CPM and CTR; CPC, conversion rate and CPA and the way they multiply; average order value, ROAS and the break-even ROAS that follows from the gross margin; customer acquisition cost in its paid and blended versions; and a simple lifetime value with the LTV:CAC ratio and payback period.

Lessons 9 to 13: from reports to plans. You split traffic by channel and device with SUMIFS and mixed references, group source and medium tags into channels with XLOOKUP and catch mistyped tags, split a monthly budget into expected visits, orders and revenue, work backwards from a revenue target to the budget it requires, and read a trend with a moving average, SLOPE and FORECAST.LINEAR.

Lessons 14 to 19: judgement. You read a first A/B test with simple house rules, build a what-if grid of CPA for every combination of click price and conversion rate, run plausibility checks on a broken export before it reaches a report, manage a campaign calendar with dates, rank channels on a quarterly scorecard with RANK.EQ, INDEX and MATCH, and compare cautious, expected and optimistic scenarios with SUMPRODUCT.

Lesson 20: the final project. You complete a one-page marketing plan for ten channels: expected orders and revenue, cost and revenue by media type, the blended CAC set against lifetime value, and a chart. A 20-question exam and a certificate follow. The course teaches the durable arithmetic and logic of the field. Platform features and prices change, so it does not teach where to click in any particular advertising tool.

Summary

Every visit to a website arrives through a channel, and channels fall into owned, earned and paid media. Three ratios make them comparable: share of sessions (=C4/$C$14), conversion rate (=D4/C4) and revenue per session (=E4/C4). At Larkhaven Candle Co., 40,000 sessions led to 835 orders, an overall conversion rate of 2.09%; the newsletter converts 5.0% of its visits and paid social 1.0%. Totals are locked with dollar signs, and overall rates come from dividing totals, never from averaging rates.

Now scroll up to the lab and build the sheet yourself. It takes about a quarter of an hour, the Coach checks each step, and at the end you will have a channel report you can rebuild with your own numbers.

Frequently asked questions

What is digital marketing in simple terms?

Digital marketing is everything a business does online to be found, to win customers and to keep them. It works through channels such as search engines, email, social networks, other websites and adverts. Each channel can be measured separately, which is what makes digital marketing manageable with a few simple ratios.

What are the main digital marketing channels?

The usual list is organic search, paid search, direct, email, organic social, paid social, referral, affiliate, creator or influencer posts and display advertising. Analytics tools group every visit into one of these channels based on where the click came from.

What is the difference between owned, earned and paid media?

Owned media is what a business controls, such as its website, email list and social profiles. Paid media is attention it buys, such as search and social adverts. Earned media is attention others give without payment, such as reviews, press coverage, links and unpaid search results.

How do I calculate a conversion rate in Excel?

Divide orders by sessions, for example =D4/C4, and format the cell as a percentage. For the overall rate divide total orders by total sessions, for example =D14/C14. Do not average the rates of the individual channels, because that gives small channels too much weight.

Why do I need dollar signs in a spreadsheet formula?

Dollar signs make a reference absolute, so it does not move when the formula is copied. In =C4/$C$14 the channel value C4 moves down row by row while the total in C14 stays fixed. Without the dollar signs the copied formulas would divide by empty cells.

Do I need marketing experience for this course?

No. The course starts with the channel landscape and basic division and explains each spreadsheet function when it is first used. All data come from a fictional shop, so you can practise without access to a real advertising account.

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

This free lab is lesson 1 of 20. Unlock the other 19 hands-on labs, the final exam and your certificate for a one-time $9.90.

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

Buy course — $9.90 See the full course