statement: Build Adwords Query Language Statement

View source: R/statement.R

statementR Documentation

Build Adwords Query Language Statement

Description

Generates and builds the Adwords Query Language Statement for querying the Adwords API.

Usage

statement(select = c("AccountDescriptiveName", "AccountId",
  "Impressions", "Clicks", "Cost", "Date"),
  report = "ACCOUNT_PERFORMANCE_REPORT", where, start = "2018-01-01",
  end = "2018-01-10", apiVersion = "201809", compress = TRUE)

Arguments

select

Attributes

report

Report type

where

Condition list, e.g. "CampaignName STARTS_WITH 'A' AND Clicks > 100", multiple conditions can be only combined with AND Operators: = | != | > | >= | < | <= | IN | NOT_IN | STARTS_WITH | STARTS_WITH_IGNORE_CASE | CONTAINS | CONTAINS_IGNORE_CASE | DOES_NOT_CONTAIN | DOES_NOT_CONTAIN_IGNORE_CASE

start

Beginning of date range. Format: 2018-01-01

end

End of date rage. Format: 2018-01-10

apiVersion

Adwords API Version, supports 201809, 201806, 201802 defaults to 201809.

compress

TRUE / FALSE, Gzipped data download if TRUE

Value

The statement neccessary for the getData function.

Examples

body <- statement(select=c('CampaignName','Clicks','Cost','Ctr'),
                  report="CAMPAIGN_PERFORMANCE_REPORT",
                  where="CampaignName STARTS_WITH 'A' AND Clicks > 100",
                  start="2018-01-20",
                  end="2018-01-21")
body <- statement(select=c('Criteria','Clicks','Cost','Ctr'),
                  report="KEYWORDS_PERFORMANCE_REPORT",
                  where="Clicks > 100",
                  start="2018-01-20",
                  end="2018-01-21")    
body <- statement(select=c('Clicks','AveragePosition','Cost','Ctr'),
                  report="ACCOUNT_PERFORMANCE_REPORT",
                  start="2018-01-20",
                  end="2018-01-21") 

jburkhardt/RAdwords documentation built on March 26, 2022, 7:20 p.m.