Supertracker

[a_berezin]

Ported from osc (and some code clearing).

The supertracker contrib is designed to give you more information on which to base marketing decisions for your store. I created the supertracker contrib because, although there were some contribs around that provide a more detailed who's online tool, nothing quite gave me the information I was after.

Here is the information that is recorded for each customer arriving at your site:

referring page
referring query (so we can get at keywords used if search engine)
landing page (including query string - important for Pay Per Click campaign assessment)
arrival time
exit time
exit page
IP address
country code / country name
customer's cart contents
Number of clicks on the site (accuracy is not 100% as this is recorded based on session ID)
Categories Viewed
Products viewed
Customer ID (if signed in)
Order ID (if order was placed)
Were products added to cart (true/false)
Did the customer Checkout (true/false)

Will not be finished, to develop and to be supported. Because I write other, tracking module. But you can add comments, bugs, wishes and modifications.

And no installing readme. Only for the experienced users!!!

Download Supertracker
Download Supertracker - GeoIP.dat and Flags
Download and instal both files!


NOW AVAILABLE IN ZEN CART DOWNLOADS AREA:
http://www.zen-cart.com/index.php?ma...roducts_id=683

[mikajlo]

Thanks barezin for this mod. I have installed all files and successfully created a supertracer table in the database, but some of the reports do not work:
if I select Visitors Countries Stats: I got this:
"1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,IMPLICIT) for operation '='
in:
[SELECT COUNT(*) AS count, s.country_code, c.countries_name FROM supertracker s LEFT JOIN countries c ON (c.countries_iso_code_2 = s.country_code) GROUP BY country_code]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
"

If I select last ten visitors, I get this:
"1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,IMPLICIT) for operation '='
in:
[SELECT s.*, c.countries_name, s.country_code FROM supertracker s LEFT JOIN countries c ON (c.countries_iso_code_2 = s.country_code) ORDER BY last_click DESC LIMIT 0, 10]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
"

Every report by Refferer has 0 records.

What I did wrong?

Thanks in advance.

Milan Ivanović

[a_berezin]

Run this sq:

DROP TABLE IF EXISTS `supertracker`;
CREATE TABLE `supertracker` (
  `tracking_id` bigint(32) NOT NULL auto_increment,
  `ip_address` varchar(15) NOT NULL default '',
  `browser_string` varchar(255) NOT NULL default '',
  `country_code` char(2) NOT NULL default '',
  `country_name` varchar(100) NOT NULL default '',
  `customer_id` int(11) NOT NULL default '0',
  `order_id` int(11) NOT NULL default '0',
  `referrer` varchar(255) NOT NULL default '',
  `referrer_query_string` varchar(255) NOT NULL default '',
  `landing_page` varchar(255) NOT NULL default '',
  `landing_page_name` varchar(255) NOT NULL,
  `exit_page` varchar(255) default NULL,
  `exit_page_name` varchar(255) NOT NULL,
  `time_arrived` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_click` datetime NOT NULL default '0000-00-00 00:00:00',
  `num_clicks` int(11) NOT NULL default '1',
  `added_cart` varchar(5) NOT NULL default 'false',
  `completed_purchase` varchar(5) NOT NULL default 'false',
  `categories_viewed` varchar(255) NOT NULL default '',
  `products_viewed` varchar(255) NOT NULL default '',
  `cart_contents` mediumtext NOT NULL,
  `cart_total` int(11) NOT NULL default '0',
  PRIMARY KEY  (`tracking_id`),
  KEY `ip_address` (`ip_address`),
  KEY `last_click` (`last_click`),
  KEY `customer_id` (`customer_id`),
  KEY `browser_string` (`browser_string`),
  KEY `cart_total` (`cart_total`)
) ENGINE=MyISAM;

[mikajlo]

Thanks Berezin. It works now. But I still have 0 recors for each report that involves Referrer. What referrer actually means and how should I use these reports? List of the last ten customers works just fine now.

Thanks in advance.

Milan

[a_berezin]

But I still have 0 recors for each report that involves Referrer.

You have no referrers.

What referrer actually means and how should I use these reports?

Referrer is very important information in internet marketing. Mine poor English does not allow me in detail to tell about importance of these reports. May be somebody else?
Referrer in wikipedia - http://en.wikipedia.org/wiki/HTTP_referrer

[mikajlo]

Barezin,

I think I got it in the meantime what referrer is. Basicaly it is a URL location from which user came to my site...

Thanks for mod, it works just fine on my ZC 1.3.5.

I will let ou know, if I'd have some more questions.

Na zdravlje!

Milan, bacuska from Serbia.

[Sensatus]

Just installed this, no probs, thanks devs.

Looked at the source and the following looks like it wouldn't work...

    //Next line defines pages on which a new visitor should definitely not be recorded
            $prohibited_pages = 'login,checkout_shipping,checkout_payment,checkout_process,checkout_confirmation,checkout_success';
            $prohibited_pages = '';
            if (!strpos($prohibited_pages, $_GET['main_page'])) { 

It seems that $prohibited_pages is set, then reset to ''

Is this right? If the code isn't meant to be executed does it need to be there?
Or should the second assignment of $prohibited_pages not be there?

Cheers,
S

[chacha-vintage]

Hello! I am trying to install this mod. Getting an error when I do this step:

2. Go to Admin->Tools->Install SQL Patches and install install.sql

I am attempting to upload the install.sql file using the Upload button on that page. When I do so, I get the following error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's', 'XTRACKING_EXCLUDED_IPS', '127.0.0.1', 'Comma Separate List of IPs which sho' at line 1
in:
[INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Excluding IP's', 'XTRACKING_EXCLUDED_IPS', '127.0.0.1', 'Comma Separate List of IPs which should not be recorded, for instance, your own PCs IP address, or that of your server if you are using Cron Jobs, etc', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Excluding UserAgent's', 'XTRACKING_EXCLUDED_UA', 'ServiceUptime.robot', 'Comma Separate List of UserAgent's substring which should not be recorded', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Excluding bot's', 'XTRACKING_EXCLUDE_BOTS', 'true', 'IP's Excluding from logging', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any thoughts?

Thanks! I am not super technical, so I hope it's something simple that I'm doing wrong!

[Woodymon]

Hello! I am trying to install this mod. Getting an error when I do this step:

2. Go to Admin->Tools->Install SQL Patches and install install.sql

I am attempting to upload the install.sql file using the Upload button on that page. When I do so, I get the following error: {snipped}

Rather han upload, copy and paste the SQL code. Open install.sql in a text editor, then copy all the text, and then paste into the big text box on "install SQL patches".

Woody

[chacha-vintage]

Super! I had tried that as well yesterday and it didn't work. I just did it again and it looks like it worked this time. Thanks for your help!