Tabellab

The Shop-Tab Funnel: Impressions, Product Views, Adds to Cart and Orders per 1,000 Impressions

Lesson 1 of 20Lab

All lessons
  1. The Shop-Tab Funnel: Impressions, Product Views, Adds to Cart and Orders per 1,000 ImpressionsLabFree
  2. Funnel Leaks: Step Rates, Change in Percentage Points and the Orders Lost at the Weakest StepLab Locked
  3. Live Viewers to Buyers: Viewer-to-Buyer Rate, Revenue per Viewer, Ranking Shows and the Pooled RateLab Locked
  4. Peak Concurrent Viewers: Peak, Minute of the Peak, Average Audience and Minutes Near the PeakLab Locked
  5. Items per Live Order: Units per Order, Average Order Value, Bundle vs Single-Item Shows and the Value of One More ItemLab Locked
  6. Host Commission: Flat Rate vs Tiers, Approximate Lookups and the Extra Cost of a Tier ModelLab Locked
  7. Returns After Live Sales: Unit Return Rate, Net Revenue, a Review Limit and the Pooled Return RateLab Locked
  8. Live Show Contribution: Net Revenue, Variable Costs, Margin and Contribution per Live HourLab Locked
  9. Return Reasons: Totals by Reason, Shares, Return Rate per Category and the Preventable ShareLab Locked
  10. Discount Depth in Flash Deals: Sale Price, Total Margin, Conversion and a Forecast at a New DiscountLab Locked
  11. Audience Retention: Retention Curve, Viewers Lost per Interval, the 50 % Minute and Average Minutes WatchedLab Locked
  12. Engagement Levels: Conversion by Level, Lift vs. Silent Viewers and Where the Buyers Come FromLab Locked
  13. Order-Log Cleaning and Attribution: Duplicates, Test and Cancelled Orders and a 24-Hour WindowLab Locked
  14. Host Scorecard: Indexes, a Weighted Score with SUMPRODUCT and the Top HostLab Locked
  15. Show Time Slots: Average Revenue per Slot, a Mixed-Reference Grid, the Best Daypart and a Heat MapLab Locked
  16. Forecasting the Next Show: Slope, R Squared, FORECAST.LINEAR and a Revenue EstimateLab Locked
  17. Testing a Show Format: Pooled Conversion, z Score, p-Value and a Careful VerdictLab Locked
  18. Stock vs Expected Demand: Demand from Show Assumptions, Lost Sales, Sell-Through and Stock-Out FlagsLab Locked
  19. Break-Even and What-If Grid: Break-Even Orders and Viewers, Mixed References and a Loss Heat FlagLab Locked
  20. Year Scorecard for Live Commerce: Conversion, Net Revenue after Commission, Return Alerts and a Combo 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…

Why a shop tab needs its own arithmetic

Social platforms have turned into shopping streets. A product can be tagged in a post, a short video or a story, listed in a shop tab, pinned during a live stream or sold through a creator’s storefront. For a small brand this is good news, because shoppers meet the product where they already spend their time. It also creates a measurement problem: the same product is shown in many places, each place has a different audience, and the only thing that is easy to see is a total number of orders.

A total hides the answer to the questions that decide where to spend time and money. Which surface turns attention into orders? Where do shoppers drop out between seeing a product and paying for it? Is a surface weak because it reaches the wrong people, or because it reaches many people with little intent? This free lesson shows how to answer these questions with a small funnel table and a handful of ratios in a spreadsheet.

The example is Harrowgate Home, a fictional brand that sells candles, ceramics, linen and kitchenware. All surfaces, counts and prices are invented for learning, and so are the other companies and people you will meet in this course. The numbers are illustrative and are not platform benchmarks. You will work with the same eight surfaces as in the lab above.

The funnel: four counts and three rates

A social-commerce funnel follows a shopper from first sight to purchase. For the maths we use four counts, which most analytics exports of a shop or a platform provide in some form:

  • Impressions. A product card, tag or sticker was shown on a screen. One person can generate several impressions.
  • Product views. The shopper opened the product page.
  • Adds to cart. The shopper put the product in the cart.
  • Orders. The shopper paid. Revenue is the money for these paid orders before returns.

