data nirvana

50
Data Nirvana Administrators Cheryl Stevenson: Vision Critical Tom Bueno: PayPal Greg Malpass: Jigsaw Simon Church: salesforce.com

Upload: salesforce

Post on 17-May-2015

1.023 views

Category:

Business


2 download

DESCRIPTION

One of the major issues that every organization faces is the quality of the data coming into the system. But if you think data nirvana doesn't exist, we're ready to prove you wrong! This session will provide several easily implemented solutions to help you start getting the quality data that you want into Salesforce.

TRANSCRIPT

Page 1: Data Nirvana

Data NirvanaAdministrators

Cheryl Stevenson: Vision CriticalTom Bueno: PayPalGreg Malpass: JigsawSimon Church: salesforce.com

Page 2: Data Nirvana

Simon Church

salesforce.com

Page 3: Data Nirvana

Safe HarborSafe harbor statement under the Private Securities Litigation Reform Act of 1995: This presentation may contain forward-looking statements that involve risks, uncertainties, and assumptions. If any such uncertainties materialize or if any of the assumptions proves incorrect, the results of salesforce.com, inc. could differ materially from the results expressed or implied by the forward-looking statements we make. All statements other than statements of historical fact could be deemed forward-looking, including any projections of subscriber growth, earnings, revenues, or other financial items and any statements regarding strategies or plans of management for future operations, statements of belief, any statements concerning new, planned, or upgraded services or technology developments and customer contracts or use of our services.

The risks and uncertainties referred to above include – but are not limited to – risks associated with developing and delivering new functionality for our service, our new business model, our past operating losses, possible fluctuations in our operating results and rate of growth, interruptions or delays in our Web hosting, breach of our security measures, the outcome of intellectual property and other litigation, risks associated with possible mergers and acquisitions, the immature market in which we operate, our relatively limited operating history, our ability to expand, retain, and motivate our employees and manage our growth, new releases of our service and successful customer deployment, our limited history reselling non-salesforce.com products, and utilization and selling to larger enterprise customers. Further information on potential factors that could affect the financial results of salesforce.com, inc. is included in our annual report on Form 10-K for the most recent fiscal year ended January 31, 2010. This documents and others are available on the SEC Filings section of the Investor Information section of our Web site.

Any unreleased services or features referenced in this or other press releases or public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make the purchase decisions based upon features that are currently available. Salesforce.com, inc. assumes no obligation and does not intend to update these forward-looking statements.

Page 4: Data Nirvana

Agenda

Costs of Having Bad Data

Vision Critical

PayPal

Jigsaw

Q & A

Page 5: Data Nirvana

Key Takeaways

Before you leave this session you should know: The impact poor data can have on your organization

The symptoms of poor data quality

How to formulate a strategy to achieve Data Nirvana

How to establish a plan to prevent poor data quality in the future

How to create a culture of maintaining clean data

Tips and tricks to achieve Data Nirvana

Page 6: Data Nirvana

Good Data is the Lifeblood of Sales & Marketing

Critical for Prospecting

Required for Customer Analysis

Marketing Lists

Sales Reps

Business Cards

Web Forms

Page 7: Data Nirvana

And a Real Impact on Sales Organizations

One sales rep calling 12 wrong numbers a

day wastes 20+ hours a month.

1Coe, John M. “B2B Data Decay – The Untold Story.” Sales & Marketing Institute. 2002 http://www.b2bmarketing.com.

Average Dirty Data Found in New Jigsaw Customers:

90%Incomplete

74%Need Updates

21%Dead

7%Duplicate

Page 8: Data Nirvana

Even When You Do, It Goes Bad…Fast

65% of titles incorrect

42% of addresses incorrect

43% of phone numbers incorrect

37% of email addresses incorrect

1Coe, John M. “B2B Data Decay – The Untold Story.” Sales & Marketing Institute. 2002 http://www.b2bmarketing.com.

2009

2010

70% of Contact Data Outdatedafter 12 Months1

Page 9: Data Nirvana

The Costs Add Up

Phone: $3.29Mail: $1.78Email: $0.25

*Direct mail & Phone cost (Source: DMA), Email: $.25 (Source Court Cunnigham, VP of DartMail)

Hourly Compensation Source: Bureau of Labor Statistics

$336,700Marketing Waste

X100,000Records

X 100 Reps@ $28.87/hr

33 MinRep/Day

Sales Waste$412,800

=

=

Page 10: Data Nirvana

Impact of Having Inaccurate Address Data

