filter for just product ids?

General discussions about Advanced Log Analyzer
Post Reply
Guest

filter for just product ids?

Post by Guest »

i have a product id with the value ?pid= in the URL, how do i create a filter to list the most popular product id's?

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Post by Abacre »

Hi,

There are plenty of different ways. For example you may create new
basic report with href as parameter or even better: uri_query parameter.

Then create the following filter to
the report:
href includes ?pid=
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

Guest

still cant get filter to work

Post by Guest »

i have tried both the uri_query and href but it still returns no data, however i have looked at the log file i am using and there is a value for the product ID (pid) as you can see bellow:

2004-12-13 00:29:11 xxxx 192 213.XXX.XXX.XX GET /img/logos.gif - 80 - 217.XXX.XXX.XX HTTP/1.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+98) ASPSESSIONIDQAAATDDR=NJBEJENDDEFKHIKOJBEJOOMK http://www.bearing-gifts.net/bearing_gi ... sp?pid=406 304 0 0 214 441 0

the filters i have tried are:

filter=uri_query;includes;pid
filter=uri_query;includes;pid=
filter=uri_query;includes;?pid=
filter=href;includes;pid
filter=href;includes;pid=
filter=href;includes;?pid=

thanx

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Re: still cant get filter to work

Post by Abacre »

Anonymous wrote:2004-12-13 00:29:11 xxxx 192 213.XXX.XXX.XX GET /img/logos.gif - 80 - 217.XXX.XXX.XX HTTP/1.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+98) ASPSESSIONIDQAAATDDR=NJBEJENDDEFKHIKOJBEJOOMK http://www.bearing-gifts.net/bearing_gi ... sp?pid=406 304 0 0 214 441 0


In this line:
/img/logos.gif is href

and
http://www.bearing-gifts.net/bearing_gi ... sp?pid=406

is referrer parameter

so you have to use referrer as parameter for your report and the
following filter:
refreer includes ?pid=
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

mav1979
Posts: 2
Joined: Fri Apr 15, 2005 8:43 am

Dynamic site

Post by mav1979 »

Hello. After reading the post above, I have been able to create my own custom report, but i could not fot the life of me make it display the
?stockcode= part of the referer.

in my report i get a lot of:
/info.asp
/info.asp
/info.asp

and I really need the dynamic part of the string.
I dont know what im doing really, I tried to follow the steps in the post above and I created a report, but it was empty.

Please help!

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Post by Abacre »

Do you use uri_query as a parameter? What is format of your log file?
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

mav1979
Posts: 2
Joined: Fri Apr 15, 2005 8:43 am

Post by mav1979 »

we run IIS6 on windows 2003 server. here are 2 entries from the log file that show the /info.asp file and the stockcode= bit i am trying to get displayed in the report.

Ideally, this would be exactly like the last 100 user paths, but with this dynamic string on the end. I really need to know which of our products are most popular to market them accordingly.

2005-04-12 00:14:32 W3SVC911645054 DMZ1 255.255.0.4 GET /info.asp Referer=DT&StockCode=PTR/HP/Q1319A 80 - 66.66.66.66HTTP/1.1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1) GTBasket=Qty1=2&Product1=PTR%2FHP%2FQ1319A;+ASPSESSIONIDSSCBCQTT=HFAAHGCBFEACLJKCMKJCLCLA http://www.superxx.com/info.asp?Referer ... /HP/Q1319A http://www.superxx.com 200 0 0 21002 582 1375


2005-04-12 00:14:39 W3SVC911645054 DMZ1 255.255.0.4 GET /info.asp Referer=DT&StockCode=CAS/IN/KHDBASEU 80 - 66.66.66.66 HTTP/1.1 Mozilla/5.0+(Windows;+U;+Windows+NT+5.1;+en-GB;+rv:1.7.6)+Gecko/20050321+Firefox/1.0.2 - http://cgi.ebay.co.uk/ws/eBayISAPI.dll? ... 77730&rd=1 http://www.superxx.com 200 0 0 19948 557 3046


thank you for the quick response.
you program has made my life 50% easier, this last bit would give me a lot more free time to promote the site on popular items.

Post Reply