Every step of the funnel is a ratio of the step before it. That gives three step rates, and each has its own denominator:

  • View rate = product views ÷ impressions.
  • Cart rate = adds to cart ÷ product views.
  • Order rate = orders ÷ adds to cart (the share of carts that become orders).

The most common error is to divide every count by the same denominator, usually the impressions. A cart rate of 0.4 % of impressions tells you nothing about the shop page, because most impressions never reach it. Dividing by the step above isolates the behaviour of the people who got that far.

Definitions differ between platforms and change over time. One platform counts an impression when a card is on screen for a moment, another needs a minimum time. Before you compare surfaces, read how your own export defines each count, and keep the definition the same when you compare months.

Normalising: orders and revenue per 1,000 impressions

Surfaces differ enormously in size. A short-video tag may be shown 265,000 times in a month and a pinned product in a live stream only 41,000 times. The raw order counts mix the effect of size with the effect of quality. To compare quality, divide by the exposure and scale to a convenient number:

  • Orders per 1,000 impressions = orders ÷ impressions × 1000.
  • Revenue per 1,000 impressions = revenue ÷ impressions × 1000.

The second figure is like a revenue version of the advertising term RPM (revenue per mille), and it is the number you can compare with what an impression costs you. If a surface earns $34.89 per 1,000 impressions and you pay $12 to buy 1,000 impressions there, the maths is very different from a surface that earns $806.05.

A fully worked example: eight surfaces for one month

Here are the eight surfaces with the counts from the lab and the four calculated columns. Revenue is the number of orders times the average order value of the surface.

SurfaceImpressionsProduct viewsAdds to cartOrdersRevenue $View rateCart rateOrders per 1,000Revenue per 1,000 $
Shop tab browse186,0009,8501,28039218,4245.30 %12.99 %2.1199.05
Product tags in posts142,0006,39081026212,0524.50 %12.68 %1.8584.87
Product tags in short videos265,0007,4207452019,2462.80 %10.04 %0.7634.89
Story product sticker98,0003,9204701647,5444.00 %11.99 %1.6776.98
Profile shop64,0004,48076028113,4887.00 %16.96 %4.39210.75
Search inside the shop52,0005,20089033716,17610.00 %17.12 %6.48311.08
Live: pinned product41,0008,6101,55061233,04821.00 %18.00 %14.93806.05
Creator storefronts78,0003,5104001186,0184.50 %11.40 %1.5177.15

The formulas for row 4 (the shop tab), copied down to row 11, are listed here. Columns B to F hold the data, G to J the results.

  • View rate (G4): =C4/B4
  • Cart rate (H4): =D4/C4
  • Orders per 1,000 impressions (I4): =E4/B4*1000
  • Revenue per 1,000 impressions (J4): =F4/B4*1000

Walk through the first row. The shop tab browse surface was shown 186,000 times; 9,850 shoppers opened a product page, a view rate of 9,850 ÷ 186,000 = 5.30 %. Of those, 1,280 added the product to the cart, a cart rate of 12.99 %, and 392 paid. The orders brought 18,424 dollars, so one thousand impressions on this surface earned 18,424 ÷ 186,000 × 1000 = $99.05.

Revenue per 1,000 impressions by surfaceLive: pinned product$806.05Search inside the shop$311.08Profile shop$210.75Shop tab browse$99.05Product tags in posts$84.87Creator storefronts$77.15Story product sticker$76.98Product tags in short videos$34.89$0$300$600$900Revenue per 1,000 impressions, one month (fictional)
Figure 1. Revenue per 1,000 impressions for each surface. The live pinned product earns about eight times as much per impression as the shop tab browse surface, and about twenty-three times as much as product tags in short videos.

How to read the result

