szehau's weblog

Life, Internet, Software, Gadgets, Programming and Investments

Adsense Tracker

As I have promised to upload my adsense tracker script at previous post, My Adsense Tracker, finally I have finalized my codes and uploaded it here. At the time I have finished the coding and testing, I found AdsenseLogger. Em… but never mind, at least I have my own tracker.

Adsense Tracker – A tracking script that tracks adsense clicks on one’s website. Adsense tracker gives a general idea on what ad your visitor is looking for.

Adsense Tracker consists of 3 modules:

  1. Tracking scripts with multiple channels supported.
  2. A very simple login page.
  3. Report.
  4. Maintenance.

1. Tracking script with multiple channels supported:

  • Tracking adsense clicks (Ad Unit and Link Unit).
  • Support multiple channels for multiple pages/sites.
  • Track referrer’s and current page’s URL.

2. A very simple login page:

  • Since the script is for personal use only, it requires password only to login

3. Report:

  • Support different time zone by setting the time offset.
  • Group ad by Ad Unit (title only) or Link Unit (keyword only) and click count.
  • Show individual clicks.
  • Generate report based on date range.
  • Generate report based on channel.

4. Maintenance:

  • Purge old transactions to keep database small and for performance wise.
  • Channel maintenance (Add, Rename, Delete).

Requirement:

  • PHP and MySql database.
  • Basic knowledge of editing PHP script.
  • Basic knowledge of MySql’s database administration.

Installation:

  • Download and unzip to a temporary folder. It should only have the following files:
    install.php – Installation page
    login.php – Login page
    maintenance.php – Maintenance page
    report.php – Report page
    setting.php – Setting
    tracker.php – Tracking script
    tracker_js.php – Tracking script (JavaScript)
    style.css – Style sheet
  • Use text editor to open the file setting.php. Modify the parameter in the file as appropiate.
  • Upload all the files to your web’s directory so that you end up with /at/install.php.
  • Create an empty database and run the installation script, e.g. http://www.yoursite.com/at/install.php.
  • Login to Adsense Tracker at /at/login.php and create your own channel, e.g. ‘mainpage’.
  • At the PHP page where you want to track the adsense clicks, insert the following script at the bottom of your page (just before the </body> tag) –
    <?php include_once ('at/tracker_js.php'); ?>
    <?php gettracker_js('mainpage'); ?>
    * where ‘mainpage’ is the channel that you have created at previous step.

Download:

Note:

  • This script is intend for personal use only and not for commercial purposes. You can download, modify and use this script at your own risk.
  • Any comments are welcome.