Hello, Thank you very much for the quick response. A .csv file is as good as an XML entry for me.
Best regards, Swanand On May 27, 10:42 pm, AdWords API Advisor <adwordsapiadvi...@google.com> wrote: > Hello, > > There's no way to get that information directly from the > ReportService. However, the next release of the adwords4r client > library should follow a trend started with the Python client library > and provide a local CSV file that contains mappings between metro > codes and area names. > > You can make use of the file right now, actually, but you'll have to > download it yourself and write code to read it into memory and do > lookups. The file is at > > http://code.google.com/p/google-api-adwords-python-lib/source/browse/... > > Cheers, > -Jeff Posnick, AdWords API Team > > On May 27, 3:08 am, Swanand <swanand.pag...@gmail.com> wrote: > > > Hello, > > > Is there a way to get the metropolitan region instead of the metro > > code in a report? More specifically, I am downloading a Geo > > Performance report, with following details: > > > selectedReportType = 'Geographic' > > aggregationTypes = 'Campaign' > > name = report_name > > selectedColumns = %w{Campaign Country CPC CPM CampaignStatus > > CampaignId City Clicks Cost DailyBudget DailyCTR ExternalCustomerId > > Impressions Metro Region } > > startDay = start_date > > endDay = end_date > > crossClient = 'true' > > > When I download this report I get a row like this: > > > <row customerid="-some-id-here-" campaignid="-some-id-here-" > > campaign="-my-campaign-name" country="USA" region="US-CA" metro="803" > > city="Culver City" budget="1950000" campStatus="Active" imps="2" > > clicks="1" cpc="680000" cpm="340000000" dailyctr="0.5" cost="680000"></ > > row> > > > Now instead of metro="803" I actually want something like metro- > > name="Los Angeles CA". > > Is that possible? What column name should be sent in the > > selectedColumns list to achieve this? > > > Any help will be much appreciated, > > > -Swanand --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "AdWords 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 -~----------~----~----~----~------~----~------~--~---