I am trying to pull email marketing data in order to train an attribution model using Hubspot’s APIs.
I pulled email events from the following API: https://api.hubapi.com/email/public/v1/events . Now I want to be able pull email metadata, especially at the campaign level so I can add the campaign name to each email event. The email events data includes a field called ‘campaign_id’. However, this campaign_id seems to be different from the id that is found in the campaign data I pulled from this API: https://api.hubapi.com/marketing/v3/campaigns .
Hubspot support has confirmed that the event data is from an older API version and there isn’t a way to map a given campaign_id from the email events API directly to the newer campaigns API. I also tried the general marketing emails API (https://api.hubapi.com/marketing/v3/emails ) but wasn’t able to find a campaign_id in that table either.
Has anyone found a workaround for this?
I’ve dealt with this too, it’s annoying. The campaign_id from the email events API doesn’t match anything in the newer campaigns API. They come from different systems, and HubSpot never made a bridge between them.
What helped in my case: I used the email subject and send time from the event data to manually match each event to the right campaign from the /marketing/v3/emails API. It’s not perfect, but if your naming or send schedule is structured, it works well enough.