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

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.

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.

Select Your Account(s)

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

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.

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.

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.

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.

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.

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.

‍