What Hubspot data can I extract using Kondado?

You can extract 24 different pipelines including Contacts with their property history, Deals with associated Line Items, Marketing Emails with engagement metrics, and Tickets with priority status. The data source also captures form submissions, call logs, meeting notes, custom objects, and pipeline stage definitions, covering marketing, sales, and service operations.

How do I authenticate Kondado with my Hubspot account?

Authentication requires a Private App Token generated from your Hubspot settings, which you paste into Kondado during the data source setup. This token-based connection provides controlled access to your portal's data without sharing password credentials.

What update frequency options are available for Hubspot data synchronization?

Kondado updates your data on a configurable schedule that you control, ranging from every five minutes for near-real-time monitoring to daily batches for historical analysis. You can set different frequencies for different pipelines based on your reporting needs.

Can I combine Hubspot data with other sources in my analytics?

Yes, you can join Hubspot data with information from advertising platforms, financial systems, or other CRMs when you send everything to a centralized destination like BigQuery or PostgreSQL . This enables cross-platform attribution modeling and unified customer journey mapping.

Which BI tools work with replicated Hubspot data?

Replicated Hubspot data works seamlessly with Power BI , Looker Studio , Tableau, and other analytics platforms. You can also analyze directly in Google Sheets or Excel for quick ad-hoc reporting.

How can I track marketing campaign ROI using Hubspot data?

Combine the Marketing Emails pipeline with Contacts form submissions and Deals data to calculate cost per lead and conversion rates by campaign. Add Line Items and Payments data to determine actual revenue attribution down to specific email sends and landing page conversions.

What sales metrics can I monitor with the Hubspot data source?

Track pipeline velocity using Deals and Pipelines data, measure rep productivity through Engagements: Calls and Engagements: Tasks, and forecast revenue by analyzing Property History for deal stage movements. The Owners pipeline helps you distribute and balance opportunity assignments across your team.

Can I analyze customer service performance with this data?

Yes, the Tickets pipeline captures resolution times, priority levels, and status changes, while Feedback Submissions provide CSAT scores and customer comments. Combine these with Contacts and Companies data to identify which customer segments require the most support resources.

Send Hubspot data to reports, spreadsheets and ETL

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Hubspot Data Pipelines for Analytics and Reporting

Access comprehensive Hubspot data including CRM records, marketing campaign metrics, sales pipeline information, and customer service interactions. Replicate contacts with their complete engagement history, deals with associated line items and payment records, marketing email performance with detailed open rates and click data, and support tickets with priority levels and resolution times. Pull form submission data, call dispositions, meeting notes, and custom object records to build a complete view of your inbound marketing and sales funnel.

Kondado’s Hubspot data source offers 24 pipelines covering 805 fields, including Companies, Contacts, Deals, Marketing Emails, Engagements, Tickets, and Property History. This direct integration captures sales pipeline stages, contact list memberships, email event sequences, and property change logs without requiring manual API configuration.

Marketing teams can analyze campaign attribution by combining Marketing Emails data with Contacts form submissions to track complete conversion paths from first touch to closed deal. Sales operations teams monitor pipeline velocity using Deals, Pipelines, and Engagements data to identify bottlenecks and optimize stage-to-stage progression. Data analysts create unified customer 360 views by joining Contacts with Companies, Line Items, and Feedback Submissions for comprehensive revenue forecasting and customer satisfaction analysis. Operations managers track team productivity through Owners, Tasks, and Tickets data to balance workloads across departments.

The Kondado platform takes care of refreshing Hubspot data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing Hubspot data in your report, spreadsheet, data warehouse, data lake, or database

The available pipelines cover every aspect of your Hubspot operations, from lead generation to customer retention. Extract Contacts lists membership to segment your audience by behavior and engagement level, then analyze Marketing Emails performance to identify which campaigns drive the highest open rates and conversions. Monitor sales effectiveness through Engagements: Calls and Engagements: Meetings data to track rep activity and meeting outcomes, while Deals and Line Items provide granular visibility into revenue opportunities and product performance. Property History enables trend analysis by showing how deal values, contact statuses, and ticket priorities change over time. Combining these pipelines allows you to calculate customer acquisition costs by joining Marketing Emails spend data with Leads and Deals conversion rates, or analyze support impact on retention by correlating Tickets resolution times with Payments and Feedback Submissions. With automated updates on a configurable schedule ranging from every five minutes to daily, your Hubspot analytics dashboards always reflect current KPIs for timely decision-making.

Try out all the features for free for 14 days

Available Hubspot data

available pipelines

805

extractable fields

Available integrations

