Internally Generated Data and Reports

As we explained, an organization generates and records a lot of information as part of its daily business operations, including sales and accounting data, and data on inventory levels, back orders, customer returns, and complaints. Firms are also constantly gathering information related to their Web sites, such as clickstream data. Clickstream dataData collected from Web sites showing the Web pages visitors clicked on and the order of their clicks. is data generated about the number of people who visit a Web site and its various pages, how long they dwell there, and what they buy or don’t buy. Companies use clickstream data in all kinds of ways. They use it to monitor the overall traffic of visitors that a site gets, to see which areas of the site people aren’t visiting and explore why, and to automatically offer visitors products and promotions by virtue of their browsing patterns. Software can be used to automatically tally the vast amounts of clickstream data gathered from Web sites and generate reports for managers based on that information. Netflix recently awarded a $1 million prize to a group of scientists to plow through Web data generated by millions of Netflix users so as to improve Netflix’s predictions of what users would like to rent.Stephen Baker, “The Web Knows What You Want,” BusinessWeek, July 24, 2009, http://www.businessweek.com/magazine/content/09_30/b4140048486880.htm (accessed December 14, 2009). (That’s an interesting way to conduct marketing research, don’t you think?)

Being able to access clickstream data and other internally generated information quickly can give a company’s decision makers a competitive edge. Remember our discussion in Chapter 9 "Using Supply Chains to Create Value for Customers" about how Walmart got a leg up on Target after 9/11? Walmart’s inventory information was updated by the minute (the retailer’s huge computing center rivals the Pentagon’s, incidentally); Target’s was only updated daily. When Walmart’s managers noticed American flags began selling rapidly immediately following the terrorist attacks on 9/11, the company quickly ordered as many flags as possible from various vendors—leaving none for Target.

Click on the following link to watch a fascinating documentary about how Walmart, the world’s most powerful retailer, operates: http://www.hulu.com/watch/103756/cnbc-originals-the-new-age -of-walmart.

Many companies make a certain amount of internal data available to their employees, managers, vendors, and trusted partners via intranets. An intranetA private, internal Web site accessible only to a firm’s employees. looks like the Web and operates like it, but only an organization’s employees have access to the information. So, for example, instead of a brand manager asking someone in accounting to run a report on the sales of a particular product, the brand manager could look on her firm’s intranet for the information.

However, big companies with multiple products, business units, and databases purchased and installed in different places and at different times often have such vast amounts of information that they can’t post it all on an intranet. Consequently, getting hold of the right information can be hard. The information could be right under your nose and you might not know it. Meet people like Gary Pool: Pool works for BNSF Railway and is one of BNSF’s “go-to” employees when it comes to gathering marketing data. Pool knows how to access different databases and write computer programs to extract the right information from the right places at BNSF, a process known as data miningThe process of extracting information from large databases so as to uncover patterns and trends.. Combining data into one location is called data warehousingA location for combining and storing data., and makes Pool’s analysis easier. He then captures the information and displays it in dashboardsA display of information used by managers to make decisions easier; often dynamic in the sense that a manager can click on the display to probe deeper into the numbers and get more detail., screens on the computer that make the data easily understood so that managers can detect marketing trends. While a dashboard may display a piece of information, such as the number of carloads sold in West Virginia, the manager can click on the number and get more detail.

Figure 10.2

Gary Pool is an expert at data mining—hunting up information for decision makers at BNSF Railway. And no, he doesn’t wear a headlamp. Nor does he wear a pocket protector! Pool’s title: Manager, Marketing Systems Support & Marketing Decision Support & Planning.

Analytics Software

Increasingly, companies are purchasing analytics software to help them pull and make sense of internally generated information. Analytics softwareSoftware that utilizes a firm’s data, regression models, linear programming, and other statistical methods to help managers who are not computer experts make decisions. allows managers who are not computer experts to gather all kinds of different information from a company’s databases—information not produced in reports regularly generated by the company. The software incorporates regression models, linear programming, and other statistical methods to help managers answer “what if” types of questions. For example, “If we spend 10 percent more of our advertising on TV ads instead of magazine ads, what effect will it have on sales?” Oracle Corporation’s Crystal Ball is one brand of analytical software.

