Simple Google Analytics - Support

**cuda** · 14 Dec 2006, 04:14 PM

I have simplified the Google Analytics integration process and am realeasing it for all to enjoy. Follow the readme directions for instalation.

There are only 2 files to be uploaded. One of which is one line and utilizes the $zv_onload variable and is not neccasary if you make an extra addition to your template and is explained in the readme. Also an sql patch needs to be installed.

Available:

http://www.zen-cart.com/index.php?ma...roducts_id=412

Enjoy

**zwenthe** · 14 Dec 2006, 06:51 PM

Will this track transaction information too? Or just the success of a sale?

I thought with analytics you can track transaction details and report on it.

**cuda** · 14 Dec 2006, 07:13 PM

Originally Posted by zwenthe

Will this track transaction information too? Or just the success of a sale?

I thought with analytics you can track transaction details and report on it.

Yes this will allow Google Analytics to track your transactions and entrance points, search queries, etc. So much info you won't know what to do with it.

**Nellie** · 14 Dec 2006, 10:36 PM

I assume this is for ver 1.3.6, will it also work for ver 1.2.7?

**cuda** · 15 Dec 2006, 02:59 AM

This should work without any problems in 1.2.7 but I have not tested it. Follow the readme and if you have any issues I am happy to help. It really is a pretty simple mod.

**MB1** · 15 Dec 2006, 07:57 PM

i'm on step 2

2. Make sure your body tag in includes/templates/[your_template] includes this code (if not see trouble shooting below it is not neccassary but an addition to your template needs to be made):

<body id="<?php echo $body_id . 'Body'; ?>"<?php if($zv_onload !='') echo ' onload="'.$zv_onload.'"'; ?>>

which file is this?

step 3 wasn't a problem, and 4 and 5 look like they will be easy enough once i get step 2 done

**samantha birt** · 2 May 2007, 08:22 AM

Originally Posted by cuda

yeah I had just uploaded it. thanks kim!

How do you upload simple google anaystics onto my site? I have downloaded it onto winzip but how do I get it on my site?

**arretx** · 7 May 2007, 08:14 AM

The SQL file won't run in SQLYog or in the SQL import tool from the admin pages.

Am I screwing something up?

Tools --> Install SQL Patches

I copy the SQL statement in the googleanalytics.sql file and try to run it and I get an error.

I try to upload it from the browse feature and I get an error.

1264 Out of range value adjusted for column 'configuration_group_id' at row 1
in:
[INSERT INTO zen_configuration_group VALUES ('', 'Google Analytics Configuration', 'Set Google Analytics Options', '1', '1');]
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.

**cuda** · 7 May 2007, 10:48 PM

Originally Posted by arretx

The SQL file won't run in SQLYog or in the SQL import tool from the admin pages.

Am I screwing something up?

Tools --> Install SQL Patches

I copy the SQL statement in the googleanalytics.sql file and try to run it and I get an error.

I try to upload it from the browse feature and I get an error.

1264 Out of range value adjusted for column 'configuration_group_id' at row 1
in:
[INSERT INTO zen_configuration_group VALUES ('', 'Google Analytics Configuration', 'Set Google Analytics Options', '1', '1');]
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.

are you using mysql 5.0? If you are try replacing any value set as '' aka no value, with NULL with no quotes. so the above would be:

INSERT INTO zen_configuration_group VALUES (NULL, 'Google Analytics Configuration', 'Set Google Analytics Options', '1', '1')

Try this:

Code:

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Google Analytics Configuration';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES (NULL, 'Google Analytics Configuration', 'Set Google Analytics Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Google Analytics Configuration';

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 (NULL, 'Analytics Account', 'GOOGLE_ANALYTICS_UACCT', 'UA-XXXXXX-X', 'Enter your Google Analytics account number', @t4, 1, NOW(), NOW(), NULL, NULL),
(NULL, 'Target Address', 'GOOGLE_ANALYTICS_TARGET', 'customers', 'What adress (City/State/Country to correlate the transaction with) use in Analytics transaction?', @t4, 2, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''customers'', ''delivery'', ''billing''),'),
(NULL, 'Affiliation', 'GOOGLE_ANALYTICS_AFFILIATION', '', 'Optional partner or store affilation', @t4, 3, NOW(), NOW(), NULL, NULL),
(NULL, 'Use sku/code', 'GOOGLE_ANALYTICS_SKUCODE', 'products_id', 'Using as Product SKU code', @t4, 4, now(), now(), NULL, 'zen_cfg_select_option(array(''products_id'', ''products_model''),');

Let us know if that works....

**DrByte** · 8 May 2007, 12:34 AM

To add to what cuda suggested, NULL or 0 should work (both without quotes).

Thread: Simple Google Analytics - Support

Thread Tools

Search Thread

Display

Hybrid View

Simple Google Analytics - Support

Re: Simple Google Analytics - Support

Re: Simple Google Analytics - Support

Re: Simple Google Analytics - Support

Re: Simple Google Analytics - Support

Re: Simple Google Analytics - Support

Re: Simple Google Analytics - Support

Re: Simple Google Analytics - Support

Re: Simple Google Analytics - Support

Re: Simple Google Analytics - Support

Similar Threads

v150 Simple Google Analytics .sql error !

Simple Google Analytics-not working

Simple (From Google) Analytics Install

Simple google analytics- help

Simple Google Analytics not working

Bookmarks

Bookmarks

Posting Permissions