We use cookies. You have options. Cookies help us keep the site running smoothly and inform some of our advertising, but if you’d like to make adjustments, you can visit our Cookie Notice page for more information.
We’d like to use cookies on your device. Cookies help us keep the site running smoothly and inform some of our advertising, but how we use them is entirely up to you. Accept our recommended settings or customise them to your wishes.

Computing Optimal Pay-Per-Click Bids In 19 Easy Steps

This post describes how to compute optimal bids in paid search.
  1. Suppose [1] you're a single-channel [2] online B2C retailer [3] seeking to maximize profit [4].
  2. Suppose you sell a single gift product [5] via a single page website [6].
  3. Suppose there's only one term [7] relevant to your offering: "gift" [8].
  4. Suppose you run "gift" on exact match [9] on Google [10].
  5. Suppose [11] that on average 2.25% of visitors to your site purchase, with an average order of $350. [12][13]
  6. Thus, your sales per click are .0225 * 350 = $7.88.
  7. Suppose this $7.88 SPC is relatively stable all day, every day,[14] all year. [15]
  8. Suppose your cost of goods for your product is $125, and it costs you on average $25 in other variable costs (pick, pack, ship, dunnage, phone support, etc) to get it out the door.
  9. So COGS is 125/350 = 35.7% and your variable costs are 25/350 = 7.1%. [16]
  10. Suppose you have no returns. [17][18]
  11. So your effective variable margin is 1 - .35 - .071 = 57.1%.
  12. Suppose you (the marketing person) don't have to worry about fixed costs. [19]
  13. To maximize profit dollars [20], give half the effective variable margin to Google, [21] and
  14. Keep half of the effective variable margin for your firm. [22]
  15. Half of 57.1% is 28.6%, so you should spend 28.6 cents of every revenue dollar on advertising. [23]
  16. So your target A/S ratio is 28.6%. [24]
  17. Your actual SPC is $7.88 and your target A/S is 28.6%, so you need your average CPC to be $2.25 cents per click.
  18. Suppose every other advertiser on "gift" has equally high Quality Scores, so max CPC bid alone dictates placement on the page [25], and suppose there is so much traffic on "gift" that max CPC bid essentially matches resulting average CPC. [26]
  19. With all these assumptions, you should bid $2.25 cents per click for this term on Google. Voilà!
Real life gets a bit more complicated, when you're wrangling tens or hundreds of thousands of ads in your campaigns, bidding hourly to exploit time-of-day and day-of-week SPC variations, managing products coming into and out of stock, navigating Quality Score issues, competitive bidding, tail terms, match types, negatives, content, testing, second-tier engines, and on and on and on. But this example captures the three essential steps of economic bidding: figure how much revenue a click produces; figure out how much advertising you can spend to get a revenue dollar; and use these two metrics to compute your maximum bid. The rest is commentary. Footnotes
  1. If footnotes make you itch, this is good time to bail on this post.
  2. So we don't have to worry about search driving orders to the call center and to stores, and we don't have to worry about catalog and mail driving orders to search. For more on tracking search into the call center, see Call Center PPC Tracking. For more on catalog driving sales to search, see Brand vs. Non-Brand Search. In real life, these are very, very important considerations.
  3. Search for B2B has important differences, and search for lead-gen and services has important differences. Not covering those here.
  4. Not all online retail advertisers seek to maximize profit dollars. For some, revenue goals trump profit. Others care about % efficiency or ROI. Some retailers advertise for branding. Others seek maximum sales within a fixed dollar budget. All different perspectives, all valid in certain situations, all in turn lead to different bidding approaches. This post is about bottom line show-me-the-money bidding.
  5. Conceptually, one SKU is enough for this discussion.
  6. Most sites have several pages where inbound traffic on a generic term could be directed. In real life, use landing page testing to determine the best URL for each term.
  7. Large term lists are essential. As a rule of thumb, we recommend testing between 3 and 10 keywords per SKU. So, for a retailer with 5k products, we may test 10k to 50k terms. Half or so may fall by the wayside due to low traffic or anemic conversion, leading to perhaps 20k active terms.
  8. "Gift" is a high traffic "head" term, with many searches each day. That's intentional for this example. It is also about as untargeted as you can get, so performance will stink. That is a different topic for a different day.
  9. Match types and negatives matter a great deal. Using exact match in this example to keep things simple. In real life, match types are not a small issue, and need to be optimized carefully.
  10. All search traffic is not created equal: traffic from different engines behave and convert differently for the same phrase, sometimes almost half an order of magnitude. Sticking with Google here just for this example.
  11. In real life, conversion and SPC are the most important thing NOT to suppose. If you're seeking to maximize profit, SPC is your key metric. Averages and assumptions will kill you here. You good data and careful statistics. Also, in real life, AOV and conversion vary widely by term and engine. Here, as we're running one term on one engine, we'll ignore that essential point.
  12. 2.25% conversion is much higher than typical in paid search, and is patently ridiculous for a generic term like "gift". These numbers are illustrative.
  13. We picked "gift" here, a "head" term with high traffic. Correctly estimating conversion, AOV, and SPC on medium-traffic "body" terms and on very low volume "tail" terms is very, very important. At our firm that's one of the most important ingredients to our secret sauce. Correctly estimating low-probability events has been an interest of mine since my doctoral research on the topic at MIT. RKG maintains collaborations with smart academicians at Rochester and Santa Clara to continue to hone our statistical algorithms. (We have some marvelous proofs for this, but sadly they will not fit in this margin.)
  14. SPCs vary by time of day and day of week and season of year. This topic is called "day-parting", and doing it right is an important aspect of bidding. It is easy to do it wrong and get burned.
  15. Another place search practitioners and bid management platforms get burned is going into and out of holiday 'crush' seasons. We've seen data from multiple retailers and agencies showing staggering over- and under-shoot behavior when going through periods of fast change. Watch carefully. (Merry Christmas!)
  16. With only one product, there's no heterogeneity in the margin structure. In real life, many retailers have products and/or product categories with different margin structures. Margin-based bidding is a big deal and not many folks seem to be doing it yet. There are several ways to bid by margin, from actual SKU margin data (we're doing that for some clients) up to category margins (usually a reasonable approach, we're using that for other clients).
  17. Wouldn't that be great!
  18. If return rates and/or fraud rates are high and variable -- they are for retailers in some categories -- those can and should be folded into bidding through post-sale order-level feedback feeds.
  19. At day's end, you do have to cover overhead and profit, but direct marketing calculations typically are done on a variable basis, unburdened. For a great intro to direct marketing math, check out Jim Novo's stuff.
  20. Which, again, might not be everyone's objective. We're assuming here it is, see [4].
  21. When these numbers get big, Google starts sending you holiday gifts.
  22. See How Much To Advertise.
  23. From this, your firm covers overhead, profit, and taxes.
  24. If your margin structure is reasonably homegenous, A/S is a great proxy for profitability. If not, see [14].
  25. I have a nice bridge in Brooklyn to sell, if anyone is interested.
  26. For terms with high competition, market pressures force you essentially up to your max bid.
Afternote Yep, for this post I'm trying Andy Hagan's advice on picking titles to generate traffic. Good titles are not only highly important to blog traffic, they're also key to natural search and to CSE feeds. Will watch how this works and report back...
Join the Discussion