NAME

Apache::SearchEngineLog - Logging of terms used in search engines

SYNOPSIS

#in httpd.conf

PerlSetEnv DBI_data_source  dbi:driver:dsn
PerlSetEnv DBI_username     username
PerlSetEnv DBI_password     password
PerlSetEnv DBI_table        db_table #optional, defaults to "hits"

PerlModule Apache::SearchEngineLog

<Location /test>
  PerlLogHandler Apache::SearchEngineLog
</Location>

DESCRIPTION

Apache::SearchEngineLog logs the terms used at a search engine into a SQL Database, making it easy to analyse it and in turn optimize your website.

TABLE LAYOUT

The table "hits" should look somewhat like this:

+--------+-------------+------+-----+---------------------+-------+
| Field  | Type        | Null | Key | Default             | Extra |
+--------+-------------+------+-----+---------------------+-------+
| term   | varchar(50) |      |     |                     |       |
| vhost  | varchar(20) |      | MUL |                     |       |
| uri    | varchar(50) |      |     |                     |       |
| domain | varchar(20) |      |     |                     |       |
| date   | datetime    |      |     | 0000-00-00 00:00:00 |       |
+--------+-------------+------+-----+---------------------+-------+

This is the table "config":

+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| domain | varchar(20) |      | PRI |         |       |
| field  | varchar(10) |      |     |         |       |
+--------+-------------+------+-----+---------+-------+

SEE ALSO

mod_perl(3), Apache(3)

AUTHOR

Florian Forster, octopus@verplant.org