Skip to main content

Community

Connector Improvement: Hubspot email campaign data

Answered

Please sign in to leave a comment.

Comments

5 comments

  • Official comment

    Hi Mohit kumar, Drew from the Product Team here!

    Are you not seeing the name field in the EMAIL_CAMPAIGN table? This should already be syncing.

    Hi Drew @...,

    Thanks for your response!

    Email campaign table is syncing but what we are missing is campaign names which we have labelled in hubspot. For e.g. see attached screenshot, we have classified emails to fund emails, leads to registration etc.

    I want to get this classification in email campaign table as well.

    Regards,

    Mohit

    Hi Mohit 

    We have reached out to hubspot support in order to understand if there is a way to fetch this data from the hubspot APIs. Might require more context regarding this. Will update as we hear from hubspot support. 

     

    Thanks 

    Rajat Kushwaha
    Senior Software Engineer
    Fivetran 

    Hi Mohit 

    We got in touch with hubspot support to check whether it is possible to fetch the requested data from Hubspot APIs. Looks like this wont be possible as this information is not exposed via any API endpoint. Below is the response from hubspot support: 

    Unfortunately we don't have a Marketing Campaign API, the campaigns tool in HubSpot allows customers to tag related marketing assets and content (Email, Forms, Landing pages etc), so they can easily measure the effectiveness of their collective marketing efforts.
    "Fund emails", "Lead to registration", "monthly newsletter" are all examples of Campaign names in the screenshot and we don't surface any campaign data via API.

     

    The Email Events API that you shared a link to includes endpoints that contain the word 'campaign' e.g Get campaign data for a given campaign, this endpoint provides a way to query data associated with a given email campaign which is different to a Marketing Campaign. The email campaign API will return information exclusively about the email e.g opens, clicks etc and it won't return information about any broader Marketing Campaign the email may be apart off e.g 'Fund emails, Lead to registration' as we don't expose Marketing Campaign data via API.

    I think it will be worth submitting a feature request to hubspot for exposing this data via their APIs.