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.
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
How to create Hubspot dashboards in Looker
Visualize your data automatically — no spreadsheet exports or custom scripts.
1
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.
2
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.
3
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.
Try out all the features for free for 14 days
Access Hubspot data in Looker and combine it with dozens of other data sources
If the source you want is not listed, drop us a chat message. We love to add new sources!
Answers about visualizing Hubspot data in Looker automatically
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.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)