Final Project: Category Dashboard with ROAS, Gross Profit, POAS, New-Customer Share, a Flag and a Combo Chart
Lessons in this course
- Product Feed Quality Audit: Title Length, Missing GTINs, Price Mismatches and the Revenue at RiskFree
- Feed Health by Category: Approval Rate, the Overall Rate from Totals and the Clicks Lost to Disapproved Items Locked
- Reading the Product-Group Report: ROAS, Cost Share, Value Share and the Share Gap Locked
- Break-Even ROAS: Why the Same ROAS Is a Profit in One Category and a Loss in Another Locked
- From ROAS to POAS: Gross Profit after Refunds, Cost of Goods and Fees per Euro of Ad Spend Locked
- When ROAS and POAS Disagree: Two Rankings with RANK.EQ, Places Lost and the ROAS Trap Locked
- Product Groups by Performance: Heroes, Villains, Sidekicks and Zombies with Nested IFs and SUMIFS Locked
- Custom Labels by Margin Band: Approximate XLOOKUP, SUMIFS and SUMPRODUCT for POAS per Label Locked
- Setting ROAS Targets from Profit Goals: Target POAS ÷ Margin, Rounded Settings, Gap and Action Locked
- Performance Max Asset Groups: ROAS, Spend Share and an Asset Coverage Check with IF and AND Locked
- Where Performance Max Spends: Cost on Feed Products vs Other Placements, a Guardrail and the Weekly Trend Locked
- New vs Returning Customers: New Share of Orders, Cost per New Customer and New-Customer ROAS Locked
- What a New Customer Is Worth: First-Order Profit, 12-Month Profit and the Maximum Acquisition Cost Locked
- Is Performance Max Incremental? A Regional Pause Test with Control Regions and Incremental ROAS Locked
- Splitting the Budget: Marginal ROAS, Marginal POAS and the Last Budget Step Worth Funding Locked
- Budget Pacing: Cumulative vs Planned Spend, Run Rate, a Linear Trend and the Budget for the Remaining Days Locked
- Price Competitiveness: Price Gap to the Benchmark, CORREL with Click Share and the Cost of Being Expensive Locked
- Testing New Product Titles: CTR Before and After, a Control Index, Adjusted Lift and Extra Clicks Locked
- What-If Grid: POAS for Every Combination of ROAS and Margin with Mixed References and a Heat Map Locked
- Final Project: Category Dashboard with ROAS, Gross Profit, POAS, New-Customer Share, a Flag and a Combo Chart Locked