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.

[BlessIsaacola]

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.

[mikajlo]

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!

[BlessIsaacola]

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.

[mikajlo]

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.