Aword's User Location Query Using AWQL

[Micheal Edward]

I can export user locations using Adword Dashboard, and it exports CSV data with following columns, (from where is get those columns added to my report are mentioned in notes)

User Locations Report (Columns on the User Locations Tab - Under 'Dimensions')

Column Name	Notes
Network	Segment
Country/Territory	Default
Town/City	Level of detail
Clicks	Performance
Impressions	Performance
CTR	Performance
Avg. CPC	Performance
Cost	Performance
Avg. position	Performance
Converted clicks	Conversions
Cost / converted click	Conversions
Click conversion rate	Conversions

but the problem is, now i want to get same data using AWQL, and despite rigorous search and struggle to find the respective report table or columns, i am unable to make such query which can get me this data, can you help please.

Following is csv header of downloaded report from dashboard, i want to replicate same using AWQL.

User locations report (1 Jan 2015-31 Mar 2015)
Network	Country/Territory	Town/City	Clicks	Impressions	CTR	Avg. CPC	Cost	Avg. position	Converted clicks	Cost / converted click	Click conversion rate

Thankyou.

[Anthony Madrigal]

Hi,

You could run a Geo Performance Report to get the statistics of the fields that you want within a given date range. Unfortunately, the fields for city and town will be their IDs which can be found in the Geotargeting Criteria Code reference page.

Cheers,

Anthony

AdWords API Team