Supertracker

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. :cool: 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?main_page=product_contrib_info&products_id=683

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ć

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;

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

mikajlo:

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

You have no referrers.

mikajlo:

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

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.

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.

When you time permits it would be great if you can post for others how you got this to work. The read me is straight forward except that some people might not be clear on how to make the adjustments in Zen Cart that were referenced for osCommerce CRE Loaded.

BlessIsaacola:

When you time permits it would be great if you can post for others how you got this to work. The read me is straight forward except that some people might not be clear on how to make the adjustments in Zen Cart that were referenced for osCommerce CRE Loaded.

OK, let me put it simple... there is no trick. You just need to copy all files from two downloaded folders into the right folders on your web server. All folders already exists exept "jscript" within custom template. Just copy the whole jscript folder under the YOUR_TEMPLATE. Be aware that YOUR_ADMIN should refer to main admin folder in the cathalog and YOUR_TEMPLATE sould refer to the folder of currently active template. Finally, just copy content of install.sql file into clipboard and execute it using PHPMyAdmin in the shop database. Do not forget to create a backup of whole site before any other action, so if somethin goes wrong, restore the backuped files.

Good luck!

mikajlo:

OK, let me put it simple... there is no trick. You just need to copy all files from two downloaded folders into the right folders on your web server. All folders already exists exept "jscript" within custom template. Just copy the whole jscript folder under the YOUR_TEMPLATE. Be aware that YOUR_ADMIN should refer to main admin folder in the cathalog and YOUR_TEMPLATE sould refer to the folder of currently active template. Finally, just copy content of install.sql file into clipboard and execute it using PHPMyAdmin in the shop database. Do not forget to create a backup of whole site before any other action, so if somethin goes wrong, restore the backuped files.

Good luck!

I was actually referencing the section in the read me for adding the links to the Admin side. It sounds like it's not needed.

BlessIsaacola:

I was actually referencing the section in the read me for adding the links to the Admin side. It sounds like it's not needed.

I don't think it is needed for Zen Cart implementation, because after deploying all the files, one can find a new menu item under "Reports menu" - "Supertracker". Clicking on this menu item, a page is opened containing a drop down list, where you can select desired report. You can also delete some old records and filter out records made by search engines.

BlessIsaacola,

BlessIsaacola:

When you time permits it would be great if you can post for others how you got this to work.

You really have a problems with this mod? :oops: Sorry :(
I shall remove the old CRE comments and I shall add new mikajlo comments to readme file.

mikajlo:

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

Na zdravlje!

Milan, bacuska from Serbia.

Ok!
Na zdorovie! :clap:

Add readme.txt file.
Download and test.

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 handicraconfiguration (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.

I see this erro and don't know what is it :wacko:

Use copy/paste to run sql patch.
See http://www.zen-cart.com/forum/showpost.php?p=330719&postcount=1

Yet another hit Andrew, thanks for the hard work. Now if I could just write a program that automatically logs in for me and installs all your mods as you come out with them, hell I could take a vacation. Haven't found one yet that I don't like or was a big help.

Thank you for this tracker. It works perfectly. I had to install the sql via my c-panel, but that's normal for me as the zencart sql installer doesn't ever seem to work well for me.

Again thank you for this very useful tool :clap:

I am updating my cart for 1.3.0.2 to 1.3.7. I am trying to add this in. It seems to work but when I go to the Configuration>Super Tracker

I just get a blank page. There are no settings. I have run the uninstall sql and the install sql from both the cart admin and myphpadmin. Still the same thing. I also have usertracking install, but this seems to be way better. I am almost sure its a sql problem here.

Any help would be great.

P.S. Andrew, I sent you a pm about other stuff. Thanks for porting this over!

I got it working. I had to clean up and compile a new database. I also had to uses the fix you posted before:

a_berezin:

Use copy/paste to run sql patch.
See http://www.zen-cart.com/forum/showpost.php?p=330719&postcount=1

Thanks that was a great fix, worked right away!

This looks way better than usertracker!

Would somebody be so kind as to e-mail me the files?
It seems the site they where hosted on doesn't have them anymore.

Thanks in advance

sales at MoparPartSales dot com