Page 1 of 1

dynamic most requested pages i.e. /index.asp?page=87

Posted: Thu Dec 08, 2005 3:26 pm
by moskolio
all our pages are dynamically generated from an sql database and the url is like this:
On the most requested pages report though i can only generated outpout for the index page that looks like this.

Most requested pages of the site:
href | Hits | KBytes | Downloads
/ | 134 | 0 | 0
/default.asp | 42 | 0 | 0
/launch/default.asp | 5 | 0 | 0
/launch/programme.asp |1 | 0 | 0

What i want is a detailed output for each page number id like the following report for the Referrer ID:

Most requested referrer IDs:
Referrer ID (uri query) | Hits | Percent
page=87 | 22 | 17.46%
page=88 | 12 | 9.52%
page=89 | 9 | 7.14%
page=93 | 9 | 7.14%
page=90 | 7 | 5.56%
page=1 | 7 | 5.56%

So can you please show me a way to generate a report for the most visited pages that looks like the Referrer ID report?
I would be very gratefull

i am using "MS IIS 5.0 Custom" Log Format with "ex*.log" naming

Posted: Thu Dec 08, 2005 7:03 pm
by Abacre

Here is information about how to handle it for Apache web sites:
Tomorrow we will tell you how to setup ALA for IIS sites (your case).

Posted: Fri Dec 09, 2005 9:11 pm
by Abacre
As promised we send you instructions about how to get stats for
dynamic IIS sites.

Download the updated version from the following location:
Install it over existing version. It will update needed files.

Start Advanced Log Analyzer.

Make sure that cache option is unchecked during your testing
experiments: go to main menu - File - Options - General and uncheck
"Incremental analysis" option.
Press OK.

In main window go to Sites tab.
Click on your web site on the sites list.
check "Show advanced options" option.

Add the following filter to your web site:

Parameter: href
Condition: Includes
Value: /index.asp
Action: assign
New value: /index_<uri_query>.asp

So your page will be shown
in reports as:

Sure we may also find other combinations of filters in order to get more
pretty results. For example, you may add as a first filter: replace
"page=" for uri_query by "page_" and your resulting page will be:
and so on...

the first filter in this case will be:

Parameter: uri_query
Condition: includes
Value: page=
Action: replace_left
New value: page_