Tabellab
Marketing Analytics Intermediate

Online Store Marketing & Growth: Traffic Mix, Conversion by Channel, AOV Levers, Repeat Purchases, Blended ROAS & Contribution Margin

Work through the marketing arithmetic of an independent online store, such as one run on a Shopify-style platform. You split traffic by source and compare session and revenue shares, follow the shopping funnel by channel, and measure revenue per session. You test the two classic AOV levers, bundles and a free-shipping threshold, then measure repeat purchase rate and a cohort retention curve. You calculate contribution margin per order, compare blended ROAS with the ROAS the ad platforms report, work out CAC and payback, and set break-even and target ROAS. Further labs cover discount codes, returns and net revenue, category margin, email flows, a dated marketing calendar, a bundle what-if table, marginal ROAS with SLOPE and FORECAST.LINEAR, and a tracking-gap check, and you finish with a half-year dashboard. 20 hands-on labs, fictional data, 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 course teaches the working arithmetic behind marketing an independent online store, for example one built on a Shopify-style platform, in 20 interactive spreadsheet labs. You play the analyst at Larkfield Desk Co, a fictional shop for notebooks, planners and desk accessories, and work through its numbers step by step: you split sessions, orders and revenue by traffic source, follow the shopping funnel for each channel, compare revenue per session and test the two classic AOV levers, bundles and a free-shipping threshold. You measure repeat purchase rate and a cohort retention curve, build contribution margin per order, contrast blended ROAS with the ROAS the ad platforms report, and calculate CAC, payback, break-even and target ROAS. Later labs cover discount codes, returns, category margin, email flows, a dated marketing calendar, a bundle what-if table, marginal ROAS and a data-quality check, and end with a half-year dashboard. Every formula is checked as you type. All companies and numbers are fictional and all benchmarks are illustrative.

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. Traffic Source Mix: Session Share, Conversion Rate and Revenue Share by ChannelLabFree
  2. Conversion by Channel: Add-to-Cart Rate, Checkout Completion and the Store-Wide BenchmarkLab Locked
  3. Revenue per Session: Average Order Value, RPS Index and Channel ConcentrationLab Locked
  4. AOV Lever 1: Bundles, Items per Order and Margin per Order with COUNTIFS and AVERAGEIFSLab Locked
  5. AOV Lever 2: The Free-Shipping Threshold, the Stretch Zone and the Net Profit EffectLab Locked
  6. Repeat Purchase Rate: One-Time vs Repeat Customers by Acquisition Channel with COUNTIFSLab Locked
  7. Cohort Retention Curve: Active Customers by Month Since First Order and the Right DenominatorLab Locked
  8. Contribution Margin per Order: Product Cost, Shipping, Payment Fees and Packaging by ChannelLab Locked
  9. Blended ROAS vs Platform ROAS: Total Ad Spend, Reported Revenue and the Overlap CheckLab Locked
  10. Customer Acquisition Cost: CAC by Channel, First-Order Profit and Orders to Pay BackLab Locked
  11. Break-Even and Target ROAS: Margin Before Ads, Profit Goal and Status by Product LineLab Locked
  12. Discount Codes: Orders, Discount Rate and Margin per Order by Code with SUMIFS and AVERAGEIFSLab Locked
  13. Returns and Net Revenue: Return Rate, Refund Rate and the Channels Above the Store AverageLab Locked
  14. Product Category Mix: Gross Margin, Margin Share, Rank and the Top-Two ConcentrationLab Locked
  15. Email Flows vs Campaigns: Revenue per 1,000 Recipients, Order Rate and UnsubscribesLab Locked
  16. Marketing Calendar: Event Length, Days Until Start, Planned ROAS and Budget by MonthLab Locked
  17. Bundle What-If: Discount Depth, Take Rate and Monthly Profit with Locked AssumptionsLab Locked
  18. Spend Response: ROAS, Marginal ROAS, Slope and a Linear Forecast for Paid SocialLab Locked
  19. Data Quality: Reconciling Analytics Orders with the Back Office, Gap % and Tolerance FlagsLab Locked
  20. Final Project: Half-Year Store Dashboard with Blended ROAS, Margin After Ads, a Flag and a Combo 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