Looking at who came from one source

How do you do it?

[TomWaits]

You have a referrer website, call it referrer.com.

You only want an analysis of your log file for that one referring website. You want to see who is coming from that one referrer to your website.

Which log analysis software will handle that, and how?

[aspdaddy]

You could just use m/s logparser :

logparser "select count(date) from *.log* where referer LIKE '%referrer.com%'"

[TomWaits]

aspdaddy, that looks like exactly what I'm after. Thank you very much. I downloaded Log Parser 2.0, read through some of the documentation, and tried several variations of the syntax that you show above, and I cannot get it to work.

When you state

logparser "select count(date) from *.log* where referer LIKE '%referrer.com%'"

I'm not sure of what syntax it's looking for the date in. And I'm probably doing some other things wrong too.

Here's my latest attempt: at the DOS command prompt, at the c:\program files\log parser level, I type this:

logparser "select count(2003-03-03) from c:\access.log where referer LIKE '%something.com%'"

What am I missing? Does the access log need to be on in the c:\program files\log parser directory?

Any further help you can provide on exact syntax and proper paths I would deeply appreciate. Thanks.

[aspdaddy]

The way I use it is I have it installed it in the same folder as the log files.

Then I just change directory using dos to get in the folder, that way everything is relative to the current folder.

You need to SElect fields from the log file e.g date, ip, user agents etc. I think what you are trying is:
logparser "select count(*)
from c:/access.log
where date ='%2003-03-03%' and referer LIKE '%something.com%'"

Beware select * is v slow on big logfiles.

The syntax is very straightfoward, it is more or less Jet SQL. The only docs I know are the word doc on the download page

HTH

[TomWaits]

I still can't get it to work, but I'll revisit this when I have another chunk of time. I do appreciate the help.

It keeps choking on variations of

referer LIKE '%something.com%'

[TomWaits]

Does anyone know of another product that does this besides Log Parser? Sorry aspdaddy, I failed miserably.

[cfx211]

You could always just load your logs into an Access or a SQL database and run queries against that, especially if you only care about one particular referrer.

select count(*) from log_table where referring_url like '%referrer.com%'

[TomWaits]

<smacks head>I could also do that in Excel. Just did. Worked beautifully.

Thank you very much, cfx. I was overthinking this.