Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

NCOA & other data hygiene

Posted on by 30

We're a direct mail firm with a client that I believe is using Microsoft CRM Online.  Their database is currently around 75,000 records from various sources over many years.  They've asked us to clean up their data for direct mail purposes.

Is there an easy way to export and import address tables so that we can run address change and other mail data services?  What is the easiest way import appended data fields (e.g. demographics, URL's, etc.)?  Lastly, while we can easily identify duplicate records from address tables, is there a straightforward way to then merge the histories of the dupes into one record?

We wouldn't be doing the hands-on with CRM.  I'd be passing on the process requests to the client.  I just need to know what is possible so that we can develop the best data hygiene strategy.

  • Suggested answer
    CU30042133-0 Profile Picture
    CU30042133-0 2 on at
    NCOA & other data hygiene

    Cut Through the Marketing Mayhem. Ignite Growth with Precision Targeting.

    Stuck in a sea of generic ads? We feel you. At M1 Data & Analytics, we're laser-focused on providing the rocket fuel you need to launch hyper-targeted marketing campaigns.

    How We Take Your Marketing to Hyperdrive:


    • Target Like a Jedi Master: We source and clean top-notch data from diverse galaxies, ensuring you reach your perfect audience, every single time.

    • Privacy Protectors: Relax, knowing we prioritize compliance with data privacy regulations. Your brand reputation is in our lightsaber-wielding hands.

    • Marketing on Autopilot:

      • Pinpoint Targeting: Beam in on your ideal customers with unmatched accuracy.

      • Hyper-Focused Segments: Craft customer segments so precise, they practically shout "Convert Me!"

      • Data-Driven Campaigns: Develop campaigns that resonate deeply and drive explosive results.


      •  


    •  

    Ready to unleash the power of data-driven marketing?

    Contact M1 Data & Analytics today and watch your campaigns go supernova!

  • Suggested answer
    Bruno Lucas Profile Picture
    Bruno Lucas 5,421 on at
    RE: NCOA & other data hygiene

    you can use different approach's for each task

    you can start with exporting to excel for updating:

    This will export to excel and than you can use Excell features like V-lookup to clean the data

    to eliminate duplicates, you can write code

    https://msdn.microsoft.com/en-us/library/jj863613.aspx

    or you can use this feature

    http://www.microsoft.com/en-us/dynamics/crm-customer-center/run-bulk-system-jobs-to-detect-duplicate-records.aspx

    however that is for removing duplicates.

    Merge feature in Dynamics CRM is available for Leads, Account, Contact and (if CRM 2013+ or online) Calls Entities

    http://crmbook.powerobjects.com/basics/data-management-in-microsoft-dynamics-crm/keeping-data-clean-in-microsoft-dynamics-crm/

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans