blog post

Connect Google My Business to Looker Studio : How-to, templates and metrics...

Florian Cabirol
November 21, 2023
Connect Google My Business to Looker Studio : How-to, templates and metrics...

Quick steps to create a Google My Business report with Google Sheets:

You can easiliy create a Google My Business report following this step :

  1. Get informations from the data integration from our Google My Business connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Google My Business data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Google My Business report with Looker Studio:

You can easiliy create a Google My Business report following this step :

  1. Get informations from the data integration from our Google My Business connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Google My Business at the end of the page.

The tutorial

Quick steps to create a Google My Business report with PowerBI:

You can easiliy create a Google My Business report following this step :

  1. Get informations from the data integration from our Google My Business connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Google My Business at the end of the page.

The tutorial

Welcome to this tutorial where we will guide you through the process of connecting your Google My Business account with Looker Studio, formerly Google Data Studio. By the end of this guide, you will have access to dynamic and customizable reports on Looker Studio using rich metrics from Google My Business.

How to connect your Google My Business account to Looker Studio

Create an Account on Looker Studio

If you're new to Looker Studio, your first step will involve setting up an account. You'll find that if you already have a Google account, you're partway there – simply link this existing account to begin working on Looker Studio.

Creating a Looker Studio account

Connect Google My Business to Looker Studio

Let's navigate through the essentials to link your Google My Business to Looker Studio:

  • Head over to your Looker Studio homepage and click on "Create"
Looker Studio dashboard - Create
  • From the dropdown, choose "Report".
Report selection
  • Within the data sources gallery, search and select the Catchr Google My Business data connector.
Catchr Google My Business data connector

Step-by-step guide on the authorization step:

When it's your first time authorizing this connection:

  • Looker Studio will need your permission to employ the Catchr community connector.
Authorize Catchr connector in Looker Studio
  • Select the Google Account you intend to use.
Selecting Google Account
  • Scroll through the permissions required by Looker Studio and then proceed to 'Allow'.
Looker Studio permissions
  • After granting Looker Studio access, it's time to authorize the connector to retrieve your Google My Business information.
Allow access to Looker Studio
  • Click 'Authorize' beneath the section outlining the need for authorization to connect Google My Business data with Looker Studio.
Authorize Catchr for Google My Business
  • A prompt will appear with instructions to finalize authorization. After completion, a confirmation window will pop up.
Authorization confirmation
  • Wait for the process to load, then continue by scrolling down.
Loading process
  • Choose the account for which Catchr should have the rights to access Google My Business data, and select "Add".
Select account and add
  • Occasionally, you might find the 'Add' button displaced, situated either at the bottom right as "Create Report" or at the top right titled "Report".

And there you have it. Your Google My Business account is now successfully linked to Looker Studio, enabling you to transform raw data into visually impactful and insightful reports.

Example of Metrics You Can Harness with Looker Studio Integration for Google My Business

You now have at your disposal a plethora of insightful metrics from Google My Business to enrich your Looker Studio dashboards. These metrics span from essential identifiers such as Account ID and Location Name to performance indicators like Average Rating Review and Total Review Count.

Imagine being able to visually track how many phone calls your listing generates over time, or understanding how users interact with different categories of your posts. For detailed insights, Looker Studio's ability to create custom visualizations can illuminate trends in Review Ratings or the impact of specific offers. The granularity of the data allows for rich analysis, such as comparing Views on Maps versus Views on Search.

By analyzing which Search Terms lead to the most impressions, businesses can tailor their SEO strategies for more effective online presence. Similarly, utilizing data on Actions, such as Website Visits or Food Orders, can directly inform and measure the success of marketing initiatives.

This data-driven approach empowers businesses to understand customer engagement deeply and make informed decisions for growth strategies. Tap into the full list of available metrics from Catchr and start visualizing your marketing data in Looker Studio, crafting compelling stories from your numbers.

Bonus : Your free Template Google My Business V2 Template

In this Google My Business template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this Google My Business template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Google My Business