So, recently we received a message from someone who has nine (9) email addresses in our CRM. This means they've emailed us from more different address than years they've been a client. Wow! (facepalm) haha
Good client? Yes. Great client.
Bad email habits? Absolutely.
What can we do to help them (and ourselves)? LOTS. (see image)
The first step is to merge each contact record containing their secondary email address into the contact record containing their primary email address. Merging cannot be easily undone, so you'll want to be certain that both email addresses belong to the same PERSON.
How Do I Merge Contacts? You'll also want a good understanding of what happens when you merge two contact records in HubSpot. In short ...
The contact record on which you originally clicked Merge remains as the existing contact record. The contact you selected during the merge process will merge into that original primary contact.
The most recent values from either contact will be the present values on the remaining contact record. However, there are some exceptions; please see below for details.
The history of property values from both contact records can still be found in Property History in the remaining (primary) contact's record.
You will see a combination of timeline activity from both the primary and secondary contact records on the remaining (primary) contact's record.
"After merging contacts, you will not be able to create a new contact with the email address of the old contact record that was merged."
This means if you accidentally merge contacts from two different PEOPLE, you'll need to engage HubSpot support to assist with that separation. (it's a pain, so try to avoid it)
HubSpot Developers - Merge Contacts Ok, I can already hear some of you saying, "but my client(s) need(s) all of those separate email addresses".
No argument there. However, WE don't need all those email addresses SEPARATED. 🙂
Once merged, you will still be able to receive email from all of their email addresses. However, you will only be able to SEND to the PRIMARY email address in HubSpot.
This organizes all of the communications we receive for a single contact no matter how email address crazy they've gone.
Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.
Thank you for sharing this process with others! This is a great process and striving to keep your database up to date and clean continually helps you and your customers grow.
Jun 12, 20188:22 AM - edited Jun 12, 20188:22 AM
HubSpot Employee
Will The Real HubSpot Email PLEASE STAND UP!
SOLVE
@MFrankJohnson This is great! Thank you so much for sharing 🙂 I would love to feature your story as its own blog post on the HubSpot Academy User blog. If you're interested, please email me at userblog@hubspot.com.
Appreciate the kudos and share @roisinkirby, @adonahue, @cbsembler. Silly email stories are often 'sad but true'. Thought it might resonate with others who share our experience.
Thanks again.
Best,
Frank
Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.
You still can't manage (add, delete, update) secondary emails programatically, but you could potentially read them by using the identity profile(s) of the contact(s) in question. This data can be pretty complicated, but generally speaking `EMAIL` identities are what appear as secondary email addresses. Here's an example:
This contact's `email` property would be "test@hubspot.com", and it's secondary email addresses would be "testalias@hubspot.com" and "testalias2@hubspot.com". If the email address is updated, new identities will be added and the `is-primary` and `is-secondary` fields will be updated appropriately.
There isn't a more efficient way to search specifically for contacts that have secondary emails right now. The team is aware of this, and is thinking about more effective ways to manage secondary email addresses (though I don't have any specific timeframe).
Understood. It's not possible to create an active list in-app with merged contacts, but you can confirm whether or not a contact was merged in two ways:
In app, you can filter the contact's timeline to show merge events; any/all merges will appear here.
When pulling a contact via the API, you can look for the `merged-vids` field, which is an array of vids that have been merged into the current contact record. If this is empty, then the contact has never been merged before.
Thanks for the insight, Frank! Is there any way to identify records that have a merge history? I'd like to build a list (if possible) so our admin team can review records post-merge to ensure data hygiene.
Jun 11, 20199:28 AM - edited Sep 30, 20205:08 PM
Thought Leader
Will The Real HubSpot Email PLEASE STAND UP!
SOLVE
Hey @kallgood, We are unaware of any way to BULK identify contacts with multiple email addresses except via an export of the contact email address property history. - see View Property History
You still can't manage (add, delete, update) secondary emails programatically, but you could potentially read them by using the identity profile(s) of the contact(s) in question. This data can be pretty complicated, but generally speaking `EMAIL` identities are what appear as secondary email addresses. Here's an example:
This contact's `email` property would be "test@hubspot.com", and it's secondary email addresses would be "testalias@hubspot.com" and "testalias2@hubspot.com". If the email address is updated, new identities will be added and the `is-primary` and `is-secondary` fields will be updated appropriately.
So basically, using the Get all contacts API example (shown below), we'd want to look at identity profiles for contacts that contain multiple 'EMAIL' identities?
[None in this example.]
Or is there a more efficient method to use (especially against portals with lots of contacts)?
There isn't a more efficient way to search specifically for contacts that have secondary emails right now. The team is aware of this, and is thinking about more effective ways to manage secondary email addresses (though I don't have any specific timeframe).
@Derek_Gervais Thanks for the insight. One clarification from my original question (and it may not change anything) I'm not necessarily looking for contacts with multiple addresses, but rather, we want to identify contact records that have ever gone thru a merge process. Many do in fact have multiple addresses, but some have since had an old address deleted and just have one.
Understood. It's not possible to create an active list in-app with merged contacts, but you can confirm whether or not a contact was merged in two ways:
In app, you can filter the contact's timeline to show merge events; any/all merges will appear here.
When pulling a contact via the API, you can look for the `merged-vids` field, which is an array of vids that have been merged into the current contact record. If this is empty, then the contact has never been merged before.
Appreciate the kudos and share @roisinkirby, @adonahue, @cbsembler. Silly email stories are often 'sad but true'. Thought it might resonate with others who share our experience.
Thanks again.
Best,
Frank
Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.
Jun 12, 20188:22 AM - edited Jun 12, 20188:22 AM
HubSpot Employee
Will The Real HubSpot Email PLEASE STAND UP!
SOLVE
@MFrankJohnson This is great! Thank you so much for sharing 🙂 I would love to feature your story as its own blog post on the HubSpot Academy User blog. If you're interested, please email me at userblog@hubspot.com.
Thank you for sharing this process with others! This is a great process and striving to keep your database up to date and clean continually helps you and your customers grow.