Break-Even CPA and ROAS: What an Order May Cost, the ROAS You Need and a Target with Profit Built In
Lessons in this course
- Break-Even Bids: Margin per Order, Break-Even CPC, Margin per Click and a Verdict for Every Ad GroupFree
- Break-Even CPA and ROAS: What an Order May Cost, the ROAS You Need and a Target with Profit Built In Locked
- Manual CPC: Turning a Target CPA into Keyword Bids with Conversion Rates, Capped Steps and ROUND Locked
- Manual CPC vs Target CPA vs Target ROAS: Spend, CPA, ROAS and Share of Spend per Bid Strategy with SUMIFS Locked
- Target ROAS: Value per Click, Tiered ROAS Targets with XLOOKUP and the Max CPC a Target Implies Locked
- Day-Parting: Conversion Rate by Hour Block, an Index Against the Account and Capped Bid Modifiers Locked
- Device Modifiers: Value per Click by Device, the Campaign Baseline with SUMIFS and Bids in 5 % Steps Locked
- Geo Modifiers: CPA by Region, a Minimum-Data Rule, Capped Location Modifiers and a Rank Locked
- Stacked Modifiers: How Device, Region and Time Adjustments Multiply, the Effective Bid and a Bid Ceiling Locked
- Monthly Pacing: Cumulative Spend, the Ideal Line, Pacing in Per Cent and the Daily Spend Left Locked
- Month-End Forecasts: Run Rate vs Recent Trend with DAY and EOMONTH, Variance to Budget and a Status with IFS Locked
- Weekday-Weighted Pacing: Weekday Weights, WEEKDAY and XLOOKUP on Dates and a Daily Plan for the Rest of the Month Locked
- Impression Share: Lost to Budget or Lost to Rank, Missed Clicks, the Spend to Capture Them and a Diagnosis Locked
- Marginal CPA: What the Last Euro Buys, a Ranking of Campaigns and Where to Move Budget Locked
- Bid Landscapes: Marginal CPC, Profit After Ads at Every Bid Level and the Profit-Maximising Bid with INDEX/MATCH Locked
- Ready for Automated Bidding? Conversion Volume, Budget-to-Target Ratio, Days to Enough Data and a Verdict Locked
- What-If Grid: Profit After Ads for Every Target ROAS and Margin with Mixed References, the Best Target and a Heat Map Locked
- Seasonal Budget Plan: A Seasonal Index, the Annual Budget Split by Month with ROUND and Expected Conversions Locked
- Testing a Bid Strategy: A Split Experiment, the Change in CPA, a Paired T.TEST and a Verdict Locked
- Final Project: Bidding & Pacing Dashboard with Month-End Projection, Profit Index, an Action per Campaign and Profit by Strategy Locked