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.
- 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
- Traffic Source Mix: Session Share, Conversion Rate and Revenue Share by ChannelFree
- Conversion by Channel: Add-to-Cart Rate, Checkout Completion and the Store-Wide Benchmark Locked
- Revenue per Session: Average Order Value, RPS Index and Channel Concentration Locked
- AOV Lever 1: Bundles, Items per Order and Margin per Order with COUNTIFS and AVERAGEIFS Locked
- AOV Lever 2: The Free-Shipping Threshold, the Stretch Zone and the Net Profit Effect Locked
- Repeat Purchase Rate: One-Time vs Repeat Customers by Acquisition Channel with COUNTIFS Locked
- Cohort Retention Curve: Active Customers by Month Since First Order and the Right Denominator Locked
- Contribution Margin per Order: Product Cost, Shipping, Payment Fees and Packaging by Channel Locked
- Blended ROAS vs Platform ROAS: Total Ad Spend, Reported Revenue and the Overlap Check Locked
- Customer Acquisition Cost: CAC by Channel, First-Order Profit and Orders to Pay Back Locked
- Break-Even and Target ROAS: Margin Before Ads, Profit Goal and Status by Product Line Locked
- Discount Codes: Orders, Discount Rate and Margin per Order by Code with SUMIFS and AVERAGEIFS Locked
- Returns and Net Revenue: Return Rate, Refund Rate and the Channels Above the Store Average Locked
- Product Category Mix: Gross Margin, Margin Share, Rank and the Top-Two Concentration Locked
- Email Flows vs Campaigns: Revenue per 1,000 Recipients, Order Rate and Unsubscribes Locked
- Marketing Calendar: Event Length, Days Until Start, Planned ROAS and Budget by Month Locked
- Bundle What-If: Discount Depth, Take Rate and Monthly Profit with Locked Assumptions Locked
- Spend Response: ROAS, Marginal ROAS, Slope and a Linear Forecast for Paid Social Locked
- Data Quality: Reconciling Analytics Orders with the Back Office, Gap % and Tolerance Flags Locked
- Final Project: Half-Year Store Dashboard with Blended ROAS, Margin After Ads, a Flag and a Combo Chart Locked
Learner reviews
Be the first to review this course.