Thread: Supertracker

Page 1 of 33 12311 ... LastLast
Results 1 to 10 of 323
  1. #1
    Join Date
    Aug 2004
    Location
    Saint Petersburg, Russia
    Posts
    1,790
    Plugin Contributions
    13

    Default 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. 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
    Good luck,
    Andrew
    Russian Zen-Cart forum

  2. #2
    Join Date
    Sep 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Supertracker

    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ć
    Geronimo is alive. You can almost here him whispering... run...run...run!

  3. #3
    Join Date
    Aug 2004
    Location
    Saint Petersburg, Russia
    Posts
    1,790
    Plugin Contributions
    13

    Default Re: Supertracker

    Run this sq:
    Code:
    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;
    Good luck,
    Andrew
    Russian Zen-Cart forum

  4. #4
    Join Date
    Sep 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Supertracker

    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
    Geronimo is alive. You can almost here him whispering... run...run...run!

  5. #5
    Join Date
    Aug 2004
    Location
    Saint Petersburg, Russia
    Posts
    1,790
    Plugin Contributions
    13

    Default Re: Supertracker

    Quote Originally Posted by mikajlo View Post
    But I still have 0 recors for each report that involves Referrer.
    You have no referrers.
    Quote Originally Posted by mikajlo View Post
    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
    Good luck,
    Andrew
    Russian Zen-Cart forum

  6. #6
    Join Date
    Sep 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Supertracker

    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.
    Geronimo is alive. You can almost here him whispering... run...run...run!

  7. #7
    Join Date
    Feb 2004
    Location
    Georgia, USA
    Posts
    1,949
    Plugin Contributions
    0

    Default Re: Supertracker

    Quote Originally Posted by mikajlo View Post
    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.

  8. #8
    Join Date
    Sep 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Supertracker

    Quote Originally Posted by BlessIsaacola View Post
    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!
    Geronimo is alive. You can almost here him whispering... run...run...run!

  9. #9
    Join Date
    Feb 2004
    Location
    Georgia, USA
    Posts
    1,949
    Plugin Contributions
    0

    Default Re: Supertracker

    Quote Originally Posted by mikajlo View Post
    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.

  10. #10
    Join Date
    Sep 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Supertracker

    Quote Originally Posted by BlessIsaacola View Post
    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.
    Geronimo is alive. You can almost here him whispering... run...run...run!

 

 
Page 1 of 33 12311 ... LastLast

Similar Threads

  1. Supertracker
    By enquirer66 in forum All Other Contributions/Addons
    Replies: 5
    Last Post: 2 Mar 2011, 08:37 PM
  2. SuperTracker
    By ma.r.a in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 11 Feb 2011, 08:19 PM
  3. Supertracker referrals?
    By mlbacher in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 24 Aug 2009, 07:53 PM
  4. supertracker mod
    By confused_aswell in forum General Questions
    Replies: 2
    Last Post: 1 Aug 2008, 12:55 PM
  5. Supertracker Add-on
    By bcmartinez in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 19 May 2006, 01:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR