Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | merchant_performance_view_year | dim | |
| Year of week (Sun-Sat) | merchant_performance_view_year_of_week | dim | ||
| Year of week (Mon-Sun) | merchant_performance_view_year_of_week_iso | dim | ||
| Year & month | merchant_performance_view_year_month | dim | ||
| Month | merchant_performance_view_month | dim | ||
| Year & week (Sun-Sat) | merchant_performance_view_year_week | dim | ||
| Year & week (Mon-Sun) | merchant_performance_view_year_week_iso | dim | ||
| Week (Sun-Sat) | merchant_performance_view_week | dim | ||
| Week (Mon-Sun) | merchant_performance_view_week_iso | dim | ||
| Day of month | merchant_performance_view_day_of_month | dim | ||
| Day of week (Sun-Sat) | merchant_performance_view_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | merchant_performance_view_day_of_week_name_iso | dim | ||
| Date | merchant_performance_view_date | dim | ||
| Datetime | merchant_performance_view_atom | dim | ||
| Account | Account name | merchant_performance_view_account_name | dim | Account name |
| Account ID | merchant_performance_view_account_id | dim | Account ID | |
| Product | Product ID | merchant_performance_view_product_id | dim | A unique identifier of your product. |
| Title | merchant_performance_view_title | dim | The name that describes your product. | |
| Brand | merchant_performance_view_brand | dim | Brand of the product. | |
| Product category | Product category (1st level) | merchant_performance_view_product_category_one | dim | The product category defined by Google and assigned to your product. |
| Product category (2nd level) | merchant_performance_view_product_category_two | dim | The product category defined by Google and assigned to your product. | |
| Product category (3rd level) | merchant_performance_view_product_category_three | dim | The product category defined by Google and assigned to your product. | |
| Product category (4th level) | merchant_performance_view_product_category_four | dim | The product category defined by Google and assigned to your product. | |
| Product category (5th level) | merchant_performance_view_product_category_five | dim | The product category defined by Google and assigned to your product. | |
| Product type | Product type (1st level) | merchant_performance_view_product_type_one | dim | The category that you defined for your product. |
| Product type (2nd level) | merchant_performance_view_product_type_two | dim | The category that you defined for your product. | |
| Product type (3rd level) | merchant_performance_view_product_type_three | dim | The category that you defined for your product. | |
| Product type (4th level) | merchant_performance_view_product_type_four | dim | The category that you defined for your product. | |
| Product type (5th level) | merchant_performance_view_product_type_five | dim | The category that you defined for your product. | |
| Custom label | Custom label 0 | merchant_performance_view_custom_label_zero | dim | The label that you assigned to the product. |
| Custom label 1 | merchant_performance_view_custom_label_one | dim | The label that you assigned to the product. | |
| Custom label 2 | merchant_performance_view_custom_label_two | dim | The label that you assigned to the product. | |
| Custom label 3 | merchant_performance_view_custom_label_three | dim | The label that you assigned to the product. | |
| Custom label 4 | merchant_performance_view_custom_label_four | dim | The label that you assigned to the product. | |
| Other | Program | merchant_performance_view_program | dim | Program to which metrics apply, for example, Free Product Listing. |
| Currency code | merchant_performance_view_currency_code | dim | Currency in which price metrics are represented. | |
| Customer country code | merchant_performance_view_customer_country_code | dim | Country where the customer is located at the time of the action. | |
| Impressions | merchant_performance_view_impressions | met | How often your product was shows on Google. | |
| Clicks | merchant_performance_view_clicks | met | The total number of clicks on your product on Google that led to visits to your product detail pages. | |
| CTR | merchant_performance_view_ctr | met | Shows how often people who saw your products on Google ended up clicking on them and visiting your product detail page. (impressions). (Clicks / impressions). | |
| Conversions | merchant_performance_view_conversions | met | Conversion are when customer completed a desired action on your website or app, such as buying your product. | |
| Conversion rate | merchant_performance_view_conversions_rate | met | Conversion rate is a ratio showing how often your customers clicked on your products on Google, completed a desired actions your website or app, such as buying your product. (Conversions / clicks). | |
| Time | Today | diagnostics_today | dim | A date field for today. |
| Account | Account name | diagnostics_account_name | dim | Account name |
| Account ID | diagnostics_account_id | dim | Account ID | |
| Product | Product ID | diagnostics_id | dim | The ID of the product for which status is reported. |
| Title | diagnostics_title | dim | The title of the product. | |
| Link | diagnostics_link | dim | The link to the product. | |
| Destination | diagnostics_product_destination | dim | The name of the destination. | |
| Status | diagnostics_status | dim | Destination approval status. | |
| Approved countries | diagnostics_approved_countries | dim | List of country codes (ISO 3166-1 alpha-2) where the offer is approved. | |
| Pending countries | diagnostics_pending_countries | dim | List of country codes (ISO 3166-1 alpha-2) where the offer is pending approval. | |
| Disapproved countries | diagnostics_disapproved_countries | dim | List of country codes (ISO 3166-1 alpha-2) where the offer is disapproved. | |
| Creation date | diagnostics_creation_date | dim | Date on which the item has been created, in ISO 8601 format. | |
| Last update date | diagnostics_last_update_date | dim | Date on which the item has been last updated, in ISO 8601 format. | |
| Google expiration date | diagnostics_google_expiration_date | dim | Date on which the item expires in Google Shopping, in ISO 8601 format. | |
| Item level issue | Issue code | diagnostics_issue_code | dim | The error code of the issue. |
| Issue servability | diagnostics_issue_servability | dim | How this issue affects serving of the offer. | |
| Issue resolution | diagnostics_issue_resolution | dim | Whether the issue can be resolved by the merchant. | |
| Issue attribute name | diagnostics_issue_attribute_name | dim | The attribute's name, if the issue is caused by a single attribute. | |
| Issue destination | diagnostics_issue_destination | dim | The destination the issue applies to. | |
| Issue description | diagnostics_issue_description | dim | A short issue description in English. | |
| Issue detail | diagnostics_issue_detail | dim | A detailed issue description in English. | |
| Issue documentation | diagnostics_issue_documentation | dim | The URL of a web page to help with resolving this issue. | |
| Issue applicable countries | diagnostics_issue_applicable_countries | dim | List of country codes (ISO 3166-1 alpha-2) where issue applies to the offer. | |
| Number of products | diagnostics_number_of_products | met | The number of products. | |
| Time | Today | product_today | dim | A date field for today. |
| Account | Account name | product_account_name | dim | Account name |
| Account ID | product_account_id | dim | Account ID | |
| Product | Item ID | product_item_id | dim | A unique identifier for the item. |
| Title | product_title | dim | Title of the item. | |
| Description | product_description | dim | Description of the item. | |
| Product link | product_product_link | dim | URL directly linking to your item's page on your website. | |
| Image link | product_image_link_gs | dim | URL of an image of the item. | |
| Image link | product_image_link | dim | URL of an image of the item. | |
| Brand | product_brand | dim | The publicly recognized name of the company that makes your product. | |
| Condition | product_condition | dim | Condition or state of the item. | |
| Availability | product_availability | dim | Availability status of the item. | |
| Feed label | product_feed_label | dim | Feed label for the item. | |
| Language | product_language | dim | The two-letter ISO 639-1 language code for the item. | |
| Source | product_source | dim | Currency in which price metrics are represented. | |
| Product Advanced | Product ID | product_product_id | dim | The REST ID of the product. |
| MPN (Manufacturer Partner Number) | product_mpn | dim | Manufacturer Part Number (MPN) of the item. | |
| GTIN | product_gtin | dim | Global Trade Item Number (GTIN) of the item. | |
| Product type | product_product_type | dim | Categories of the item. | |
| Target country | product_target_country | dim | The CLDR territory code for the item's country of sale. | |
| Google product category | product_google_product_category | dim | Google's category of the item (see Google product taxonomy). | |
| Item group ID | product_item_group_id | dim | Shared identifier for all variants of the same product. | |
| Shipping label | product_shipping_label | dim | The shipping label of the product, used to group product in account-level shipping rules. | |
| Channel | product_channel | dim | The item's channel (online or local). | |
| Sales | Price | product_price | dim | The price represented as a number. |
| Currency | product_currency | dim | The currency of the price. | |
| Tax category | product_tax_category | dim | The tax category of the product, used to configure detailed tax nexus in account-level tax settings. | |
| Custom label | Custom label 0 | product_custom_label_zero | dim | Custom label 0 for custom grouping of items in a Shopping campaign. |
| Custom label 1 | product_custom_label_one | dim | Custom label 1 for custom grouping of items in a Shopping campaign. | |
| Custom label 2 | product_custom_label_two | dim | Custom label 2 for custom grouping of items in a Shopping campaign. | |
| Custom label 3 | product_custom_label_three | dim | Custom label 3 for custom grouping of items in a Shopping campaign. | |
| Custom label 4 | product_custom_label_four | dim | Custom label 4 for custom grouping of items in a Shopping campaign. | |
| Number of products | product_number_of_products | met | The number of products. |