5 tips so your sales data is ready for analytics

Quoted on this wiki

Every place a page here uses this source, in the order the words come in it.

1. While technically it is not cleaning, append and enrichment of your data can bring big dividends for data hygiene. “Compare all contact information against the external data and fix format errors, missing extensions, suite numbers etc., while adding new contact info you did not have.” We use cookies to give you relevant experience by remembering your preferences and repeat visits. By clicking “Accept” you consent to use of all cookies. .

   In Contact enrichment

2. Predictive analytics needs a foundation of clean data. Here are our top five tips for data hygiene, so you’re always ready for marketing and sales campaigns via Salesforce. You can use these immediately in any environment: “1. Standardize addresses and change of address” Up to 30% of records lack complete address information, and 10% of businesses move each year. This affects both deliverability and duplicate search. If you have not done so in three years, run a Change of Address (NCOA) process to get any new addresses. When you receive a street address change, but it’s a PO Box in the same city, retain both – one for mailing and one for secondary validation.

   In CRM data standardization

3. 2. Dupes are the silent killer – banish them “De-dupe the files using a variety of match logic.” Take address elements into account, but use transactional information to determine which record to keep or drop.

   In Data hygiene

4. Predictive analytics needs a foundation of clean data. Here are our top five tips for data hygiene, so you’re always ready for marketing and sales campaigns via Salesforce. You can use these immediately in any environment: “1. Standardize addresses and change of address” Up to 30% of records lack complete address information, and 10% of businesses move each year. This affects both deliverability and duplicate search. If you have not done so in three years, run a Change of Address (NCOA) process to get any new addresses. When you receive a street address change, but it’s a PO Box in the same city, retain both – one for mailing and one for secondary validation.

   In Data hygiene

5. 1. Standardize addresses and change of address “This affects both deliverability and duplicate search.” 2. Dupes are the silent killer – banish them

   In Data hygiene