Webtrends ODBC driver only selects current day’s data


Webtrends Analytics 9.x
Webtrends Analytics 8.x


The Webtrends ODBC driver only selects the current day’s data instead of larger and customizable date ranges.


The Webtrends ODBC Driver interacts with Webtrends by making calls through the user interface. The user interface calls the Webtrends “on demand database” (ODDB) for the requested report data. Webtrends stores its data in five tables (sometimes referred to as buckets). The default date range returned when viewing a report is the current or the last day of analysis, which is why when importing data into Excel or Access only one day of data is displayed.

There are two ways to specify time ranges. In the query, specify a TimePeriod such as the one below:

2006.m08.d01 to 2006.m08.d31

Alternately, in the query, specify a StartDate like the following: 08/01/2006 00:00:00

…and an EndDate like: 08/31/2006 23:59:59

This will query the ODDB for the requested date range.

More Information

For more detailed information, refer to the Webtrends Marketing Lab Programmer’s Reference in the Webtrends Documentation Center at the following URL: