Introduction

Datasources and destinations

Fields listing for Google Merchant Center

Product Brand Name
Product Brand Name
Field IDproduct_view.brand
TypeTEXT
Data Typedimension
Product ID
Product ID
Field IDproduct_view.id
TypeTEXT
Data Typedimension
Product Source
Product Source
Field IDproduct_view.source
TypeTEXT
Data Typedimension
Product Offer ID
Product Offer ID
Field IDproduct_view.offer_id
TypeTEXT
Data Typedimension
Product Title
Product Title
Field IDproduct_view.title
TypeTEXT
Data Typedimension
Product Category L1
Product Category L1
Field IDproduct_view.category_l1
TypeTEXT
Data Typedimension
Product Category L2
Product Category L2
Field IDproduct_view.category_l2
TypeTEXT
Data Typedimension
Product Category L3
Product Category L3
Field IDproduct_view.category_l3
TypeTEXT
Data Typedimension
Product Category L4
Product Category L4
Field IDproduct_view.category_l4
TypeTEXT
Data Typedimension
Product Category L5
Product Category L5
Field IDproduct_view.category_l5
TypeTEXT
Data Typedimension
Product Type L1
Product Type L1
Field IDproduct_view.product_type_l1
TypeTEXT
Data Typedimension
Product Type L2
Product Type L2
Field IDproduct_view.product_type_l2
TypeTEXT
Data Typedimension
Product Type L3
Product Type L3
Field IDproduct_view.product_type_l3
TypeTEXT
Data Typedimension
Product Type L4
Product Type L4
Field IDproduct_view.product_type_l4
TypeTEXT
Data Typedimension
Product Type L5
Product Type L5
Field IDproduct_view.product_type_l5
TypeTEXT
Data Typedimension
Product Price
Product Price
Field IDproduct_view.price_micros
TypeNUMBER
Data Typedimension
Product Currency Code
Product Currency Code
Field IDproduct_view.currency_code
TypeTEXT
Data Typedimension
Product Language Code
Product Language Code
Field IDproduct_view.language_code
TypeTEXT
Data Typedimension
Product Condition
Product Condition
Field IDproduct_view.condition
TypeTEXT
Data Typedimension
Product Custom Label 0
Product Custom Label 0
Field IDproduct_view.custom_label0
TypeTEXT
Data Typedimension
Product Custom Label 1
Product Custom Label 1
Field IDproduct_view.custom_label1
TypeTEXT
Data Typedimension
Product Custom Label 2
Product Custom Label 2
Field IDproduct_view.custom_label2
TypeTEXT
Data Typedimension
Product Custom Label 3
Product Custom Label 3
Field IDproduct_view.custom_label3
TypeTEXT
Data Typedimension
Product Custom Label 4
Product Custom Label 4
Field IDproduct_view.custom_label4
TypeTEXT
Data Typedimension
Product Channel
Product Channel
Field IDproduct_view.channel
TypeTEXT
Data Typedimension
Product Availability
Product Availability
Field IDproduct_view.availability
TypeTEXT
Data Typedimension
Product Shipping Label
Product Shipping Label
Field IDproduct_view.shipping_label
TypeTEXT
Data Typedimension
Product GTIN
Product GTIN
Field IDproduct_view.gtin
TypeTEXT
Data Typedimension
Product Item Group ID
Product Item Group ID
Field IDproduct_view.item_group_id
TypeTEXT
Data Typedimension
Product Creation Time
Product Creation Time
Field IDproduct_view.creation_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Product Expiration Time
Product Expiration Time
Field IDproduct_view.expiration_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Product Destination Status
Product Destination Status
Field IDproduct_view.aggregated_destination_status
TypeTEXT
Data Typedimension
Product Item Issue Canonical Attribute
Product Item Issue Canonical Attribute
Field IDproduct_view.item_issues.issueType.canonicalAttribute
TypeTEXT
Data Typedimension
Product Item Issue Code
Product Item Issue Code
Field IDproduct_view.item_issues.issueType.code
TypeTEXT
Data Typedimension
Product Item Issue Destination
Product Item Issue Destination
Field IDproduct_view.item_issues.severity.severityPerDestination.destination
TypeTEXT
Data Typedimension
Product Item Issue Severity
Product Item Issue Severity
Field IDproduct_view.item_issues.severity.aggregatedSeverity
TypeTEXT
Data Typedimension
Product Item Issue Disapproved Countries
Product Item Issue Disapproved Countries
Field IDproduct_view.item_issues.severity.severityPerDestination.disapprovedCountries
TypeCOUNTRY_CODE
Data Typedimension
Product Item Issue Demoted Countries
Product Item Issue Demoted Countries
Field IDproduct_view.item_issues.severity.severityPerDestination.demotedCountries
TypeCOUNTRY_CODE
Data Typedimension
Product Item Issue Resolution
Product Item Issue Resolution
Field IDproduct_view.item_issues.resolution
TypeTEXT
Data Typedimension
Product Click Potential
Product Click Potential
Field IDproduct_view.click_potential
TypeTEXT
Data Typedimension
Product Click Potential Rank
Product Click Potential Rank
Field IDproduct_view.click_potential_rank
TypeNUMBER
Data Typedimension
Customer Country
Customer Country
Field IDsegments.customer_country_code
TypeCOUNTRY_CODE
Data Typedimension
Clicks
Clicks
Field IDmetrics.clicks
TypeNUMBER
Data Typemetric
Impressions
Impressions
Field IDmetrics.impressions
TypeNUMBER
Data Typemetric
CTR
CTR
Field IDmetrics.ctr
TypePERCENT
Data Typemetric
Conversions
Conversions
Field IDmetrics.conversions
TypeNUMBER
Data Typemetric
Conversion Value
Conversion Value
Field IDmetrics.conversion_value_micros
TypeNUMBER
Data Typemetric
Conversion Rate
Conversion Rate
Field IDmetrics.conversion_rate
TypePERCENT
Data Typemetric
Ordered Items
Ordered Items
Field IDmetrics.ordered_items
TypeNUMBER
Data Typemetric
Shipped Items
Shipped Items
Field IDmetrics.shipped_items
TypeNUMBER
Data Typemetric
Unshipped Items
Unshipped Items
Field IDmetrics.unshipped_items
TypeNUMBER
Data Typemetric
Rejected Items
Rejected Items
Field IDmetrics.rejected_items
TypeNUMBER
Data Typemetric
Returned Items
Returned Items
Field IDmetrics.returned_items
TypeNUMBER
Data Typemetric
Item Days to Ship
Item Days to Ship
Field IDmetrics.item_days_to_ship
TypeNUMBER
Data Typemetric
Item Fill Rate
Item Fill Rate
Field IDmetrics.item_fill_rate
TypePERCENT
Data Typemetric
Item Ordered Sales Value
Item Ordered Sales Value
Field IDmetrics.ordered_item_sales_micros
TypeNUMBER
Data Typemetric
Item Shipped Sales Value
Item Shipped Sales Value
Field IDmetrics.shipped_item_sales_micros
TypeNUMBER
Data Typemetric
Item Return Value
Item Return Value
Field IDmetrics.returns_micros
TypeNUMBER
Data Typemetric
Item Return Rate
Item Return Rate
Field IDmetrics.return_rate
TypePERCENT
Data Typemetric
Orders
Orders
Field IDmetrics.orders
TypePERCENT
Data Typemetric
Shipped Orders
Shipped Orders
Field IDmetrics.shipped_orders
TypeNUMBER
Data Typemetric
Unshipped Orders
Unshipped Orders
Field IDmetrics.unshipped_orders
TypeNUMBER
Data Typemetric
Days to Ship
Days to Ship
Field IDmetrics.days_to_ship
TypeNUMBER
Data Typemetric
Average Orders Sales
Average Orders Sales
Field IDmetrics.aos
TypeNUMBER
Data Typemetric
Average Orders Value
Average Orders Value
Field IDmetrics.aov_micros
TypeNUMBER
Data Typemetric
Price Insight - Suggested Price
Price Insight - Suggested Price
Field IDprice_insights.suggested_price_micros
TypeNUMBER
Data Typemetric
Price Insight - Suggested Price Currency Code
Price Insight - Suggested Price Currency Code
Field IDprice_insights.suggested_price_currency_code
TypeTEXT
Data Typedimension
Price Insight - Predicted Impressions Change Fraction
Price Insight - Predicted Impressions Change Fraction
Field IDprice_insights.predicted_impressions_change_fraction
TypeNUMBER
Data Typemetric
Price Insight - Predicted Clicks Change Fraction
Price Insight - Predicted Clicks Change Fraction
Field IDprice_insights.predicted_clicks_change_fraction
TypeNUMBER
Data Typemetric
Price Insight - Predicted Conversions Change Fraction
Price Insight - Predicted Conversions Change Fraction
Field IDprice_insights.predicted_conversions_change_fraction
TypeNUMBER
Data Typemetric
Price Competitiveness - Country Code
Price Competitiveness - Country Code
Field IDprice_competitiveness.country_code
TypeTEXT
Data Typedimension
Price Competitiveness - Benchmark Price
Price Competitiveness - Benchmark Price
Field IDprice_competitiveness.benchmark_price_micros
TypeNUMBER
Data Typemetric
Price Competitiveness - Benchmark Price Currency Code
Price Competitiveness - Benchmark Price Currency Code
Field IDprice_competitiveness.benchmark_price_currency_code
TypeTEXT
Data Typedimension
Topic Trends - Customer Country Code
Topic Trends - Customer Country Code
Field IDtopic_trends.customer_country_code
TypeTEXT
Data Typedimension
Topic Trends - Topic
Topic Trends - Topic
Field IDtopic_trends.topic
TypeTEXT
Data Typedimension
Topic Trends - Search Interest
Topic Trends - Search Interest
Field IDtopic_trends.search_interest
TypeNUMBER
Data Typedimension
Topic Trends - Last 7 Days Search Interest
Topic Trends - Last 7 Days Search Interest
Field IDtopic_trends.last7_days_search_interest
TypeNUMBER
Data Typedimension
Topic Trends - Last 30 Days Search Interest
Topic Trends - Last 30 Days Search Interest
Field IDtopic_trends.last30_days_search_interest
TypeNUMBER
Data Typedimension
Topic Trends - Last 90 Days Search Interest
Topic Trends - Last 90 Days Search Interest
Field IDtopic_trends.last90_days_search_interest
TypeNUMBER
Data Typedimension
Topic Trends - Last 120 Days Search Interest
Topic Trends - Last 120 Days Search Interest
Field IDtopic_trends.last120_days_search_interest
TypeNUMBER
Data Typedimension
Topic Trends - Next 7 Days Search Interest
Topic Trends - Next 7 Days Search Interest
Field IDtopic_trends.next7_days_search_interest
TypeNUMBER
Data Typedimension
Account Status - Account Level Issue ID
Account Status - Account Level Issue ID
Field IDAccountStatusAccountLevelIssue.id
TypeTEXT
Data Typedimension
Account Status - Account Level Issue Title
Account Status - Account Level Issue Title
Field IDAccountStatusAccountLevelIssue.title
TypeTEXT
Data Typedimension
Account Status - Account Level Issue Country
Account Status - Account Level Issue Country
Field IDAccountStatusAccountLevelIssue.country
TypeCOUNTRY_CODE
Data Typedimension
Account Status - Account Level Issue Severity
Account Status - Account Level Issue Severity
Field IDAccountStatusAccountLevelIssue.severity
TypeTEXT
Data Typedimension
Account Status - Account Level Issue Detail
Account Status - Account Level Issue Detail
Field IDAccountStatusAccountLevelIssue.detail
TypeTEXT
Data Typedimension
Account Status - Account Level Issue Destination
Account Status - Account Level Issue Destination
Field IDAccountStatusAccountLevelIssue.destination
TypeTEXT
Data Typedimension
Account Status - Account Level Issue Documentation
Account Status - Account Level Issue Documentation
Field IDAccountStatusAccountLevelIssue.documentation
TypeTEXT
Data Typedimension
Product Status - Channel
Product Status - Channel
Field IDAccountStatusProducts.channel
TypeTEXT
Data Typedimension
Product Status - Destination
Product Status - Destination
Field IDAccountStatusProducts.destination
TypeTEXT
Data Typedimension
Product Status - Country
Product Status - Country
Field IDAccountStatusProducts.country
TypeCOUNTRY_CODE
Data Typedimension
Product Status - Active
Product Status - Active
Field IDAccountStatusProducts.statistics.active
TypeNUMBER
Data Typedimension
Product Status - Pending
Product Status - Pending
Field IDAccountStatusProducts.statistics.pending
TypeNUMBER
Data Typedimension
Product Status - Disapproved
Product Status - Disapproved
Field IDAccountStatusProducts.statistics.disapproved
TypeNUMBER
Data Typedimension
Product Status - Expiring
Product Status - Expiring
Field IDAccountStatusProducts.statistics.expiring
TypeNUMBER
Data Typedimension
Item Issues - Code
Item Issues - Code
Field IDAccountStatusProducts.itemLevelIssues.code
TypeTEXT
Data Typedimension
Item Issues - Servability
Item Issues - Servability
Field IDAccountStatusProducts.itemLevelIssues.servability
TypeTEXT
Data Typedimension
Item Issues - Resolution
Item Issues - Resolution
Field IDAccountStatusProducts.itemLevelIssues.resolution
TypeTEXT
Data Typedimension
Item Issues - Attribute Name
Item Issues - Attribute Name
Field IDAccountStatusProducts.itemLevelIssues.attributeName
TypeTEXT
Data Typedimension
Item Issues - Description
Item Issues - Description
Field IDAccountStatusProducts.itemLevelIssues.description
TypeTEXT
Data Typedimension
Item Issues - Detail
Item Issues - Detail
Field IDAccountStatusProducts.itemLevelIssues.detail
TypeTEXT
Data Typedimension
Item Issues - Documentation
Item Issues - Documentation
Field IDAccountStatusProducts.itemLevelIssues.documentation
TypeTEXT
Data Typedimension
Item Issues - Item Count
Item Issues - Item Count
Field IDAccountStatusProducts.itemLevelIssues.numItems
TypeNUMBER
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Date
Date
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Day of the week
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the year
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension