How do I connect Hubspot to Looker using Kondado?

Start by selecting Hubspot as your data source in the Kondado platform, then authenticate with your Hubspot credentials. Choose Looker as your destination and configure which pipelines you want to replicate, such as Deals, Contacts, or Email Events. Your data will begin flowing immediately, with updates occurring on your chosen schedule without any coding required.

What Hubspot data can I visualize in Looker?

You can access 24 different pipelines including Contacts, Companies, Deals, Tickets, and Marketing Emails to build comprehensive reports. Each pipeline contains specific fields like deal values, contact properties, and email open rates that you can transform into visual charts. This allows you to analyze everything from lead generation to customer support performance in one place.

How often does Hubspot data update in Looker?

You control the refresh frequency based on your business needs, choosing intervals from every 5 minutes to daily updates. This configurable schedule ensures your dashboards reflect recent activities without overwhelming your system with unnecessary updates. Marketing teams often prefer hourly refreshes for campaign monitoring, while sales teams might select 15-minute intervals for pipeline management.

Can I build a sales pipeline dashboard in Looker with Hubspot data?

Yes, using the Deals and Pipelines data you can create visualizations showing deal stages, values, and conversion rates across your sales process. Combine this with the Owners pipeline to see individual rep performance and identify bottlenecks in your funnel. These insights help sales managers forecast revenue and allocate resources more effectively.

Is there a pre-built Hubspot dashboard template for Looker?

Kondado does not provide pre-built report templates for Looker, allowing you to build custom dashboards tailored to your specific KPIs and business questions. You have complete flexibility to design visualizations that match your agency's reporting style or internal brand requirements. This approach ensures you track the exact metrics that matter most to your stakeholders.

How do I share Hubspot reports with my team in Looker?

Once you build your dashboards in Looker, use Looker's native sharing features to distribute reports to stakeholders across your organization. Team members can view the latest Hubspot metrics without needing access to the original CRM, ensuring everyone works from the same data. You can also schedule automated email delivery of these reports to keep leadership informed.

Can I combine Hubspot data with other sources in Looker?

Yes, Kondado enables you to bring data from multiple sources into your visualization tool alongside Hubspot information. You might combine Hubspot marketing data with financial information from Google Sheets or product usage data from BigQuery . This creates unified reports that show the complete customer journey across all your business systems.

What KPIs should I track when visualizing Hubspot in Looker?

Focus on metrics like lead-to-customer conversion rates, average deal size from the Deals pipeline, and email engagement scores from Marketing Emails. You should also monitor ticket resolution times using the Tickets data and track list growth through Contact Lists to measure inbound marketing success. These indicators provide a complete picture of your marketing, sales, and service performance.

Connect Hubspot to Looker: Dashboards in Minutes

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

How to Visualize Hubspot Data in Looker

Connecting your Hubspot account to Looker allows marketing and sales teams to transform raw CRM data into actionable visual insights that drive business growth. With Kondado, you can replicate information from your marketing automation, sales pipeline, and customer service activities directly into Looker without complex technical setup or intermediate databases.

Kondado provides a direct integration between Hubspot and Looker, replicating data on a configurable schedule to keep your reports updated automatically.

Once connected, business users can build custom dashboards tracking lead generation, deal progression, and campaign performance using near-real-time data refreshed every few minutes or on an hourly basis. This connection helps agencies and SMBs make faster decisions by visualizing Hubspot metrics alongside other business data sources, all without writing code or managing complex infrastructure. Marketing managers can monitor conversion rates while sales leaders track pipeline health, creating a single source of truth for revenue operations. The platform connects 80+ sources, enabling comprehensive reporting across your entire tech stack.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

With Kondado’s Hubspot to Looker connection, you can unlock powerful insights by combining customer behavior data with sales performance metrics in visual reports. The Deals and Contacts pipelines let you analyze conversion funnels from first touch to closed won, while Email Events data reveals which campaigns actually drive meaningful engagement. Marketing teams can track list growth and segment performance through the Contact Lists pipeline, and service managers can monitor ticket resolution times using the Tickets data to improve customer satisfaction scores. These combined datasets enable agencies to demonstrate ROI to clients and help internal teams optimize their inbound strategy.

Try out all the features for free for 14 days

Hubspot data available in Looker

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 create Hubspot dashboards in Looker

Visualize your data automatically — no spreadsheet exports or custom scripts.

Connect Hubspot as data source

Select Hubspot from Kondado's available data sources and authenticate your account to establish the initial connection. Choose which pipelines you need, such as Contacts, Deals, or Email Events, to begin replicating your CRM data.

Select Looker destination

Choose Looker as your visualization destination and configure the connection settings to establish the data flow. This creates a direct link that sends your Hubspot information directly into Looker without requiring intermediate storage or complex setup.

Build dashboards and configure refresh

Create custom reports in Looker using your replicated Hubspot data, then set your preferred update schedule ranging from every 5 minutes to daily refreshes. Your dashboards will stay current automatically, giving your team always-accessible visual insights for decision making.