Update: The query is already giving me the results I was looking for. I have noticed that the problem was that I have fields in the Select clause with ad_group entity and this is not the case for PERFORMANCE_MAX campaigns. But, If you can help me with the other question, how can I get the asset group ID for this result?
Thank you Ivan El martes, 19 de julio de 2022 a las 12:47:19 UTC+2, Iván López escribió: > Hello, > > We have a process which uses the shopping_performance_view to have the > stats (clicks, conversions, etc.) info. Until now, we were only using it > with shopping campaigns. But now we are trying to integrate it with > PERFORMANCE_MAX campaigns. > > But, when I ask for a query to this report with the campaign.id condition > with one PERFORMANCE_MAX campaign, the result is empty, and the campaign > does have products on it, I can see it on Google Ads. > > Here is the query I am doing: > > > SELECT > campaign.id, > campaign.status, > ad_group.status, > ad_group.id, > campaign.name, > ad_group.name, > metrics.clicks, > metrics.conversions, > metrics.cost_micros, > segments.product_custom_attribute4 > FROM > shopping_performance_view > WHERE campaign.id = 17593385238 > AND campaign.status = 'ENABLED' > AND segments.date BETWEEN 20220420 AND 20220719 > > I know there is confidential information in the query, but I think you > need it to test it. The advertising account is: 749-031-9553. > > Moreover, when we are doing this with shopping campaigns, we filter in the > query by the ad group ID. But the shopping_performance_view is not related > with asset_group. > > How can I get the asset_group where the product results from this query > belongs? How can I get the relationship between this report and the > asset_group? > > Why am I getting an empty results for this query? Is it impossible to get > the products report in a PERFORMANCE_MAX campaign? or should I use another > report? > > Thank you, > > Iván > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/f9dbcc67-67e9-40c1-b36b-6a160794d25cn%40googlegroups.com.
