GeoPerformance
The Geo Performance report includes all statistics aggregated at the country/territory level, one row per country/territory.
Last updated
The Geo Performance report includes all statistics aggregated at the country/territory level, one row per country/territory.
Last updated
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.)
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
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.
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.