Reports

Reports present log file statistics in an attractive and easily navigable graphical format.

The Reports Header

The header of the Reports page is a bar containing the following:

• Logo: The logo for Sawmill.

• Profile Name: The name of the active profile (the profile whose reports are displayed).

• Config Options: A link to the configuration area that shows where your log source is coming from, log filters and database info and report options.

• Database / Tools: A link to database information and build and update database actions.

• Admin: A link to the administrative interface (profiles list, and other administrative functions).

• Logout: A link to log out of Sawmill, with the user name in brackets.

• Help: A link which opens a new window containing the Sawmill documentation.

• About: Shows you which version of Sawmill you are running, and if you are running the trail version, how many days you have left.

The Reports Tool Bar

Below the header is a bar which contains the following:

• Date Picker: Click this to open the Date Picker window, where you can select a range of days to use as the date/time filter. When you have selected a range in the Date Range, all reports will show only information from that time period, until the date/time filter is removed.

• Filters: Click this to open the Filters window, where you can create filters for any fields, in any combination. Filters created here dynamically affect all reports for a particular profile. Once you have set a Filter, all reports will show only information for that section of the data. Filters remain in effect until you remove them in the Filter window.

• Macros: You can create a new macro here or manage an existing one.

• Miscellaneous: Click this to email the report, save changes, save as a new report, or to get the database info, where you can also update or rebuild the database.

• Printer Friendly: Click on this icon and a separate page will launch, with only the report showing without the menus, ready to print.

• Customize: This link takes you directly to the Reports Editor for this profile.

The Reports Menu

At the left of the window is the Reports Menu, which lets you select the report to view. When you first open the report, the Overview report is visible. As you scroll through this menu, you can choose what information you want in the report. Clicking a category will expand or collapse that category; clicking an item in the category will change the report display to show that one. For instance, clicking Date and time, will expand the category and by clicking on Date/times, that report will open showing the date range for your data.

Calendar: Click this to open the Calendar window, this shows the date range that the statistics cover. To change this range, use the Date Picker in the tool bar.

Overview: This will bring you back to the Overview summary of your data.

Date and Time: For each category, you can select the date and times in years, months, days, days of weeks, and hours of day.

Hit Types: This section will show the list of hit types along the left vertical column, with the number of page views, spiders, worms, errors, broken links, etc. for each hit type. You can customize this report by clicking on the Customize button, and select or deselect the types of hits you want to show.

Content: Content creates a report with either pages/directories, pages, file types or broken links as the first column, and shows the top hits, page views, spiders, worms, etc. for each page. You can customize this report to show more or less columns as needed.

Visitor Demographics: This section allows you to sort the data according to your visitor demographics, such as hostnames, domains, geographical areas, organizations, ISPs, and unique users. As in the other categories, you can customize these reports, choosing the number of columns you want to report on.

Visitor Systems: This section refers to the systems, as in hardware and monitors, that your visitors are using. You can see what web browsers they are using and also the operating systems. As in the previous sections, you can customize these reports as well, adding or eliminating the columns.

Single Page Summary: In the default view, the Single Page Summary shows the Overview Report and all of the other reports included in the Report Menu. The Single Page Summary is fully configurable, you can select Customize Report in Config, and choose which reports you want shown. Once you go into the config area, you can select or deselect the reports along the left menu. The middle section shows the current report elements, which can be added to or deleted from.

Log Detail: The Log Detail report is the most granular report, because it shows the date/time timestamp which is up to the minute for each log. In the default setting, it lists the hit type, page, hostname, referrer, server domain, etc. for each log. You can customize this report adding or deleting columns. But it will give you the most complete information of your log files.

The Report

The main portion of the window is occupied by the report itself. This is a view of the data selected by the filters that are preset or that you have selected. This provides one breakdown of the data specified by the filters -- you can select another report in the Reports Menu to break down the same data in a different way.

There are several parts of the report:

The Report Bar

At the top of the report is a bar containing the report label and the current global and date/time filters, if any.

The Report Graph

For some reports, there will be a graph above the table. The existence of this graph, its size, type (e.g. pie chart or bar or line), and other characteristics, varies from report to report, and can be edited in the Report Options. The graph displays the same information as the table below it.

The Report Table

The Report Table contains the main information of the report. It displays one row per database field item, with the aggregated numerical values (e.g. sum of hits) in columns next to it. It may also include columns showing bar graph representations of the numbers, and/or percentages. The Customize link above and to the right of the table can be used to change which columns are visible, the number of rows, the sort order, and other aspects of the report. The sort order can also be changed by clicking a column name; click once to sort by that column, or again to sort in reverse.

Filters

There are many levels of filters when viewing reports:

• Log Filters. These remain in effect until they are removed in the Log Filters page.

• Date/Time Filters. These remain in effect until they are removed in the Date Picker.

• Global Report Filters. These are options set in the Report Options configuration page, per report, and apply to all reports in the profile.

• Report Element Filters. These are set per-report-element in the Reports Editor configuration page. These filters will persist until removed.

All these filters are "anded" together; i.e. an item is in the total filter set if it is selected by the Filters AND by the Date/Time Filters AND by the Report Filters AND by the Report Element Filters. For instance, if the Date and Time Filters show hours of days events during 1am-2am, and the Days Filters show events on January 1, then the table will show event from January 1, during 1am-2am.