Hi team, I am querying geographic_view with ad_group. But the ad_group id and names in the response are not the exact one in AWFE. Could you help me investigate?
query SQL String geoViewSql = "SELECT campaign.id, campaign.name, ad_group.id, ad_group.name, geographic_view.country_criterion_id, "+ "metrics.cost_micros, metrics.clicks, metrics.impressions "+ "FROM geographic_view where segments.date = '2020-04-20' "+ "ORDER BY campaign.id" System.out.printf( "----------------- \n" + "campaign id '%d'\n" + "campaign name '%s'\n" + "ad group id '%d'\n" + "ad group name '%s'\n" + "country code '%s'\n" + "cost '%d'\n" + "clicks '%s'\n" + "impressions '%s'\n" , campaign.getId().getValue(), campaign.getName().getValue(), adGroup.getId().getValue(), adGroup.getName().getValue(), geoMap.get(googleAdsRow.getGeographicView().getCountryCriterionId().getValue()), googleAdsRow.getMetrics().getCostMicros().getValue(), googleAdsRow.getMetrics().getClicks().getValue(), googleAdsRow.getMetrics().getImpressions().getValue()); Response: Take an example ad group id '77484492406' ad group name 'feed_walnut_broads_cadmus:0:broad:76677779697' In fact, the 76677779697 part in the ad group name is what I can find in AWFE, not 77484492406. Best, Dong -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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/f0e904c7-36ea-4747-a8bd-4b7aa6436e68%40googlegroups.com.