Support page for the
Google Merchant Connector
With the Google Merchant Connector you can report on the most important statistics of your Google Merchant account. To use the connector you can connect with your Google Account or just with your email. Both Logins will make an account in the Data Hub app. If you have any questions about the connector, go to our Support Center.
How to connect the
Google Merchant data?
Step 1.
When you’ve selected the connector in Looker Studio, you need to authorize the use of the Looker Studio Connector.
Step 2.
The next step is to authorize the Google Merchant Connector.
Step 3.
Login to your Google account and make the connection.
Step 4.
When you’ve made the connection with Looker Studio you will see all the possible fields of data with a description of what they mean.
Step 5.
When you click on ‘make report’ you will connect the data to the template.
Metrics and Dimensions of the Google Merchant Connector
You can use the following metrics and dimensions to Looker Studio:
| Name | Type | Description |
|---|---|---|
| Date | YEAR_MONTH_DAY | Date |
| Product type level 1 | TEXT | Product type level 1 |
| Product type level 2 | TEXT | Product type level 2 |
| Product type level 3 | TEXT | Product type level 3 |
| Product type level 4 | TEXT | Product type level 4 |
| Category type level 1 | TEXT | Category level 1 |
| Category type level 2 | TEXT | Category level 2 |
| Category type level 3 | TEXT | Category level 3 |
| Category type level 4 | TEXT | Category level 4 |
| Category type level 5 | TEXT | Category level 5 |
| Custom label 1 | TEXT | Custom label 1 |
| Custom label 2 | TEXT | Custom label 2 |
| Custom label 3 | TEXT | Custom label 3 |
| Custom label 4 | TEXT | Custom label 4 |
| Custom label 5 | TEXT | Custom label 5 |
| Brand | TEXT | Brand of the item. |
| Offer id | TEXT | A unique identifier for the item. |
| Title | TEXT | Title of the item. |
| Program | TEXT | Shopping Ads, Free product listings, etc |
| Currency code | TEXT | |
| Clicks | NUMBER | Clicks count the total number of clicks on your products on Google |
| Impressions | NUMBER | Impressions count how often your products were shown on Google |
| CTR | PERCENT | The CTR shows how often clicks on your products on Google |
| Product offer id | TEXT | A unique identifier for the item. |
| Product title | TEXT | Title of the item. |
| Product description | TEXT | Description of the item. |
| Product link | URL | URL of an image of the item. |
| Product image link | TEXT | URL of an image of the item. |
| Product image | IMAGE | URL of an image of the item. |
| Product targetCountry | TEXT | The CLDR territory code for the item. |
| Product content language | TEXT | Required. The two-letter ISO 639-1 language code for the item. |
| Product channel | TEXT | The item's channel (online or local). |
| Product brand | TEXT | Brand of the item. |
| Product color | TEXT | Color of the item. |
| Product Google category ID | TEXT | Google's category of the item (see Google product taxonomy). When querying products, this field will contain the user provided value. |
| Product Google category | TEXT | Google's category of the item (see Google product taxonomy). When querying products, this field will contain the user provided value. |
| Product Google category full category path | TEXT | Google's category of the item (see Google product taxonomy). When querying products, this field will contain the user provided value. |
| Product gtin | TEXT | Global Trade Item Number (GTIN) of the item. |
| Product item group id | TEXT | Shared identifier for all variants of the same product. |
| Product material | TEXT | The material of which the item is made. |
| Product price | CURRENCY_EUR | Price of the item. |
| Product sale price | CURRENCY_EUR | Advertised sale price of the item. |
| Product product height | TEXT | The height of the product in the units provided. The value must be between 0 (exclusive) and 3000 (inclusive). |
| Product product length | TEXT | The length of the product in the units provided. The value must be between 0 (exclusive) and 3000 (inclusive). |
| Product product width | TEXT | The width of the product in the units provided. The value must be between 0 (exclusive) and 3000 (inclusive). |
| Product product weight | TEXT | The weight of the product in the units provided. The value must be between 0 (exclusive) and 2000 (inclusive). |
| Product shipping weight | TEXT | The shipping weight of the product in the units provided. The value must be between 0 (exclusive) and 2000 (inclusive). |
| Product age group | TEXT | Target age group of the item. |
| Product availability | TEXT | Availability status of the item. |
| Product gender | TEXT | Target gender of the item. |
| Product ID | TEXT | The REST ID of the product. |
| Product total count | TEXT | |
| Product visibility | TEXT | The visibility of the product. Possible values: paused or active. |
| Product source | TEXT | The source of the product. |
| Product status | TEXT | The status of the product. |
| Items Total | NUMBER | Total items in the data feed |
| Items Valid | NUMBER | Total valid items in the data feed |