Published on 13-Sep-2011
Validated on 18 Apr 2013
"With Netezza, we’re able to process all of our forecast models in a day, compared with the previous three to four days. This enables us to produce vehicle values that we can deliver in near real-time to the marketplace instead of waiting up to two weeks to push those values out to KBB.com." - Dan Ingle, Vice President of Analytic Insights, Kelley Blue Book
Kelley Blue Book
Data Warehouse, Information Governance, Information Integration, Smarter Computing
The publisher that has long provided a reliable mechanism for buying and selling cars is rapidly becoming an analytics-driven information powerhouse that facilitates the buying process for consumers while providing qualified leads and market insights to dealers and OEMs (original equipment manufacturers).
Advertising data volumes exceeded the capability of the existing SQL Server environment, slowing data loading and queries. The company also needed greater computational power to estimate advertising inventory availability a year in advance.
With initial deployment completed in two days, the IBM Netezza data warehouse appliance provides the load and scale to support the company’s analytics requirements.
Increased ad revenue from better ad analysis, forecasting and fill rate; improved profitability from ad pricing and search engine marketing optimization; strengthened customer satisfaction with faster, accurate publication of auto valuations.
In the early 1920s, the owner of Kelley Kar Company in Los Angeles began distributing to other dealers and banks a list of automobiles he wanted to buy and the prices he would pay. Demand grew for “Kelley’s Cash Price List” as the trade recognized Les Kelley’s ability to predict market values accurately. In 1926, Kelley’s inventory wish list became the Blue Book of Motor Car Values, offering factory list prices and cash values for thousands of vehicles, and establishing “Blue Book value” as the standard of car valuation referenced by sellers and buyers.
More than 80 years later, Kelley Blue Book (KBB) is still innovating and transforming itself. The publisher that has long provided a reliable mechanism for buying and selling cars is rapidly becoming an analytics-driven information powerhouse that facilitates the buying process for consumers while providing qualified leads and market insights to dealers and OEMs (original equipment manufacturers). The company estimates that each month its website, KBB.com, experiences more than 16 million visits making it a top online destination for car shoppers. Because three of every four visitors are “undecided,” KBB.com is also a “must buy” on the advertising media plans of every OEM. Car dealerships count on a steady flow of leads from consumers who generate more than 30 million pricing reports monthly.
Analytics: the heart of KBB’s strategy
From “Kelley’s Cash Price List” through today, KBB at its core has always been a data company, but until three years ago, analytics played a minor role in most decisions. That is changing, according to Dan Ingle, Vice President of Analytic Insights: “Now analytics are at the heart of KBB’s strategy. We use analytics to optimize lead generation, and analytics enable us to maintain a very low error rate in forecasting vehicle valuation. With Netezza [now IBM Netezza], we’re able to process all of our forecast models in a day, compared with the previous three to four days. This enables us to produce vehicle values that we can deliver in near real-time to the marketplace instead of waiting up to two weeks to push those values out to KBB.com.”
It is in online advertising sales, however, where analytics capabilities arguably have become the most important differentiator available to websites in highly competitive ad-driven markets. The fractured, fast-growing online ad business still depends largely on ad server technology and workflow conceived in the 1990s to solve simpler problems than today’s data-intensive riddles, such as inventory forecasting, impression and page revenue yield management, audience-based targeting and ad price optimization.
Like ad server technology designed for less complex tasks, KBB’s existing Microsoft® SQL Server® environment also proved to be inadequate. Advertising data volumes would swell to 10 terabytes, and data loads and queries were taking too long. Other critical business centers faced similar performance challenges; for example, the legacy system used to set vehicle values was antiquated. The time had come to build a data infrastructure that could handle the current load and scale with KBB’s aggressive goals.
KBB decided to implement a business intelligence (BI) platform to improve reporting and visualization capabilities. However, with the BI platform pulling data from the SQL Server warehouse, the fastest queries would still take hours to days to complete, or would time out and never return at all. At the same time, these queries were taxing the server and negatively impacting other processes that needed to run. Many of the BI platform features, such as automated dashboarding capabilities, were rendered useless due to the processing time needed through SQL Server.
KBB knew that it was time to evaluate a new data warehouse platform to empower their BI capabilities. After evaluating the performance, total cost of ownership (TCO) and ease of implementation of data warehouse appliances, KBB decided to move forward with Netezza (now the IBM® Netezza® data warehouse appliance). The appliance offered fast analytic performance, integrated seamlessly with KBB’s existing BI and SAS environments, and represented lower TCO than similar competitive products in terms of pricing, licensing and maintenance costs.
Netezza’s data warehouse (now the IBM Netezza data warehouse appliance) was selected to help gather, analyze and distribute data from many different sources much faster and in multiple applications. The logical first application that KBB deployed in production on the platform was their Advertising Reporting Tool (ART), which was up and running in a matter of days. “Netezza is one of the best companies I’ve ever worked with – a true cohesive relationship,” says Karen Simmons, Senior Director of Data Warehousing at KBB. “They delivered on what they said they would, got us up and running, and then they stayed after to make sure the team understood how to use it and how we could do special things with the data.”
Once the IBM Netezza data warehouse appliance was deployed, KBB found they could take advantage of BI features that were previously inaccessible due to performance issues. All of a sudden, queries that took days came back in minutes. With SQL Server, the more KBB tried to narrow down their data, the slower it would come back. With the IBM Netezza data warehouse appliance, the opposite is true: the more filters used, the faster the performance. Kelley Blue Book built out the ART system to allow granular access to the data, so the ability to dive into detailed data quickly made the IBM Netezza data warehouse appliance a huge success. The IBM Netezza appliance is going to allow KBB to combine advertising data, revenue data, and site traffic data – they can merge several different data sources and get a multi-channel view of their business.
ART: accuracy and speed provide path to higher ad revenue
As a result of the legacy of television advertising buying schedules, auto makers traditionally plan and buy much of their online advertising according to an “upfront” schedule. For Kelley Blue Book, this means using historical ad and site data – site visits, page views, historical trends and granular ad impression history – as early as March to forecast and allocate advertising inventory for each OEM for the next 12 to 24 months. There are consequences for miscalculating; if KBB delivers more ads than estimated, they receive no additional revenue for the overage. If they deliver fewer impressions than estimated, KBB returns money to the advertiser. In both cases, poor forecasting can hurt credibility and the relationship with the client. The IBM Netezza data warehouse appliance helps Kelley Blue Book mitigate financial risks.
Impressions analysis improves forecasting capabilities
KBB experienced its first big win with Netezza (now the IBM Netezza data warehouse appliance) after migrating impressions data to the appliance, which provided better forecasting capabilities. Before, extracting impression, click and rich media data from Kelley Blue Book’s DoubleClick DART ad server into SQL Server required one to two weeks and much tuning. A high level SAS optimization analysis that would take one or two days in SQL Server now runs on the IBM Netezza data warehouse appliance in one or two minutes. Queries that took SQL Server an hour take just three seconds on the IBM Netezza data warehouse appliance. With the IBM Netezza appliance, KBB can update its forecasts faster, using more data and resulting in higher accuracy.
Because so many of KBB’s ad revenues are sold up front, having the ability to create accurate and reliable impression forecasts is helpful in generating ad revenues and establishing trust with clients. “Now our clients are always telling us that our forecasts are among the best within our competitors,” says Simmons. “We’ve had auto makers and competitors asking for insight into how we’re able to forecast as accurately as we do.”
According to Ingle, “The company’s ability to pinpoint estimated impressions is worth millions to KBB. We have much more flexibility with Netezza. More of our analysts have access to more accurate data than ever. Our models now generate accurate forecasts quickly for OEMs that literally would have taken months before.”
The integration of SAS and the IBM Netezza data warehouse appliance is allowing Kelley Blue Book to automate much of the forecasting process.“Upfront forecasting is not a one-time effort each year,” says Simmons. “As a result of different clients’ timing, it is an almost nine-month long project. Being able to automate the update of the models frees up resources for other projects.” In fact, Simmons noted that with the ability to gather, analyze and distribute data faster from many different sources, there is now a clear path to more efficient site monetization: “Netezza is a critical component in the tech stack that we use to analyze our DART data and generate more ad revenue using existing data,” says Simmons. “It is one of the best investments we have made within our database infrastructure. More accurate analysis of ads enables us to increase the ad ‘fill’ rate, which translates into higher revenues for KBB.”
Simmons cites an example of a negotiation with an OEM: “Let’s say our sales executive is working with an OEM. She asks us how much inventory is available for that OEM and how and where it should be spent to maximize their investment and our returns. Before, we had to pull the data manually and painstakingly compare it with its competitors, one by one. Thanks to Netezza, now we can compare that OEM optimized inventory with all of its competitors and make more informed decisions much faster than ever before.”
Next-generation insight from click data and rich media analysis
After migrating impressions data to Netezza (now IBM Netezza data warehouse appliance), KBB’s next steps were to get click data and rich media data onto the data warehouse appliance. By analyzing click data, KBB can evaluate its ad offerings based on where the ads run and perform in different areas of the site. It can now compare the operational costs of running and managing each ad to the revenue generated by that specific ad to determine whether or not it is worthwhile to sell that particular placement. This is a strategic application for KBB that is helping it to increase overall revenues and improve trust in KBB ad forecasting.
“The ability to analyze our product offerings and look at how they perform across the site is invaluable in improving them,” says Simmons. “We have been collecting this performance data since 2008, but had enough performance problems with SQL Server when it was dealing only with impressions data; adding click or rich media data was not feasible. In fact, many at KBB find it hard to believe we didn’t have access to these insights all along, because they are so crucial to understanding our ad product.”
KBB can also perform iterative analyses that lead to smarter ad pricing. As opposed to using typical rate card pricing – so much for so many impressions of this type in this content – KBB is moving to a more dynamic system in which the data will help the company price impressions based on their value to the OEM. Having access to detailed data over long histories is allowing KBB to analyze the offerings it has, identify their value, and be in a better position to negotiate rate cards. The company is able to use analytics to better negotiate pricing with OEMs, based on better insight into the value of offerings. This sets the stage for individualized, dynamic pricing.
Once KBB finishes migrating rich media data to the IBM Netezza data warehouse appliance, it will have the capability to see how people are interacting with the ads. For example, it will be able to monitor whether people are expanding the ad window, where they’re hovering, how long they’re viewing video ads, and more.
Next up: SEM optimization
Now that Kelley Blue Book has migrated ad and valuations data to the IBM Netezza data warehouse appliance, the next step is to integrate web analytics and search engine management (SEM) data. This will offer KBB the ability to optimize SEM spending and align it correctly with the needs of ad sales for the right delivery of impressions to the right consumers.
With the help of the IBM Netezza data warehouse appliance, KBB will be able to filter data to Search Ignite to optimize keyword performance, a capability that will sharpen its aim, maximize its search investment, and help it deliver content that improves the consumer’s overall experience on the site. This will give consumers greater confidence and comfort with the process of researching and buying a new or used car.
Paying off today, and opening the door to a data-driven future
The initial deployment of Netezza (now IBM Netezza data warehouse appliance) took just two days. In its first year in production, the appliance is delivering performance, results and benefits appreciated by KBB’s consumers, dealers, OEMs, and employees. Simmons comments, “Our CEO and product managers are very happy with the interactive dashboards that they can now access directly through MicroStrategy. Product managers can run many different pre-built dashboards with drill down capabilities without requiring an analytic resource. Our analysts can focus on actually analyzing and providing insights, rather than pulling together information for a report. I don’t think I’m the only one wearing my ‘I heart Netezza’ shirt!” Here are some of the other benefits KBB is realizing from its use of the IBM Netezza data warehouse appliance:
- More ad revenue resulting from
- more accurate and speedier ad analysis
- improved ad inventory forecasting and fill rate––
- Increased customer satisfaction resulting from
- faster valuations (model processing reduced from three days to one
- alignment of ad and consumer data to make decisions leading to delivery of better overall experience on the website
- More profitable operations resulting from
- optimization of ad pricing
- reallocation of valuable staff time (only one part-time DBA needed to manage the environment)
These are still the early days of KBB as an analytics-driven organization. According to Ingle, “Analytics will be a primary source of our competitive advantage – and Netezza is the foundation of our data-driven strategy.”
About Netezza, an IBM Company
Netezza, an IBM Company is a global leader in data warehouse, analytic and monitoring appliances that dramatically simplify high-performance analytics across an extended enterprise. Netezza’s technology enables organizations to process enormous amounts of captured data at exceptional speed, providing a significant competitive and operational advantage in today’s data-intensive industries, including digital media, energy, financial services, government, health and life sciences, retail and telecommunications.
About IBM Data Warehousing and Analytics Solutions
IBM provides the broadest and most comprehensive portfolio of data warehousing, information management and business analytic software, hardware and solutions to help customers maximize the value of their information assets and discover new insights to make better and faster decisions and optimize their business outcomes.
For more information
To learn more about the IBM Data Warehousing and Analytics Solutions, please contact your IBM sales representative or visit ibm.com/software/data/netezza/
Products and services used
IBM products and services that were used in this case study.
IBM Netezza 1000
© Copyright IBM Corporation 2011 IBM Corporation Software Group Route 100 Somers, NY 10589 U.S.A. Produced in the United States of America May 2011 All Rights Reserved IBM, the IBM logo, ibm.com and Netezza are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol (® or ™), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at ibm.com/legal/copytrade.shtml Microsoft and SQL Server are trademarks of Microsoft Corporation in the United States, other countries or both. Other company, product and service names may be trademarks or service marks of others. Please Recycle