Charts & Reports

One of the main benefits of WhosOn is that whilst it is providing you with live stats and useful alerts & exceptions it is maintaining a SQL Database of visitor activity. This database can provide you with a wealth of very useful data about your web site traffic.

 

We have included a Charts & Reports Tool which you can use to view historical reports from the WhosOn Database.

 

Run Charts & Reports from the Tools menu (the Tools menu is located on the Windows Start menu - WhosOn folder).

 

The Charts & Reports tool comes pre-supplied with over 75 Charts & Reports.. and if you understand SQL you can add your own. We hope users will send us their queries so we can add them to the list of standard ones.

 

You can select the Site you want to view from the Site drop down menu. You can also select Groups of sites. The results of any Chart or Report will be the combined results of all sites in the folder.

 

Most Charts & Reports allow you to enter a DateRange in the From and To date entries. When you start Charts & Reports the date range defaults to Jan 1st  for the current year to the present date. If you change a date click the Refresh button to update the chart or report. You can also move back or forward by 1 day, week, month or year.

 

Charts that chart by date can also show data grouped by Day , Week  or Month . When viewing visitor traffic reports by date it’s often useful to just concentrate on weekdays – since Saturdays & Sundays will always have lower figures. Click the Exclude Weekends to exclude results for Saturdays & Sundays from the view.

 

When viewing a Chart you can always view the data behind it by click the Data tab

 

 

The Data tab will also show the Total, Average, Highest & Lowest values. You can export the data to a CSVfile by clicking the Save button.

 

Some Charts show in Pie chart format:

 

 

Reports show data in a tabular format that cannot be shown as a chart (or is better suited to a report type view).

 

 

Reports will show totals for most numerical columns.

 

This data can also be saved to a CSV file using the Save button.