APIs & Integrations

Chrintz
Contributor

Syncing company data about gmail users from Segment.com to Hubspot

SOLVE

We are using Segment.com to sync data about user behaviour from our Software product to Hubspot. 

 

We are sending data about specific users as an identity call (works fine) and account information as a group call (company data). The challenge is that Hubspot requires a website address along with the group call.

That is fine for all users that have a company email address as we can just extract that and parse it as the company website address but we also have 12.000 freemium users and many of those are using a gmail.com or similar.

That means that if we extract the email domain and use that as a company website in the group call, all those contacts is put under the same company and constantly overrides account information from the other organisations.

 

A solution that we have been considering is the parse their unique organisation id as the website address - that would look something like this: http://ef9c7c50-4174-4578-ac56-b81123bced8a.com.

The issue with the solution is that our sales team is quite happy with the company data automatically extracted by Hubspot from the company website and that would obviously not work with the above solution.

 

Do you have any suggestions as to how we can solve it in a better way?

0 Upvotes
1 Accepted solution
MFrankJohnson
Solution
Thought Leader

Syncing company data about gmail users from Segment.com to Hubspot

SOLVE

>>"...if we are to cover all cases there will be some maintenance work in order to keep that list updated - and the dev team is not thrilled about that."


Fortunately (or unfortunately depending on your perspective), the list of free email service providers (ESPs) is skewed heavily in favor of the top providers who represent the lion's share of the free email market (99%?). The high percentage of users who prefer popular free email services combined with the large market share of popular email clients makes us wanna agree with the dev team on this -- upkeep is probably not worth dev resources.

 

In fact, Claire Hughes Johnson, COO of Stripe (Yale alumni and former 10yr Google Executive) delivered a thought provoking presentation at INBOUND 2018 about the 'developer force multipler effect' and how [current developers] x [greater productivity] = [increased GDP].
- see [VIDEO] Claire Hughes Johnson | INBOUND 2018 Spotlight

- see Becoming a Developer Team Force Multiplier by Steve Smith, Founder, Ardalis Services


-see Primary US Email Providers by Statista

 

Primary US Email Providers by StatistaPrimary US Email Providers by Statista

 


- see [Infographic] Email Client Market Share 2019 by Litmus

 

[Infographic Exerpt] Email Client Market Share 2019 by Litmus[Infographic Exerpt] Email Client Market Share 2019 by Litmus

Full Litmus Infographic


For the extremely detailed among us, there's always the free_email_provider.domains.txt list of over 3700 free ESPs on GitHub by tbrianjones. That GitHub repository is updated regularly and also includes a link to at least one other repository that supports REST API updates!

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com

View solution in original post

4 Replies 4
MFrankJohnson
Thought Leader

Syncing company data about gmail users from Segment.com to Hubspot

SOLVE

Not sure this will be helpful, but since you have dev resources ...


Couldn't you parse the unique organisation id as the website address, BUT only for those freemium users WITHOUT free email addresses?

 

A little more dev work, but that would give you the best of both worlds -- i.e., freemium users with non-free website addresses would retain their company associations in HubSpot, thereby reaping the benefits of HubSpot Insights data, AND freemium users with free website addresses would still get the funky unique abcxyz123.com company association. Just a thought.

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com
Chrintz
Contributor

Syncing company data about gmail users from Segment.com to Hubspot

SOLVE

That is definitely also an option - the challenge here is that there are quite a lot of free email services, it's easy to cover the most popular (Gmail, yahoo, outlook, AOL, Hotmail etc.) but if we are to cover all cases there will be some maintenance work in order to keep that list updated - and the dev team is not thrilled about that. 

0 Upvotes
MFrankJohnson
Solution
Thought Leader

Syncing company data about gmail users from Segment.com to Hubspot

SOLVE

>>"...if we are to cover all cases there will be some maintenance work in order to keep that list updated - and the dev team is not thrilled about that."


Fortunately (or unfortunately depending on your perspective), the list of free email service providers (ESPs) is skewed heavily in favor of the top providers who represent the lion's share of the free email market (99%?). The high percentage of users who prefer popular free email services combined with the large market share of popular email clients makes us wanna agree with the dev team on this -- upkeep is probably not worth dev resources.

 

In fact, Claire Hughes Johnson, COO of Stripe (Yale alumni and former 10yr Google Executive) delivered a thought provoking presentation at INBOUND 2018 about the 'developer force multipler effect' and how [current developers] x [greater productivity] = [increased GDP].
- see [VIDEO] Claire Hughes Johnson | INBOUND 2018 Spotlight

- see Becoming a Developer Team Force Multiplier by Steve Smith, Founder, Ardalis Services


-see Primary US Email Providers by Statista

 

Primary US Email Providers by StatistaPrimary US Email Providers by Statista

 


- see [Infographic] Email Client Market Share 2019 by Litmus

 

[Infographic Exerpt] Email Client Market Share 2019 by Litmus[Infographic Exerpt] Email Client Market Share 2019 by Litmus

Full Litmus Infographic


For the extremely detailed among us, there's always the free_email_provider.domains.txt list of over 3700 free ESPs on GitHub by tbrianjones. That GitHub repository is updated regularly and also includes a link to at least one other repository that supports REST API updates!

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com
Chrintz
Contributor

Syncing company data about gmail users from Segment.com to Hubspot

SOLVE

That list looks great.

We will probably go that way.

Thanks!