HubSpot Connector
Start moving your HubSpot data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.
View more about the HubSpot connector in the Weld documentation
Explore available HubSpot data
Browse all the data tables available for the HubSpot connector, in our interactive ERD data viewer.
View the HubSpot Data SchemaTransform and model HubSpot data
Get clean data models from your HubSpot data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.
HubSpot
raw.hubspot.table1
raw.hubspot.table2
Get started with HubSpot SQL Templates
Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for HubSpot.
New companies by month
Retrieves a list of new companies created each month from the HubSpot integration and groups them by month. The results are ordered by month.
Closed won deals by owner
Retrieves the number of closed won deals by owner from HubSpot and orders them in descending order based on the number of deals.
Closed lost deals by owner
Retrieves the number of closed lost deals by owner from HubSpot and orders them by the highest number of deals. It uses a left join to match the owner ID from the deals table to the owners table and concatenates the first and last name of the owner for readability.
Closed won deals amount by owner
Retrieves the total amount of closed won deals for each owner in HubSpot and orders them in descending order.
Emails by owner
Retrieves the number of emails sent by each owner in HubSpot by joining the engagements and owners tables and grouping the results by owner.
View all HubSpot templatesStart working with your HubSpot data today
Get started building your data warehouse with HubSpot and connect all your apps and databases
Explore more connectors
Select the tools you need data from and start syncing your data now.
View all Marketing connectors
