Supertracker

[Woodymon]

Supertracker 1.0 has been uploaded to the Zen Cart downloads area.
No code changes. Readme is updated.

-----------
Supertracker for Zen Cart
Version 1.0 (Ported to Zen Cart by Andrew Berezin - 05-09-07)
Based on Supertracker v.3.20b (01-11-05) by Mark Stephens

Download from:
http://www.zen-cart.com/index.php?ma...roducts_id=683

Support forum:
http://www.zen-cart.com/forum/showthread.php?t=65040

Supertracker records statistics for each user arriving at your shop and allows merchants to generate various reports.

Straight forward installation. No core files overwritten.

Download latest GeoIP.dat IP database separately
(Required but free - see readme)
Download flags separately
(Optional and free - see readme)

Supertracker records the following data:
====================
• Referring page
• Referring query (allows access to keywords used in search engine)
• Landing page (including query string - important for PPC campaign assessment)
• Arrival time / exit time / exit page
• IP address
• Country code / country name
• Customer's cart contents
• Number of clicks on shop (accuracy is not 100% as this is recorded based on session ID)
• Products viewed / Categories 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)

Reports Generated:
====================
• Top Referrers
• Top Sales Generating Referrers
• Visiting Countries Stats
• Search Keywords Used - Totals
• Search Keywords Used in Last 24 Hours
• Search Keywords Used in Last 3 Days
• Search Keywords Used in Last Week
• Search Keywords Used in Last Month
• Top Exit Pages (No Sale)
• Top Exit Pages (No Sale, but added to cart)
• Average Clicks on Site by Referrer
• Average Time Spent on Site by Referrer
• Products Viewed Report
• Last Ten Visitors

History
=======
v.1.0.0 05.09.07 a_berezin
(Initial ZC version - based on ported v.3.20b - 01.11.05)
+ Code optimization
+ Updated Readme (08.04.07)

[Pixxi]

Small typo in label/constant:

admin/supertracker.php

Lines c. 272 - 280

    case 'landing':
      $title = TEXT_LANDING_PAGE;
      $headings[] = TEXT_SERIAL;
      $headings[] = TEXT_LANDING_PAGE;
      $headings[] = TEXT_NUMBER_OF_OCCURRENCES;
      $row_data[] = 'landing_page';
      $row_data[] = 'total';
      $tracker_query_raw="SELECT landing_page, landing_page_name, COUNT(*) as total FROM " . TABLE_SUPERTRACKER . " GROUP BY landing_page ORDER BY total DESC";
      break; 

Needs 'TABLE_' in front of 'TEXT_LANDING_PAGE':

    case 'landing':
      $title = TABLE_TEXT_LANDING_PAGE;
      $headings[] = TEXT_SERIAL;
      $headings[] = TABLE_TEXT_LANDING_PAGE;
      $headings[] = TEXT_NUMBER_OF_OCCURRENCES;
      $row_data[] = 'landing_page';
      $row_data[] = 'total';
      $tracker_query_raw="SELECT landing_page, landing_page_name, COUNT(*) as total FROM " . TABLE_SUPERTRACKER . " GROUP BY landing_page ORDER BY total DESC";
      break; 

[Woodymon]

Small typo in label/constant:
admin/supertracker.php
Lines c. 272 - 280
Needs 'TABLE_' in front of 'TEXT_LANDING_PAGE':

Thanks Pixxi.

Would you know which Supertracker report(s) where this issue manifests itself?

Woody

[Woodymon]

Would you know which Supertracker report(s) where this issue manifests itself?

I see now. If you don't change the define the two Landing Page reports will not show in the drop down. Thanks for the heads up.

BTW some of the features in Supertracker are disabled within the mod code. When Andrew ported he did not plan to further develop this mod, rather he was working on releasing his own tracking mod with features from Supertracker, User Tracking, BBClone, etc. But with Andrew saying goodbye to the Zen Cart community looks like that will never happen. So unless a developer picks this mod up to improve on it don't expect any bug patches or complex fixes or updates to be released. But might as well post your ideas and wishes for this mod in case a developer does pick up on it.

Woody

[Woodymon]

In YOUR_ADMIN/includes/languages/english/supertracker.php

After Line 65
INSERT

define('TEXT_LANDING_PAGE', 'Landing Page');


It doesn't really matter where you insert it but that seemed like a nice location ;-)

Woody

[StoryBook]

Hi Woody,

Does the release of SuperTracker in the downloads area include all the fixes discussed in this thread? Including the sql patch from Andrew on the first page of this thread?

I just want to know where I need to start from before I attempt to install this mod.

I love this mod! I've seen it in action on an OSC store. Would love to get it up on my Zen site.


Thanks,
Kevin

[Woodymon]

Does the release of SuperTracker in the downloads area include all the fixes discussed in this thread? Including the sql patch from Andrew on the first page of this thread?

As far as I can see no code fixes were discussed or posted to this thread. Only sql patch by Andrew in post #3.

Regarding the questin on if the updated sql patch is in the available download version of Supertracker mod, it is easy enough for you to check. Just download and compare!

At bottom of the announce post:

v.1.0.0 05.09.07 a_berezin
(Initial ZC version - based on ported v.3.20b - 01.11.05)

Since the release date of the mod, as listed above, is AFTER Andrew's sql fix posting, it could be presumed the updated sql patch would be in version in the ZC downloads area. But if you do not like to assume things then as stated it would easy enough for you to compare with the sql posted on the forum and rectify.

At any rate Andrew would not have updated the mod version number just because of a slightly altered sql patch.

But for you I just checked and the version in the downloads area indeed contains the updated sql patch. So please proceed.

Woody