Written by: Bruce Chapman
Thursday, March 06, 2008 1:51 PM

 I've created a set of reports that expand the DNN Site Log Reports.  I wrote these reports to get more information out of the treasure-trove of log data stuck in the DNN tables.  In particular, I've always wanted a site-level view of the link clicks, particular with regard to file and page clicks.

The three reports are:

• Link Clicks Report : Shows the link click statistics for any links in DNN which have been marked as 'Log each click'.
• File Downloads Report: Shows the link click statistics for any downloads from a file link.
• User Visit Detail:  Shows the detail of an individual user visit, including entry and exit times, pages viewed, referring Url and any Affiliate information.

 Link Clicks Report

 The Link Clicks report give a simple overview of the different links in a DNN portal, and how often they are clicked. The Clicks per day averages out the number of clicks since the link was created. Here is an example:

File Downloads Report

The file downloads report works off any file where you have used a standard DNN link module entry to download a file via a postback (instead of a straight Url to the file location). The report shows how many downloads there have been for each file, and how much data has been transferred for that file. The Clicks per day averages out the number of clicks since the link was created. Here is an example:

User Visit Detail

The User Visit Detail report gives a more detailed listing of actual user visits, showing where a user started and finished their visit, including the number of pages and if they came in on an Affiliate link. It can be quite useful for tracking individual problems and getting a good overview on how visitors actually use your site. Here is an example:

I removed the IP addresses in the interests of privacy

How to Install

Here is the very simple steps to install the reports;

1. Download the DotNetNuke Reports Scripts
2. Extract the zip file to a location on your computer, and open one of script files in a text editor
3. On your DNN installation, go to the Host->Sql page
4. Paste the script from the file into the 'SQL' box on the page
5. Check the 'Run as Script' checkbox
6. Click on 'Execute'
7. Repeat for each of the Reports you want to install
8. Go to your Admin->Site Log page
9. You will see the new reports in the drop down list.  Select the report and run.
10. Enjoy!

NOTE: The Link Click reports (File Downloads and Link Clicks) are not affected by the date range boxes shown on the Site Log Reports page.  Changing these dates will have no affect, as the links are only saved as a total, not logged over time.

Copyright ©2008 Bruce Chapman

Trackback Print

Location: Blogs Crafty Code

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment    Cancel