How to create a predictive modeling table to calculate the most to pay for a CPM or click in the online display ad channel.
Often times we're approached by direct marketing clients who want to scale up their online sales, but have exhausted or saturated their successful channels. They're bidding on all the keywords that perform, they hit their e-mail list as much as they can, and they're applying all the focus in their power to SEO (define). The one channel they haven't successfully cracked open is display advertising.
Unlike search, where you're limited to the volume of consumer queries around your performing terms, display ads, particularly banners, have a lot more scalability if done right. The amount of inventory and opportunities in some cases (if your target audience is broad enough) is unlimited. The challenge is to crack the formula of what sites, placements, rates, creative (offers, images, messages, etc.), and conversion environments (landing pages, conversion paths, etc.) will ultimately form a scalable and reliable channel that grows your business.
The problem is that many companies have tried to use display advertising with sporadic bursts of banners, often in high CPM (define) and premium placements, without a foresight of predictive modeling and a sustained effort that applies an ROI (define) optimization process and methodology. They then fail and condemn the whole category of online display.
If they just applied some simple media math before starting their planning process, they would have cut out a lot of discovery cost right away. Seems obvious right? Well, guess what -- I see tons of companies fail because they didn't start with this simple step.
Often, I look at the failed campaigns of clients and think, I could have told you this media plan wouldn't work before the first impression was even purchased. The math just doesn't work -- no common sense was applied. You don't need to be a genius to know that $15 CPMs aren't going to work if your average sale is $160, your profit margin is 50 percent, a banner's average click rate is 0.15 percent (that's 1.5 tenths of a percent) and your site's historical average conversion rate from advertising is 3 percent. In this scenario, you're pretty much looking for a cost per sale of $80 or less just to break even, and $15 CPM won't get you there on day one. (Of course, there's a huge value to a new customer -- but let's assume we need to at least break on the first sale.)
Also, when doing a predictive model, don't assume the best and don't assume the worst. Don't be over confident and assume a 10 percent conversion rate, and don't stack the deck against yourself with a 1 percent conversion rate. Start from the middle and, here's the big thing, start your channel development by entering races you can win. Then, optimize your click and conversion rates up from there, and start buying higher price CPMs and CPCs (define).
Predictive Modeling Example: Setting Your Media Rate Thresholds
So, using the assumption above, let's create a predictive modeling table and identify the most we could pay for a CPM or click, based on historical data and assumptions -- in other words, set our media rate thresholds to achieve a cost per sale for around $80 or below. By just doing this, we'll cut out testing and heartbreak for placements that, barring some anomaly or miracle, won't perform in our first phase. By using these thresholds as buying parameters, we'll of course save tons of cash in the optimization process.
Below, you can see a predictive modeling table in chronological order of key performance indicator (KPI) metrics, from budget to cost per sale. The green zone represents CPMs and CPCs we can pay in this first round to come in below our $80 target. Pay any more than the highest rate in the green zone ($4), and it's unlikely we'll be successful. So you or the client may want the home page of CNET, but you won't be successful if you can't get it for a $4 CPM or less. (Notice the green zone goes up to a cost per sale of $88.89 -- well, no one said we couldn't push the envelope a little and hopefully lower CPMs -- and CPC deals will pull the average down.)
Note: "Cost Per Sale" is "Budget" divided by number of "Sales," e.g., conversions.
After You've Achieved Success in the Green Zone, Scale Up!
Now, once things work in the green zone, the objective is to raise our banner click rates and site conversion rates. When we do this, we'll be able to buy higher priced CPMs and CPCs and thus, our channel becomes wider and more scalable, we move into premium positions, and our client's business grows.
After you perform the above process and have a viable display ad channel based on clicks and easily measurable ROI, you can start to do longer term analysis and ROI modeling on your display campaign, by:
However, first we have the hard task of proving the display ad channel, and the first step is realistic predictive modeling combined with a client who is willing to invest the time and money in cracking the success code for their online display ad channel.
Want to learn more?
Attend ClickZ Live New York March 30 - April 1. With over 15 years' experience delivering industry-leading events, ClickZ Live brings together over 60 expert speakers to offer an action-packed, educationally-focused agenda covering all aspects of digital marketing. Register today!
As founder and CEO of Overdrive, Harry Gold is the architect and conductor behind the company's ROI-driven programs. His primary mission is to create innovative marketing programs based on real-world success and to ensure the marketing and technology practices that drive those successes are continually institutionalized into the culture and methods of the agency. What excites him is the knowledge that Overdrive's collaborative environment has created a company of online media, SEM, and online behavioral experts who drive success for the clients and companies they serve. Overdrive serves a diverse base of B2B and B2C clients that demand a high level of accountability and ROI from their online programs and campaigns.
Harry started his career in 1995 when he founded online marketing firm Interactive Promotions, serving such clients as Microsoft, "The Financial Times," the Hard Rock Cafe, and the City of Boston. Since then, he has been at the forefront of online branding and channel creation, developing successful Web and search engine-based marketing programs for various agencies and Fortune 500 companies.
Harry is a frequent lecturer on SEM and online media for The New England Direct Marketing Association; Ad Club; the University of Massachusetts, Boston; Harvard University; and Boston University.
Singapore, 5-6 March
Bangkok, 17-18 March
Hong Kong, April 2015
A Buyer's Guide to Affiliate Management Software
Manage your performance marketing with the right solution. Choose a platform that will mutually empower advertisers and media partners!
Google My Business Listings Demystified
To help brands control how they appear online, Google has developed a new offering: Google My Business Locations. This whitepaper helps marketers understand how to use this powerful new tool.
March 24, 2015
12:00pm ET/9:00am PT