Before you start
- Live data sources enabled for your organization. See Live data sources.
- Admin role in the Lightdash project.
- A private app access token. In HubSpot, go to Settings → Integrations → Private Apps, create an app, and give it read scopes for all three objects:
crm.objects.deals.read,crm.schemas.deals.read,crm.objects.contacts.read,crm.schemas.contacts.read,crm.objects.companies.readandcrm.schemas.companies.read. Copy the app’s access token.
Connect HubSpot
- On the nav bar, click Browse → Semantic Layer.
- In the sidebar, select Live data sources, then click Add.
- Select HubSpot.
- Enter a Name, such as
HubSpot. People see this name in Explore and agents use it to refer to the source. - Enter the Access token, then click Test access.
- Click Add source.
Dimensions and metrics
Each table has these fields:
Select Refresh fields from the source’s menu to read the properties again after you add one in HubSpot. A property’s field is named after its internal name, so renaming its label in HubSpot doesn’t change it.
Dropdown, radio and checkbox properties show HubSpot’s internal option values, such as
closedwon, not their labels. Filter with those values; each field’s description lists them.
Text properties can be filtered with equals and contains, which matches whole words or part of one word. Number, date, checkbox and dropdown properties can be filtered too.
Date filters work on whole days in UTC and can look ahead, which suits fields like a deal’s close date: in the next 90 days runs from today, and in the current month covers the whole month, including days still to come.
Supported features
Limits
When more records match than a query reads, Lightdash shows the first ones in the sort order you picked. Add a filter, or use Count to see how many match.
Example questions
- “How many deals in the closed won stage closed this quarter?”
- “Contacts created in the last 7 days, with their email and lifecycle stage.”
- “The 50 largest open deals, by amount.”
- “Open deals closing in the next 90 days, by close date.”