statement {RAdwords}

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")