Perfect... This was exactly what I needed. Can you (in just a few lines) tell me why [ad_group] don't return the same results as [customer]. I would expect it to some kind of join that excludes some results in ad_group, that is on customer. But isn't all ads part of an ad_group?
I got the previous query from this page: https://developers.google.com/google-ads/api/docs/shopping-ads/reporting I just removed the ad_group.type where condition because I want all results. On Monday, 11 September 2023 at 20:20:58 UTC+2 Google Ads API Forum Advisor wrote: > Hi, > > Thank you for your response and for providing us the requested information. > > Upon checking, we've seen that you're using ad_group resource in your > request. This might be the reason for the data not matching. We've tried to > use the resource of customer ( > https://developers.google.com/google-ads/api/fields/v14/customer) to get > the equal data. Upon trying the below query, we're able to get the matching > data results. With that, kindly try it in your end. > > *"SELECT customer.id <https://customer.id/>, customer.descriptive_name, > segments.date, metrics.impressions, metrics.clicks FROM customer > WHERE customer.id <https://customer.id/> = 7778999633 AND segments.date >= > '2023-09-01' AND segments.date <= '2023-09-07' ", "summaryRowSetting": > "SUMMARY_ROW_WITH_RESULTS"* > This message is in relation to case "ref:_00D1U1174p._5004Q2ojS6M: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/b9141ce0-a220-4491-aae4-d65e412e0a2en%40googlegroups.com.