Sales and marketing:– Waste in materials, labor, time and postage

– Lost sales and marketing opportunities

Mailing/Fulfillment:– Deliveries are late or returned

– Additional handling time

– Additional repackaging and postage costs

Customer Support– Unreceived packages puts pressure on customer support team

– Reputation of company may be damaged

Finance– Payments arrive late or not at all

– Cash flow impacted

Page 11: Data Nirvana

Cheryl Stevenson, VP Demand Marketing

Vision Critical

Page 12: Data Nirvana

About Vision Critical

Technology-based research company

Established in 2000

2009 revenue growth: 50%

World’s most adopted online research platform

Used by 25% of the world’s top brands

Led by CEO and market research veteran, Angus Reid

Page 13: Data Nirvana

History of Data Challenges: Wild West of CRM

Pace of company growth• Infrastructure not able to keep up; not IT supported tool

• Database growing at same rate as company

• Cowboys

Disparate sales teams across company• Not all using same CRM systems

• Number of new users arriving with legacy data (dirty laundry)

Previous failed attempts• No clear data owner & thus, no governance!

• Lack of executive visibility & buy-in

Page 14: Data Nirvana

Example: Sending a Holiday Card to Clients

Page 15: Data Nirvana

Bad Data: Costs to the Company

Marketing & Sales• Communication collisions to prospect database

• Measurement: which tactics or campaigns worked?

• Wasted effort on campaigns sent to Scooby-Doo

• No method / means of going after new markets

Pipeline Visibility & Insight (lack of!)• Client service team resourcing and efficiency

• Cost of errors in opportunities

• Cost of new opportunities not identified

• Cost of cross/up-sell to existing clients missed

Page 16: Data Nirvana

The Solution: Process to Get Started

1. Validation Rules

Page 17: Data Nirvana

The Solution: Process to Get Started

2. Enforce consistency through:– Required fields when necessary

– Picklists

– Help

3. Data imports via one method

Page 18: Data Nirvana

The Solution: Tools to Support Process

Jigsaw– Continuous data appending

– Retire aged data

– Add new data from reliable source

CRM Fusion– Scheduled de-dupe (complex or simple)

– Manual clean

Conga Composer

Page 19: Data Nirvana

The Results

360 degree view of client

Strategic selling higher revenue

Client satisfaction

Smarter marketing

And so much more to come!

Page 20: Data Nirvana

Tom Bueno

Manager

Salesforce Technology

PayPal Inc.

Page 21: Data Nirvana

About PayPal

PayPal is the faster, safer way to pay and get paid

online. The service allows members to send money

without sharing financial information, with the

flexibility to pay using their account balances, bank

accounts, credit cards or promotional financing. With

more than 90 million active accounts in 190 markets

and 24 currencies around the world, PayPal enables

global ecommerce. PayPal is an eBay company and

is made up of three leading online payment services:

the PayPal global payment service, the Payflow

Gateway and Bill Me Later.

Implementation highlights

1,053 active users

Global implementation

727,107 Accounts

807,258 Opportunities

Partner Portal User

Integrated via Cast Iron

Xactly User

Demand Tools/Dupe Blocker

Conga Merge

Work-It

Page 22: Data Nirvana

The Evolution of Data Quality for PayPal

Identify the Challenges

Identify the Model

Implement the model

Cleanse the Data

Protect the Data

Page 23: Data Nirvana

Data Quality Challenges

Cause

Organically grown

implementation

Multiple groups using the same

records for different purposes

No change management

Huge amount of duplicate

records

Lack of Executive Sponsorship

Effect

No master/single source of truth

Lack of confidence in reporting

Dashboards are ineffective

Inability to develop scalable

solutions

User adoption suffers

Page 24: Data Nirvana

Identify the Model

Create a model with clear ownership of records/process

Account(entity)

Contact

PP Acct

n 1 1 n

1

n

n n

1 n

Integration- presales- active- certification- post live

Contact Rolesn n

1 n

Account Config

includes product

1 1

eBayFinancial Details

Sales/Channel Opportunity

n n ?? 1 n

n 1

Vetting - Risk

Management

Opp 1 PPAcct 1PPAcct2

Opp2 PPAcct3PPAcct1

BN Code

1 n

BPI Score

1 n

Mapping from target product to api???

Pricing

1 n

1 n

n 1

Page 25: Data Nirvana

Implement the Model

Secure executive sponsorship

Secure resources and budget

Build the solution in Sandbox

