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
"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