blog post

Import your Google Merchant center KPI to Google Sheets : How-to, metrics and more

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

Quick steps to create a Google Merchant Center report with Google Sheets:

You can easiliy create a Google Merchant Center report following this step :

  1. Get informations from the data integration from our Google Merchant Center 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 Merchant Center 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 Merchant Center report with Looker Studio:

You can easiliy create a Google Merchant Center report following this step :

  1. Get informations from the data integration from our Google Merchant Center 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 Merchant Center at the end of the page.

The tutorial

Quick steps to create a Google Merchant Center report with PowerBI:

You can easiliy create a Google Merchant Center report following this step :

  1. Get informations from the data integration from our Google Merchant Center 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 Merchant Center at the end of the page.

The tutorial

In this comprehensive tutorial, you'll embark on a streamlined journey to bridge your Google Merchant Center with Google Sheets. The aim is to empower marketing professionals like you with the capability to effortlessly visualize and analyze your marketing data within the familiar and flexible environment of Google Sheets. By the conclusion, you'll possess mastery over the process, enabling you to craft insightful reports and dashboards that drive strategic decisions.

How to connect your Google Merchant Center account to Google Sheets

Add a source on Catchr

Navigate to the Catchr homepage and locate the Source option within the left-hand menu. Click on Add a Source situated at the top right corner of your screen. Choose the appropriate platform, in this case, Google Merchant Center, and proceed through the identification process to establish a connection between Catchr and the selected platform.

Adding a source in Catchr

Create a New Query

Launch Google Sheets and look for the Catchr tab in the menu. Select "New Query" to set up a new query aimed at importing your Google Merchant Center data into the sheet.

Select Your Data Source

In the new query tab, pick Google Merchant Center as your data source. Should your account not appear in the provided list, simply add a new source by tapping on the "+" icon.

Selecting data source in Catchr

Select Your Account(s)

Under the "Select account(s)" section, choose the Google Merchant Center account(s) you wish to pull data from.

Selecting accounts in Catchr

Choose Metrics and Dimensions

Proceed to the Metrics and Dimensions tabs to specify the data points you'd like to include. Consider incorporating the following:

Metrics:

  • Account Name: Display name for the account.
  • Adult Content: Indicates whether the merchant sells adult content.
  • Active offers: Number of active offers.
Choosing metrics in Catchr

Dimensions:

  • Country: Account country (e.g., US)
  • Device Type: Merchant Center ID.
  • Browser: Website URL of the merchant.

Make sure to select metrics and dimensions that align with your analysis and reporting needs.

Choosing dimensions in Catchr

Set Date Range

After choosing your metrics and dimensions, navigate to the "Date Range" tab. Here, you can opt for preset date ranges like "Last month" or "This year", or define custom start and end dates for your data query.

Setting date range in Catchr

Apply Filters

For more targeted data, utilize filters under the "Filters" section by populating the fields as follows:

  • Field: Country
  • Operator: Equals
  • Value: United States

This example filters the data for visitors from the United States.

Applying filters in Catchr

Schedule & Customize Data Refreshness

Last but not least, visit the "Options" section to schedule automated refreshes for your query. Here, you can also enable features like "Append rows", which adds newfound data rows to the bottom of your query range, or "Combine rows" for updating all rows within the selected range.

Scheduling data refresh in Catchr

With these steps, you've successfully connected your Google Merchant Center to Google Sheets, unlocking new horizons for data visualization and analytics.

Example of Google Sheets you can create to use with the Google Merchant Center source

Connecting Google Merchant Center to Google Sheets opens up a world of possibilities for creating detailed reports and dashboards tailored to your business needs. For instance, you can craft a Product Performance Dashboard, enabling you to see at a glance which products are your top performers in terms of views, sales, and profitability. This visibility helps in making informed decisions about stocking, promotion strategies, and discontinuation of underperforming products.

Another impactful application is a Marketing Analysis Report. By tracking metrics like Active Offers, Pending, Disapproved Offers, and Expiring alongside dimensions such as Country and Device Type, you can gauge the effectiveness of your current marketing strategies, adapt to market trends, and identify areas for improvement.

In order to cater to businesses with a global customer base, a Geographical Insights Sheet could be invaluable. By analyzing data such as Account Country, and correlating it with Active Offers and Sales, you can uncover invaluable insights into which regions are most receptive to your products, thereby fine-tuning your global marketing efforts.

Lastly, a Customer Service Feedback Report can assist in maintaining a high level of customer satisfaction. By pulling in data points like Customer Service Email and Phone Number alongside product and sales data, you can keep track of customer inquiries and issues, ensuring they are resolved promptly to maintain or improve customer satisfaction rates.

Each Google Sheet you create becomes a powerful asset in understanding your business, driving efficiencies, improving customer satisfaction, and ultimately, boosting your bottom line. Dive into these possibilities with Catchr, and elevate your data analysis to the next level.

No items found.

In this Google Merchant Center 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 Merchant Center 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 Merchant Center

Import your Google Merchant center KPI to Google Sheets : How-to, metrics and more

Effortlessly integrate Google Merchant Center data into Google Sheets with Catchr, enabling advanced visualization and analysis for strategic decision-making. Ideal for marketing professionals seeking to enhance reporting and insights.

Florian Cabirol

Explore your Google Merchant Center Product KPI with PowerBI : how-to, templates and metrics..

Unlock the full potential of your Google Merchant Center data with PowerBI through Catchr. This guide will walk you through the steps to connect, visualize, and analyze crucial marketing metrics, enabling you to make informed decisions and optimize your digital marketing strategies. Learn to harness the power of PowerBI for detailed insights into inventory levels, pricing trends, product conditions, and more, transforming raw data into actionable intelligence for your business.

Florian Cabirol

Connect Google Merchant Center to Looker Studio : How-to, templates and metrics...

Get all shopping products data in Looker Studio thanks to the Google Merchant Center connector. Free templates included.

Florian Cabirol