The ranking is clear. The pinned product in a live stream earns $806.05 per 1,000 impressions, search inside the shop $311.08 and the profile shop $210.75. At the bottom are product tags in short videos with $34.89. The short-video tags are not useless: they are shown 265,000 times, 28.6 % of all impressions, but they bring 8.0 % of the revenue. The live stream is the opposite: 4.4 % of the impressions and 28.5 % of the revenue.

The reason sits in the first two rates. The live pinned product has a view rate of 21.0 % because the shopper is already watching the person who holds the product. A short-video tag has a view rate of 2.8 %: most viewers watch the video and never tap the tag. The cart rates are closer together (10.0 % to 18.0 %), so the biggest difference between the surfaces is intent at the top of the funnel, not the quality of the product page.

For the whole month, 926,000 impressions led to 49,380 product views (5.33 %), 6,905 adds to cart (13.98 % of the views) and 2,367 orders (34.28 % of the carts). That is 2.56 orders and $125.27 of revenue per 1,000 impressions on average. Notice that the overall rate is the total orders divided by the total impressions, not the average of the eight surface rates.

One month, all surfaces: where shoppers drop outImpressions926,000Product views49,3805.33 % step rateAdds to cart6,90513.98 % step rateOrders2,36734.28 % step rateBox widths are not to scale. Fictional data of one month.
Figure 2. The funnel of the whole month. Roughly one impression in 19 leads to a product view, one view in 7 to a cart and one cart in 3 to an order.

Put the funnel on one row per surface and one column per step. When you add a new surface or a new month, copy the formulas down: the calculated columns need no change, which keeps the sheet easy to check.

Step by step in your own sheet

  1. Export the four counts for each surface and month from your shop or platform tools and paste them as plain numbers.
  2. Write the view rate in the first data row, =C4/B4, check one result by hand with a calculator, then copy the formula down.
  3. Add the cart rate =D4/C4 and, if you like, the order rate =E4/D4.
  4. Add the per-1,000 columns. Multiply by 1000 in the formula so that the number is easy to read.
  5. Format the rates as percentages and the money columns with two decimals, but do not round inside the formulas.
  6. Chart the revenue per 1,000 impressions as a bar chart sorted from high to low: a long list of rates is hard to read, a sorted bar chart is not.

Common mistakes and how to spot them

  • One denominator for every rate. Dividing carts and orders by the impressions makes the later steps look tiny and hides where shoppers drop out. Each step divides by the step above it.
  • Forgetting to multiply by 1000. Orders per impression is a number such as 0.0021. If your per-1,000 column shows values below 1 for all surfaces, the factor is missing.
  • Averaging rates. The average of the eight view rates is not the overall view rate, because a surface with 41,000 impressions counts as much as one with 265,000. Add the counts first and divide once.
  • Mixing definitions. If the live stream counts an impression after three seconds and the short-video tag counts it immediately, the view rates are not comparable. Check the definitions.
  • Comparing different months. A surface measured in a sale month against another in a quiet month tells you nothing about the surface. Compare surfaces within the same period.
  • Treating revenue as profit. Revenue per 1,000 impressions ignores product cost, returns, shipping and commission. Later in the course you will turn revenue into contribution.
  • Reading a small sample as a law. A surface with 400 adds to cart can move a lot from one month to the next. Look for the same pattern in several months before you move budget.

Quick reference: formulas in this lesson

MeasureMeaningExample formula
View rateShare of impressions that open a product page=C4/B4
Cart rateShare of product views that add to cart=D4/C4
Order rateShare of carts that become orders=E4/D4
Orders per 1,000 impressionsOrders scaled to exposure=E4/B4*1000
Revenue per 1,000 impressionsRevenue scaled to exposure=F4/B4*1000
Average order valueRevenue per order=F4/E4
F4 / Cmd + TSwitch between relative and absolute references$B$4