The camping, hunting, fishing, and hiking retailer Cabela’s has managed to refine its marketing efforts considerably using analytics software developed by the software maker SAS. “Our statisticians in the past spent 75 percent of their time just trying to manage data. Now they have more time for analyzing the data with SAS, and we have become more flexible in the marketplace,” says Corey Bergstrom, director of marketing research and analysis for Cabela’s. “That is just priceless.”Christina Zarello, “Hunting for Gold in the Great Outdoors,” Retail Information Systems News, May 5, 2009, http://www.risnews.com/ME2/dirmod.asp?sid=&nm=&type=MultiPublishing&mod=PublishingTitles&mid =2E3DABA5396D4649BABC55BEADF2F8FD&tier=4&id =7BC8781137EC46D1A759B336BF50D2B6 (accessed December 14, 2009).

Figure 10.3

Cabela’s’ analytics software has helped the outdoor sporting retailer reach the right customers with the right catalogs.

© Cabela’s Inc., used with permission.

The company uses the software to help analyze sales transactions, market research, and demographic data associated with its large database of customers. It combines the information with Web browsing data to gain a better understanding of the individual customers marketing channel preferences as well as other marketing decisions. For example, does the customer prefer Cabela’s’ one-hundred-page catalogs or the seventeen-hundred-page catalogs? The software has helped Cabela’s employees understand these relationships and make high-impact data-driven marketing decisions.Christina Zarello, “Hunting for Gold in the Great Outdoors,” Retail Information Systems News, May 5, 2009, http://www.risnews.com/ME2/dirmod.asp?sid=&nm=&type=MultiPublishing&mod=PublishingTitles&mid =2E3DABA5396D4649BABC55BEADF2F8FD&tier=4&id =7BC8781137EC46D1A759B336BF50D2B6 (accessed December 14, 2009).

Market Intelligence

A good internal reporting system can tell a manager what happened inside his firm. But what about what’s going on outside the firm? What is the business environment like? Are credit-lending terms loose or tight, and how will they affect what you and your customers are able to buy or not buy? How will rising fuel prices and alternate energy sources affect your firm and your products? Do changes such as these present business obstacles or opportunities? Moreover, what are your competitors up to?

Not gathering market intelligence leaves a company vulnerable. Remember Encyclopedia Britannica, the market leader in print encyclopedia business for literally centuries? Encyclopedia Britannica didn’t see the digital age coming and nearly went out of business as a result. (Suffice it to say, you can now access Encyclopedia Britannica online.) By contrast, when fuel prices hit an all-time high in 2008, unlike other passenger airline companies, Southwest Airlines was prepared. Southwest had anticipated the problem, and early on locked in contracts to buy fuel for its planes at much lower prices. Other airlines weren’t as prepared and lost money because their fuel expenses skyrocketed. Meanwhile, Southwest Airlines managed to eke out a profit. Collecting market intelligence can also help a company generate ideas or product concepts that can then be tested by conducting market research.

Gathering market intelligence involves a number of activities, including scanning newspapers, trade magazines, and economic data produced by the government to find out about trends and what the competition is doing. In big companies, personnel in a firm’s marketing department are primarily responsible for their firm’s market intelligence and making sure it gets conveyed to decision makers. Some companies subscribe to news service companies that regularly provide them with this information. LexisNexis is one such company. It provides companies with news about business and legal developments that could affect their operations. Other companies subscribe to mystery shopping services, companies that shop a client and/or competitors and report on service practices and service performance. Let’s now examine some of the sources of information you can look at to gather market intelligence.

Search Engines and Corporate Web Sites

