Bookending: Predict The Success Of Your Optimizations
It’s hard to see the forest for the trees when making account changes, sometimes. Meaning, when we get granular in our account changes, which we should, it’s often difficult to understand exactly how granular changes will affect the entirety of your account. The best way to remedy this is to utilize bookending. Bookending is a term we use at Hanapin to mean that you’ve did all the math/guesstimating that you can do when making account optimizations to figure out where those changes are going to bring you, and you’ve projected those changes to see where you’ll end up for the month.
In its most basic, data-driven form, bookending happens after bid changes. Here’s a step-by-step guide to bookending bid changes:
- Once you’ve downloaded all your keyword data, create a “% change” and “new max cpc” column next to the current “Max CPC” column in your spreadsheet.
- I don’t need to tell you how to make bid changes, especially because this changes for every account, manager, and goal, but put the change you’d like to make in the “% change” column. This could be 5%, -10%, 7.5%…whatever you want.
- Formulate the “new max cpc” like this: (old max cpc * %change) + old max cpc
- Create a “new cost” column, a “new revenue” column, a “new conversions” column, or whatever you’re trying to change in the account. Use the same formula for these, and sum everything at the bottom. The new as well as the old.
- Now, you’ve got your old totals and your new totals. You should be able to see pretty much what your bid changes will do, but to be sure–project! Divide your data by the number of days you pulled it for to get one days worth of data. Then, you can times that by 30 or 31 to see what next month could look like with these changes or times it by the number of days left in this month added to the data already available for the month to see where you could end this month.
- If your data reflects exactly what you want–great! Implement! If not, make some changes until you see what you want.
It’s also often difficult to understand if new keywords will or won’t help your account. Here’s some bookending you can do when adding new keywords to get an idea for where you’ll stand with them.
- Upload the keywords into the Google Traffic Estimator
- Now, you have the estimated monthly searches, estimated CPC, clicks, CTR, cost, and impressions. The conversion rate you’ll have to guesstimate based on either the account as a whole or the product you’re trying to sell.
- Spend / CPC * Conversion Rate = Leads. From here you could figure cost/conversion or even ROAS if you know the average revenue from each conversion for the product you’re adding keywords for.
- Project all this like we did for the bookending stuff.
- For whatever data you do have, you could calculate the % of increase in bid, etc. just like normal bookending, but for the new conversion data, use the formula: Spend / CPC * Conversion Rate = Leads. Again, you’ll have to guesstimate the conversion rate.
Browse By Category
The Advertising Principles That Guide Facebook's Decisions
Facebook highlights the advertising principles that guide their decision making in response to recent events.
Smart Ways to Get More Marketing Budget and Better Tools
In this new live webinar, Kristin Vick from Hanapin Marketing and Jeff Sauer from Jeffalytics discuss how marketers can ensure they have the budget they need to be effective with online advertising and get the right tools to make that argument.
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
The Hero Conf Difference
Of the 50+ search and social conferences you can choose from, we're here to show you why Hero Conf is a can't miss event for busy digital marketers like you.
Improve Your Facebook Ads With Creative Hub and Split Testing
With the updates to Creative Hub and the Split Test feature, one can now institute a basic ad creation and testing process directly within Facebook.
Work Habits & Resources for the Stressed-Out PPC Manager
Feeling a bit stressed this holiday season? Get tips and resources that will help you become more efficient and alleviate stress!