Requests use the Merchant Center Query Language, which lets you select
performance metrics and segments that determine how the metrics are
summarized in the response, and additional filtering to select the date range
and other criteria. If you also use the reporting features of the Google Ads
API, you find that many of these concepts are similar.
For example, a common use case is to summarize the performance of your account
over the last 30 days segmented by program and offer_id. The following is the
query for this report:
SELECT
segments.program,
segments.offer_id,
metrics.impressions,
metrics.clicks,
metrics.ctr
FROM MerchantPerformanceView
WHERE segments.date BETWEEN '2020-11-01' AND '2020-11-30'
To issue this request, pass the Merchant Center Query Language statement, shown
above, to the reports.search method.
The request consists of an HTTP POST to the Content API for Shopping server at
the following URL (substitute the merchant ID for merchantId):
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-09-03 UTC."],[[["\u003cp\u003eFree Listing Performance reporting enables merchants to monitor impressions and clicks of their products across Google surfaces like Shopping, YouTube, and Knowledge Panel.\u003c/p\u003e\n"],["\u003cp\u003eUtilize the Reporting API and Merchant Center Query Language to access and analyze performance data for your products and programs.\u003c/p\u003e\n"],["\u003cp\u003eA common use case involves summarizing account performance over a period, segmented by program and offer ID, using specific queries.\u003c/p\u003e\n"],["\u003cp\u003eEnsure users have the "reporting manager" role for data access and cross-check API data with the Google Merchant Center platform for verification.\u003c/p\u003e\n"]]],["Merchants can access free listing performance data, including clicks and impressions, across Google platforms. This data is retrievable via the Reporting API using Merchant Center Query Language. Requests, sent as HTTP POSTs, allow users to filter and segment data (e.g., by program, offer ID, and date range). The `reports.search` method is used to issue queries. Access requires the *reporting manager* role. Results can be cross-checked with the Google Merchant Center platform.\n"],null,["5.1 Reporting Free Listings Performance (Impressions and Clicks)\n----------------------------------------------------------------\n\n### Introduction and Business Impact\n\n*** ** * ** ***\n\nFree Listing Performance reporting allows your merchants to view the number of\nclicks and impressions that your products receive across the Shopping tab,\nYouTube, the Shopping Knowledge Panel, and Popular Product. Learn more about\n[where Google shows your free product listings](https://support.google.com/merchants/answer/9826670) and [how performance\nreporting works in Merchant Center](https://support.google.com/merchants/answer/10265167).\n\n### Tech Guidance\n\n*** ** * ** ***\n\nUse the [Reporting API](https://developers.google.com/shopping-content/guides/reports/overview) to retrieve [performance data](https://support.google.com/merchants/answer/10265167) for products and\nprograms in Merchant Center accounts.\n\nRequests use the [Merchant Center Query Language](https://developers.google.com/shopping-content/guides/reports/query-language/overview), which lets you select\nperformance metrics and segments that determine how the metrics are\nsummarized in the response, and additional filtering to select the date range\nand other criteria. If you also use the [reporting features of the Google Ads\nAPI](https://developers.google.com/google-ads/api/docs/reporting/overview), you find that many of these concepts are similar.\n\nFor example, a common use case is to summarize the performance of your account\nover the last 30 days segmented by program and offer_id. The following is the\nquery for this report: \n\n SELECT\n segments.program,\n segments.offer_id,\n metrics.impressions,\n metrics.clicks,\n metrics.ctr\n FROM MerchantPerformanceView\n WHERE segments.date BETWEEN '2020-11-01' AND '2020-11-30'\n\nTo issue this request, pass the Merchant Center Query Language statement, shown\nabove, to the [`reports.search`](https://developers.google.com/shopping-content/reference/rest/v2.1/reports/search) method.\n\nThe request consists of an HTTP POST to the Content API for Shopping server at\nthe following URL (substitute the merchant ID for merchantId): \n\n https://shoppingcontent.googleapis.com/content/v2.1/merchantId/reports/search\n\nFor the full example, see the [Example in the Content API documentation](https://developers.google.com/shopping-content/guides/reports/example).\nFor more examples and information, see the following:\n\n- Retrieve product [performance metrics](https://developers.google.com/shopping-content/guides/reports/metrics).\n- Learn about [segmentation](https://developers.google.com/shopping-content/guides/reports/segmentation).\n- Learn about [paging your data](https://developers.google.com/shopping-content/guides/reports/paging).\n- Learn the syntax of the [Merchant Center Query Language](https://developers.google.com/shopping-content/guides/reports/query-language/overview).\n\n| **Important:** Users need to have the *reporting manager* role enabled using the content API ([`Accountsuser`](https://developers.google.com/shopping-content/reference/rest/v2.1/accounts#accountuser)) or manually added through Merchant Center to see the data.\n| **Tip:** You can cross check what you pull using the Reporting API with what you see in the Google Merchant Center platform. See [About performance reporting for\n| free listings - Google Merchant Center Help](https://support.google.com/merchants/answer/9826542) for more information and troubleshooting advice.\n\nSee: [Track your product performance](https://support.google.com/merchants/answer/188492)"]]
