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 | Metric | Avg CPV | Avg CPV for the GeoPerformance report. |
AveragePosition | Double | Metric | Avg Position | Avg Position for the GeoPerformance report. |
Clicks | Long | Metric | Clicks | Clicks for the GeoPerformance report. |
ConversionRate | Double | Metric | Conv Rate | Conv Rate for the GeoPerformance report. |
Conversions | Double | Metric | Conversions | Conversions for the GeoPerformance report. |
ConversionValue | Double | Metric | Total Conv Value | Total Conv Value for the GeoPerformance report. |
Cost | Decimal | Metric | Cost | Cost for the GeoPerformance report. |
CostPerAllConversion | Decimal | Metric | Cost Per All Conv | Cost Per All Conv for the GeoPerformance report. |
CostPerConversion | Decimal | Metric | Cost Per Conv | Cost Per Conv for the GeoPerformance report. |
CrossDeviceConversions | Double | Metric | Cross-device Conv | Cross-device Conv for the GeoPerformance report. |
Ctr | Double | Metric | CTR | CTR for the GeoPerformance report. |
Impressions | Long | Metric | Impressions | Impressions for the GeoPerformance report. |
InteractionRate | Double | Metric | Interaction Rate | Interaction Rate for the GeoPerformance report. |
Interactions | Long | Metric | Interactions | Interactions for the GeoPerformance report. |
InteractionTypes | String | Metric | Interaction Types | Interaction Types for the GeoPerformance report. |
ValuePerAllConversion | Double | Metric | Value Per All Conv | Value Per All Conv for the GeoPerformance report. |
ValuePerConversion | Double | Metric | Value Per Conv | Value Per Conv for the GeoPerformance report. |
VideoViewRate | Double | Metric | View Rate | View Rate for the GeoPerformance report. |
VideoViews | Long | Metric | Views | Views for the GeoPerformance report. |
ViewThroughConversions | Long | Metric | View-through Conv | View-through Conv for the GeoPerformance report. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
StartDate | String | Start date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days. |
EndDate | String | End date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days. |
Last updated