Integration	Description
Companies	Includes information such as id, name, and properties related to contacts and deals.
Contact lists	Presents contact lists with details on membership and relevant properties.
Contacts	Brings contact information such as id, email, name, and created date.
Contacts: form submissions	Includes form submissions with fields such as conversion id, content type, and form id.
Contacts: lists membership	Displays the association of contacts to specific lists and their properties.
Custom object	Represents custom objects with fields such as id and specific properties.
Deals	Contains information about deals, including id, value, and related contacts.
Email events	Records email events with details on sending, opens, and clicks.
Engagements: Calls	Includes call details such as id, dispositions, and related objects.
Engagements: Emails	Presents email details including id and related objects.
Engagements: Meetings	This table contains information about meetings, including fields such as id, contact_id, company_id, and updated_at.
Engagements: Notes	Notes table includes fields such as id, contact_id, body, and created_at, allowing tracking of relevant information.
Engagements: Tasks	Tasks table presents fields such as id, contact_id, due_date, and status, facilitating activity management.
Feedback Submissions	Feedback submissions table includes fields such as id, contact_id, feedback_type, and created_at, allowing analysis of responses.
Leads	Leads table contains information such as id, email, status, and created_at, essential for managing potential customers.
Line Items	Line items table presents fields such as id, deal_id, product_id, and quantity, useful for tracking sales.
Marketing Emails	Marketing emails table includes fields such as id, subject, sent_date, and open_rate, allowing analysis of campaigns.
Owners	Owners table contains fields such as id, name, email, and created_at, essential for user management.
Payments	Payments table includes fields such as id, amount, payment_date, and status, useful for financial control.
Pipelines	Pipelines table presents fields such as id, name, stage, and created_at, important for sales management.
Products	Table contains information about products, including fields such as id, name, price, and description.
Properties Metadata	Table presents metadata of properties, including fields such as name, type, and description.
Property History	Table logs changes to properties, with fields such as id, created_at, and previous_value.
Tickets	Table includes information about tickets, with fields such as id, status, priority, and created_at.

Companies

Includes information such as id, name, and properties related to contacts and deals.

Contact lists

Presents contact lists with details on membership and relevant properties.

Contacts

Brings contact information such as id, email, name, and created date.

Contacts: form submissions

Includes form submissions with fields such as conversion id, content type, and form id.

Contacts: lists membership

Displays the association of contacts to specific lists and their properties.

Custom object

Represents custom objects with fields such as id and specific properties.

Deals

Contains information about deals, including id, value, and related contacts.

Email events

Records email events with details on sending, opens, and clicks.

Engagements: Calls

Includes call details such as id, dispositions, and related objects.

Engagements: Emails

Presents email details including id and related objects.

Engagements: Meetings

This table contains information about meetings, including fields such as id, contact_id, company_id, and updated_at.

Engagements: Notes

Notes table includes fields such as id, contact_id, body, and created_at, allowing tracking of relevant information.

Engagements: Tasks

Tasks table presents fields such as id, contact_id, due_date, and status, facilitating activity management.

Feedback Submissions

Feedback submissions table includes fields such as id, contact_id, feedback_type, and created_at, allowing analysis of responses.

Leads

Leads table contains information such as id, email, status, and created_at, essential for managing potential customers.

Line Items

Line items table presents fields such as id, deal_id, product_id, and quantity, useful for tracking sales.

Marketing Emails

Marketing emails table includes fields such as id, subject, sent_date, and open_rate, allowing analysis of campaigns.

Owners

Owners table contains fields such as id, name, email, and created_at, essential for user management.

Payments

Payments table includes fields such as id, amount, payment_date, and status, useful for financial control.

Pipelines

Pipelines table presents fields such as id, name, stage, and created_at, important for sales management.

Products

Table contains information about products, including fields such as id, name, price, and description.

Properties Metadata

Table presents metadata of properties, including fields such as name, type, and description.

Property History

Table logs changes to properties, with fields such as id, created_at, and previous_value.

Tickets

Table includes information about tickets, with fields such as id, status, priority, and created_at.

See all available data →

Try out all the features for free for 14 days

How to visualize Hubspot data in 3 steps

Connect Hubspot to dashboards, spreadsheets, or databases — no code required.

Add Hubspot using Private App Token

Create a new data source in Kondado, select Hubspot, and authenticate using your Private App Token from Hubspot's Private Apps settings to establish the connection.

Select your data pipelines and destination

Choose specific pipelines such as Contacts, Deals, Marketing Emails, or Tickets, then configure delivery to BigQuery, Power BI, PostgreSQL, or other destinations including MySQL and Amazon S3.

Build dashboards and analyze data

Create visualizations in Looker Studio or Power BI, perform calculations in Google Sheets or Excel, and run SQL queries on your database tables to generate Hubspot analytics and reports.

Try out all the features for free for 14 days