Merged (Secondary) Emails Don't Appear in Export Files

Hi Hubspot Community & Team,

 

When we started using Hubspot we merged duplicate contacts with different email addresses. Now when exporting contacts there is no option of exporting the merged email addresses which are saved as secondary email addresses. In future this may lead to redundancies. In order to avoid further duplicate contacts it is important to be able to lookup also the secondary email addresses and compare with a potential new email but right now the secondary email is kind of hidden. It can be used to send an email to a contact but further than that there is no other functionality related to it as I could test. When downloading a file the secondary email does not appear in export files. Could you change this? If this is not planned to be changed then it is definitely better to forgo and not use the merge function.

Best regards.

HubSpot updates
changed to: Delivered
2 weeks ago

Hello HubSpot Community, 

 

Thank you as always for your continued feedback, it helps us build a great product. I'm excited to let you all know that this is officially available via contact exports! 

31 Replies
Visitor

I recognize you can obtain the secondary email address via API (and apparently with a dedicated endpoint as BB1 pointed out. We recently encountered a situation where people were unexpectedly found with multiple email addresses and that affected an integration we have with our application. We needed to assess how many Contacts were in this state and it was not possible to export data via Hubspot's data export - secondary email address is still incredibly hidden there.

 

We ended up exporting the change history for the email field for all Contacts and using that as a data source to narrow the scope of affected users - only those that had changes in their email field. We wrote a one off script that utilized the API to query whether any of those users ended up with multiple email addresses. It could have easily been many thousands if this problem had persisted longer but took quite a lot longer to assess the impact because we couldn't simply export the data as a field from Hubspot.

Top Contributor

It's been about a year since I first commented on this idea post asking for details on the timeline and updates that @jennysowyrda teased about this issue two years ago. Any updates? Any timeline?

Regular Contributor

Hi all,

One solution (but it's a manual process) is to export the email history. 

This can help identify some of the secondary email addresses.


Email Export History.JPG

New Contributor

My company also needs this capability.  It seems like putting the cart before the horse to release the "Review duplicates" tool and encourage the merging of contacts while simultaneously not allowing users to export any kind of report displaying both of a contact's email addresses.

Occasional Contributor

March 2020 - Any updates on this implementation?? 

New Contributor

Yeah, I have been waiting for the past 2 years.  It could be as simple as just export two rows of contacts with different email addresses for each row for the same contact.

Occasional Contributor | Gold Partner
Occasional Contributor | Gold Partner

Ditto to all the above.

Occasional Contributor

Update to all - 

Not sure when it was implemented but when I export a list with ALL properties, one of the columns in csv/excel is called additional email. All you do is "text to columns" in excel and separate the emails with semicolon. 

 

Done deal for now. But HubSpot should in the future make each additional email a column so we don't have to use the formula in excel. Just a thought. 

Occasional Contributor | Gold Partner
Occasional Contributor | Gold Partner

That's great to hear!

Thanks deaguer

Just confirmed. Great news.

Unfortunately that requires all data for 64K contacts be exported, but can't have your cake and eat it too, as they say.

Or used to say. I don't think anyone says that anymore.

HubSpot Moderator
HubSpot Moderator
updated to: Delivered

Hello HubSpot Community, 

 

Thank you as always for your continued feedback, it helps us build a great product. I'm excited to let you all know that this is officially available via contact exports! 

Regular Contributor

Hi @Dylan - yes, I used it today, awesome!!!