Google Merchant Center

Google · Disponível

Consultar via API

GET https://askaner.askan.com.br/api/v1/data/google_merchant?fields=date,account_id&date_preset=last_30d
Authorization: Bearer ik_...

Campos (33 métricas, 108 dimensões)

ID	Tipo	Natureza	Descrição
`cv_benchmark_category_id`	TEXT	Dimensão	The Google product taxonomy category ID the benchmark applies to. reports
`cv_benchmark_category_visibility_trend`	NUMERIC	Métrica	Change in the category average visibility relative to the first day of the requested range, as a fraction. reports
`cv_benchmark_country`	COUNTRY	Dimensão	The CLDR territory code of the country the benchmark applies to. reports
`cv_benchmark_date`	DATE	Dimensão	Date in the merchant timezone to which the benchmark applies. reports
`cv_benchmark_traffic_source`	TEXT	Dimensão	Traffic source of the impressions: ADS, ORGANIC or ALL. reports
`cv_benchmark_your_domain_visibility_trend`	NUMERIC	Métrica	Change in your visibility relative to the first day of the requested range, as a fraction. reports
`cv_competitor_ads_organic_ratio`	NUMERIC	Métrica	Ratio of ads impressions to organic impressions for the domain. reports
`cv_competitor_category_id`	TEXT	Dimensão	The Google product taxonomy category ID the ranking applies to. reports
`cv_competitor_country`	COUNTRY	Dimensão	The CLDR territory code of the country the ranking applies to. reports
`cv_competitor_domain`	TEXT	Dimensão	Domain of one of the businesses with similar visibility to yours. reports
`cv_competitor_higher_position_rate`	NUMERIC	Métrica	Fraction of impressions where the domain was shown in a higher position than your domain on the same page. reports
`cv_competitor_is_your_domain`	BOOLEAN	Dimensão	True if the domain is your own domain. reports
`cv_competitor_page_overlap_rate`	NUMERIC	Métrica	Fraction of impressions where your domain and the domain both appeared on the same page. reports
`cv_competitor_rank`	NUMERIC	Métrica	Position of the domain in the competitor ranking by impressions, where 1 is the highest. reports
`cv_competitor_relative_visibility`	NUMERIC	Métrica	Visibility of the domain relative to your own, as a fraction (negative means less visible than you). reports
`cv_competitor_traffic_source`	TEXT	Dimensão	Traffic source of the impressions: ADS, ORGANIC or ALL. reports
`cv_top_merchant_ads_organic_ratio`	NUMERIC	Métrica	Ratio of ads impressions to organic impressions for the domain. reports
`cv_top_merchant_category_id`	TEXT	Dimensão	The Google product taxonomy category ID the ranking applies to. reports
`cv_top_merchant_country`	COUNTRY	Dimensão	The CLDR territory code of the country the ranking applies to. reports
`cv_top_merchant_domain`	TEXT	Dimensão	Domain of one of the businesses with the highest visibility. reports
`cv_top_merchant_higher_position_rate`	NUMERIC	Métrica	Fraction of impressions where the domain was shown in a higher position than your domain on the same page. reports
`cv_top_merchant_is_your_domain`	BOOLEAN	Dimensão	True if the domain is your own domain. reports
`cv_top_merchant_page_overlap_rate`	NUMERIC	Métrica	Fraction of impressions where your domain and the domain both appeared on the same page. reports
`cv_top_merchant_rank`	NUMERIC	Métrica	Position of the domain in the top merchants ranking by impressions, where 1 is the highest. reports
`cv_top_merchant_traffic_source`	TEXT	Dimensão	Traffic source of the impressions: ADS, ORGANIC or ALL. reports
`product_status_active_count`	NUMERIC	Métrica	Number of active products for the reporting context and country. aggregateProductStatuses
`product_status_country`	COUNTRY	Dimensão	The CLDR territory code of the country the aggregate product status applies to. aggregateProductStatuses
`product_status_disapproved_count`	NUMERIC	Métrica	Number of disapproved products for the reporting context and country. aggregateProductStatuses
`product_status_expiring_count`	NUMERIC	Métrica	Number of expiring products for the reporting context and country. aggregateProductStatuses
`product_status_pending_count`	NUMERIC	Métrica	Number of products pending review for the reporting context and country. aggregateProductStatuses
`product_status_reporting_context`	TEXT	Dimensão	The destination (reporting context) the aggregate product status applies to, for example SHOPPING_ADS or FREE_LISTINGS. aggregateProductStatuses
`account_id`	TEXT	Dimensão	The Google Merchant account ID. accounts
`account_name`	TEXT	Dimensão	The Google Merchant account name. accounts
`data_fetched_at`	TIMESTAMP	Dimensão	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
`datasource`	TEXT	Dimensão	The name of the Windsor connector returning the row
`date`	DATE	Dimensão	Universal date field, for product performance contains value of product_performance_date field, for other product related queries contains date part of product_creation_time field, and if only account data (like account_name) queried, contains date when the quiery is being made.
`day_of_month`	TEXT	Dimensão	Day of the month
`month`	TEXT	Dimensão	Number of the month
`now`	TIMESTAMP	Dimensão	Current timestamp
`product_ads_grouping`	TEXT	Dimensão	Used to group items in an arbitrary way. Only for CPA%, discouraged otherwise. products
`product_ads_redirect`	TEXT	Dimensão	Allows advertisers to override the item URL when the product is shown within the context of Product ads. products
`product_adult`	BOOLEAN	Dimensão	Set to true if the item is targeted towards adults. products
`product_age_group`	TEXT	Dimensão	Target age group of the item. products
`product_availability`	TEXT	Dimensão	Availability status of the item. For example, "inStock" or "out_of_stock". products
`product_availability_date`	DATE	Dimensão	The day a pre-ordered product becomes available for delivery, in ISO 8601 format. products
`product_benchmark_price`	NUMERIC	Métrica	Latest available price benchmark for the product's catalog in the benchmark country. reports
`product_benchmark_price_currency_code`	TEXT	Dimensão	Currency Code for latest available price benchmark for the product's catalog in the benchmark country. Product Benchmark Price should be requested for the field to be available. reports
`product_brand`	TEXT	Dimensão	Brand of the item. For example, "Google". products
`product_canonical_link`	TEXT	Dimensão	URL for the canonical version of your item's landing page. products
`product_category_l1`	TEXT	Dimensão	Product category (1st level) in Google's product taxonomy. reports
`product_category_l2`	TEXT	Dimensão	Product category (2nd level) in Google's product taxonomy. reports
`product_category_l3`	TEXT	Dimensão	Product category (3rd level) in Google's product taxonomy. reports
`product_category_l4`	TEXT	Dimensão	Product category (4th level) in Google's product taxonomy. reports
`product_category_l5`	TEXT	Dimensão	Product category (5th level) in Google's product taxonomy. reports
`product_channel`	TEXT	Dimensão	Channel of the product. Can be ONLINE or LOCAL. reports
`product_click_potential`	TEXT	Dimensão	Estimated performance potential compared to highest performing products of the merchant. reports
`product_click_potential_rank`	NUMERIC	Métrica	Rank of the product based on its click potential. A product with clickPotentialRank1 has the highest click potential among the merchant's products that fulfill the search query conditions. reports
`product_click_uplift`	PERCENT	Métrica	Predicted change in clicks as a fraction afterintroducing the suggested price compared to current active price.For example, 5 is a 5% predicted increase in clicks. reports
`product_clicks`	NUMERIC	Métrica	Number of clicks. reports
`product_color`	TEXT	Dimensão	Color of the item. For example, "red". products
`product_condition`	TEXT	Dimensão	Condition or state of the item. For example, "new" or "used". products
`product_content_language`	TEXT	Dimensão	The two-letter ISO 639-1 language code for the product. products
`product_conversion_rate`	PERCENT	Métrica	Number of conversions divided by the number of clicks, reported on the impression date. Available only for the FREE traffic source. reports
`product_conversion_uplift`	PERCENT	Métrica	Predicted change in conversions as a fraction afterintroducing the suggested price compared to current active price.For example, 5 is a 5% predicted increase in conversions. reports
`product_conversions`	NUMERIC	Métrica	Number of conversions attributed to the product, reported on the conversion date. Depending on the attribution model, a conversion might be distributed across multiple clicks, where each click gets its own credit assigned. This metric is a sum of all such credits. Available only for the FREE traffic source. reports
`product_creation_date`	DATE	Dimensão	The date the merchant created the product. products
`product_creation_time`	TIMESTAMP	Dimensão	The time the merchant created the product in timestamp seconds. reports
`product_ctr`	PERCENT	Métrica	Click-through rate - the number of clicks merchant's products receive (clicks) divided by the number of times the products are shown (impressions).
`product_custom_label_0`	TEXT	Dimensão	Custom label 0 for custom grouping of items in a Shopping campaign. products
`product_custom_label_1`	TEXT	Dimensão	Custom label 1 for custom grouping of items in a Shopping campaign. products
`product_custom_label_2`	TEXT	Dimensão	Custom label 2 for custom grouping of items in a Shopping campaign. products
`product_custom_label_3`	TEXT	Dimensão	Custom label 3 for custom grouping of items in a Shopping campaign. products
`product_custom_label_4`	TEXT	Dimensão	Custom label 4 for custom grouping of items in a Shopping campaign. products
`product_data_source`	TEXT	Dimensão	The primary data source of the product. products
`product_description`	TEXT	Dimensão	Description of the item. products
`product_display_ads_id`	TEXT	Dimensão	An identifier for an item for dynamic remarketing campaigns. products
`product_display_ads_link`	TEXT	Dimensão	URL directly to your item's landing page for dynamic remarketing campaigns. products
`product_display_ads_title`	TEXT	Dimensão	Title of an item for dynamic remarketing campaigns. products
`product_display_ads_value`	NUMERIC	Métrica	Offer margin for dynamic remarketing campaigns. products
`product_effectiveness`	TEXT	Dimensão	The predicted effectiveness of applying the price suggestion, bucketed. reports
`product_energy_efficiency_class`	TEXT	Dimensão	The energy efficiency class as defined in EU directive 2010/30/EU. products
`product_expiration_date`	DATE	Dimensão	Date on which the item expires, in ISO 8601 format. reports
`product_external_seller_id`	TEXT	Dimensão	Required for multi-seller accounts. Use this attribute if you're a marketplace uploading products for various sellers to your multi-seller account. products
`product_feed_label`	TEXT	Dimensão	Feed label of the product. reports
`product_gender`	TEXT	Dimensão	Target gender of the item. For example, "male" or "female". products
`product_google_category`	TEXT	Dimensão	Google's category of the item (see Google product taxonomy).When querying products, this field will contain the user provided value.There is currently no way to get back the auto assigned google product categories through the API. products
`product_gtin`	TEXT	Dimensão	Global Trade Item Numbers (GTIN) of the item. You can provide up to 10 GTINs. This field includes all provided ones. reports
`product_id`	TEXT	Dimensão	Your unique identifier for the product. reports
`product_image_link`	IMAGE	Dimensão	URL of an image of the item. products
`product_impression_uplift`	PERCENT	Métrica	Predicted change in impressions as a fraction afterintroducing the suggested price compared to current active price.For example, 5 is a 5% predicted increase in impressions. reports
`product_impressions`	NUMERIC	Métrica	Number of times merchant's products are shown. reports
`product_item_group_id`	TEXT	Dimensão	Shared identifier for all variants of the same product. products
`product_language_code`	TEXT	Dimensão	Language code of the product in BCP 47 format. reports
`product_last_update_date`	DATE	Dimensão	Date on which the item has been last updated, in ISO 8601 format. products
`product_link`	TEXT	Dimensão	URL directly linking to your item's page on your online store. products
`product_material`	TEXT	Dimensão	The material of which the item is made. For example, "Leather" or "Cotton". products
`product_max_energy_efficiency_class`	TEXT	Dimensão	The energy efficiency class as defined in EU directive 2010/30/EU. products
`product_min_energy_efficiency_class`	TEXT	Dimensão	The energy efficiency class as defined in EU directive 2010/30/EU. products
`product_mobile_link`	TEXT	Dimensão	URL for the mobile-optimized version of your item's landing page. products
`product_mpn`	TEXT	Dimensão	Manufacturer Part Number (MPN) of the item. products
`product_multipack`	NUMERIC	Métrica	The number of identical products in a business-defined multipack. products
`product_name`	TEXT	Dimensão	The name of the product. Format: accounts/{account}/products/{product}where the last section product consists of 4 parts:channel~contentLanguage~feedLabel~offerId example for product name isaccounts/123/products/online~en~US~sku123 products
`product_pattern`	TEXT	Dimensão	The item's pattern. For example, polka dots. products
`product_performance_date`	DATE	Dimensão	Date in the merchant timezone to which metrics apply. reports
`product_pickup_method`	TEXT	Dimensão	The pickup option for the item. products
`product_pickup_sla`	TEXT	Dimensão	Item store pickup timeline. products
`product_price`	NUMERIC	Métrica	Product price. reports
`product_price_currency_code`	TEXT	Dimensão	Product price currency code. Product Price should be requested for the field to be available. reports
`product_price_gap`	PERCENT	Métrica	Percentage difference between your price and the benchmark price for a product.
`product_sale_price`	NUMERIC	Métrica	Price of the item. products
`product_sale_price_currency_code`	TEXT	Dimensão	Currency code of the price of the item. products
`product_sale_price_effective_end_date`	DATE	Dimensão	End of date range during which the item is on sale. products
`product_sale_price_effective_start_date`	DATE	Dimensão	Start of date range during which the item is on sale. products
`product_sale_price_micros`	NUMERIC	Métrica	Price of the item in micros. products
`product_sell_on_google_quantity`	NUMERIC	Métrica	The quantity of the product that is available for selling on Google.Supported only for online products. products
`product_shipping_label`	TEXT	Dimensão	The shipping label of the product,used to group product in account-level shipping rules. products
`product_size`	TEXT	Dimensão	Size of the item. Only one value is allowed. For variants with different sizes, insert a separate product for each size with the same itemGroupId value. products
`product_size_system`	TEXT	Dimensão	System in which the size is specified. Recommended for apparel items. For example, "US", "UK", "DE". products
`product_suggested_price`	NUMERIC	Métrica	Latest suggested price for the product. reports
`product_suggested_price_currency_code`	TEXT	Dimensão	Currency code of latest suggested price for the product. Product Suggested Price should be requested for the field to be available. reports
`product_thumbnail_link`	IMAGE	Dimensão	Link to the processed image of the product, hosted on the Google infrastructure. reports
`product_title`	TEXT	Dimensão	Title of the item. reports
`product_type_l1`	TEXT	Dimensão	Product type (1st level) in merchant's own product taxonomy. reports
`product_type_l2`	TEXT	Dimensão	Product type (2nd level) in merchant's own product taxonomy. reports
`product_type_l3`	TEXT	Dimensão	Product type (3rd level) in merchant's own product taxonomy. reports
`product_type_l4`	TEXT	Dimensão	Product type (4th level) in merchant's own product taxonomy. reports
`product_type_l5`	TEXT	Dimensão	Product type (5th level) in merchant's own product taxonomy. reports
`product_virtual_model_link`	TEXT	Dimensão	URL of the 3D image of the item. products
`source`	TEXT	Dimensão	The name of the Windsor connector returning the row
`today`	DATE	Dimensão	Today's date
`week`	TEXT	Dimensão	Week (Sun-Sat).
`week_day`	TEXT	Dimensão	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
`week_day_iso`	TEXT	Dimensão	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
`week_iso`	TEXT	Dimensão	Week, ISO format (Mon-Sun).
`year`	TEXT	Dimensão	Year
`year_month`	TEXT	Dimensão	Year and month, e.g. 2024\|3
`year_month_name`	TEXT	Dimensão	Year and month with the month name written out, e.g. "Jan 2025".
`year_of_week`	TEXT	Dimensão	The year that contains first day of the week (Sun-Sat).
`year_of_week_iso`	TEXT	Dimensão	The year that contains first day of the ISO week (Mon-Sun).
`year_week`	TEXT	Dimensão	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
`year_week_iso`	TEXT	Dimensão	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20