WebTrends Connector

One of the least publicized but most exciting features in the newest version of WebTrends is the addition of a direct connection to WebTrends data. WebTrends has now given all their customers, not just those who buy the Marketing Lab, access to their data from all the WebTrends reports.

WebTrends

Having a connection to the data is of limited use, however, unless you have the right tool to efficiently connect to and query the data and work with it in a familiar environment. WebTrends customers have long favored Excel as the reporting and analysis tool of choice and now you can make full use of the new WebTrends connector while feeding your addiction to Excel by using DataLinks from Business Intelligence Inc.

DataLinks

Imagine being able to update your Excel reports and analyses with current WebTrends data at the click of a mouse! No more Copy/Paste! With DataLinks you can even join data across different WebTrends reports or profiles and create a consolidated report in Excel! Since DataLinks also connects easily to virtually any other data source you can also use it to combine data from your CRM, ERP or other systems with your WebTrends data, all in the familiar working environment of Excel.

WebTrends data and Microsoft Excel using DataLinks

If you are intrigued by the possibilities, we encourage you to read on to learn how to install and configure the WebTrends connector and the DataLinks desktop program. Once these one-time setup procedures are completed you are ready to reap the benefits of having a direct connection between your WebTrends data and Microsoft Excel using DataLinks from Business Intelligence Inc:

  • Install and configure the WebTrends ODBC Connector.
  • Install and configure DataLinks creating a new datasource in DataLinks for each WebTrends profile that you wish to report on.
  • Use DataLinks to connect to your new WebTrends datasource and build your query/report pushing the dataset out to a worksheet in an Excel workbook using the Query Table option.
  • Use DataLinks to create a relationship between different Tables/Reports in WebTrends and push the resulting dataset out to Excel.
  • Use DataLinks to connect to any other configured data source and build your query/report and push the resulting dataset out to another worksheet in the same Excel workbook as in 3 above using the Query Table option.
  • Save the Excel workbook.
  • Create a new data source in DataLinks pointing to the Excel workbook you just created and saved. Since DataLinks interprets each worksheet in an Excel workbook as a “table” in a database, the user is able to relate data from one source to data from another source by joining the "tables" or worksheets.
  • Push the resulting dataset out to a worksheet in the same workbook or to a new Excel workbook altogether.
  • Refresh the data in all the reports/tables simply by clicking the Refresh All button in Excel.