An obvious way to gain market intelligence is by examining your competitors’ Web sites as well as doing basic searches with search engines like Google. If you want to find out what the press is writing about your company, your competitors, or any other topic you’re interested in, you can sign up to receive free alerts via e-mail by going to Google Alerts at http://www.google.com/alerts. Suppose you want to monitor what people are saying about you or your company on blogs, the comment areas of Web sites, and social networks such as Facebook and Twitter. You can do so by going to a site like WhosTalkin.com, typing a topic or company name into the search bar, and voilà! All the good (and bad) things people have remarked about the company or topic turn up. What a great way to seek out the shortcomings of your competitors. It’s also a good way to spot talent. For example, designers are using search engines like WhosTalkin.com to search the blogs of children and teens who are “fashion forward” and then involve them in designing new products.

WhosTalkin.com and Radian6 (a similar company) also provide companies with sentiment analysis. Sentiment analysisExamining content in social media to determine what a market is thinking or how customers feel, in general, about an offering or an idea. Also used by the government to track the progress of epidemics. is a method of examining content in blogs, tweets, and other online media (other than news media) such as Facebook posts to determine what people are thinking at any given time. Some companies use sentiment analysis to determine how the market is reacting to a new product. The Centers for Disease Control (CDC) uses sentiment analysis to track the progress of flu; as people post or tweet how sick they are, the CDC can determine where the flu is increasing or decreasing.

Figure 10.4

Type a company’s name (or anything else you want) into the search bar and see what comes up. (Note: It takes a little while for all of the results to show up.)

Source: http://www.whostalkin.com.

Can Market Intelligence Be Taken Too Far?

Can market intelligence be taken too far? The answer is yes. In 2001, Procter & Gamble admitted it had engaged in “dumpster diving” by sifting through a competitors’ garbage to find out about its hair care products. Although the practice isn’t necessarily illegal, it cast P&G in a negative light. Likewise, British Airways received a lot of negative press in the 1990s after it came to light that the company had hacked into Virgin Atlantic Airways’ computer system.“P&G Admits to Dumpster Diving,” PRWatch.org, August 31, 2001, http://www.prwatch.org/node/663 (accessed December 14, 2009).

Gathering corporate information illegally or unethically is referred to as industrial espionageThe process of gathering corporate information illegally or unethically.. Industrial espionage is not uncommon. Sometimes companies hire professional spies to gather information about their competitors and their trade secrets or even bug their phones. Former and current employees can also reveal a company’s trade secret either deliberately or unwittingly. Microsoft recently sued a former employee it believed had divulged trade secrets to its competitors.“Microsoft Suit Alleges Ex-Worker Stole Trade Secrets,” CNET, January 30, 2009, http://news.cnet.com/8301-10805_3-10153616-75.html (accessed December 14, 2009). It’s been reported that for years professional spies bugged Air France’s first-class seats to listen in on executives’ conversations.Jack Anderson, “Bugging Air France First Class,” Ellensburg Daily News, March 25, 1995, 3, http://news.google.com/newspapers?nid=860&dat =19950320&id=ddYPAAAAIBAJ&sjid=F48DAAAAIBAJ&pg=4554,2982160 (accessed December 12, 2009).

Figure 10.5

Don’t get caught doing this—unless you work for the natural-cosmetics maker Burt’s Bees. To get across to employees the amount of material being wasted, Burt’s Bees had its employees put on hazmat suits and sort through garbage for a couple of weeks. (No, employees weren’t engaging in industrial espionage.) The recycling opportunities they spotted as part of the exercise ended up saving the natural-cosmetics maker $25,000 annually.Judith Nemes, “Dumpster Diving: From Garbage to Gold,” Greenbiz.com, January 16, 2009, http://www.businessgreen.com/bg/analysis/1805796/dumpster-diving-from-garbage-gold (accessed December 14, 2009).

© 2010 Jupiterimages Corporation

To develop standards of conduct and create respect for marketing professionals who gather market intelligence, the Society of Competitive Intelligence Professionals has developed a code of ethics. It is as follows:

