blog post

Import your Google My Business KPI to Google Sheets : How-to, metrics and more

Florian Cabirol
January 31, 2024
Import your Google My Business KPI to Google Sheets : How-to, metrics and more

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

With the vast amount of data available through Google My Business, capturing and analyzing this information can provide invaluable insights into your business's performance on Google. This step-by-step guide is designed to help you seamlessly connect your Google My Business account to Google Sheets using Catchr, allowing you to automate data analysis and gain deeper insights into your engagement, reviews, and overall visibility on Google.

How to connect your Google My Business account to Google Sheets

Add a source on Catchr

To get started, navigate to the Catchr homepage. From there, find and click on Source located in the left menu. Next, click on Add a Source at the top right corner. Choose Google My Business from the list of available platforms and proceed through the identification process to establish a connection between Catchr and Google My Business.

Adding a source on Catchr

Create a New Query

Open up Google Sheets and locate the Catchr option in the menu. Click on it, then select New Query to create a fresh query for transferring your Google My Business data over.

Select Your Data Source

In the query tab, select Google My Business as your desired data source. If your account doesn't immediately appear in the source list, you can easily include it by clicking on the "+" button.

Selecting data source

Select Your Account(s)

Move on to the Select account(s) tab and pick the specific Google My Business account(s) you wish to import data from.

Selecting accounts

Choose Metrics and Dimensions

Head over to the Metrics and Dimensions tabs to select the particular data points you wish to incorporate into your query. Here are a few examples of metrics and dimensions:

Metrics :

  • Account ID: Obtain the Ad Account Id.
  • Total views: The total number of times the resource was viewed.
  • Total Review Count: The total number of reviews for this location.
Selecting metrics

Dimensions :

  • Location ID: Google identifier for this location.
  • Primary Category: Category that best describes the core business this location engages in.
  • Address Language Code: BCP-47 language code of the address contents (if known).
Selecting dimensions

Ensure you select metrics and dimensions that align with your analysis and reporting needs.

Set Date Range

After picking your metrics and dimensions, proceed to the Date Range tab. This allows you to choose from preset date ranges like "Last month" or "This year", or set custom start and end dates for your data import.

Setting date range

Apply Filters

To narrow your data even further, employ filters in the Filters tab. To add a filter, complete the following fields:

  • Field: country
  • Operator: equals
  • Value: United States
Applying filters

Schedule & Customize Data Refreshness

Finally, head to the Options tab to set up automatic data refreshes for your query. Additional functionalities like "Appends rows" and "Combine rows" are available to further customize your data retrieval.

Scheduling data refresh

In sum, this guide provides a straightforward path for integrating Google My Business data into Google Sheets. By leveraging Catchr, you can efficiently automate data collection and analysis, unlocking powerful insights into your business's online presence.

Example of Google Sheets you can create to use with the Google My Business source

Google My Business data is rich and multifaceted, offering a treasure trove of insights that, when properly analyzed, can significantly impact your business strategy. By connecting Google My Business to Google Sheets, you gain the ability to create dynamic reports and dashboards that keep you informed in real time.

Examples of Google Sheets you can create include:

  • Customer Engagement Reports: Track metrics like total views, phone calls, website visits, and direction requests to analyze how customers interact with your business listing.
  • Review and Feedback Analysis: Aggregate review data such as star ratings, review counts, and review texts to monitor customer satisfaction and respond proactively to feedback.
  • Performance Dashboard: Compile key performance indicators (KPIs) into a comprehensive dashboard, including impressions across different platforms, actions taken (direction requests, phone calls, website visits), and postings engagement.
  • Local SEO Tracking Sheet: Monitor how your business is performing in search by analyzing search terms impressions and views on Google Search and Google Maps to inform your local SEO strategy.

Creating these Google Sheets empowers you to make data-driven decisions and to quickly adjust your strategies based on the performance of your Google My Business listing. The ability to automate data transfer and manipulation through Catchr saves time and increases efficiency, allowing you to focus more on strategy and less on manual data entry.

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

Import your Google My Business KPI to Google Sheets : How-to, metrics and more

Streamline your Google My Business data analysis with our comprehensive guide on integrating it into Google Sheets via Catchr. Perfect for business owners and marketers, this tutorial simplifies the process of capturing and analyzing crucial metrics like engagement, reviews, and visibility. Learn to automate data analysis, enhancing your decision-making and strategy optimization directly within Google Sheets. Ideal for those aiming to leverage Google My Business insights for improved business performance on Google.

Florian Cabirol

Explore your Google My Business Location data with PowerBi : How to, templates and metrics

Discover how to integrate Google My Business with PowerBI using Catchr, enhancing your marketing analytics capabilities. This step-by-step guide will lead you through the process of connecting, visualizing, and analyzing key metrics from Google My Business in PowerBI. Learn to track customer engagement, analyze sentiment, and gain deep insights into your business performance with this powerful integration.

Florian Cabirol

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

Connect your Google My Business Data to Looker Studio thanks to Catchr. Visualize, in one click, how your business performs from bookings to reviews. Template included !

Florian Cabirol