Setting up a Master List to Sync With Your CRM
Creating a Master List is a best practice that can vastly improve your experience with Act-On by centralizing your contacts in a single location. By default, a Master List will need to be updated manually when you have new records to add. This process will show you how to use an integrated CRM to keep your list updated automatically.
Overview
This process uses CRM lists, an temporary Master List for editing, and a truly complete Master List.
Requirements
- A Master List
- An integrated CRM
- Your CRM Leads and Contacts imported and added to your Master List
- 5-10 minutes to complete these steps
Follow these steps carefully. There are severe possible ramifications including deleting your entire Master List if this is done incorrectly. Please check your work several times over when setting up an auto-delete function.
This process only covers CRM lists. If you have other one-off lists in Act-On that do not come from your CRM, they will not be added to your Master List.
Steps
- Copy your Master List
- Click the dropdown next to the list > Copy > Choose Copy the structure and all the records
- This will be your interim Master List, so give it a name like "Temp Master List"
- On each of your CRM lists, create a segment that excludes records without emails
- Create 3 separate List Maintenance Programs on your interim Master List (they must be 3 distinct programs, not a 3-step program, or you will end up with this error and the program will not run):
- Program 1: Copy from Contacts with a Delete option - this is copying from the “has email” Contacts segment
- Program 2: Copy from Leads with a Delete option - this is copying from the “has email” Leads segment
- Program 3: Copy from Contacts with NO Delete option - this is copying from the “has email” Contacts segment
- Program 1: Copy from Contacts with a Delete option - this is copying from the “has email” Contacts segment
- Schedule all three new programs to run daily, 10-15 minutes apart, in the order they were created above
- Your result will be:
- Your interim list becomes a true copy of your CRM Contacts list
- Leads are copied into the list, overwriting any existing information (duplicates in both Leads and Contacts) and deleting records that aren’t Leads
- Finally, Contacts are copied into the interim list, appended to the bottom
- Final Step: On your true Master List (not the interim list), create a List Maintenance Program
- Set it to copy from the interim Master List with a delete option
- Schedule it to run at least 30 minutes after the 3rd Program on the Interim list
You will now have a Master List that updates dynamically based on your CRM lists.
By setting up your CRM lists to sync and auto-remove records not found, your Master List will contain only the records that actually exist within your CRM.
More Information
This process uses a series of List Maintenance Programs that essentially delete the list they copy to, then overwrite with their data.
One of the benefits of a Master List is that you can use segments from it to drive your Automated Programs. However, when a record is removed from the source list of a program, they are deleted from that program.
This process avoids this issue by using an interim list. By copying to/deleting from the interim list and then only copying/deleting that list to your Master List, you do not need to wipe your Master List completely to keep it current.
Comments
0 comments
Please sign in to leave a comment.