It's easier than ever to analyze your HubSpot data with Panoply's HubSpot Snap Connector. Consolidate HubSpot, plus all other business data in a secure data warehouse, then explore it with our SQL workbench and in-product graphs and charts. You can also connect your favorite BI tools for more advanced HubSpot reporting and analysis.
Some of the available tables Panoply can collect from HubSpot include:
The Campaigns resource is Panoply's abstraction of HubSpot's Email Events API. This resource is used to get information about events generated by marketing emails or email campaigns sent through a HubSpot account.
The Companies resource represents company records that store information about a business or organization. This information may include any statistics created from email marketing campaigns, among others.
The Contacts resource refers to stored information about individuals. Panoply uses this resource to retrieve contact data in your account and stockpile in in our database.
The Deals resource represents an ongoing transaction that a sales team is pursuing with a contact or a company. It's tracked through pipeline stages until won or lost.
The Engagements resource store data from CRM actions, including notes, tasks, email, meetings, and calls. At a minimum, engagements should be associated with at least one CRM record.
The Forms resource represents the forms that have been created in your HubSpot account. They gather essential information about your visitors and contacts and are used to generate website leads.
The Owners resource represents the owners that are available for an account. HubSpot uses owners to assign specific users to various categories. Any HubSpot user with access to contacts can be assigned as an owner.
The Pipelines resource represents the pipelines created for an account. A pipeline describes progress towards a goal involving discrete stages. Currently, the HubSpot object types that support pipelines are Deals and Tickets.
Sync HubSpot data with multiple sources in Panoply, then access it via your BI tool