dfp_select

0th

Percentile

PublisherQueryLanguageService

Provides methods for executing a PQL Statement to retrieve information from the system. In order to support the selection of columns of interest from various tables, Statement objects support a "select" clause. An example query text might be "select CountryCode, Name from Geo_Target", where CountryCode and Name are columns of interest and Geo_Target is the table.

Usage
dfp_select(request_data, verbose = FALSE)
Arguments
request_data

a list or data.frame of data elements to be formatted for a SOAP request (XML format, but passed as character string)

verbose

a boolean indicating whether to print the service URL and POSTed XML

Details

The following tables are supported:

  • Geo_Target

  • Bandwidth_Group

  • Browser

  • Browser_Language

  • Device_Capability

  • Device_Category

  • Device_Manufacturer

  • Mobile_Carrier

  • Mobile_Device

  • Mobile_Device_Submodel

  • Operating_System

  • Operating_System_Version

  • Third_Party_Company

  • Line_Item

  • Ad_Unit

  • User

  • Exchange_Rate

  • Programmatic_Buyer

  • Audience_Segment_Category

  • Audience_Segment

  • Proposal_Retraction_Reason

  • Time_Zone

  • Proposal_Terms_And_Conditions

  • Change_History

  • ad_category

Visit the See Also section below to proceed to Google and view columns in each of these tables.

select

Retrieves rows of data that satisfy the given Statement query from the system.

Value

a data.frame or list containing all the elements of a selectResponse

See Also

Google Documentation for select

Aliases
  • dfp_select
Examples
# NOT RUN {
 request_data <- list(selectStatement=
 list(query='SELECT Id, Name, Targeting FROM LineItem LIMIT 3')) 
 dfp_select_result <- dfp_select(request_data)
 
 request_data <- list(selectStatement=
 list(query="SELECT Id
                  , Name
                  , CanonicalParentId
                  , CountryCode
                  , Type 
             FROM Geo_Target 
             WHERE CountryCode='US' AND (TYPE='STATE' OR TYPE='COUNTY')"))
 us_geos <- dfp_select(request_data)
# }
Documentation reproduced from package rdfp, version 0.1.4, License: MIT + file LICENSE

Community examples

Looks like there are no examples yet.