High churn rates -monster cause that you can fix today

You know the numbers. The cost of acquiring a customer can be 5 times that of retaining an existing one, and you can more than double profits if you reduce churn by just 5%.

 

Many companies today rely on data insight to understand customer behavior and become able to differentiate both through customer service and product quality.

 

Any form of erroneous or missing data - including inaccurate, incomplete, or duplicated information - may bear an impact on the efficiency of customer engagement programs, which ultimately depresses customer retention.

Integrate Oracle CRM On Demand with Dun & Bradstreet: Part 2

Introduction

In part one of this three part blog series, the concept of integrating COD (Oracle CRM On Demand) with D&B was introduced along with the technologies to be used, including Javascript/HTML/CSS, JQuery, REST APIs and JSON.

 

This second of three articles describes connecting to the COD REST API, connecting to the D&B REST API, transforming the resulting JSON data, and standardizing the data so COD will accept the records.

 

For this example the Account record being created in COD will contain three fields; the AccountName, the Location, and the PublicCompany field. These can be expanded upon to contain any number of fields.

Buying Lists? 6 Rules to Help Protect Your Business

With so much emphasis placed on the different opt-in techniques companies use to build lists, it seems counter to the trend to be talking about purchased or rented lists.

 

But as anyone who works in marketing can tell you, the list business is alive and well, because it needs to be.

 

For any company that’s not generating a mountain of traffic through their website and newsletter opt-ins, for any company looking to grow beyond its current customer and prospect base, and for any business branching into new markets without partners or a large enough advertising budget - purchased lists might be an unavoidable necessity.

 

Here are six rules to follow in order to use this source responsibly, protect your business, and avoid wasting money and destroying your sender reputation.

Integrate Oracle CRM On Demand with Dun & Bradstreet: Part 1

So you have Oracle COD (CRM On Demand) and you’d like to create an integration to allow your end users to import D&B data into your CRM system. How can you do this?

There are many variables to be considered with this integration. How do we get data out of D&B? How do we get data into COD? What transformation is needed between the D&B data and how it gets into COD? How do we enable the end user to start and finish the process? What technologies should we use?

crm on demand-logo.png

The Three Articles

In this series of three articles we’ll answer the above questions and more. You’ll have a good understanding of what’s involved in building such an integration and, with some development effort, it could get built.

This article, part 1, presents the overall problems involved in building this integration and describes what the finished solution will look like. Technologies to be used are introduced.

Part 2 of the series presents the Oracle and D&B REST APIs needed, as well as an overview of transforming the JSON data from D&B to COD. Issues around Country and State (Province) data is discussed to ensure that data can be inserted into COD without generating errors.

The final article, Part 3, presents the UI. This includes an introduction to the COD Javascript API, how to launch the integration process, how to view potential D&B records before being entered into COD, and then writing the results into COD.

 

Technologies

Four main technologies will be used for this project.

1. Javascript, HTML and CSS are the core building blocks of the modern web. Javascript is the programming language used in all browsers. HTML is the page layout language that describes where to place text, images, and other objects in the browser window. CSS specifies things like size, font, color, etc for all the objects in the browser window. For an overview of these three technologies, see this article.

2. JQuery is an amazing Javascript library that is used by an immense number of websites. See this article for an introduction to JQuery as well as detailed articles on many aspects of JQuery.

jquery.png

3. REST is a way of providing interoperability (APIs) on the internet. It was first coined back in 2000 and since then has drastically simplified how to connect to a remote internet based system via an API. Before REST the most common framework in use was called SOAP. SOAP is still used today, and COD has a SOAP API. However, REST is much easier to comprehend and is arguably just as powerful as SOAP. In these blog articles we will only work with REST APIs.

rest.png

4. JSON is a syntax for storing and exchanging data and will be the sole syntax for transferring data between D&B and COD. The results from a D&B API call is JSON and the data to be pushed to the COD API is JSON. Hence, JSON is an important technology, not only for this project, but for many modern web services available today. An introduction to JSON is available here.

Now that we’ve introduced the technologies to be used in integrating D&B and COD, in our next blog article the back-end work will be discussed including accessing D&B and COD via their APIs.

Integrate Oracle CRM On Demand with D&B: Part 2

COD REST API

D&B REST API

Transforming the JSON structure

Ensure country and states are standardized

 

Integrate Oracle CRM On Demand with D&B: Part 3

COD Javascript APIs

Starting the process

Viewing results

Writing the results to COD

Recap

 

Say Goodbye to Cleaning, Complaints and Extra CRM Data Costs

Low sales efficiency, poor marketing response rates, and declining revenues are the most visible effects of bad data in your CRM.

But poor data quality impacts business in more insidious ways. Lack of confidence in the accuracy of customer data causes user adoption rates to drop - along with your return on CRM investment.

More than 20% of problems related to successful CRM implementation are linked to user adoption, and  55% of users consider ease of use as the most significant CRM capabilities.

Frustration about data quality combined with limitations of the CRM functionality can rapidly lead to user rejection of the system.

IT_CRM_usage.jpeg

What poor data quality means for IT teams

 

1. Costly data cleansing

Cleaning up data requires expensive resources - up to 50% of a company’s IT budget goes into information scrap and rework caused by poor data quality.

CRM users in Sales and Marketing are a constant source of duplicates. Inaccurate search results, lead conversion, lists import, all feed duplicate records into your CRM.

 

2. Frequent user complaints

Bad data makes it difficult for users to find value in the CRM. Duplicated records, missing fields of information, inaccurate contact data are common causes of complaints from Sales and Marketing teams.

Poor data quality weakens users’ confidence in the CRM and eventually leads to low usage of the system.

 

3. Higher storage costs

Wasted marketing budgets and lost sales opportunities are just two facets of the what bad data is costing you. The cost of storing data can dramatically increase if your CRM is filled with duplicate records.

 

3 steps that help you improve your CRM Adoption

 

1. Keep a clean CRM

A CRM deduplication solution should be quick and efficient in identifying and removing duplicates. To meet specific user needs and business requirements, select a tool that also provides flexibility working with any object type, allows you to set your own duplicate detection rules, and can perform automated tasks on your own schedule.

 

2. Enhance CRM ease of use

Enhancing native CRM functionality in terms of record search reduces user frustration about finding the right customer data.

Duplicate detection upon data entry and file import is particularly valuable for Marketing users who can instantly view existing CRM data and avoid creating duplicates.

 

3. Monitor your data quality

Prevent CRM data from deteriorating by consistently monitoring duplicated, inaccurate, and incomplete data. Knowing where duplicates are hiding allows you to dedupe smaller batches of data so you can avoid a greater impact on business later on.
 

Are you making the most of your CRM investment? Evaluate the current state of your data with our free assessment, the Data Quality Report.

Need guidance with specific actions you can take to improve your data quality? We’re here to help!