Create Associations between Contacts, Companies, and Deals to Link Key Info
Your sales and marketing teams rely on properly associated data for context in communications and sales conversations. Without proper associations in place, they might lack vital context and potentially miss big opportunities.
Use Insycle to automatically detect and link contacts, companies, deals, custom objects, or any other record in bulk to maintain order in your CRM and give your teams a complete picture of every account.
There are two different modules that could be used to address this.
Which Module to Use When
To associate records that are currently in the database in bulk, use the Bulk Operations module and the Associate action.
To associate new records from CSV, use the Magical Import module and the Associate action under the Manage Data Step. Associating in this module is a little less flexible than what can be done with Bulk Operations, as you cannot use the associated record to fill in fields in the original record.
Associating records is a powerful way of creating relationships between your data. You tell Insycle which records you would like to associate, and the direction you'd like the linked information to flow.
To associate records, you need a field with a similar value in both records. For example, "Email Domain" on the contact, and "Website Domain" on the company. Then, you can pick those fields to match the records and establish the association.
You can set associations in both directions:
Though setting associations will work in both directions, consider that Contacts to Companies is the standard direction and some features (such as the "If Company is Not Found Create New Company" feature) are only designed to work when Contacts are associated to Companies.
For straightforward associations with obvious matching fields, the direction of the association doesn't matter. But in some cases, such as associating custom objects or child and parent companies, association direction may be important.
Associating Contacts to Companies in Bulk Using the Bulk Operations Module
To associate existing records, use the Bulk Operations module. Here, you can associate contacts, companies, deals, and custom objects as needed, including child and parent associations.
- Select and filter records.
- Configure rules that will make the associations.
- Preview changes in a CSV report.
- Apply the changes to the CRM.
- Save the configuration as a template.
- Set up an Association automation.
Select the Bulk Operations module from the left navigation, then select the database and the Contacts record type in the top menu.
Select the “Associate Contacts to Companies Using Name” template. This is the most commonly used template for bulk associations. The configuration looks for contacts that do not have an "Associated Company ID" but do have a company name. These are the contacts that we want to filter down to and potentially associate, assuming a match can be found. You can edit this filter and use any field.
Why Filters Are Important
A filter such as, "Associated Company ID doesn't exist" ensures that Insycle will only look to associate those records that do not already have an association in place. Otherwise, Insycle will scan your entire database, including contacts that already have associations. This will slow your processes down significantly.
As with all Insycle templates, this is an excellent starting point, but you can customize this filter as needed.
Click Search to see the records that match these criteria at the bottom of the page in the Record Viewer
In this step, we'll tell Insycle how to associate companies in bulk, and define the rules for matching contacts to companies during the association process.
Under Step 2, click the Associate tab.
Numerous settings specify how to make the linking connection.
The Action setting tells Insycle whether to add or remove associations among the records we filtered in Step 1. To associate contacts to companies, select "Add."
In the Record Type picklist, select "Contact to Company." There are also other association options available here, including associating contacts, companies, deals, and custom objects.
Then click the Companies Filter button.
While in Step 1 we told Insycle how to filter down our contacts to only those that are fit for associating with a company, in this step, we tell Insycle how to filter companies down to those that would be a good fit.
Here, if not already set up, select the Field, "Company name," and Condition, "exists." This tells Insycle to only consider companies for association if the Company name field has a value in the database.
The Field Name is the field contained within the Contact record type and the Match Field is the Company record field we will be matching it with.
For the Comparison Rule, the template is configured to only associate if company names between the Contact and Company records are an exact match, but you could change this to "Similar Match." The Ignored picklist tells Insycle to ignore common terms in the company name such as "LLC," "Inc." or "Co." These terms can be edited using the Terms button.
Use the Match Parts field to tell Insycle whether to match the entire field or just part of it—such as the first or last few words, or first and last characters.
When no matching Company is found, an association will not be created. In these cases, you can choose to automatically create a new Company record for the association in your CRM and link it.
To enable this, check the "Create new Companies when no matching is found." In this scenario, if no matching company is found when linking contacts to companies, a new company would be created and linked to the contact.
When using the "Exact Match" Comparison Rule, the "Create new..." setting could potentially create duplicates, so you should be thoughtful with the Matching Field and Comparison Rule that you use.
With the "Create new..." checkbox checked, only the first field added to Step 2 will be populated in the new record in the Company Name field. This feature is only designed to work associating Contacts to Companies, and not Companies to Contacts. The direction matters.
Now with the filters and functions set up, you can preview the changes you are making to your data. That way, you can check to ensure your association configuration is working as expected before those changes are pushed to your live database.
First, under Step 3, click the Review button.
In the Bulk Associate popup, select Preview and click Next.
On the Notify tab, add any additional recipients who should receive the CSV (and make sure to hit Enter after each address). You can add colleagues and additional context here.
On the When tab, click Run Now and select which records to apply the change to (in most cases this will be All), then click the Run Now button.
Open the CSV file from your email in a spreadsheet application and review the columns. For each field you’ve set up to change, a column will appear for both (Before) and (After). This will let you know what you started with and what change will be made to your CRM.
If everything in your CSV preview looks correct, return to Insycle and move forward with applying the changes to the live CRM data.
Under Step 3, click the Review button, select Update mode, then click Next.
On the Notify tab, add any additional recipients who should receive the CSV.
On the When tab you can choose to run and apply the update now, or you can set up an automation to run the template on a regular basis. The first time you apply these changes to the CRM, we suggest you Run Now.
In the Run Now tab, you can control how many records to run the template on. Click Run Now to apply the changes to your CRM.
Save the Configuration as a New Template
After you've seen the results in the CRM and you are satisfied with how the operation runs, you can save all of the configurations as a template. This will save you time and provide consistent results.
Return to the Template menu at the top of the page and click the + to give it a unique name and then click the Save button.
Setup Automation to Run the Template on a Regular Basis
Under Step 3, click the Review button, select Update mode, then click Next.
On the When tab under Automate, you can schedule this template to run on an hourly, daily, weekly, or monthly basis.
After setting up an automation, Insycle will scan your database and automatically associate contacts to companies on the set schedule. When the operation runs, you'll receive the CSV in your inbox showing the changes that were made.
You can view all automations you have scheduled on the Automations page of your dashboard, and all updates to your data can be viewed and downloaded as reports in the Activity Tracker.
Associating Contacts to Companies Using the Magical Import Module
If you have a CSV file containing data to be imported as new records, use the Magical Import module to associate people and companies to existing records in your database, on import.
To learn more about the importing process, review this help article: Import new records or update and append to existing from CSV.
- Select the CSV file.
- Map the CSV columns to the CRM fields and select the import mode for each field.
- Select the unique identifier field.
- Optionally, specify how to prepare and modify your data before importing.
- Set up the association between the CSV and CRM records.
- Select the rows to import.
- Import the data with the specified associations to your CRM.
Select the Magical Import module from the left navigation, then select the database and the Contacts record type in the top menu.
Select the CSV file that you would like to import. Uploading a file into Insycle does not import it to the CRM immediately; instead, you can prepare the data in various ways before importing it to the CRM.
After uploading your CSV data, Insycle analyzes your file and compares the columns in the file to fields in your CRM database.
A column is included for each field in the CSV, with the CSV column header appearing as the top row. Then, Insycle automatically detects the matching CRM fields and maps them for you. The second row shows the mapped CRM field names. If your CSV contains fields that are not matched to your CRM, a red exclamation point error notification will show.
These "Not Mapped" fields need to be mapped manually by clicking the picklist and finding the appropriate CRM field. If they remain unmapped they will not be imported. You can leave those columns unmapped, or click the “X” next to the column when you hover over it to remove it from the list.
If a field in your CRM includes defined values to select from a picklist and the data included in your CSV does not match the values in your CRM, the row will display an "Invalid picklist value" error.
With all relevant fields mapped, you tell Insycle how to use the data on a field-by-field basis by selecting the Import Mode, which is the third row in the table.
To add the field data in your CSV to the existing field data in your database select "Append" from the Import Mode picklist.
Insycle uses Identity Fields to compare your CSV to your CRM data. Identity Fields must be "unique identifiers." These are data points that would only belong to a single contact—such as email addresses, phone numbers, home addresses, or ID numbers.
Under Step 2 on the Import tab, and select the Identity Field from the multi-select picklist.
Select the Records Mode to tell Insycle how the imported data should be handled during the import process.
- Update existing and create net new – Insycle will attempt to match imported records to existing CRM records using the identity field. If Insycle is unable to find a corresponding record, a new record will be created in your CRM.
- Only update existing – Insycle will attempt to match imported records to existing CRM records using the identity field. If a corresponding record is found, it will be updated with the data from your CSV import. Records that are not matched with an existing CRM record will not be imported.
- Only create net new – Insycle will attempt to match imported records to existing CRM records using the identity field. Only records that can not be matched with an existing record in your database will be imported. Records that already exist in your CRM will not be.
For example, if you want to make associations for existing records but do not want to create new records in your database, you can select "Only update existing."
You can select more than one identity field, however, Insycle will check all the fields to match. If one single field does not match, the corresponding matching CRM record will not be identified and will not be deleted.
Using the "Update existing and create net new" setting, Insycle will fail to match many records and instead will create a new record.
If you use the "Only update existing" setting with many Identity Fields, you will identify far fewer existing records and much of your CSV data will not be imported, and data will not be appended because Insycle will not be able to find the correct record to update.
Outside of specific use cases, it is typically best to use a single identity field.
If you're using a field that is not uniquely identifying, Insycle is likely to identify the wrong record in your CRM as a match and will not be able to identify a record to pull data from. For instance, there are probably many people with the first name "John" in your CRM, but you want to make sure that you are pulling data from the correct record for John. This is why it is important that we use uniquely identifying fields.
You can make changes to the CSV data in Insycle before it is uploaded to your CRM. You could apply formatting to a field, cleanse data, organize, and perform other actions prior to import.
On the Functions tab of Step 3, select fields and functions to apply to the field data.
Under Step 4, click the Associate tab (this may also be called the Link tab, depending on the naming convention in your CRM).
Choose an Action, either to Add or Remove associations. For associating on import, choose “Add."
Click the Associate field and select the second Record Type. This tells Insycle what kind of associations we would like to make using the CSV import data.
You can choose:
- Contacts to company
- Contacts to deals
- Contacts to custom objects (HubSpot only)
In the CSV Column field, select the CSV field to use for matching and associating. If you were associating contacts to companies, for example, you would likely choose the “Company” or “Company Name” field from your CSV import.
On the Match Field, select the field that the CSV field should match to in your CRM database. If you are using the “Company” field from the CSV, for example, you'd want to match that to the “Company” or “Company Name” field in your CRM.
Additionally, you have the option to create a new company record when there is no match automatically found by Insycle. You can do this by selecting the checkbox next to the picklist selections in this tab.
If there are only a few records you want to apply the association to—perhaps to test things out before importing the entire CSV—return to the table under Step 1 and check the boxes beside the select records. Leave the checkboxes blank to import all of the records.
Click the IMPORT X CONTACTS button under Step 5, and the matching associations will automatically be created in your CRM based on your settings.
A record of these changes can be found anytime in the Activity Tracker.
Troubleshooting & Gotchas
If you receive a "Multiple Sources Matched" error, this indicates Insycle found multiple records that meet the criteria. Try changing the direction of the association to resolve the error.
Bulk associations require that you have a field that you can use to match the two records. For instance, you might store "Company" for contacts, and "Company Name" for companies. You then use these two fields to associate the two records.
But what do you do if you have no obvious matching field between the two record types that you would like to associate?
This is a fairly common scenario. For example, maybe you would like to associate contacts not only with the company that they work for but with the parent company as well. In this scenario, it is not very likely that you capture the parent company on the Contact record, which means that you may have no field to use to match the association. As a result, you'll need to create a custom field for contacts and companies, such as "Custom Parent Company." Ideally, if child companies are already associated with parent companies, you'll be able to pull this data from your company records and populate both custom fields using your CRMs automation features.
Then, you'll be able to use the Custom Parent Company field for both contacts and companies to make the patch.
The key is finding a data point that would allow you to match the associations, even if it is only available for one record type. Then we create the custom matching fields that allow us to make the associations.
Frequently Asked Questions
No, Insycle does not currently allow you to access, update, or associate activities. When you merge companies, it would re-associate activities from the duplicate company to the master company, and re-assign contacts and deals to the master, see below and attached help article.
Insycle allows you to use any field in your database to match associations. Commonly used fields for linking include company names, company domains, company domains, and company URLs.
It means that when Insycle goes to make the association, it is finding multiple records that meet your criteria. Often, this is either because you are using a field that is not a uniquely identifying field (so Insycle will detect multiple records that match the criteria), or you have duplicate records that need to be merged before the association can take place.
Yes, with Insycle you can associate in any direction and it will work. Please make sure you have the correct starting record type selected at the top of your module screen.
Yes, check the "Create when no matching is found" checkbox.
Related Help Articles
- HubSpot Multiple Associations and Labels
- Associate or Link Parent-Child Companies, Create Accounts Hierarchy and Relationships
- Module Overview: Bulk Operations
- Import New Records or Update and Append to Existing from CSV
Related Blog Articles
- Fix Stray HubSpot Contacts With Bulk Association — Connect Contacts to Companies and Deals With Complete Control
- How Insycle Solves Common Problems with HubSpot and Salesforce Integration
- Considerations for Using HubSpot’s Automatic Contact to Companies Association
- Salesforce ABM - Associating Leads and Contacts to Accounts