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/trunk/aw_api/data/us_metros.csv 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 -~----------~----~----~----~------~----~------~--~---
