Metropolitan Names

[Swanand]

Hello,

In the Geographic Performance report, is there a way to get human
readable metropolitan area names.
For eg instead of metro="803", I'd like, metro-name="Los Angeles CA".
I do not want to make separate API call just for the metro name. I am
using v13 API through adwords4r ruby gem.

A few 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 MetropolitanRegion}
startDay = start_date
endDay = end_date
crossClient = 'true'

Any help is much appreciated,
Swanand

[Swanand]

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

[AdWords API Advisor]

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

[Swanand]

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/...