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.