Alooma pulls all HubSpot data incrementally, to be as efficient as possible with your API quota. We support replication of the following HubSpot tables:
contactstable contains information about individual contacts in HubSpot. Attributes include the contact ID, first and last name, and custom attributes.
contact_liststable contains information about your HubSpot contact lists. Attributes include the list ID, name, internal list ID, portal ID, meta data, and created and updated at timestamps.
- Thee email_subscription_timeline table contains information about your HubSpot subscription changes as a time-ordered list. Attributes include the portal ID, timestamp, recipient, and the changes that were made.
email_eventstable contains information about email events and how recipients interact with content. Attributes include the email event ID, event type, recipient, portal ID, app ID, app name, email campaign ID, IP address, location, and created at timestamp. Sent by data is also included, if applicable.
recent_campaignstable contains campaign IDs with recent activity associated with the portal. Attributes include the app ID, app name, campaign ID, and last updated time. Note that this table doesn't guarantee having all campaign IDs, since it only contains ones with recent activity from the time you connected to HubSpot.