I'm a new developer to Hubspot. I'm trying to wrap my head around the data relationships among all the different API objects. To make this more straightforward, it would be great to take a look at an ERD, or entity relationship diagram, in order to more easily work with Hubspot data.
I haven't been able to find one in the docs or past posts herein.
Could someone point me in the right direction to find one?
I need the engagement entities to be more organized on the map. If you have those engagement relationships solved, let's work together to improve the map.
The ERD says it was updated in March 2022, however it still glosses over emails - Emails are still summarised within an 'Engagement' entity with 'Type(oneof: Email, Call, Task, Meeting, Note)'.
I'm using an API to enable visualisations of HubSpot data in Tableau (for all it's benefits, I find HubSpot enforces too much 'silo-ing' of data for full analysis of results across different entities), and from looking at tables via Tableau Prep, there appear to be a number of email/campaign related tables underlying HubSpot - 'Campaign', 'CampaignEmail', and 'CampaignEmailEvent'.
It would simplify things enormously if we could see just how these are related to each other, as well as to 'Contact' and 'Company' entities. I'm sure i'll figure it out, but it would be useful to easily see what the relevant primary and foreign keys are for each relationship.
It looks like this revolves around the CRM system, and marketing emails aren't included.
Looking for how lists relate to marketing emails and contacts, and any other relationships on the marketing email delivery side of your system. Is there an ERD for those?
.png "HubSpot Employee"){kind=icon}
