Re: Simple Google Analytics - Support
Is this the script I use in the admin/ install SQL Patch ?
SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Google Analytics Configuration' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google Analytics Configuration', 'Set Google Analytics Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Analytics Account', 'GOOGLE_ANALYTICS_UACCT', 'UA-XXXXXX-X', 'Enter your Google Analytics account number', @configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'Target Address', 'GOOGLE_ANALYTICS_TARGET', 'customers', 'What adress (City/State/Country to correlate the transaction with) use in Analytics transaction?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'customers\', \'delivery\', \'billing\'),'),
(NULL, 'Affiliation', 'GOOGLE_ANALYTICS_AFFILIATION', '', 'Optional partner or store affilation', @configuration_group_id, 3, NOW(), NULL, NULL),
(NULL, 'Use sku/code', 'GOOGLE_ANALYTICS_SKUCODE', 'products_id', 'Using as Product SKU code', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'products_id\', \'products_model\'),'),
(NULL, 'Use pagename', 'GOOGLE_ANALYTICS_USE_PAGENAME', 'false', 'Use pagename in tracking? Be careful when using this!', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Attributes Brackets', 'GOOGLE_ANALYTICS_PRODUCTS_ATTRIBUTES_BRACKETS', '[]', 'Attributes Brackets', @configuration_group_id, 6, NOW(), NULL, NULL),
(NULL, 'Attributes Delimiter', 'GOOGLE_ANALYTICS_PRODUCTS_ATTRIBUTES_DELIMITER', '; ', 'Attributes Delimiter', @configuration_group_id, 7, NOW(), NULL, NULL),
(NULL, 'Tracking Outbound', 'GOOGLE_ANALYTICS_TRACKING_OUTBOUND', 'false', '', @configuration_group_id, 21, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Tracking Outbound Links Prefix', 'GOOGLE_ANALYTICS_TRACKING_OUTBOUND_LINKS_PREFIX', '/outgoing/', '', @configuration_group_id, 22, NOW(), NULL, NULL),
(NULL, 'Use AdWords Conversion', 'GOOGLE_CONVERSION_ACTIVE', 'true', 'Use AdWords Conversion', @configuration_group_id, 91, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'AdWords Conversion ID', 'GOOGLE_CONVERSION_ID', '', 'Enter your Google Conversion ID', @configuration_group_id, 92, NOW(), NULL, NULL),
(NULL, 'AdWords Conversion Language', 'GOOGLE_CONVERSION_LANGUAGE', 'en_US', 'Enter your Google Conversion Language', @configuration_group_id, 93, NOW(), NULL, NULL);
"I shoot an arrow into the air, where it lands I do not care: I get my arrows wholesale!” Curly Howard