Simple Google Analytics - Support

[mattys]

I'm still using zen cart v1.3.9h, but have latest version of this mod installed.

I wander whether it is installed properly though as I dont get any options for custom variables, as per http://www.zen-cart.com/forum/showth...t=52145&page=4:

1) Ecommerce transactions
2) Goals / Funnels
3) Standard Google Analytics informtion
4) Adwords Conversion Tracking
5) any other custom variables you want to include in your tracking code (by using the 'custom tracking' section of my mod.)

An screen grab is attached.

Also, although in google analytics it shows products purchased, etc. under Conversions > Ecommerce, i cant see any info about keywords used, etc. as per info that you posted here http://www.zencartoptimization.com/2...sion-tracking/, specifically

"Conversion Tracking reports things such as How effective your Adwords ads are”, “which actual keywords convert to sales, and which just cost you money”, “overall conversion rate for a campaign, ad, or group of keywords”, and more

Do i find this info on google analytics, or in my adwords account?

[mattys]

I found how to check which keywords are associated with purchases in google analytics, but still not sure if module is installed correctly, as per above...

[Miff]

Okay, so this may already have been covered however I cannot find any other reports of the exact issue that I am experiencing.
I have a fresh zen 1.50 installation with a brand new database to match. I uploaded all 4 of the supplied files and made the edit to the core file as explained in the readme. No isses so far...
The problem occurs when I attempt to run the install.sql. I have tried to upload it in every way other than directly through phpmyadmin but whenever I try to install via admin I get the following message:
error: please refresh the page and try again!
I have never encountered this sort of error message before and am slightly confused.
I am currently running this site on a local server which may be the issue, however I have previously uploaded a lot of other .sql files without an issues....
Any ideas?

[TrevorJ]

In ZC 1.5 you need to register the page within the Admin.

First, create the adminXXXXXXXXXXXX/includes/languages/english/extra_definitions/googleanalytics.php page with the following:

<?php 
define('UN_BOX_GOOGLE_ANALYTICS', 'Simple Google Analytics');

Fire up your mysql client (HeidiSQL, phpMyAdmin, etc)
and run the query:

SELECT `configuration_group_id` FROM `configuration` WHERE `configuration_title` like '%google%' LIMIT 1;

If it returns nothing, you didn't run the SQL included with the installer.

Take the resultant # and use that for your gID in the next step.



Now within your carts admin console, go to:

Admin Access Management => Admin Page Registration

Register the page as per the previous posts:

Page Key: Simple Google Analytics
Page Name: UN_BOX_GOOGLE_ANALYTICS
Page Filename: FILENAME_CONFIGURATION
Page Parameters: gID=XXXX
Menu: configuration
Display on Menu? Y
Sort Order: whatever you want


Save it, and refresh your admin console. You should now see it under 'Configuration'.

Thanks for this, Im trying to follow the above but im having problems finding the gID number.
I have no experiance of PHP but I have downloaded PHPmyadmin and have it up an running. However this is where im having trouble, am i right in saying i have to import the googleanalytics-INSTALL.sql and run the query:

SELECT `configuration_group_id` FROM `configuration` WHERE `configuration_title` like '%google%' LIMIT 1;

When i try and import googleanalytics-INSTALL.sql i get the following error:

Error

SQL query:

SELECT (

@t4:= configuration_group_id
) AS t4
FROM configuration_group
WHERE configuration_group_title ='Google Analytics Configuration';

MySQL said:
#1046 - No database selected

What am i doing wrong?? Please help!!

[mattys]

this module still puts the ga code just before the </body> tag

these days, google specifically advises:

Copy the following code, then paste it onto every page you want to track immediately before the closing </head> tag

i wander whether this will cause problems now or in future?

[Limitless]

Thanks for this, Im trying to follow the above but im having problems finding the gID number.
I have no experiance of PHP but I have downloaded PHPmyadmin and have it up an running. However this is where im having trouble, am i right in saying i have to import the googleanalytics-INSTALL.sql and run the query:

SELECT `configuration_group_id` FROM `configuration` WHERE `configuration_title` like '%google%' LIMIT 1;

When i try and import googleanalytics-INSTALL.sql i get the following error:

Error

SQL query:

SELECT (

@t4:= configuration_group_id
) AS t4
FROM configuration_group
WHERE configuration_group_title ='Google Analytics Configuration';

MySQL said:
#1046 - No database selected

What am i doing wrong?? Please help!!

Within phpMyAdmin, select your zencart database, then execute the script.

[TrevorJ]

Within phpMyAdmin, select your zencart database, then execute the script.

Where do I find the Zencart database? Is it in a particular folder?

[countrycharm]

Where do I find the Zencart database? Is it in a particular folder?

On your server control panel. phpMyAdmin

[econcepts]

this module still puts the ga code just before the </body> tag

these days, google specifically advises:



i wander whether this will cause problems now or in future?

This won't cause any problems and shouldn't in the future. Google recommends that (as they state) but so long as it is in the header part of the site you're ok (they are looking to load it prior to the rest of the page loading.)

The newest version here removes the code at that point and instead dynamically inserts it above the </head>. There is no need to alter the html_header.php file anymore.

If you still show the code at the point above the </body> tag then you likely upgraded from a previous version and at that time did not remove the lines in the 'html_header.php' file (as per the instructions.)

Let me know if that clears it up for you.

[econcepts]

Within phpMyAdmin, select your zencart database, then execute the script.

You should be able to run the script by copy and pasting it into the Admin (sqlpatch) portion of zen cart.

If you run it from phpMyAdmin you'll need to take note of any table prefixes you may have for your zen cart installation and then manually include those in the SQL script for it to run properly.