Community Add-Ons

This is a modification to the existing version. I added a German language file, spiffycal, percentages, and order details.

It should be possible to copy this version over an existing one.

This is a real easy mod based on Ad tracker 1.1. I don’t know what changes have been made since then, but as long as the basic function is the same it should work fine.
This add on, simply looks up who your customer selected as a source and adds it to the order information to be viewed under the admin orders page. It solves having to look up where they came from manually.

Table now includes Number of Sales as well as amount generated by each ad. Total amount and total sales over period of time. No need to use osC Affiliate to track your advertising activities. Both modules should be used for their own purpose and Ad Tracker offers much needed tool to keep an eye on your advertising expenses. You're more than welcome to make further improvements as there is no other contribution that will offer you what this one does.

If you're updating from v2.1 or v2.2 just replace admin/stats_ad_results.php and admin/includes/languages/english/stats_ad_results.php.
Full Install Package.
Support Thread: http://forums.oscommerce.com/index.php?showtopic=30626

I need as much information as possible about advertising campaigns and as I could not find any other ad tracking contribution, I decided to use this one, however date range and sorting was needed. Therefore I updated this verion and you can now enter a specific date range, sort ads by amount earned and also generate printable version. It could still be improved further.
If you're updating from v2.1, just replace admin/stats_ad_results.php and amnin/includes/languages/english/stats_ad_results.php.
Full package.
Support thread: http://forums.oscommerce.com/index.php?showtopic=30626

This is the updated package of Ad Tracker 2.1

FULL PACKAGE

The modifications of application_top.php in 3 different places, like stated in v2.1, did not work for me:
the recorded referer was always my own site!

I solved it by modifying application_top.php in only 1 place instead of 3: at the end.

Installation instruction step 4 modified.
Not a full package.

It keeps giving me this error message
"Ad Results

Start Date
(YYYY-MM-DD):
No. Ad Amount Earned
1054 - Unknown column 'customers_advertiser' in 'field list'

select distinct customers_advertiser, sum(value) as total_value from customers, orders, orders_total where customers_advertiser <> '' and customers.customers_id = orders.customers_id and orders.orders_id = orders_total.orders_id and class = 'ot_subtotal' and date_purchased > '' group by customers_advertiser

[TEP STOP]
"
Any help will be appreciated.
Please email me: a_abdrapo@hotmail.com

For users of the Purchase Without Account (PWA) contribution:

In Step 5: UPDATE /catalog/create_account_process.php, you should also update Order_Info_Process.php in the same way. If you don't, none of the ads will show up in admin.

Update by Aaron Hiatt
http://www.scaredrabbit.com

This is an updated full package. The only change I made was in the install instructions.

In osCommerce Version 2.2MS2 filenames are store in the filenames.php file, not application_top.php.

Thanks to the creator of this great Contribution!

Here is the update of the ad tracking 2 application for MS2.

Changes:
//user_tracking modications
if (!$referer_url)
{
if ($HTTP_SERVER_VARS['HTTP_REFERER'])
{
$referer_url = $HTTP_SERVER_VARS['HTTP_REFERER'];
session_register('referer_url');
}
}

//user_ad_tracker modification
if ($ad)
{
$advertiser = $_GET["ad"];
session_register('advertiser');
}

Otherwise, parameters and referer could not be added to the session.

Some small additional changes and bugfixes to get it work. Just have a look at the original and my updated files in the attached zip file.

You can see this script in action at: http://shop.die-hochzeit.com

Comments and feedback appreciated!

I updated the Ad Tracker to include a fix for PHP 3.4.x that was causing query 'link' errors. In addition, I recently added a report that shows total revenue derived from each ad source.

Please note that this tracker should work with the latest build but was only tested on one from Dec 02. I haven't quite gotten around to updating to osCommerce 2.2MS1. I tried but I have way too many mods to bring over so I went back.

Anyway, please let me know if you run into any problems with this latest version. It works great for me and I've been using the report function religiously to track and update my google and overture campaigns.

To see a sample report:
http://www.100monkeys.org/images/store/adresultsreport.gif

Feedback is welcome and encouraged.

I just started using osCommerce three weeks ago and I love it. However, I was desperately trying to find a way to track the various ad campaigns I was running for my new store (www.monkeygoods.com).
<br><br>
This modification allows you to keep track of where your registered users came from. For anyone running multiple ad banners or paid google-type links, knowing which ads are effective is pretty nice.
<br><br>
In addition, I wanted to capture the entire referring url so I could later see what the
users search string was to get to my link.
<br><br>
One database change is needed and four files need to be slightly modified.