investment optimization for execs at dell using big data

26
Strategic Case Study: Investment Optimization for Executives using Big Data Big Data Texas March 2013 Natalie Kortum Natalie Kortum marketingmathgirl.com

Upload: natalie-kortum

Post on 22-Apr-2015

631 views

Category:

Business


0 download

DESCRIPTION

Dell is using innovative big data techniques to inform their investment optimization decisions in multiple areas. Natalie will walk the audience through the problem, the evolution of the techniques in use, and the results that have come out of this model. She'll also discuss one of the big challenges in the process -- how to help non-technical executives understand and buy into decision-making based on big data. This presentation from Data Day Texas 2013.

TRANSCRIPT

Page 1: Investment Optimization for Execs at Dell using Big Data

Strategic Case Study: Investment Optimization for Executives using Big Data

Big Data Texas March 2013

Natalie Kortum

Natalie Kortum marketingmathgirl.com

Page 2: Investment Optimization for Execs at Dell using Big Data

Global Marketing

Was the campaign successful?

0

25

50

75

100

125

Prior Year Current Year

Marketing Spend

Other Marketing Campaign

($M)

0.00.20.40.60.81.01.21.4

Prior Year Current Year

Revenue ($B)

“We spent $10M and total revenue increased $400M… what a smashing success!”

*Numbers for illustrative purposes; not actual Dell figures

Natalie Kortum

Page 3: Investment Optimization for Execs at Dell using Big Data

Global Marketing

Was the campaign successful?

0

25

50

75

100

125

Prior Year Current Year

Marketing Spend

TV PrintOnline Campaign

($M)

0.00.20.40.60.81.01.21.4

Prior Year Current Year

Revenue ($B)

“Marketing mix shifted, but increasing marketing spend was a good investment overall!”

*Numbers for illustrative purposes; not actual Dell figures

Natalie Kortum

Page 4: Investment Optimization for Execs at Dell using Big Data

Global Marketing

What drove revenue?

0%

20%

40%

60%

80%

100%

120%

Prior Year Current Year

Marketing Spend

Sales People Marketing SpendProduct Quality Support Staff

“Sales investment was the main reason for the revenue increase. Let’s cut more from Product and Support for next year.”

*Numbers for illustrative purposes; not actual Dell figures

Natalie Kortum

0.00.20.40.60.81.01.21.4

Prior Year Current Year

Revenue ($B)

Page 5: Investment Optimization for Execs at Dell using Big Data

Global Marketing

*Numbers for illustrative purposes; not actual Dell figures

Natalie Kortum

Page 6: Investment Optimization for Execs at Dell using Big Data

Global Marketing

*Numbers for illustrative purposes; not actual Dell figures

Natalie Kortum

Page 7: Investment Optimization for Execs at Dell using Big Data

Global Marketing Natalie Kortum

What impact is marketing having on Revenue in comparison to other factors?

Page 8: Investment Optimization for Execs at Dell using Big Data

Global Marketing

Big Data Collection

Over 1100 variables used by

other groups to run the business

Over 100 distinct data owners

(people)

Over 10 different data systems

Over 25 different vendors

Natalie Kortum

Page 9: Investment Optimization for Execs at Dell using Big Data

Global Marketing 9 Confidential 3/30/2013

Questions?

Natalie Kortum

Page 10: Investment Optimization for Execs at Dell using Big Data

Global Marketing Natalie Kortum

Product Innovation

Ship Commit Accuracy

Marketing Spend

Sales Investments

Support Satisfaction

Pricing

Product Quality

Page 11: Investment Optimization for Execs at Dell using Big Data

Global Marketing Natalie Kortum

Page 12: Investment Optimization for Execs at Dell using Big Data

Global Marketing 12 Confidential 3/30/2013

Questions?

Natalie Kortum

Page 13: Investment Optimization for Execs at Dell using Big Data

Global Marketing

Starting Revenue

*Numbers for illustrative purposes; not actual Dell figures

Ending Revenue

Explaining the Changes in Revenue

Natalie Kortum

Page 14: Investment Optimization for Execs at Dell using Big Data

Global Marketing

Starting Revenue

*Numbers for illustrative purposes; not actual Dell figures

Ending Revenue

Explaining the Changes in Revenue

Natalie Kortum

Page 15: Investment Optimization for Execs at Dell using Big Data

Global Marketing 15 Confidential 3/30/2013

Questions?

Natalie Kortum

Page 16: Investment Optimization for Execs at Dell using Big Data

How investment levers compare

Sales Marketing

Demand Gen Pricing

Marketing

Brand

Marginal Return on Investment

0.9 X 1.3 X 0.4 X 2.2 X

Social Media

4.1 X

If $1 M additional were available to invest, what’s the marginal ROI?

*Numbers for illustrative purposes; not actual Dell figures

Product

2.5 X

Natalie Kortum

Page 17: Investment Optimization for Execs at Dell using Big Data

Global Marketing

Short-term and Long-term ROIs and Cross BUs of B2B

Sales Marketing Transactional

Pricing Brand

Campaign

B2B Revenue in period 0.7 X 1.2 X 5.7 X 0.2 X

Additional long term benefits on B2B (12-18 months)

+ 0.1 X + 0.06 X - 5.4 X + 1.9 X

Cross BU Impact + 0.1 X + 0.04 X + 0.1 X + 0.1 X

Total Return of $1M investment in lever = 0.9 X = 1.3 X =0.4 X =2.2 X

+ 0.3 X

+ 2.2 X

0 X

=2.5 X

Product

*Numbers for illustrative purposes; not actual Dell figures Natalie Kortum

Page 18: Investment Optimization for Execs at Dell using Big Data

Global Marketing

Inception

Sales Investments

Re

ve

nu

e

Plateau

Current Level

Range of Sales Spends over the last 3 years

Sales Investments

Re

ve

nu

e

A saturated curve shows that we are in the plateau stage of the S curve

Natalie Kortum

*Numbers for illustrative purposes; not actual Dell figures

Page 19: Investment Optimization for Execs at Dell using Big Data

Global Marketing

What’s in the future?

Natalie Kortum

Page 20: Investment Optimization for Execs at Dell using Big Data

Global Marketing 20 Confidential 3/30/2013

Questions?

Natalie Kortum

Page 21: Investment Optimization for Execs at Dell using Big Data

Global Marketing

Tips for explaining to non-Technical folks

• Walk a mile in their shoes. • Run your presentation past a nontechnical supporter.

– Pretend your audience is your 10 year old nephew or mother.

• Only two minutes (and no more!) to explain your methodology.

• Create proof points for your techniques – Execs who have used this approach. – Companies/markets using this approach. – Respected PhD or Tech person they trust to back the approach.

• Watch the assumptions. – Choose only two or three if you must that might be highly suspect.

• Use Analogies! Natalie Kortum

Page 22: Investment Optimization for Execs at Dell using Big Data

Global Marketing 22

Direct Attribution has a big downfall

• Direct = All or Nothing

Traditionally Understated Traditionally Overstated

Social Media Coupons

Brand Campaigns Online Promotion/Referral

Events Sales

Corporate Social Responsibility Transactional Actions

22 Natalie Kortum

Page 23: Investment Optimization for Execs at Dell using Big Data

Global Marketing Natalie Kortum

Page 24: Investment Optimization for Execs at Dell using Big Data

Global Marketing

Human Brain Network

24 Natalie Kortum

Page 25: Investment Optimization for Execs at Dell using Big Data

Global Marketing Natalie Kortum

Page 26: Investment Optimization for Execs at Dell using Big Data

Thank You

Natalie Kortum marketingmathgirl.com