Hello Google Ads API Forum Advisor, can you send me a query similar to Mike to extract all account data on asset group level rather for a specific asset group id?
Thank you On Friday 24 November 2023 at 14:38:18 UTC+4 Pere Munar wrote: > Hi! > > I tried to get data from the asset_group_product_group_view report and I > got some data. However, the data retrieved does not match the data > displayed on the Google Ads platform. > Any ideas on what might be happening? Are you aware of that issue? > > Best, > > Pere > > On Thursday, October 19, 2023 at 4:14:24 AM UTC+2 Mike Fang wrote: > >> Thanks! >> >> On Wednesday, October 18, 2023 at 5:10:01 PM UTC+8 Google Ads API Forum >> Advisor wrote: >> >>> Hi Mike, >>> >>> Thank you for reaching out to the Google Ads API support team. >>> >>> After reviewing your concern, I understand that your query is regarding >>> the asset_group in the PMax campaign. However, there are some limitations >>> for Performance Max (PMax) asset group reporting with metrics by API. The >>> asset_group >>> <https://developers.google.com/google-ads/api/fields/v14/asset_group_query_builder> >>> resource >>> does not support metric selection or filtering. This is why you received >>> the error message when you tried to query for the clicks and impressions >>> metrics. >>> >>> To get asset group performance metrics, you can use the >>> asset_group_product_group_view >>> <https://developers.google.com/google-ads/api/fields/v14/asset_group_product_group_view> >>> resource. >>> This resource allows you to segment your results by product group, but you >>> can also limit the results to a single asset group by adding an asset group >>> filtering condition to the WHERE clause. >>> >>> The following example demonstrates how to use the >>> asset_group_product_group_view resource to retrieve performance metrics by >>> asset group: >>> >>> SELECT >>> asset_group.name, >>> metrics.impressions, >>> metrics.clicks, >>> metrics.cost_micros >>> FROM asset_group_product_group_view >>> WHERE asset_group.id = '6479664517 <(647)%20966-4517>' >>> AND segments.date DURING LAST_MONTH >>> ORDER BY metrics.impressions DESC >>> Also, you can utilize the *Google Ads Query Builder* >>> <https://developers.google.com/google-ads/api/fields/v14/overview_query_builder> >>> >>> and *Query Validator* >>> <https://developers.google.com/google-ads/api/fields/v14/query_validator> >>> to build and validate the queries for retrieving the data from the Google >>> Ads API. If you have any concerns / queries related to *Google Ads API* >>> <https://developers.google.com/google-ads/api/docs/start>, please feel >>> free to get back to us. >>> >>> >>> This message is in relation to case "ref:!00D1U01174p.!5004Q02pU79C:ref" >>> >>> Thanks, >>> >>> [image: Google Logo] Google Ads API Team >>> >>> >>> >>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/02de356a-980f-4517-ad2b-f2e6e60eec8an%40googlegroups.com.
