Google Merchant Center to Looker Studio
Step 1: Create a Google Merchant Center Source on Catchr
First, create a Google Merchant Center source on Catchr. Follow this tutorial to add your new source: Create a source on Catchr.
Step 2: Install the Connector
Open Looker Studio and log in with your Google account.
On the Home page, click the Create button in the top-left corner.
Select Data Source.
In the search bar, type "Catchr".
Click on the Google Merchant Center connector and press Authorize.
Step 3: Authenticate Your Google Merchant Center Account
If you did not add a source on Catchr in Step 1, you will be prompted to do it here:
Grant the connector permission to access your Google Merchant Center data.
This will link your Google Merchant Center account to Looker Studio via the Catchr connector.
Step 4: Configure Your Data Source
After authentication, select the Google Merchant Center account you want to pull data from (if you manage multiple accounts).
There aren’t any special configurations like attribution models for Google Merchant Center data.
If you want to use the default template, leave the checkbox "Use default template" checked.
Click Connect to create your data source.
Step 5: Review Data Source Fields
You'll now see the list of available fields for Google Merchant Center. Here, you can:
Modify field types (e.g., set a field as currency, percentage, etc.).
You can return to this section later to make further modifications if needed.
Step 6: Create Your Report
Once connected, click Create Report in Looker Studio.
If you didn’t use the template, you’ll see a blank report page. If you used the template, you can add a new page by clicking the page number in the top menu, then selecting Add a page at the bottom right.
Start by clicking Add a Chart and selecting your preferred chart type (e.g., time series, bar chart).
Choose the metrics and dimensions you wish to display in each chart (e.g., product performance, impressions, clicks).
Continue adding multiple charts to visualize various aspects of your Google Merchant Center performance.
Step 7: Customize Your Report
Date Range Filters: Add a date range filter to allow users to select specific time periods.
Custom Calculations: You can create calculated metrics (e.g., click-through rate, conversion rate) directly in Looker Studio.
Blending Data: If you want to compare Google Merchant Center data with other platforms (e.g., Google Ads, Facebook Ads), use the data blending feature.
Step 8: Share or Schedule Reports
To share the report, click the Share button in the top right corner and enter the email addresses of recipients.
You can also schedule the report to be sent periodically (e.g., weekly or monthly) by setting up email delivery under File > Schedule email delivery.
First, create a Google Merchant Center source on Catchr. Follow this tutorial to add your new source: Create a source on Catchr.
Step 2: Install the Connector
Open Looker Studio and log in with your Google account.
On the Home page, click the Create button in the top-left corner.
Select Data Source.
In the search bar, type "Catchr".
Click on the Google Merchant Center connector and press Authorize.
Step 3: Authenticate Your Google Merchant Center Account
If you did not add a source on Catchr in Step 1, you will be prompted to do it here:
Grant the connector permission to access your Google Merchant Center data.
This will link your Google Merchant Center account to Looker Studio via the Catchr connector.
Step 4: Configure Your Data Source
After authentication, select the Google Merchant Center account you want to pull data from (if you manage multiple accounts).
There aren’t any special configurations like attribution models for Google Merchant Center data.
If you want to use the default template, leave the checkbox "Use default template" checked.
Click Connect to create your data source.
Step 5: Review Data Source Fields
You'll now see the list of available fields for Google Merchant Center. Here, you can:
Modify field types (e.g., set a field as currency, percentage, etc.).
You can return to this section later to make further modifications if needed.
Step 6: Create Your Report
Once connected, click Create Report in Looker Studio.
If you didn’t use the template, you’ll see a blank report page. If you used the template, you can add a new page by clicking the page number in the top menu, then selecting Add a page at the bottom right.
Start by clicking Add a Chart and selecting your preferred chart type (e.g., time series, bar chart).
Choose the metrics and dimensions you wish to display in each chart (e.g., product performance, impressions, clicks).
Continue adding multiple charts to visualize various aspects of your Google Merchant Center performance.
Step 7: Customize Your Report
Date Range Filters: Add a date range filter to allow users to select specific time periods.
Custom Calculations: You can create calculated metrics (e.g., click-through rate, conversion rate) directly in Looker Studio.
Blending Data: If you want to compare Google Merchant Center data with other platforms (e.g., Google Ads, Facebook Ads), use the data blending feature.
Step 8: Share or Schedule Reports
To share the report, click the Share button in the top right corner and enter the email addresses of recipients.
You can also schedule the report to be sent periodically (e.g., weekly or monthly) by setting up email delivery under File > Schedule email delivery.
Updated on: 17/09/2024
Thank you!