Navigation
Home Page
Product Overview
Log Processing
Reporting Tool
Standard Reports
Advanced Reports
Word Report Tool
Register Interest

Useful Links
Debian
MySQL
Remote Data Services
Office Web Components

Customer Login
Report Database
Username
Password

Website Statistics are compliant with the rules and regulations as set by industry standards for web log processing.
Website Log Analysis And Reporting

Advanced Reports

Using the Report Administration Tool it is possible to build any number of customised reports applicable to your individual needs. Say you have a specific file or web page that you want to monitor and report on, or perhaps you have an affiliate deal with another website and you want to report on the number of page refers or unique user referrals that affiliate website passes to yours. You can do all this and more with the ANL Website Log Analysis and Reporting System.

Using MySQL as a backend database provides extensive functionality within database queries. There is a large number of string manipulation functions that can be used within database statements - perfect for querying the text that occurs in web logs.

Here's some examples on how you might utilise the above functionality to create your own advanced reports.

AFFILIATE DEALS
Let's say that we have an affiliate deal with the website ebookconnections.com. Part of the deal specifies that ebookconnections.com gets 10p for every unique user passed from their website to ours. We pay ebookconnections.com at the end of every month so need a report showing the number of referrals per day and a calculation of how much we owe them.

Using the Report Administration Tool we create a database query to count all of the Unique Visitors passed to us from ebookconnections.com for a specified month which we can choose easily from a drop box. The database query also calculates the amount of pennies we owe ebookconnections.com and outputs an Excel Spreadsheet by default. All of these details are parameterised, so we can specify how much we pay for each Unique Visitor. With the Report Administration Tool we can also add any number of affiliate websites as parameters for the query.

Here's how our report might look. Click the image for the bigger picture.


SPECIFIC FILE DOWNLOADS
Pretend we have written some software for sale on our website. We offer potential customers to download a demo or evaluation version of our program and want to check how many downloads of that file have taken place during a specific month.

Using the Report Administration Tool we create a report that offers Month and Year parameters to select the date and a text box with the default setting "demo_v1.zip".

The text box will allow us to easily change the filename in case we release different versions of our evaluation software and the files are called different names.

The report is configured to display a table of results as default.