Real-world uses

  • Deciding where to tag. If search inside the shop and the profile shop earn two to four times more per impression than posts, product pages and titles deserve more attention there than the tenth tagged post.
  • Briefing creators. A creator storefront with a view rate of 4.5 % and a cart rate of 11.4 % shows how much of the audience’s attention turns into intent. Compare it with the shop tab before you agree on a fee.
  • Planning a live show. If a pinned product has a high view rate and a cart rate that is no better than elsewhere, the live show is finding the shoppers and the product page has to do more.
  • Finding the leak after a site change. A drop of the cart rate on every surface at once points to the product page or the price, not to a single audience.
  • Reporting. A one-page table of rates per surface is easier for a manager to read than a long list of totals, and it answers the question what to do next.

Honest measurement and fair selling

Social commerce works on trust. Count orders you can verify, say clearly when numbers are estimates, and do not build pressure with false counters or invented scarcity. Target and segment on behaviour (what people watched, saved or bought) and never on protected characteristics such as age, gender or health. Where you message shoppers, make sure they agreed to receive messages. The later labs of this course on returns and stock are partly about keeping the promises that a lively stream makes.

What you will build in the rest of this course

Lesson 1 is free. Lessons 2 to 20 make up the paid course. Each has its own live lab with a different data set of Harrowgate Home and builds on the funnel you learned today.

  1. Funnel Leaks: Step Rates, Change in Percentage Points and the Orders Lost at the Weakest Step. You compare every step of the funnel between two months, find the step with the biggest fall and estimate the orders it cost.
  2. Live Viewers to Buyers: Viewer-to-Buyer Rate, Revenue per Viewer, Ranking Shows and the Pooled Rate. You turn twelve live shows into comparable rates and learn why a pooled rate beats an average of rates.
  3. Peak Concurrent Viewers: Peak, Minute of the Peak, Average Audience and Minutes Near the Peak. You read the audience curve of one show and chart it.
  4. Items per Live Order: Units per Order, Average Order Value, Bundle vs Single-Item Shows and the Value of One More Item. You compare show formats by basket size and price one more item per order.
  5. Host Commission: Flat Rate vs Tiers, Approximate Lookups and the Extra Cost of a Tier Model. You price two commission models with an approximate lookup.
  6. Returns After Live Sales: Unit Return Rate, Net Revenue, a Review Limit and the Pooled Return Rate. You measure returns per show and flag the shows above a limit.
  7. Live Show Contribution: Net Revenue, Variable Costs, Margin and Contribution per Live Hour. You build what a show earns after product, shipping, commission and show costs.
  8. Return Reasons: Totals by Reason, Shares, Return Rate per Category and the Preventable Share. You find out why goods come back and which part you can prevent.
  9. Discount Depth in Flash Deals: Sale Price, Total Margin, Conversion and a Forecast at a New Discount. You test how deep a discount can go before it eats the margin.
  10. Audience Retention: Retention Curve, Viewers Lost per Interval, the 50 % Minute and Average Minutes Watched. You follow one group of viewers through a show.
  11. Engagement Levels: Conversion by Level, Lift vs. Silent Viewers and Where the Buyers Come From. You compare buyers across chat, question and follow behaviour.
  12. Order-Log Cleaning and Attribution: Duplicates, Test and Cancelled Orders and a 24-Hour Window. You clean an order export and apply an attribution window.
  13. Host Scorecard: Indexes, a Weighted Score with SUMPRODUCT and the Top Host. You combine three metrics into one score with weights.
  14. Show Time Slots: Average Revenue per Slot, a Mixed-Reference Grid, the Best Daypart and a Heat Map. You compare weekday and time-of-day slots.
  15. Forecasting the Next Show: Slope, R Squared, FORECAST.LINEAR and a Revenue Estimate. You forecast orders and revenue from the planned audience.
  16. Testing a Show Format: Pooled Conversion, z Score, p-Value and a Careful Verdict. You test whether a new show format really converts better.
  17. Stock vs Expected Demand: Demand from Show Assumptions, Lost Sales, Sell-Through and Stock-Out Flags. You plan stock per product and flag the products that will run out.
  18. Break-Even and What-If Grid: Break-Even Orders and Viewers, Mixed References and a Loss Heat Flag. You find the audience a show needs and map profit and loss across scenarios.
  19. Year Scorecard for Live Commerce: Conversion, Net Revenue after Commission, Return Alerts and a Combo Chart. You finish with a yearly scorecard that joins all skills.
