I’m running into problems getting Amplitude Hubspot Integration to work.
I’ve followed the instructions detailed in Send Cohorts to HubSpot and they seem to almost work.
- Amplitude setup step works
- Send a cohort works according to the Amplitude UI
However, when i examine the Cohorts in HubSpot, I find that a contacts list is created with the correct name, i.e. with the Amplitude_ prefix, but the list is empty and remains empty despite Amplitude claiming it has synced users to the list.
@kdavis ! Welcome to the Amplitude Community 👋
If the contact list is created with the correct name in Hubspot, that should represent that the sync was successful and completed. Did you see any errors pop up in the Cohort Sync Details section within Amplitude or maybe errors in Hubspot? That would help with troubleshooting.
Otherwise, the only other reason I know users not appearing in a cohort sync destination is because the user doesn’t exist in the destination already. I see that with the Hubspot integration, if you choose Contact ID as the mapping key for example, then the user has to exist in Hubspot: https://www.docs.developers.amplitude.com/data/destinations/hubspot-cohort/?h=hubspot#considerations Can you share if this is how you have set up your integration?
Thanks for helping!
I’ve may a bit of progress with this problem, but only a bit.
I’ve found that if when creating the sync I do the following:
then a corresponding static list is created in HubSpot and the list is populated with the current members of the cohort with no errors in the Details section of the Amplitude cohort.
However, I want the HubSpot list to be updated with new members of the Amplitude cohort. So, I then edit the sync schedule of the Amplitude cohort to have the sync happen hourly, and this is where the problems begin.
The history of the cohort sync in Amplitude looks perfect with no errors, e.g. lots of….
However, the added users do not appear in the corresponding HubSpot list. (I don’t even know where the log is on the HubSpot side so I don’t even know where to look for errors on their side.)
However, it seems like removals from the HubSpot lists are synced, i.e. for the Amplitude History item I provided above 2 users would be removed from the HubSpot list, but no users would be added.
So things are a bit strange.
PS: If you need more specific info on the setup, just ask.
@kdavis ! Thanks for the info you provided earlier. I reached out to the Engineering team with that info and they responded with the following:
Could you try the Engineering team’s suggestion and let me know if that works?
Do you recall whether you had upsert enabled when you created the syncs the first time around?
PS: I did have upsert enabled initially.
Now I’ll just wait at least an hour to see what happens.
For example, since I wrote the last message there are about 33 more users in the [HubSpot] Users Validating Email Within the Last Day cohort, but 0 of those have been added to the corresponding list in HubSpot.
Furthermore, the sync history indicates 35 added, 2 removed with no errors for the last 14 days.
@kdavis ! To clarify, you created new scheduled syncs right? So the steps are:
I’m assuming that’s what you did based on the Engineering team’s suggestion but the steps you shared are slightly different from how I was imaging. Wanted to confirm!
Thanks for followup up!
What I did is what I captured in the steps a listed above.
In particular your step “Create a new fresh sync schedule on the cohort with the Upsert enabled” isn’t possible with the current Amplitude + HubSpot integration.
Setting upsert on or off is only exposed when creating a cohort from scratch. It isn’t exposed once the cohort is already created. Once a cohort has been created you can only do what I did above.
That said, if I were to delete the cohort completely and create a new cohort with upsert enabled and a hourly or daily sync set, then I’d be in the original situation I found myself in when I opened the ticket, i.e. a cohort is created and claims to sync every day or hour and an empty list is created on the HubSpot side and the list remains empty.
The only way I’ve been able to have data be sent to HubSpot is to create a cohort with upsert enabled and also select a one-time sync. If I do this, then a list get created and populated on HubSpot. After that I then set the sync to hourly or daily. But then, as explained above, the sync doesn’t work.
@kdavis ! Thanks for sharing this! Do you mind if I test some things in your cohorts? I’ll email you separately. :)
@kdavis ! I’m ooo this week and will ask another team member to help. In the meantime, I did send an email last week to your email associated with the Amplitude Community post to confirm the two cohorts that you were attempting to sync and permission to disable those syncs and recreate a new one. I just checked the email and it looks like I haven’t heard back from you yet on confirming those two cohorts. Could you check your email inbox? Thank you!
I didn’t receive an email from you, not sure what happened.
Least email I got was the one containing
Thanks for sharing this! Do you mind if I test some things in your cohorts? I’ll email you separately. :)