Commerce Server provides several user interfaces that are used in the course of analyzing Web site activity in order to devise improvements to the site. The Analysis category in Business Desk contains two modules related to reporting, and a viewer.
Commerce Server 2002 includes more than 30 pre-defined reports, most of which are dynamic. Because dynamic reports allow the business manager viewing the report to choose many different ways to examine the available data, each dynamic report can be seen as many different reports all rolled into one. Combined with the ability to customize existing reports define entirely new reports, and export report data in a format compatible with Microsoft Excel, Commerce Server offers a very rich reporting environment.
Commerce Server categorizes reports into the following types:
|Product Sales Reports||Buyer Browse to Purchase, Customer Sales, Order Events, Product Sales, Shopping Basket Events|
|Web Usage Reports||Activity by Browser, Directories, Entry Path Analysis, Top Referring Domains by Requests, Top Requested Pages, Usage Summary by Day of Week, Usage Summary by Hour of Day, Usage Summary by Week of Year, Usage Trends|
|Advertising Reports||Ad Reach and Frequency by Date, Ad Reach and Frequency per Advertiser, Campaign Event Summary, Campaign Item Summary|
|User Reports||Distinct Users by Time, New Registered Users, Registered User Properties, Registered Users by Date Registered, User Days to Register, User Registration Rate, User Trends|
|Visit Reports||Entry Pages, Exit Pages, General Activity Statistics, User Visit Trends|
|Diagnostic Reports||Bandwidth Summary, Bandwidth Trends, Hits by HTTP Status, Hits by Win32 Status|
|Query String Reports||Query Strings (multi-value), Query Strings (single value)|
In order for the business managers to be able to run the available reports and analyze the trends they expose, the site administrators must make sure that the corresponding data is routinely imported into the data warehouse from which the reports are derived. The data warehouse is maintained in Microsoft SQL Server, and many of the tasks involved in populating and maintaining the data warehouse are performed using the user interfaces provided by SQL Server. For this reason, the Microsoft SQL Servers node is included in the Microsoft Management Console (MMC) interface that constitutes Commerce Server Manager. Site administrators configure the data warehouse using the Data Warehouse global resource in the Commerce Server Manager node, and import data using the Microsoft SQL Servers node. Data is imported using several SQL Server Data Transformation Services (DTS) tasks designed specifically for importing various types of Commerce Server data.