Looker Studio templates

HubSpot report template for Looker Studio

Unlock the full potential of your HubSpot data with this Looker Studio template. Track sessions, new contacts, customers, and page performance in a centralized dashboard. Analyze traffic sources, form submissions, UTM campaigns, and email engagement. Gain insights into audience behavior, optimize marketing strategies, and drive growth with data-driven decisions to enhance your lead generation and customer conversion efforts.

Connectors used in this template:
No items found.
How the template can help

Questions you can answer with this template

Website traffic and sources

  • How many sessions has my website received?
  • Which traffic sources are driving the most sessions?
  • What is the session-to-contact conversion rate for each source?
  • How does traffic performance vary between paid, organic, and referral sources?

Contact and customer insights

  • How many new contacts have been generated during the selected period?
  • What is the contact-to-customer conversion rate?
  • How many leads and customers have been added to the database?
  • Which sources are driving the highest number of new contacts and customers?

Page performance

  • Which pages have the most views and entrances?
  • What is the average time per page view across all pages?
  • Which pages have the highest bounce rates, and why?
  • How does engagement vary across different pages and content types?

Form performance

  • How many form views and submissions have been recorded?
  • What is the form view-to-submission conversion rate?
  • Which forms generate the most leads?
  • Are there any forms with particularly high or low performance?

UTM campaign tracking

  • Which UTM campaigns drive the most traffic to the website?
  • How do different UTM sources and mediums perform?
  • What is the session-to-contact rate for each UTM campaign?
  • Which UTM campaigns contribute the most to new contacts and conversions?

Email marketing performance

  • How many emails have been sent during the selected period?
  • What are the open, click, and click-through rates for my email campaigns?
  • Which email campaigns generate the most engagement?
  • How do bounce and unsubscribe rates impact email performance?

Device and location insights

  • What devices are my visitors using to access the website?
  • How do session and engagement rates differ between mobile and desktop users?
  • Which countries generate the most traffic to my site?
  • Are there significant performance differences based on visitor location?

Deal performance

  • How many deals have been created, won, and lost?
  • What is the total value of deals closed during the selected period?
  • How does deal performance vary across different pipelines?
  • Which deal stages experience the most movement and success?
Done in a snap

How to use the template

  1. Connect your HubSpot user in your Reporting Ninja account.
  2. Start creating a Looker Studio data source by clicking on the button ‘Get the template’ below.
  3. Authenticate your account by clicking on ‘Authorize’.
  4. Enter the token your can find the Looker Studio area in your Reporting Ninja account.
  5. Choose an account. The account and the blue check mark next to ‘Use report template for new reports’ must be selected. Other parameters are optional.
  6. Once you’re happy, click on ‘Connect’ in the top-right.
  7. The next page will display all available dimensions and metrics.
  8. Click 'Create report'. After this, the template will fetch all your data in the report, ready for you to derive insights!