In this webinar, our experts showcase a variety of demo use cases of how different components of the...
Are you planning to migrate from an old-fashioned marketing platform to CRM? Are you facing the difficulty of updating communication preferences for existing contacts in CRM? Do you need to update thousands of records? This blog will cover several ways to update your communication preferences in CRM.
Preconditions:
Making the updates in Excel and reimporting
The first option you have is to export your CRM contacts, use vLookup formulas in Excel to combine the communications preferences from your marketing system, and then reimport your CRM contacts. This scenario is suitable if you are comfortable working with Microsoft Excel formulas. This approach does not require any coding or development knowledge.
Since you have a spreadsheet of subscribers and opt-outs with the most current communication preferences from your Marketing platform, you then need to export your existing contacts from CRM. To achieve this, please complete the following steps:
Note: It is helpful if your view contains the columns for the communication preferences you need to update. In general, you would include "Do not Allow Emails", "Do not Allow Bulk Emails", ''Do not Allow Phone Calls", "Do not Allow Faxes" and "Do not Allow Mails". Do not forget to include additional communication preferences which are custom for your organization. The screenshot of general communication preferences is provided below.
Once you have the CRM data exported, you will use Vlookup formulas to update the communication preferences. In order to do this, you would also need to define matching criteria between two spreadsheets. In the example below we are using three email addresses as a matching criteria for opt-outs with an email address and Full name for opt-outs without email addresses.
Note: You may need to "Unprotect" the spreadsheet to insert new columns before applying the formula.
Add the necessary vLookups to the spreadsheet with the columns needed. A good way to structure the spreadsheet is to add the following columns:
After opt-outs are defined, you can remove rows that do not require Communication Preferences Updates via filtering. Select Subscribers only and then remove filtered rows keeping opt-outs in the file. Please note that you should remove complete rows, not just values in these rows.
After this is complete, simply update Communication preferences in the spreadsheet for all opt-outs, remove extra columns (Match Email1, Match Email2, Match Email3 and Concatenate column)
Updates via Custom Entity
Another way to update communication preferences is to create a custom Update entity with Communication preferences fields and develop a custom workflow to apply its values for Communication preferences updates.
This method is very helpful for anyone preferring working with CRM Customizations and workflows instead of using Microsoft Excel formulas. It was described in details here: https://powerobjects.com/blog/2013/08/01/updating-records-in-microsoft-dynamics-crm/
The summary steps are provided below:
The only limitation is that you need to properly link an update record with a contact record via Data Import Mapping rules. If Contact entity contains duplicates, you may need to reimport records failing on data import and manually link them.
Updates via PowerShell Scripts
The PowerShell approach is very convenient for anyone comfortable with development expertise.
Sample code is provided below: http://blogs.msdn.com/b/aymerics_blog/archive/2014/06/28/crm-data-management-with-powershell.aspx
If you want more information about how CRM can be used as a marketing platform, please visit our Marketing Solutions page.
Happy CRM'ing!