Test

Training

Rollout

Page 26: Data Nirvana

Clean the Data

What is a duplicate?

Which record survives?

What happens to the duplicate?

What tools will you use?

Who will manage data quality?

Page 27: Data Nirvana

Protect the Data

All data loads and updates must be approved

Validation rules– Ensures complete and uniform data

Reports to identify bad data– Configure reports so bad data rises to the top

Maintenance tools– Demand Tools

– Dupe Blocker

Page 28: Data Nirvana

Result

30% increase in active user adoption

42% increase in user base Globally

15% increase in user productivity

Comprehensive reports and dashboards

Scalable platform to build future SFA

Page 29: Data Nirvana

Keys to Success

Executive Sponsorship– The mandate for data quality is driven from the top down

Change Management Process/Policy– All changes must be vetted

– Twice weekly CR review

– Twice monthly Governance, Code Prioritization and Project

reviews

Remain flexible to the needs of the business– What works for some may not work for all

– Identify the best process for your business

Page 30: Data Nirvana

Greg Malpass

Professional Services

Jigsaw Data Corporation

Page 31: Data Nirvana

Too much for 12 minutes

Tools Resources Ideas and Sharing

www.datanirvana.com

www.datanirvana.com

Page 32: Data Nirvana

1. Establish you data quality baseline

-Define your measures of quality

-Develop a means of benchmarking

2. Engage resources to assist in rapid data improvement

-Users

-Customers

-Tools

Achieving Nirvana is a two step process

Page 33: Data Nirvana

Baseline

CompletenessFreshness Consistency

Page 34: Data Nirvana

Benchmark against third party data

Ideal benchmark is accuracy

Page 35: Data Nirvana

No one get’s to Nirvana alone

Users Tools and SystemsCustomers

Page 36: Data Nirvana

Force quality data when possibleUse Validation rules over required fields

Conditional Required Fields Quality Formats Validate Data

Help & Training

Page 37: Data Nirvana

Favorite – Validation Rules/Workflow

Validation – appropriate questions– Set required fields on stage change

– Expose obvious errors

– Validate data before quoting

Workflow – if you can figure it out, don’t ask– If state is blank, fill in based on phone area code

– Auto standardize country spelling / ISO code

– If state format is wrong, fix it

– Auto-set close date when deal is closed

Page 38: Data Nirvana

Make constructive use of dataSave reps time, email merge templates

Page 39: Data Nirvana

Help users get a headstartRoll-Out quote functionality in Salesforce

Phase it outDon’t stop at quoting

Make your docs “brilliant”Consider e-Signature

Page 40: Data Nirvana

Engage customers in the process

On Action survey is sent– Append

– Update

– Insert

Consider using an embedded survey solution

Page 41: Data Nirvana

Leverage native salesforce.com functionalityUse the Request Update button

Page 42: Data Nirvana

Get free tools to assist with changes

Salesforce connector

Quick batch improvements

Works with Professional and above

Quick and easy

Page 43: Data Nirvana

Employ tools, leverage free data – paper/lead sheets

Page 44: Data Nirvana

Employ tools, leverage free data – open page, click, csv

Constantly be on the search for better data. Acquire, Compare, Append, Insert

Page 45: Data Nirvana

Employ tools, leverage free data – highlight, click, lead

Easy data capture for users

Page 46: Data Nirvana

Get a strategy for managing duplicates

Make merge predictableInvolve usersDon’t settle for stock

Page 47: Data Nirvana

Final Steps, some useful tools

Free validation rules and workflow

Data Quality formula and Dashboard

Extended trial of CRM Fusion, 14 days, with Free Merge Routines

Clicktools for Salesforce Surveys

Free trial of Conga

Free trial of Copy to Contact

sForce Connector

More…

Page 48: Data Nirvana

D I S C O V E R

Visit Customer Success Team at Campground

Discover

Training

Learning Paths

Experience

Product

Demos

Learn about Customer

Resources

the products, services and resources

Meet Success Experts

S U C C E S S

Find us at the Customer Success Team area of Salesforce.com Campground at Moscone North

Learn about how to win prizes including 10 iPads & more!

that help you achieve

Page 49: Data Nirvana

Data Nirvana

Page 50: Data Nirvana

How Could Dreamforce Be Better? Tell Us!

Log in to the Dreamforce app to submit

surveys for the sessions you attendedUse the

Dreamforce Mobile app to submit

surveysEvery session survey you submit is

a chance to win an iPod nano!

OR