Tabellab

Device Modifiers: Value per Click by Device, the Campaign Baseline with SUMIFS and Bids in 5 % Steps

Lesson 7 of 20 Lab 🔒 Locked

Lessons in this course

  1. Break-Even Bids: Margin per Order, Break-Even CPC, Margin per Click and a Verdict for Every Ad GroupLabFree
  2. Break-Even CPA and ROAS: What an Order May Cost, the ROAS You Need and a Target with Profit Built InLab Locked
  3. Manual CPC: Turning a Target CPA into Keyword Bids with Conversion Rates, Capped Steps and ROUNDLab Locked
  4. Manual CPC vs Target CPA vs Target ROAS: Spend, CPA, ROAS and Share of Spend per Bid Strategy with SUMIFSLab Locked
  5. Target ROAS: Value per Click, Tiered ROAS Targets with XLOOKUP and the Max CPC a Target ImpliesLab Locked
  6. Day-Parting: Conversion Rate by Hour Block, an Index Against the Account and Capped Bid ModifiersLab Locked
  7. Device Modifiers: Value per Click by Device, the Campaign Baseline with SUMIFS and Bids in 5 % StepsLab Locked
  8. Geo Modifiers: CPA by Region, a Minimum-Data Rule, Capped Location Modifiers and a RankLab Locked
  9. Stacked Modifiers: How Device, Region and Time Adjustments Multiply, the Effective Bid and a Bid CeilingLab Locked
  10. Monthly Pacing: Cumulative Spend, the Ideal Line, Pacing in Per Cent and the Daily Spend LeftLab Locked
  11. Month-End Forecasts: Run Rate vs Recent Trend with DAY and EOMONTH, Variance to Budget and a Status with IFSLab Locked
  12. Weekday-Weighted Pacing: Weekday Weights, WEEKDAY and XLOOKUP on Dates and a Daily Plan for the Rest of the MonthLab Locked
  13. Impression Share: Lost to Budget or Lost to Rank, Missed Clicks, the Spend to Capture Them and a DiagnosisLab Locked
  14. Marginal CPA: What the Last Euro Buys, a Ranking of Campaigns and Where to Move BudgetLab Locked
  15. Bid Landscapes: Marginal CPC, Profit After Ads at Every Bid Level and the Profit-Maximising Bid with INDEX/MATCHLab Locked
  16. Ready for Automated Bidding? Conversion Volume, Budget-to-Target Ratio, Days to Enough Data and a VerdictLab Locked
  17. What-If Grid: Profit After Ads for Every Target ROAS and Margin with Mixed References, the Best Target and a Heat MapLab Locked
  18. Seasonal Budget Plan: A Seasonal Index, the Annual Budget Split by Month with ROUND and Expected ConversionsLab Locked
  19. Testing a Bid Strategy: A Split Experiment, the Change in CPA, a Paired T.TEST and a VerdictLab Locked
  20. Final Project: Bidding & Pacing Dashboard with Month-End Projection, Profit Index, an Action per Campaign and Profit by StrategyLab Locked