Bulk Associate Parent-Child Companies in HubSpot

 

Associating child companies with parent companies is critical for maintaining order in HubSpot CRM and giving your teams a single customer view.

Your sales and marketing teams rely on properly associated data for context in communications and sales conversations. Without proper child-parent company associations in place, you lack vital context and potentially miss big opportunities.

With Insycle, you can automatically detect and associate child companies to parent companies using advanced matching.

Insycle can help you to associate, in bulk:

  • Child company to parent company
  • Parent company to child company
  • Contacts, companies, deals, and custom objects amongst each other.

How It Works

Insycle allows you to set child-parent hierarchies and associations in bulk, either for existing data in your CRM or from a CSV.

For example, you might tell Insycle to look for two companies with the same company domain, but one of them has "HQ" in the company name. Then, the HQ record would become the parent company, and the non-HQ record would become the associated child company.

Summary

With Insycle, you can associate parent and child companies in HubSpot flexibly and powerfully.

To associate parent and child companies, you use the Bulk Operations module. First, you filter your data down to the records that you would like to update, based on rules. Then you use the "Associate" tab in Step 2 to set the rules for your associations.

To associate child and parent company records, you need a naming convention for parent companies, such as including "HQ" in the title.

Step 1: Define Filter

To associate contacts in bulk, we will use the Bulk Operations Module. Navigate there.

First, we have to select the “Companies” record type or comparable record type in your CRM. Without selecting companies, you will not be able to make associations between child and parent companies.

bulk operations companies


Insycle’s Bulk Operations module includes a pre-built template for associating or linking child to parent companies in relevant CRMs.

Select the “Associate Child to Parent Companies” Template. To load this template, select it from the Template dropdown menu.

template


This template provides you with a solid starting point for making child-to-parent company associations and can be customized to fit your exact situation.

In Step 1, tell Insycle how to filter your database down to only the child company records that are relevant for the association.

The default filter for the “Associate Child to Parent Companies” Template is:

  • A Parent Company does not exist
  • The Company Name does not include the term “HQ”

Your company might use a convention for naming or marking parent companies in your CRM. A common convention is the use of “HQ” in the company name.

define filter parent company company name


With this filter in place, we have a list of companies that meet those specifications. By clicking the yellow Search button in Step 1, we’ll be able to preview the companies identified using this filter.

records

 

Step 2: Associate

In Step 2, we want to make sure that we are working from the third tab, “Associate.”

associate


In selecting the “Associate Child to Parent Companies,” Insycle automatically loads the saved template that is available for this task.

Let’s break down how the child company to parent company association process works, piece by piece.

First, we have the Action, we select the action that Insycle will take with this process. You can choose to “Add” or “Remove” associations. To create the child-parent company associations, choose “Add.”

Then we select the Record Type.

child company to parent company


This is where we tell Insycle what kind of associations we will be making. You can associate contacts, companies, and deals as needed here.

options for association


We will select, “Child company to parent company.”

Then, we have the Company Filter.

companies filter


Here, we are telling Insycle how to identify the parent company.

Click on the Company Filter button and the filter screen will pop up.

company filter


With this filter in place, Insycle will only match parent companies when they have “hq” in the company title—such as Microsoft HQ. You can also choose whether or not your filter phrase is case-sensitive.

Now we tell Insycle how to match child companies and parent companies in flexible ways.

The "Field Name" in this instance is a field from your Child companies.

company name company domain name


Then we must select the corresponding company field that we will match with.

These are the fields from your Parent Companies.

company name


Then we have the Comparison Rule. Here, you can choose:

  • Exact Match
  • Similar Match
company name


While not ideal for every situation, similar matching can be a good way to find more child and parent companies to link during this process.

Then, we must choose the Ignored portions of each field. Here, you can tell Insycle to ignore certain aspects of a field.

Here, you can tell Insycle to ignore things like:

  • Common Terms
  • Symbols
  • Digits
  • Letters
  • Whitespace
  • Specific Text
  • Top-Level Domains
  • Subdomains

The default settings for associating Child to Parent companies are Common Terms for company names (this includes things like Inc., LLC, etc.). This is often a necessary field for matching companies and making child-parent links.

To view or alter the common terms, click the Terms button at the bottom of this section.

terms


