GeoPerformance
The Geo Performance report includes all statistics aggregated at the country/territory level, one row per country/territory.
Table Specific Information
Select
Google AdWords does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the AdWords console.
To use the nondefault fields, explicitly select them in your query.
Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the AdWords API.
Note that the CountryCriteriaId field is always required in the SELECT columns (SELECT * should automatically account for this.)
Columns
Name | Type | Behavior | DisplayName | Description |
AccountCurrencyCode | String | Attribute | Currency | Currency for the GeoPerformance report. |
AccountDescriptiveName | String | Attribute | Account | Account for the GeoPerformance report. |
AccountTimeZone | String | Attribute | Time Zone | Time Zone for the GeoPerformance report. |
CampaignId | Long | Attribute | Campaign ID | Campaign ID for the GeoPerformance report. |
CampaignName | String | Attribute | Campaign | Campaign for the GeoPerformance report. |
CampaignStatus | String | Attribute | Campaign State | Campaign State for the GeoPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
CityCriteriaId | Integer | Attribute | City | City for the GeoPerformance report. |
CountryCriteriaId | Integer | Attribute | Country Per Territory | Country Per Territory for the GeoPerformance report. |
CustomerDescriptiveName | String | Attribute | Client Name | Client Name for the GeoPerformance report. |
ExternalCustomerId | Long | Attribute | Customer ID | Customer ID for the GeoPerformance report. |
IsTargetingLocation | String | Attribute | Is Targetable | Is Targetable for the GeoPerformance report. The allowed values are TRUE, FALSE. |
MetroCriteriaId | Integer | Attribute | Metro Area | Metro Area for the GeoPerformance report. |
MostSpecificCriteriaId | Long | Attribute | Most Specific Location | Most Specific Location for the GeoPerformance report. |
RegionCriteriaId | Integer | Attribute | Region | Region for the GeoPerformance report. |
AdFormat | String | Segment | Ad Type | Ad Type for the GeoPerformance report. The allowed values are UNKNOWN, TEXT, IMAGE, DYNAMIC_IMAGE, FLASH, VIDEO, HTML, AUDIO, COMPOSITE, PRINT. |
AdGroupId | Long | Segment | Ad Group ID | Ad Group ID for the GeoPerformance report. |
AdGroupName | String | Segment | Ad Group | Ad Group for the GeoPerformance report. |
AdGroupStatus | String | Segment | Ad Group State | Ad Group State for the GeoPerformance report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
AdNetworkType1 | String | Segment | Network | Network for the GeoPerformance report. The allowed values are UNKNOWN, SEARCH, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED. |
AdNetworkType2 | String | Segment | Network (with Search Partners) | Network (with Search Partners) for the GeoPerformance report. The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED. |
ConversionCategoryName | String | Segment | Conversion Category | Conversion Category for the GeoPerformance report. |
ConversionTrackerId | Long | Segment | Conversion Tracker Id | Conversion Tracker Id for the GeoPerformance report. |
ConversionTypeName | String | Segment | Conversion Name | Conversion Name for the GeoPerformance report. |
Date | Date | Segment | Day | Day for the GeoPerformance report. |
DayOfWeek | String | Segment | Day Of Week | Day Of Week for the GeoPerformance report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. |
Device | String | Segment | Device | Device for the GeoPerformance report. The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET. |
ExternalConversionSource | String | Segment | Conversion Source | Conversion Source for the GeoPerformance report. The allowed values are UNKNOWN, WEBPAGE, ANALYTICS, UPLOAD, AD_CALL_METRICS, OFFERS, ENGAGEMENT, WEBSITE_CALL_METRICS, STORE_VISITS, ANDROID_IN_APP, ANDROID_DOWNLOAD, IOS_IN_APP, IOS_FIRST_OPEN, APP_UNSPECIFIED, ANDROID_FIRST_OPEN, UPLOAD_CALLS, FIREBASE, CLICK_TO_CALL, SALESFORCE, STORE_SALES_CRM, STORE_SALES_PAYMENT_NETWORK, GOOGLE_PLAY, THIRD_PARTY_APP_ANALYTICS, GOOGLE_ATTRIBUTION, STORE_SALES_DIRECT. |
LocationType | String | Segment | Location Type | Location Type for the GeoPerformance report. The allowed values are AREA_OF_INTEREST, LOCATION_OF_PRESENCE, UNKNOWN. |
Month | String | Segment | Month | Month for the GeoPerformance report. |
MonthOfYear | String | Segment | Month Of Year | Month Of Year for the GeoPerformance report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER. |
Quarter | String | Segment | Quarter | Quarter for the GeoPerformance report. |
Week | String | Segment | Week | Week for the GeoPerformance report. |
Year | Integer | Segment | Year | Year for the GeoPerformance report. |
AllConversionRate | Double | Metric | All Conv Rate | All Conv Rate for the GeoPerformance report. |
AllConversions | Double | Metric | All Conv | All Conv for the GeoPerformance report. |
AllConversionValue | Double | Metric | All Conv Value | All Conv Value for the GeoPerformance report. |
AverageCost | Decimal | Metric | Avg Cost | Avg Cost for the GeoPerformance report. |
AverageCpc | Decimal | Metric | Avg CPC | Avg CPC for the GeoPerformance report. |
AverageCpm | Decimal | Metric | Avg CPM | Avg CPM for the GeoPerformance report. |
AverageCpv | Double < |