Thanks Marjorie. I'm actually building an ETL pipeline, and I had not incorporated the ability to use one requests results as the data for a second request. I had no need for this functionality until now. I ended up just incorporating the ability to download the csv file programmatically every time it was needed (I know, I know...this was very lazy of me).
But the csv was just removed. The link no longer works :(. I guess this is as good a reason as ever to do as you suggested. Thanks again! On Wednesday, December 14, 2022 at 10:20:39 PM UTC-8 adsapi wrote: > Hi Chad, > > Thanks for reaching out to the Google Ads API Forum. I hope you are doing > well today. > > I understand that you have issues on how to convert country_id to country > name. I will recommend to *separate API request *with the following query: > > SELECT geo_target_constant.canonical_name, > geo_target_constant.country_code, > geo_target_constant.id, > geo_target_constant.name, > geo_target_constant.status, > geo_target_constant.target_type > FROM geo_target_constant > WHERE geo_target_constant.resource_name = 'geoTargetConstants/<<criterion > ID>>' > > It is true that the geo_target_constant resource is not compatible with > ad_group.type. However, while using geographic_view report, you should be > able to use ad_group report fields such as name, type etc as it is a > segmented report. > > In addition, to get name of campaign, you should be able to pull this > using geographic_view report as campaign resource is segmented, and pulling > campaign.name is possible. However, is geo_target_constant report > compatible with the campaign. > > You should be able to use a sample GAQL for geographic_view *here* > <https://gaql-query-builder.uc.r.appspot.com/v12/share?q=SELECT%20geographic_view.country_criterion_id%2C%20metrics.clicks%2C%20ad_group.type%2C%20ad_group.name%2C%20campaign.name%2C%20campaign.advertising_channel_type%2C%20campaign.advertising_channel_sub_type%20FROM%20geographic_view%20WHERE%20segments.date%20BETWEEN%20%272022-12-14%27%20AND%20%272022-12-14%27> > where > campaign fields are added. Then a separate request to pull the > canonical_name using geo_target_constant report. > > With regards to this *link* > <https://developers.google.com/adwords/api/docs/appendix/geotargeting>, > we do not have any Google Ads API service / method to download it so it is > not recommended to use AdsWords API > <https://developers.google.com/adwords/api/docs/guides/start>. > > I hope it helps. Have a great day. > > Regards, > [image: Google Logo] > Marjorie > Google Ads API Team > > > ref:_00D1U1174p._5004Q2h3Ar4:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/e91a9ee0-68e5-43df-aa80-bb51edb0d828n%40googlegroups.com.