• To continually strive to increase the recognition and respect of the profession.
• To comply with all applicable laws, domestic and international.
• To accurately disclose all relevant information, including one’s identity and organization, prior to all interviews.
• To avoid conflicts of interest in fulfilling one’s duties.
• To provide honest and realistic recommendations and conclusions in the execution of one’s duties.
• To promote this code of ethics within one’s company, with third-party contractors and within the entire profession.
• To faithfully adhere to and abide by one’s company policies, objectives and guidelines.“SCIP Code of Ethics for CI Professionals,” Society of Competitive Intelligence Professionals, http://www.scip.org/About/content.cfm?ItemNumber=578&navItemNumber=504 (accessed December 14, 2009).

Marketing Research

Marketing research is what a company has to resort to if it can’t answer a question by using any of the types of information we have discussed so far—market intelligence, internal company data, or analytics software applied to data. As we have explained, marketing research is generally used to answer specific questions. The name you should give your new product is an example. Unless your company has previously done some specific research on product names—what consumers think of them, good or bad—you’re probably not going to find the answer to that question in your internal company data. Also, unlike internal data, which is generated on a regular basis, marketing research is not ongoing. Marketing research is done on an as-needed or project basis. If an organization decides that it needs to conduct marketing research, it can either conduct marketing research itself or hire a marketing research firm to do it.

So when exactly is marketing research needed? Keep in mind marketing research can be expensive. You therefore have to weigh the costs of the research against the benefits. What questions will the research answer, and will knowing the answer result in the firm earning or saving more money than the research costs?

Marketing research can also take time. If a quick decision is needed for a pressing problem, it might not be possible to do the research. Lastly, sometimes the answer is obvious, so there is no point in conducting the research. If one of your competitors comes up with a new offering and consumers are clamoring to get it, you certainly don’t need to undertake a research study to see if such a product would survive in the marketplace.

Alex J. Caffarini, the president and founder of the marketing research firm Analysights, believes there are a number of other reasons companies mistakenly do marketing research. Caffarini’s explanations (shown in parentheses) about why a company’s executives sometimes make bad decisions are somewhat humorous. Read through them:

• “We’ve always done this research.” (The research has taken on a life of its own; this particular project has continued for years and nobody questioned whether it was still relevant.)
• “Everyone’s doing this research.” (Their competitors are doing it, and they’re afraid they’ll lose competitive advantage if they don’t; yet no one asks what value the research is creating.)
• “The findings are nice to know.” (Great—spend a lot of money to create a wealth of useless information. If the information is nice to know, but you can’t do anything with it, you’re wasting money.)
• “If our strategy fails, having done the research will show that we made our best educated guess.” (They’re covering their butts. If things go wrong, they can blame the findings, or the researcher.)
• “We need to study the problem thoroughly before we decide on a course of action.” (They’re afraid of making a tough decision. Conducting marketing research is a good way to delay the inevitable. In the meantime, the problem gets bigger, or the window of opportunity closes.)
• “The research will show that our latest ad campaign was effective.” (They’re using marketing research to justify past decisions. Rarely should marketing research be done after the fact.)Alex J. Caffarini, “Ten Costly Marketing Mistakes and How to Avoid Them,” Analysights, LLC.

Is Marketing Research Always Correct?

To be sure, marketing research can help companies avoid making mistakes. Take Tim Hortons, a popular coffee chain in Canada, which has been expanding in the United States and internationally. Hortons recently opened some self-serve kiosks in Ireland, but the service was a flop. Why? Because cars in Ireland don’t have cup holders. Would marketing research have helped? Probably. So would a little bit of market intelligence. It would have been easy for an observer to see that trying to drive a car and hold a cup of hot coffee at the same time is difficult.

That said, we don’t want to leave you with the idea that marketing research is infallible. As we indicated at the beginning of the chapter, the process isn’t foolproof. In fact, marketing research studies have rejected a lot of good ideas. The idea for telephone answering machines was initially rejected following marketing research. So was the hit sitcom Seinfeld, a show that in 2002 TV Guide named the number-one television program of all time. Even the best companies, like Coca-Cola, have made mistakes in marketing research that have led to huge flops. In the next section of this chapter, we’ll discuss the steps related to conducting marketing research. As you will learn, many things can go wrong along the way that can affect the results of research and the conclusions drawn from it.