StatsAd Industry MetricsMarketing Execs Excel — To A Fault

Marketing Execs Excel -- To A Fault

Product marketing and management executives rely on Microsoft Excel spreadsheets -- and gut instinct -- to make business-changing decisions.

Businesses may invest in CRM systems and other reporting tools to track company data, yet many product marketing and product management executives rely on Microsoft Excel spreadsheets and gut instinct to make business-changing decisions. That’s according to “Market Vigilance, Product Diligence,” a study released by the Business Performance Management Forum (BPM) and sponsored by the CMO Council and Vistaar Technologies

A previous study released by the CMO Council identified the need for marketers to have better tracking and reporting tools. This study finds product marketing and product management executives don’t have access to CRM and enterprise resource planning (ERP) software and other tools, even when the organization has such data systems available.

Microsoft Excel spreadsheets often compensate for lack of technology. Over 78 percent of executives use Microsoft Office software to communicate key marketing outputs within their organization. Excel is used to formulate product profitability analysis (80 percent); competitive intelligence and market analytics (73 percent); long-range product forecasting (79 percent); product portfolio evaluation (79 percent); short-term product forecasting (78 percent); product category forecasting (77 percent); competitive intelligence and market analytics (73 percent); customer analysis (73 percent); supply chain visibility (56 percent) and demand chain visibility (54 percent).

Data in the spreadsheets may come from tracking and forecast tools operating within an organization, but it can often come from other silos. These data often use differing methodology and may not even match with data assets pulled from other departments.

Sixty-eight percent of respondents are unsatisfied with the results of a static spreadsheet. “Even if the data they are extracting is 100 percent accurate and use the same methodology [across the silos of an organization], they are till relying on flat, static data for pricing and forecasting, they could actually do ‘what if’ scenarios, and could extract these changes,” said Scott Buckley, director of product marketing at Vistaar Technologies.

“With the forward impact of the decisions they’re making today, Excel doesn’t provide the capability,” said Buckley. “You need a multi-dimensional approach to analysis.”

Where there are gaps in data, executives say they often rely on intuition and gut instinct when making decisions. “It’s about measurement and accountability,” said Buckley. “[Executives] might not understand that a simple change in one SKU can really ripple across products within the category, which can affect other stakeholders in the process.”

Respondents say better reporting tools would influence performance and their organization’s bottom line. “Sixty percent of participants felt they could boost revenue by more than 6 percent,” said Buckley. A further 30 percent said they believed they could raise margins by 10 percent.

To complete the study, a task force of 13 senior marketers from highly regarded companies such as Autodesk, Kodak, Xerox, Lucent Technologies, Avaya, Honeywell and Kyocera-Mita. Qualitative interviews were conducted with each individual to determine pain points, outstanding issues and best practices. The initial findings wer used to create a quantitative component where a survey was fielded through SurveyMonkey. Product management and product marketing executives from over 150 companies participated in the survey. Respondents are representative of the consumer electronics, high-tech, healthcare, software, telecom, office equipment and games industries.

Related Articles

The evolution of display: How is advertisers' use of display advertising changing?

Ad Industry Metrics The evolution of display: How is advertisers' use of display advertising changing?

8m Rebecca Sentance
What can advertising spend tell us about the future of social networks?

Ad Industry Metrics What can advertising spend tell us about the future of social networks?

8m Rebecca Sentance
Breaking down the Facebook auction: How to manage rising CPMs and deliver sales

Actionable Analysis Breaking down the Facebook auction: How to manage rising CPMs and deliver sales

9m Clark Boyd
The Year Ahead: Top Resolutions for Digital Advertisers

Ad Industry Metrics The Year Ahead: Top Resolutions for Digital Advertisers

11m Chad Bronstein
Do ad blockers hold the clue to the future of advertising?

Ad Industry Metrics Do ad blockers hold the clue to the future of advertising?

1y Tim Flagg
Our four favourite findings from the ClickZ Digital Advertising Breakfast

Actionable Analysis Our four favourite findings from the ClickZ Digital Advertising Breakfast

9m Leonie Mercedes
YouTube is getting rid of 30-second unskippable pre-roll ads

Ad Industry Metrics YouTube is getting rid of 30-second unskippable pre-roll ads

9m Al Roberts
Ad blocker use continues to grow rapidly

Ad Industry Metrics Ad blocker use continues to grow rapidly

10m Al Roberts