WebLog Expert Help - Custom Tables & Charts

[Requires Professional or Enterprise Edition]

WebLog Expert allows you not only to change properties of existing report items (e.g. number of rows in tables), but also to create your own tables and charts. Most predefined tables and charts can be also modified.

Tables and charts can be managed in Options > Report > Tables.

The Table Properties dialog contains the following pages:

General

Table name:	Name of the table displayed in the report. You can use the %TrackedFile% macro in the name if the Special table type option is set to "Tracked files" and the %Goal% macro if the option is set to "Goals".
Category:	Table category name. You can either choose an existing category or specify a new one.
Section:	Table section name. You can use the %TableName% macro in the section name. Category and section names are used to determine location of the table in the report. They are also shown in the report contents. E.g. you can specify "Top Virtual Domains" as table name, "Access Statistics" as category and "Virtual Domains" as section.
Special table type:	Show custom table for each tracked file or goal. If the table type is set to "Tracked files", visitors that requested the tracked file as well as requests for the file will be analyzed to generate the associated custom table. If the type is set to "Goals", the conversion and conversion rate counts will include statistics for the tracked goal.
Custom analysis settings:	You can specify whether to exclude requests from spiders and/or failed requests. The Exclude requests from spiders setting has effect if the Count visitors as spiders program option is disabled.
Translate table and charts (if required):	Use this setting to translate the table and associated charts when custom report language is specified in the program options or profile properties. You need to have a proper language file that contains translations for the strings used in the table to get it properly shown in the reports.
Block table updates:	Don't update the table when a new version of the program is installed or when tables are loaded from the program options. This setting is useful if you modify a standard table and don't want it to be overwritten.

Data

Basic settings

You can specify main data, group data (if any), columns, base column and sort order used in the table.

Main data and group data contain data based on hits (e.g. file name or status code) as well as data based on visitors (e.g. visitor referring URL). You can use both main/group data based on hits or visitors as well as specify main data based on hits with group data based on visitors and vice versa.

E.g. if you specify file name as main data and directory as group data, the program will show files grouped by directories. If you specify file name as main data and referring URL as group data, the program will show information on files requested by visitors that came from different referring URLs. If you specify referring URL as main data and file name as group data, the program will show information on referrers of visitors who requested different files.

You can choose various columns. The conversion column includes number of visitors that reached any goal. If a table has the "Goals" type, the conversion column includes number of visitors that reached the tracked goal only.

Data from the base column is used to sort the table and is also shown in the associated charts.

Additional settings

You can also specify additional data settings by clicking the Custom button. Available options depend on data chosen.

·Modification rules allow you to specify how to modify values before showing them in the report.

·Count one hit value per visitor - if several different values have been extracted from visitor requests only one of them will be counted in the number of visitors. E.g. even if a visitor used multiple browsers only one of them will be counted. This option doesn't affect other columns (hits/page views/bandwidth/etc.) shown in the table.

·Always show totals for visitors - show totals for the visitors column even if the same visitor may be counted in several rows (e.g. if he/she used multiple browsers). In this case total number of visitors shown in the table may be more than total number of visitors shown in the report general statistics.

·Grouped tables with the goal main data have the Show grouped data in N columns option available. Goals are shown in columns instead of rows if the setting is enabled.

Filters

Filters allow you to specify which information should be shown in the table.

You can use hit and visitor filters at the same time. In this case WebLog Expert first filters visitors and gets visitor data from the remaining visitors. Then it applies hit filters to the hits of these visitors and gets hit data from the hits.

Charts

You can create charts associated with the table if no group data is specified. Chart names can include the %TableName% macro. Click the More button to enter names of weekly/monthly/yearly charts that are used when the Create weekly/monthly/yearly charts instead of daily ones profile property is enabled.