Purpose

Specifies the values of Google Analytics startDate, endDate, and viewId query parameters for WHERE clause filtering during a session. Providing values for these parameters simplifies queries.

Valid Values

(key=value[;key=value])

where:

key

is one of the following query parameters:

  • startDate: the inclusive starting date for the query. The default is 30daysago (thirty days prior to the current date).

  • endDate: the inclusive ending date for the query. The default is yesterday (the day prior to the current date).

  • viewId: a comma-separated list of Google Analytics View IDs. A View ID can be obtained from your Google Analytics dashboard (Dashboard>Admin>View Settings>View ID). There is no default..

    Important: In order for SELECT * FROM to work , viewId must be specified. If viewId is not specified using DefaultQueryOptions, then it must be set explicitly in the WHERE clause.

Notes

  • The syntax for startDate and endDate values is as follows:
    • A date in the format YYYY-MM-DD
    • The word today for the current date
    • The word yesterday for the day prior to the current date
    • nndaysAgo where nn is a number of days prior to the current date

Data Source Methods

public String getDefaultQueryOptions()

public void setDefaultQueryOptions(String)

Default Value

If no value is specified (the default), the driver uses startDate=30daysAgo;endDate=yesterday.

Data Type

String