Tabellab
Marketing Analytics Intermediate

Google Shopping & Performance Max for Online Shops: Feed Quality, Product Groups, ROAS vs POAS, Asset Groups, New Customers & Budget Split

Run Shopping and Performance Max campaigns on profit instead of on revenue. You audit a product feed for short titles, missing GTINs and price mismatches, measure approval rates, read the product-group report, derive break-even ROAS from margins and move from ROAS to POAS, then rank campaigns both ways, sort products into heroes, villains, sidekicks and zombies, build margin-based custom labels and ROAS targets, check asset groups, track where Performance Max spends, separate new from returning customers, value a new customer over twelve months, measure incrementality with a regional pause test, split budget by marginal POAS, pace a monthly budget, compare prices with the market, evaluate a title test, build a what-if grid and finish with a profit dashboard. 20 hands-on labs, fictional shop 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 numbers behind Google Shopping and Performance Max campaigns for online shops, with profit as the yardstick. In 20 interactive spreadsheet labs you work for Pebblewick Outdoor, a fictional shop for hiking and camping gear. You audit a product feed for short titles, missing GTINs and price mismatches, measure approval rates, read the product-group report and derive the break-even ROAS from margins. You then move from ROAS to POAS (profit on ad spend), sort products into performance tiers, build custom labels by margin band, set ROAS targets from a profit goal, check Performance Max asset groups, separate new from returning customers, evaluate a regional pause test for incrementality, split and pace the budget with marginal returns and finish with a category dashboard. Every answer is a formula that is checked instantly. All companies, products and figures are fictional, benchmarks are illustrative, and the course is not affiliated with Google.

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. 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

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