All data in this lesson and in the course are fictional and illustrative. They are not taken from any platform and do not describe typical results.

Frequently asked questions

What is a social-commerce funnel?

It is the path from seeing a product inside a social app to paying for it: impressions, product views, adds to cart and orders. Each step has a rate relative to the step before it, which shows where shoppers drop out.

How do I calculate a view rate and a cart rate in Excel?

View rate is product views divided by impressions, for example =C4/B4. Cart rate is adds to cart divided by product views, for example =D4/C4. Copy the formulas down and format the columns as percentages.

Why compare surfaces per 1,000 impressions?

Surfaces differ in size. Orders or revenue per 1,000 impressions removes the effect of size, so a small surface with a high intent can be compared fairly with a large surface with low intent.

What is the difference between an impression and a product view?

An impression means a product card, tag or sticker was shown. A product view means the shopper opened the product page. The ratio between them, the view rate, measures how often attention turns into interest.

Is the overall rate the average of the surface rates?

No. Add the counts of all surfaces first and divide once. The average of rates gives a small surface the same weight as a large one and usually gives a misleading overall figure.

Are the numbers in this lab real platform benchmarks?

No. All companies, surfaces and numbers are fictional and illustrative. Platforms define impressions and views in their own way and change those definitions, so always check the definitions in your own export.

Keep going: Social Commerce & Live Shopping: Shop-Tab Funnels, Viewer-to-Buyer Conversion, Peak Concurrency, Items per Order, Host Commission & Returns

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. Funnel Leaks: Step Rates, Change in Percentage Points and the Orders Lost at the Weakest Step
  2. Live Viewers to Buyers: Viewer-to-Buyer Rate, Revenue per Viewer, Ranking Shows and the Pooled Rate
  3. Peak Concurrent Viewers: Peak, Minute of the Peak, Average Audience and Minutes Near the Peak
  4. Items per Live Order: Units per Order, Average Order Value, Bundle vs Single-Item Shows and the Value of One More Item
  5. Host Commission: Flat Rate vs Tiers, Approximate Lookups and the Extra Cost of a Tier Model
  6. Returns After Live Sales: Unit Return Rate, Net Revenue, a Review Limit and the Pooled Return Rate
  7. Live Show Contribution: Net Revenue, Variable Costs, Margin and Contribution per Live Hour
  8. Return Reasons: Totals by Reason, Shares, Return Rate per Category and the Preventable Share
  9. Discount Depth in Flash Deals: Sale Price, Total Margin, Conversion and a Forecast at a New Discount
  10. Audience Retention: Retention Curve, Viewers Lost per Interval, the 50 % Minute and Average Minutes Watched
  11. Engagement Levels: Conversion by Level, Lift vs. Silent Viewers and Where the Buyers Come From
  12. Order-Log Cleaning and Attribution: Duplicates, Test and Cancelled Orders and a 24-Hour Window
  13. Host Scorecard: Indexes, a Weighted Score with SUMPRODUCT and the Top Host
  14. Show Time Slots: Average Revenue per Slot, a Mixed-Reference Grid, the Best Daypart and a Heat Map
  15. Forecasting the Next Show: Slope, R Squared, FORECAST.LINEAR and a Revenue Estimate
  16. Testing a Show Format: Pooled Conversion, z Score, p-Value and a Careful Verdict
  17. Stock vs Expected Demand: Demand from Show Assumptions, Lost Sales, Sell-Through and Stock-Out Flags
  18. Break-Even and What-If Grid: Break-Even Orders and Viewers, Mixed References and a Loss Heat Flag
  19. Year Scorecard for Live Commerce: Conversion, Net Revenue after Commission, Return Alerts and a Combo Chart

Buy course — $9.90 See the full course