An example query text might be {@code "select CountryCode, Name fromGeo_Target"}, where {@code CountryCode} and {@code Name} arecolumns of interest and {@code Geo_Target} is the table.
The following tables are supported:
Use this table instead of the other Geo tables below (Country, Region, Metro, City, Postal_Code) which will eventually be removed.
Column Name | Description |
---|---|
Id | Unique identifier for the Geo target |
Name | The name of the Geo target |
CanonicalParentId | The criteria ID of the direct parent that defines the canonical name of the geo target. For example, if the current geo target is "San Francisco", its canonical name would be "San Francisco, California, United States" thus the canonicalParentId would be the criteria ID of California and the canonicalParentId of California would be the criteria ID of United states |
ParentIds | A comma separated list of criteria IDs of all parents of the geo target ordered by ascending size |
CountryCode | Country code as defined by ISO 3166-1 alpha-2 |
Type | Allowable values:
|
Targetable | Indicates whether geographical targeting is allowed |
Column Name | Description |
---|---|
Id | Unique identifier for the country |
CountryCode | Country code as defined by ISO 3166-1 alpha-2 |
CountryName | The name of the country |
CurrencyCode | Currency code as defined by ISO 4217 |
Targetable | Indicates whether geographical targeting is allowed |
Column Name | Description |
---|---|
Id | Unique identifier for the region |
RegionCode | Region code as defined by ISO 3166-2 |
RegionName | The name of the region |
CountryCode | Country code as defined by ISO 3166-1 alpha-2 |
CountryName | The name of the country |
Targetable | Indicates whether geographical targeting is allowed |
Column Name | Description |
---|---|
Id | Unique identifier for the metro |
MetroCode | 3 digit metro code required for metro targeting |
MetroName | The name of the metro |
CountryCode | Country code as defined by ISO 3166-1 alpha-2 |
CountryName | The name of the country |
Targetable | Indicates whether geographical targeting is allowed |
Column Name | Description |
---|---|
Id | Unique identifier for the city |
CityName | The city name |
MetroCode | 3 digit metro code that the city belongs to |
MetroName | The name of the metro |
RegionCode | Region code as defined by ISO 3166-2 |
RegionName | The name of the region |
CountryCode | Country code as defined by ISO 3166-1 alpha-2 |
CountryName | The name of the country |
Targetable | Indicates whether geographical targeting is allowed |
Column Name | Description |
---|---|
Id | Unique identifier for the postal code |
PostalCode | Postal code |
CountryCode | Country code as defined by ISO 3166-1 alpha-2 |
Targetable | Indicates whether geographical targeting is allowed |
Column Name | Description |
---|---|
Id | Unique identifier for the bandwidth group |
BandwidthName | Name of the bandwidth group |
Column Name | Description |
---|---|
Id | Unique identifier for the browser |
BrowserName | Name of the browser |
MajorVersion | Major version of the browser |
MinorVersion | Minor version of the browser |
Column Name | Description |
---|---|
Id | Unique identifier for the browser language |
BrowserLanguageName | Browser's language |
Column Name | Description |
---|---|
Id | Unique identifier for the device capability |
DeviceCapabilityName | Name of the device capability |
Column Name | Description |
---|---|
Id | Unique identifier for the device category |
DeviceCategoryName | Name of the device category |
Column Name | Description |
---|---|
Id | Unique identifier for the device manufacturer |
MobileDeviceManufacturerName | Name of the device manufacturer |
Column Name | Description |
---|---|
Id | Unique identifier for the mobile carrier |
CountryCode | The country code of the mobile carrier |
MobileCarrierName | Name of the mobile carrier |
Column Name | Description |
---|---|
Id | Unique identifier for the mobile device |
MobileDeviceManufacturerId | Id of the device manufacturer |
MobileDeviceName | Name of the mobile device |
Column Name | Description |
---|---|
Id | Unique identifier for the mobile device submodel |
MobileDeviceId | Id of the mobile device |
MobileDeviceSubmodelName | Name of the mobile device submodel |
Column Name | Description |
---|---|
Id | Unique identifier for the operating system |
OperatingSystemName | Name of the operating system |
Column Name | Description |
---|---|
Id | Unique identifier for the operating system version |
OperatingSystemId | Id of the operating system |
MajorVersion | The operating system major version |
MinorVersion | The operating system minor version |
MicroVersion | The operating system micro version |
Column Name | Description |
---|---|
Id | Unique identifier for the third party company |
Name | The third party company name |
Type | The third party company type |
Status | The status of the third party company |
Column Name | Description |
---|---|
Id | Unique identifier for the time zone in the form of {@code America/New_York} |
StandardGmtOffset | The standard GMT offset of the time zone in the form of {@code GMT-05:00} for{@code America/New_York} |
SupportedInReports | Indicates whether the time zone is supported in reports. Only time zones that are full hour offsets from {@link Network#timeZone} are supported in reports. |
Column name | Type | Description |
---|---|---|
CostType | Text | The method used for billing this {@code LineItem}. |
CreationDateTime | Datetime | The date and time this {@code LineItem} was last created. This attribute may be null for {@code LineItem}s created before this feature was introduced. |
DeliveryRateType | Text | The strategy for delivering ads over the course of the {@code LineItem}'s duration. This attribute is optional and defaults to {@link DeliveryRateType#EVENLY}. Starting in v201306, it may default to {@link DeliveryRateType#FRONTLOADED} if specifically configured to on the network. |
EndDateTime | Datetime | The date and time on which the {@code LineItem} stops serving. |
Id | Number | Uniquely identifies the {@code LineItem}. This attribute is read-only and is assigned by Google when a line item is created. |
IsMissingCreatives | Boolean | Indicates if a {@code LineItem} is missing any {@link Creative creatives} for the {@code creativePlaceholders} specified. |
LastModifiedDateTime | Datetime | The date and time this {@code LineItem} was last modified. |
LineItemType | Text | Indicates the line item type of a {@code LineItem}. |
Name | Text | The name of the {@code LineItem}. |
OrderId | Number | The ID of the {@link Order} to which the {@code LineItem} belongs. |
StartDateTime | Datetime | The date and time on which the {@code LineItem} is enabled to begin serving. |
Status | Text | The status of the {@code LineItem}. |
UnitsBought | Number | The total number of impressions or clicks that will be reserved for the {@code LineItem}. If the line item is of type {@link LineItemType#SPONSORSHIP}, then it represents the percentage of available impressions reserved. |
Column name | Type | Description |
---|---|---|
AdUnitCode | Text | A string used to uniquely identify the ad unit for the purposes of serving the ad. This attribute is read-only and is assigned by Google when an ad unit is created. |
Id | Number | Uniquely identifies the ad unit. This value is read-only and is assigned by Google when an ad unit is created. |
LastModifiedDateTime | Datetime | The date and time this ad unit was last modified. |
Name | Text | The name of the ad unit. |
ParentId | Number | The ID of the ad unit's parent. Every ad unit has a parent except for the root ad unit, which is created by Google. |
PartnerId | Number | The unique ID of the {@link Company}, which is of type {@link Company.Type#AFFILIATE_DISTRIBUTION_PARTNER}, to which this ad unit belongs. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|