All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.google.api.ads.dfp.jaxws.v201602.PublisherQueryLanguageServiceInterface Maven / Gradle / Ivy

There is a newer version: 5.8.0
Show newest version

package com.google.api.ads.dfp.jaxws.v201602;

import javax.jws.WebMethod;
import javax.jws.WebParam;
import javax.jws.WebResult;
import javax.jws.WebService;
import javax.xml.bind.annotation.XmlSeeAlso;
import javax.xml.ws.RequestWrapper;
import javax.xml.ws.ResponseWrapper;


/**
 * 
 *       Provides methods for executing a PQL {@link Statement} to retrieve
 *       information from the system. In order to support the selection of columns of
 *       interest from various tables, {@link Statement} objects support a "select"
 *       clause.
 *       

* An example query text might be {@code "select CountryCode, Name from * Geo_Target"}, where {@code CountryCode} and {@code Name} are * columns of interest and {@code Geo_Target} is the table. *

*

* The following tables are supported: *

* *

Geo_Target

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the Geo target
NameThe name of the Geo target
CanonicalParentIdThe 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 *
ParentIdsA comma separated list of criteria IDs of all parents of the geo target ordered by ascending * size
CountryCodeCountry code as defined by ISO 3166-1 alpha-2
TypeAllowable values: *
    *
  • Airport
  • *
  • Autonomous_Community
  • *
  • Canton
  • *
  • City
  • *
  • Congressional_District
  • *
  • Country
  • *
  • County
  • *
  • Department
  • *
  • DMA_Region
  • *
  • Governorate
  • *
  • Municipality
  • *
  • Neighborhood
  • *
  • Postal_Code
  • *
  • Prefecture
  • *
  • Province
  • *
  • Region
  • *
  • State
  • *
  • Territory
  • *
  • Tv_Region
  • *
  • Union_Territory
  • *
*
TargetableIndicates whether geographical targeting is allowed
* *

Bandwidth_Group

* * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the bandwidth group
BandwidthNameName of the bandwidth group
* *

Browser

* * * * * * * * * * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the browser
BrowserNameName of the browser
MajorVersionMajor version of the browser
MinorVersionMinor version of the browser
* *

Browser_Language

* * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the browser language
BrowserLanguageNameBrowser's language
* *

Device_Capability

* * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the device capability
DeviceCapabilityNameName of the device capability
* *

Device_Category

* * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the device category
DeviceCategoryNameName of the device category
* *

Device_Manufacturer

* * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the device manufacturer
MobileDeviceManufacturerNameName of the device manufacturer
* *

Mobile_Carrier

* * * * * * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the mobile carrier
CountryCodeThe country code of the mobile carrier
MobileCarrierNameName of the mobile carrier
* *

Mobile_Device

* * * * * * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the mobile device
MobileDeviceManufacturerIdId of the device manufacturer
MobileDeviceNameName of the mobile device
* *

Mobile_Device_Submodel

* * * * * * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the mobile device submodel
MobileDeviceIdId of the mobile device
MobileDeviceSubmodelNameName of the mobile device submodel
* *

Operating_System

* * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the operating system
OperatingSystemNameName of the operating system
* *

Operating_System_Version

* * * * * * * * * * * * * * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the operating system version
OperatingSystemIdId of the operating system
MajorVersionThe operating system major version
MinorVersionThe operating system minor version
MicroVersionThe operating system micro version
* *

Third_Party_Company

* * * * * * * * * * * * * * * * * * * * * *
Column NameDescription
IdUnique identifier for the third party company
NameThe third party company name
TypeThe third party company type
StatusThe status of the third party company
*

Line_Item

Column nameTypeDescription
CostTypeTextThe method used for billing this {@code LineItem}.
CreationDateTimeDatetimeThe date and time this {@code LineItem} was last created. This attribute may be null for {@code LineItem}s created before this feature was introduced.
DeliveryRateTypeTextThe 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.
EndDateTimeDatetimeThe date and time on which the {@code LineItem} stops serving.
ExternalIdTextAn identifier for the {@code LineItem} that is meaningful to the publisher.
IdNumberUniquely identifies the {@code LineItem}. This attribute is read-only and is assigned by Google when a line item is created.
IsMissingCreativesBooleanIndicates if a {@code LineItem} is missing any {@link Creative creatives} for the {@code creativePlaceholders} specified.
IsSetTopBoxEnabledBooleanWhether or not this line item is set-top box enabled.
LastModifiedDateTimeDatetimeThe date and time this {@code LineItem} was last modified.
LineItemTypeTextIndicates the line item type of a {@code LineItem}.
NameTextThe name of the {@code LineItem}.
OrderIdNumberThe ID of the {@link Order} to which the {@code LineItem} belongs.
StartDateTimeDatetimeThe date and time on which the {@code LineItem} is enabled to begin serving.
StatusTextThe status of the {@code LineItem}.
TargetingTargetingThe targeting criteria for the ad campaign.<p> * <b>This object is experimental! * <code>Targeting</code> is an experimental, innovative, and rapidly * changing new feature for DFP. Unfortunately, being on the bleeding edge means that we may make * backwards-incompatible changes to * <code>Targeting</code>. We will inform the community when this feature * is no longer experimental.</b>
UnitsBoughtNumberThe 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.

Ad_Unit

Column nameTypeDescription
AdUnitCodeTextA 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.
ExternalSetTopBoxChannelIdTextThe channel ID for set-top box enabled {@link AdUnit ad units}.
IdNumberUniquely identifies the ad unit. This value is read-only and is assigned by Google when an ad unit is created.
LastModifiedDateTimeDatetimeThe date and time this ad unit was last modified.
NameTextThe name of the ad unit.
ParentIdNumberThe ID of the ad unit's parent. Every ad unit has a parent except for the root ad unit, which is created by Google.
PartnerIdNumberThe unique ID of the {@link Company}, which is of type {@link Company.Type#AFFILIATE_DISTRIBUTION_PARTNER}, to which this ad unit belongs.

User

Column nameTypeDescription
EmailTextThe email or login of the user.
ExternalIdTextAn identifier for the user that is meaningful to the publisher.
IdNumberThe unique ID of the user.
IsServiceAccountBooleanTrue if this user is an OAuth2 service account user, false otherwise.
NameTextThe name of the user.
RoleIdNumberThe unique role ID of the user. {@link Role} objects that are created by Google will have negative IDs.
RoleNameTextThe name of the {@link Role} assigned to the user.

Exchange_Rate

Column nameTypeDescription
CurrencyCodeTextThe currency code that the exchange rate is related to. The exchange rate is between this currency and {@link Network#currencyCode the network's currency}. This attribute is required for creation and then is readonly.
DirectionTextThe direction that the exchange rate is in. It determines whether the exchange rate is from this currency to {@link Network#currencyCode the network's currency}, or from {@link Network#currencyCode the network's currency} to this currency. This attribute can be updated.
ExchangeRateNumberThe latest exchange rate at current refresh rate and in current direction. The value is stored as the exchange rate times 10,000,000,000 truncated to a long. Setting this attribute requires the refresh rate to be already set to {@link ExchangeRateRefreshRate#FIXED}. Otherwise an exception will be thrown.
IdNumberThe ID of the {@code ExchangeRate}. This attribute is readonly and is assigned by Google when an exchange rate is created.
RefreshRateTextThe refresh rate at which the exchange rate is updated. Setting this attribute to {@link ExchangeRateRefreshRate#FIXED} without setting the exchange rate value will cause unknown exchange rate value returned in future queries.

Programmatic_Buyer

Column nameTypeDescription
AdxBuyerNetworkIdNumberThe ID used by Adx to bill the appropriate buyer network for a programmatic order.
BuyerIdNumberThe ID used by the buyer for their billing reference. This may represent either an Advertiser or Partner ID.
NameTextDisplay name that references the buyer.
ParentIdNumberThe ID of the programmatic buyer's parent. For advertisers, this field contains the advertiser's partner ID. For partners, this field is zero.
TypeTextThe type of a programmatic buyer.

Audience_Segment_Category

Column nameTypeDescription
IdNumberThe unique identifier for the audience segment category.
NameTextThe name of the audience segment category.
ParentIdNumberThe unique identifier of the audience segment category's parent.

Audience_Segment

Column nameTypeDescription
CategoryIdsSet of numberThe ids of the categories that this audience segment belongs to.
IdNumberThe unique identifier for the audience segment.
NameTextThe name of the audience segment.
OwnerAccountIdNumberThe owner account id of the audience segment.
OwnerNameTextThe owner name of the audience segment.
SegmentTypeTextThe type of the audience segment.

Proposal_Retraction_Reason

Column nameTypeDescription
IdNumberThe ID of the {@code ProposalRetractionReason}. This attribute is readonly and is assigned by Google when a proposal retraction reason is created.
IsActiveBooleanTrue if the {@code ProposalRetractionReason} is active.
NameTextThe name of the {@code ProposalRetractionReason}.

Audience_Explorer

Column nameTypeDescription
IdNumberUniquely identifies the audience segment.
ThirtyDayActiveSizeNumberThe number of active unique cookies in this segment over the last 30 days.
ThirtyDayClicksNumberThe number of clicks for this segment over the last 30 days.
ThirtyDayImpressionsNumberThe number of impressions for this segment over the last 30 days.

Time_Zone

Column nameTypeDescription
IdTextThe id of time zone in the form of {@code America/New_York}.
StandardGmtOffsetTextThe standard GMT offset in current time in the form of {@code GMT-05:00} for {@code America/New_York}, excluding the Daylight Saving Time.

Proposal_Terms_And_Conditions

Column nameTypeDescription
ContentTextThe content of the terms and conditions.
IdNumberUniquely identifies the terms and conditions.
IsDefaultBooleanWhether or not this set of terms and conditions are the default for a network.
LastModifiedDateTimeDatetimeThe date and time this terms and conditions was last modified.
NameTextThe name of the terms and conditions.
* * * This class was generated by the JAX-WS RI. * JAX-WS RI 2.2.9-b130926.1035 * Generated source version: 2.1 * */ @WebService(name = "PublisherQueryLanguageServiceInterface", targetNamespace = "https://www.google.com/apis/ads/publisher/v201602") @XmlSeeAlso({ ObjectFactory.class }) public interface PublisherQueryLanguageServiceInterface { /** * * Retrieves rows of data that satisfy the given {@link Statement#query} from * the system. * * @param selectStatement a Publisher Query Language statement used to * specify what data needs to returned * * @return a result set of data that matches the given filter * * * @param selectStatement * @return * returns com.google.api.ads.dfp.jaxws.v201602.ResultSet * @throws ApiException_Exception */ @WebMethod @WebResult(name = "rval", targetNamespace = "https://www.google.com/apis/ads/publisher/v201602") @RequestWrapper(localName = "select", targetNamespace = "https://www.google.com/apis/ads/publisher/v201602", className = "com.google.api.ads.dfp.jaxws.v201602.PublisherQueryLanguageServiceInterfaceselect") @ResponseWrapper(localName = "selectResponse", targetNamespace = "https://www.google.com/apis/ads/publisher/v201602", className = "com.google.api.ads.dfp.jaxws.v201602.PublisherQueryLanguageServiceInterfaceselectResponse") public ResultSet select( @WebParam(name = "selectStatement", targetNamespace = "https://www.google.com/apis/ads/publisher/v201602") Statement selectStatement) throws ApiException_Exception ; }




© 2015 - 2025 Weber Informatics LLC | Privacy Policy