For the Company Domain Name field, the template instructs Insycle to ignore Top-level domains and subdomains by default.

This way, Insycle only looks at the domain name and not at the extension or subdomain. As an example, using the above settings, Microsoft.com, Microsoft.co.uk, and app.Microsoft.com would all be matched.

You can add new fields by clicking the Field button at the bottom right-hand corner of the Step 2 section.

field


At the bottom left-hand side of Step 2, you can instruct Insycle to create a new company when no matches are found by checking the box at the bottom of the Step 2 section.

create new companies when no match is found


This setting is typically only used for specific use cases. If you would like to use this setting, start by running in preview mode to view the effect without creating accidental clutter in your database.

Step 3: Preview or Update

Now, with our Filter and association/linking Actions in place, we can run the bulk operation.

When running the Bulk Operation module, especially for the first time, it is a good idea to run in Preview Mode. This allows you to view the changes to the data in a CSV file before the updates are pushed to your database.

You can do this by clicking the Review button in Step 3.

review button


A popup will appear. Here, in Stage 1: Mode, we can select the Preview Mode or Update Mode. Preview mode runs to process and makes the changes reviewable in a CSV file, but does not update your CRM database. With Update mode, the data changes will go live in your CRM when the operation is processed.

preview


For many tasks in Bulk Operations, it may be a good idea to run a preview to view how the changes will look in your database before running in Update mode.

Then click the “Next” button.

In Step #2 of the “Review” process, you can choose where you send the generated report. Your email will automatically be added to the list but can add other co-workers and colleagues that you are collaborating with here.

bulk associate


Once finished, click the “Next” button.

In Step 3, you can choose whether you would like this operation to run one time, or continuously.

There are two tabs on this screen—Automateand Run Now.

bulk associate


When you select the Run Now tab, you are choosing to run the child-to-parent association operation one time, immediately.

Bulk Associate Child-Parent Companies From CSV

You can also use Insycle's Magical Import module to associate child and parent companies directly from CSV files.

To learn more, see Link and Associate People to Companies.

When using Magical Import, associations are handled in Step 4.

How To Associate Child-Parent Companies from CSV (Step #4)

In Step 4, we can tell Insycle how to associate the records from a CSV using the Magical Import module.

In “Step 4: Manage Data,” click on the Associate tab. This may also be called the Link tab, depending on which CRM you have connected and what naming convention they use.

associate on import


Here, we can tell Insycle how associations should work, using the dropdown selections contained in the tab.

child to parent from CSV

In the "Associate" dropdown, we can choose child-to-parent companies, or parent-to-child companies. With Insycle you can make associations in both directions from CSVs.

select child to parent


Then you set your matching fields. Often, for child-to-parent associations, companies will match using things like company domain names, email domains, ID numbers, or other relevant uniquely identifying fields that you can use.

Additionally, you have the option to create a new company record when one is not automatically matched by Insycle. You can do this by selecting the checkbox next to the dropdown selections in this tab.

create when no match found


Insycle's Magical Import module makes it simple to create child-to-parent, or parent-to-child associations from a CSV, on import, or as a CSV update.

Preview Changes Before They Go Live

With Insycle, you can always preview the changes that you are making to your data before those changes are pushed to your live database. When you run any module in Insycle, you have the option of choosing between Preview Mode and Update Mode once you click the button.

Automation

You can set up ongoing data maintenance automation with Insycle on the module level, using Recipes, or integrating with Workflows.

Audit Trail and History

The Activity Tracker lets you review all changes made through Insycle. At any time you can download a CSV report of the operation and records affected, including while using Bulk Operations.

Frequently Asked Questions

How does Insycle know which company is the parent?

Insycle does not know what company is the parent. You have to make that clear through the data itself. A common way of tagging the parent company is to include "HQ" in the company name field.

Can I have Insycle create a new company record and associate it if no match is found?

Yes, you can instruct Insycle to create the new company record if no match is found in both the Bulk Operations module and Magical Import module.

create when no match found

Can I make child-parent associations from a CSV?

Yes, click here to learn more about making child-parent associations from a CSV file.

Can I make child-parent associations in bulk?

Yes, you can make child-parent associations in bulk using the Bulk Operations module.

Additional Resources

Related Blog Articles

Related Help Articles

Additional Resources