Tabellab

Final Project: Half-Year Store Dashboard with Blended ROAS, Margin After Ads, a Flag and a Combo Chart

Lesson 20 of 20 Lab 🔒 Locked

Lessons in this course

  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