Google Merchant Center — data points

In PMA

Product performance and catalogue data

Shopping ad performance by product: clicks, impressions, CTR, conversions, conversion value, purchase rate
Rich product dimensions: brand, category L1–L5, custom labels 0–4, product type L1–L2, offer ID, marketing method
Product catalogue: name, title, description, image URL, GTIN, channel, availability, condition, price, sale price
Promotions report (schema available; metric data depends on account setup)
Joinable with Google Ads shopping report (google_ads / shopping) for full spend + feed analysis

Native MCP

No native MCP — PMA is the only source

There is no Hedgehog native MCP for Google Merchant Center at this time
All Merchant Center data must be queried via PMA
Google Ads Shopping performance (via mechanic-mcp-server) covers spend-side metrics but does not include product feed metadata or catalogue health

PMA is the only source for Merchant Center

No native MCP exists for Google Merchant Center. Use google_merchant in PMA for all product feed analysis, Shopping performance breakdowns, and catalogue health queries. Product-level spend data can be joined with the google_ads / shopping report type using product_item_id / offer_id as the join key.

PMA field catalogue

Every queryable field in PMA

Grouped by report type. Filter to find a field fast. formula fields are computed — use their component fields in SQL.

Product performance

report_type: product_performance · 6 metrics · 43 dimensions · showing 6 of 6 metrics and 20 of 43 dimensions retrievable via API

Metrics

Field name	Label	Type
`clickThroughRate`	CTRformula	NUMBER
`clicks`	Clicks	NUMBER
`conversion_rate`	Purchase Rate	NUMBER
`conversion_value`	Conversion Value	NUMBER
`conversions`	Purchases	NUMBER
`impressions`	Impressions	NUMBER

Dimensions

Field name	Label	Type
`offer_id`	Offer ID	STRING
`brand`	Brand	STRING
`category_l1`	Category L1	STRING
`category_l2`	Category L2	STRING
`category_l3`	Category L3	STRING
`category_l4`	Category L4	STRING
`category_l5`	Category L5	STRING
`product_type_l1`	Product Type L1	STRING
`product_type_l2`	Product Type L2	STRING
`custom_label0`	Custom Label 0	STRING
`custom_label1`	Custom Label 1	STRING
`custom_label2`	Custom Label 2	STRING
`custom_label3`	Custom Label 3	STRING
`custom_label4`	Custom Label 4	STRING
`marketing_method`	Marketing Method	STRING
`customer_country_code`	Customer Country Code	STRING
`account_id`	Account ID	STRING
`configName`	Entity Name	STRING
`date`	Date	STRING
`dataFreshness`	Data Freshness	STRING

Products (catalogue)

report_type: products · 3 metrics · 28 dimensions · showing 3 of 3 metrics and 20 of 28 dimensions retrievable via API

Metrics

Field name	Label	Type
`num_of_products`	Total productsformula	NUMBER
`productPrice`	Product Price	NUMBER
`productSalePrice`	Product Sale Price	NUMBER

Dimensions

Field name	Label	Type
`offer_id`	Offer ID	STRING
`productName`	Product Name	STRING
`product_title`	Product Title	STRING
`product_description`	Product Description	STRING
`product_brand`	Product Brand	STRING
`product_availability`	Product Availability	STRING
`product_condition`	Product Condition	STRING
`product_imageLink`	Product Image Link	STRING
`product_link`	Product Link	STRING
`productGTIN`	Product GTIN	STRING
`product_itemGroupId`	Product Item Group ID	STRING
`productChannel`	Product Channel	STRING
`productLastUpdateDate`	Product Last Update Date	STRING
`productSaleCurrencyCode`	Product Sale Currency Code	STRING
`account_id`	Account ID	STRING
`configName`	Entity Name	STRING
`product_image`	Imageformula	STRING

Promotions

report_type: promotions · 0 metrics · 13 dimensions

Dimensions

Field name	Label	Type
`account_id`	Account ID	STRING
`configName`	Entity Name	STRING
`dataFreshness`	Data Freshness	STRING
`MinDate`	PMA Minimum Cached Data Date	STRING
`MaxDate`	PMA Maximum Cached Data Date	STRING
`isInterpolated`	PMA Is Interpolated?	BOOLEAN
`dataSource`	Data Source	STRING
`executionId`	Function Execution ID	STRING
`dataPlatform`	Data Platform	STRING