Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Hubspot Events v3

Completed
Austin Lin Gibbons User

There appears to be a hubspot endpoint for getting activity events as part of hubspot API v3. I want to replicate events for each of the contacts in hubspot

 

e.g., https://api.hubapi.com/events/v3/events?hapikey=<redacted>&objectType=contact&objectId=45104

-> 

    {
      "objectType": "CONTACT",
      "objectId": "45104",
      "eventType": "e_visited_page",
      "occurredAt": "2022-06-22T16:26:44.153Z",
      "id": "magician-ad763ea5-a4bb-3466-bf93-483958bb735e",
      "properties": {
        "hs_base_url": "myurl.com/docs/api",
        "hs_browser": "Chrome",
        "hs_city": "jersey city",
        "hs_country": "us",
        "hs_device_name": "Mac",
        "hs_device_type": "Desktop",
        "hs_operating_system": "macOS",
        "hs_page_title": "My Page Title",
        "hs_region": "nj",
        "hs_title": "My Page Title",
        "hs_url": "https://myurl.com/",
        "hs_url_domain": "myurl.com",
        "hs_url_path": "/docs/api",
        "hs_user_agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/526.36 (KHTML, like Gecko) Chrome/101.0.0.0 Safari/526.36"
      }
    },

is there a way to have this data be loaded into Snowflake through Fivetran? Is it either already on fivetran's roadmap, or is there some way to extend my existing hubspot connection as a "custom connection"

 

See also: https://community.fivetran.com/t5/using-fivetran/querying-hubspot-v3-event-endpoint/td-p/242

Please sign in to leave a comment.

Comments

9 comments

Date Votes
  • Official comment
    Sadie Martin Fivetranner
    • Edited

    Hi all,

    Standard event data is now available in Fivetran's HubSpot connector in the EVENT table. We are also working on adding custom event data. If you would like to try out the custom event data, before we release it to all customers, please comment on this Feature Request and I will reach out to you.

    Best,

    Sadie

  • Drew Fivetranner

    Hi Austin Lin Gibbons, Drew from the Product Team here.

    Could you share a bit more about your use case for this data? It looks like it would be very high volume (tracking page views and other web analytics actions), so I'd want to make sure that the use case is very clear.

    Where is Hubspot tracking these events? How does a customer implement this feature of Hubspot?

  • Paul Maisondieu User
    • Edited

    Hello!

    I'm also interested in this feature. Here is my use case: I have a website and a SaaS platform. Hubspot is tracking users on both domains.
    In the contact properties, I have access to the first and last pages visited by a contact on my website.
    I would like to have access to all visited pages to understand users's behavior.
    The information is available thanks to this endpoint.

  • Eoghan McNulty User

    I would also be interested in ingesting the events/web analytics data from HubSpot.

    Events API | Web Analytics (hubspot.com)

  • Uriel Elituv User

    Also interested in this feature. Many use cases, but one example use case is to understand how specific web pages influenced a prospect. To do that, need to know who visited that web page.

    HubSpot includes this data in its native HubSpot to Snowflake sync and is potentially leading us to move the HubSpot sync workload off of Fivetran.

  • Sadie Martin Fivetranner
    • Edited

    Hi all, Sadie from the Product Management team here. We are actively working on adding this data to the HubSpot connector. We will update you here once it's available.

    Best,

    Sadie

  • Jonas Bauer User

    Hi Sadie, 

    Can you give any guidance on availability timeline of the contact-level events data in the hubspot connector? I'm working on something that needs this data and trying to make a decision on building something custom to import this data vs wait for it to become available in the connector. Thanks

  • Sadie Martin Fivetranner

    Hi Jonas, 

    We are working out some implementation details right now and hope to have this available to you by the end of April. In the meantime, can you share what specific events you are interested in? Most of the requests here are asking about page visits - are there other types of events you need? 

    Best,

    Sadie

  • Jonas Bauer User

    Hi Sadie,

    For our use case we ideally would want to be extract any types supported by the underlying API, but for the time being the most important are page view and ad interaction events, since those aren't available through any other API at the moment. Would be happy to work with your team to validate early versions of the endpoint as soon as something is available if helpful.

    Best,

    - Jonas