It's easier than ever to access your HubSpot data with Panoply's HubSpot Snap Connector. Consolidate HubSpot, plus all other business data, in a secure data warehouse for a single source of truth. Explore it with our SQL workbench, in-product graphs and charts, or connect your favorite BI tools for advanced reporting and analysis.
Some of the available tables Panoply can collect from HubSpot include:
Campaigns
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.
Companies
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.
Contacts
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.
Deals
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.
Engagement
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.
Forms
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.
Owners
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.
Pipelines
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
“ Panoply has given us drastic improvements in query speed and brought all our data in one place. Our visualizations in Looker are much more fast and efficient.