Tabellab

Final Project: Category Dashboard with ROAS, Gross Profit, POAS, New-Customer Share, a Flag and a Combo Chart

Lesson 20 of 20 Lab 🔒 Locked

Lessons in this course

  1. Product Feed Quality Audit: Title Length, Missing GTINs, Price Mismatches and the Revenue at RiskLabFree
  2. Feed Health by Category: Approval Rate, the Overall Rate from Totals and the Clicks Lost to Disapproved ItemsLab Locked
  3. Reading the Product-Group Report: ROAS, Cost Share, Value Share and the Share GapLab Locked
  4. Break-Even ROAS: Why the Same ROAS Is a Profit in One Category and a Loss in AnotherLab Locked
  5. From ROAS to POAS: Gross Profit after Refunds, Cost of Goods and Fees per Euro of Ad SpendLab Locked
  6. When ROAS and POAS Disagree: Two Rankings with RANK.EQ, Places Lost and the ROAS TrapLab Locked
  7. Product Groups by Performance: Heroes, Villains, Sidekicks and Zombies with Nested IFs and SUMIFSLab Locked
  8. Custom Labels by Margin Band: Approximate XLOOKUP, SUMIFS and SUMPRODUCT for POAS per LabelLab Locked
  9. Setting ROAS Targets from Profit Goals: Target POAS ÷ Margin, Rounded Settings, Gap and ActionLab Locked
  10. Performance Max Asset Groups: ROAS, Spend Share and an Asset Coverage Check with IF and ANDLab Locked
  11. Where Performance Max Spends: Cost on Feed Products vs Other Placements, a Guardrail and the Weekly TrendLab Locked
  12. New vs Returning Customers: New Share of Orders, Cost per New Customer and New-Customer ROASLab Locked
  13. What a New Customer Is Worth: First-Order Profit, 12-Month Profit and the Maximum Acquisition CostLab Locked
  14. Is Performance Max Incremental? A Regional Pause Test with Control Regions and Incremental ROASLab Locked
  15. Splitting the Budget: Marginal ROAS, Marginal POAS and the Last Budget Step Worth FundingLab Locked
  16. Budget Pacing: Cumulative vs Planned Spend, Run Rate, a Linear Trend and the Budget for the Remaining DaysLab Locked
  17. Price Competitiveness: Price Gap to the Benchmark, CORREL with Click Share and the Cost of Being ExpensiveLab Locked
  18. Testing New Product Titles: CTR Before and After, a Control Index, Adjusted Lift and Extra ClicksLab Locked
  19. What-If Grid: POAS for Every Combination of ROAS and Margin with Mixed References and a Heat MapLab Locked
  20. Final Project: Category Dashboard with ROAS, Gross Profit, POAS, New-Customer Share, a Flag and a Combo ChartLab Locked