QueueTrended: Run a QueueTrended Report

Description

A QueueTrended report is a report where a single metric is retrieved, broken down by an element such as page, eVar, prop, etc. and with a time component. Within the 'element' list, either the "Top X" number of elements can be received or you can specify the specific elements you are interested in (such as 3 specific page names).

Usage

QueueTrended(reportSuiteID, dateFrom, dateTo, dateGranularity, metric, element,
  top = "", startingWith = "", selected = "", segment_id = "",
  anomalyDetection = "", currentData = "", searchType = "",
  searchKW = "", maxTries = 120, waitTime = 5)

Arguments

reportSuiteID

Report Suite ID

dateFrom

Report Start Date in "YYYY-MM-DD" format

dateTo

Report End Date in "YYYY-MM-DD" format

dateGranularity

"Day", "Week", "Month", "Quarter" or "Year" (case-insensitive).

metric

The metric you want to trend.

element

The element (page, browser eVar, prop) for the report to be broken down by.

top

How many results you want trended. Used in combination with "startingWith". Not used if "selected" argument used.

startingWith

The first ranked number you want in the report. Used in combination with "top". Not used if "selected" argument used.

selected

List of selected values, such as specific pages or eVar values. Not used if "top" and "startingWith" arguments are used

segment_id

Optional. If no segment_id is specified, metrics will be reported for all visitors.

anomalyDetection

Optional. Use value of "1" to get anomaly detection results. Results only returned by API for 'Day' granularity.

currentData

Optional. Use value of "1" to get current data results. Only needed when dateTo is greater than or equal to the current day.

searchType

Optional. An enumerated list of boolean values used to link multiple search terms in a report search. Takes values of "AND", "OR" or "NOT".

searchKW

Optional. A list of keywords to include or exclude from the search, based on the searchType. Keyword values can also leverage the following special characters: '*' (Wild card), '^' (Starts With), '$' (Ends With). "Top" argument required when using

maxTries

Optional. Provide integer value for the max number of API attempts you want to try retrieve the report before function errors out. Defaults to 120.

waitTime

Optional. Provide integer value for the number of seconds between tries to API to try retrieve the report. Defaults to 5 seconds.

Value

Data Frame

Details

The QueueTrended report is analogous to pulling a "trended" report within SiteCatalyst, but without the limitation of only 5 elements as in the SiteCatalyst interface.

Because of the Reporting API structure, this function first requests the report, then checks the reporting queue to see if the report is completed, and when the report returns as "done" pulls the report from the API. This checking process will occur up to the specified number of times (default 120), with a delay between status checks (default 5 seconds). If the report does not return as "done" after the number of tries have completed, the function will return an error message.

Note: Because of the multiple argument type ("top" and "startingWith" OR "selected"), keyword arguments are generally needed towards the end of the function call instead of just positional arguments.

Examples

Run this code

#Pageviews for the Top 100 pages by Day in the Loyal_Visitors segment
pages_by_day <-
QueueTrended("keystonerandy", "2013-02-13", "2013-02-19", "day",
"pageviews", "page", top="100", startingWith= "1", segment_id= "Loyal_Visitors")


#Specifying two specific pages, trended by hour for pageviews in the Loyal_Visitors segment
specific_pages_by_hour <-
QueueTrended("keystonerandy", "2013-02-13", "2013-02-19", "hour",
"pageviews", "page", selected = c("http://randyzwitch.com",
"http://randyzwitch.com/about"), segment_id = "Loyal_Visitors")

)

Run the code above in your browser using DataLab