Alooma can read and replicate many of the HubSpot tables from your HubSpot account. This allows you to, among other scenarios, merge contact and email events with other data in Alooma to get deeper insights on your business.
Alooma synchronizes HubSpot data by default every 30 minutes. Since each synchronization contributes to your HubSpot API calls count, we pull all HubSpot data incrementally, to be as efficient as possible with your API quota.
You can connect HubSpot to Alooma in just a few steps:
Add your HubSpot input from Alooma's plumbing screen
Give your HubSpot input a name. The name will appear in the plumbing screen, but the names of the events themselves will be based on the replicated table names.
Supply your HubSpot API Key. You can find this by following HubSpot's instructions, in short:
Navigate to your HubSpot Account Menu and select Integrations.
Select HubSpot API key from the left side menu.
As an Account Administrator, click the blue View Key button.
Select the tables you'd like to stream to Alooma (by default we pull all the supported tables).
If there's another HubSpot table you'd like supported, feel free to reach out!
[Optionally] Under Advanced Settings you can:
Change the pull frequency. As stated above, if you choose to pull more frequently, your data will be fresher, but we'll use more of your HubSpot API calls.
Limit the number of daily API calls Alooma can make to HubSpot.
If you limit the daily calls, we'll pick up where we left off the next day. We recommend at least 100 calls per table, or we may miss data.
Keep the mapping mode to the default of OneClick if you'd like Alooma to automatically map all HubSpot tables directly to your target data warehouse. Otherwise, they'll have to be mapped manually from the Mapper screen.
That's it, you're ready to replicate your HubSpot tables to your target data warehouse!
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.
email_subscription_timelinetable 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.