Hi, Eric (econcepts),
Thanks for rolling the Conversion Tracking into the mod.
I am converting my site from hand-inserted GA and Conversion codes, to the simple-google-analytics mod. When I install the sql patch, I get the error display shown below between the "****" marks, and my Google Analytics menu in Admin stops just before the Conversion Tracking settings shown on your site's screen shot. Is this a problem on my site, or am I just on the "bleeding edge" of your new addition?
My host provides MySQL 4.1.22-standard, not version 5. Is that the problem? We're running Zen Cart 1.3.7. This install was to our test site which we keep permanently in maintenance mode and not viewable by the public at large.
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 'Yes', 'No'), ')' at line 1
in:
[INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate Conversion Tracking', 'GOOGLE_CONVERSION_ACTIVE', 'No', 'This element enables you turn on or off Google Conversion Tracking.
Please Note: Conversion tracking is used to track the effectiveness of Google AdWords paid search campaigns. If you are not running any paid search campaigns, then you should leave this set to "No".
If you are running Google AdWords (paid search) campaigns, then turning this on will place the proper conversion tracking code on your checkout success page and enable you to start tracking conversions.
Turning this on requires you to enter your unique Google Conversion Tracking ID in place of the "XXXXXXXXXXX" number shown in the next section.
For more hints and tips on how to use Google Analytics to increase sales from your store, visit ZenCartOptimization.com
Do you want to turn on Google AdWords Conversion Tracking?
', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('Yes', 'No'), ');]
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.