Simple Google Analytics - Support

RJugalbot:

I was able get the configuration ID in the configuration database using phpMyAdmin.

I added the Simple Google Analytics to the Admin Page Registration using this info:

Page Key: Simple Google Analytics
Page Name: UN_BOX_GOOGLE_ANALYTICS
Page Filename: FILENAME_CONFIGURATION
Page Parameters: gID=49
Menu: Tools
Display on Menu? Y
Sort Order: 0

The menu was added in under Tools. However, when clicked it just shows the My Store configuration.

Thank in advance for any help.

I didn''t have any luck with it under 'Tools' either.

Registering it under 'Configuration' and it shows properly.

DragonLady:

Where did you find the fix, please? I've been fighting with this all morning.

My GA numbers seemed to be fine after the upgrade, but they've slowly dropped 'till they are showing ZERO visitors...despite the fact I have plenty of people online, and am getting business-as-usual.

So I downloaded this and installed it, but now there's nothing in the configuration menu; so I'm at a dead end.

http://www.zen-cart.com/forum/showpost.php?p=1096990&postcount=1729

beyre:

Wow! I was really surprised when I went to install this addon on a newly installed ZC 1.5.0 that there was no Google analytics showing under Configuration in Admin. That is a first, as I have installed this addon on previously ZCs with no problems..Nearly ALL add-ons will need to be upgraded in order to work with Zen Cart v1.5.. This is an easier task for some add-ons than others, and Eric is being cautious to make sure that any "quick fixes" posted do not cause and PCI compliance and security issues.. So be prepared to wait through this process prepare to continue to be "surprised".

Limitless:

http://www.zen-cart.com/forum/showpost.php?p=1096990&postcount=1729

Thank-you! Thank-you! Thank-you! :D

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/showthread.php?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/2007/08/10/google-analytics-demystified-part-4-conversion-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?

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...

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?

Limitless:

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!! :frusty:

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?

TrevorJ:

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!! :frusty:

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

Limitless:

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

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

TrevorJ:

Where do I find the Zencart database? Is it in a particular folder? :blush:
On your server control panel. phpMyAdmin

mattys:

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.

Limitless:

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.

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/showthread.php?t=52145&page=4:

If you want to use Custom Variables you'll need to set those up yourself and include them in an 'custom' tracking at the end of the tracking code. The box in this contribution enables you to set any type of custom variable you wish (per google instructions) and those will show up within your Google Analytics reports (if you have set them up correctly.)

I was trying to install this addon and I have killed my admin! The site still runs, but I cannot access my admin - This happened after I ran the admin configuration - I filled in all the boxes, clicked update and the site died. Any help? I backed up my DB before, and I restored it, but admin area is still dead. Here's my admin address:
http://www.goldenapplels.com/shop/gazadmin/

Okay, I got it back by trashing all the files from this add-on. Maybe I'm missing something but the read me for this add-on has nothing about the 1.5 modifications - is there an up to date readme? Combing through the forum for updates doesn't seem to be the best way to install this mod.

I took another crack at this, and managed to get much further. It would be great if a sticky was created with additional info for installing on 1.5 - the admin configure is an important part! My site works, but I'm now stuck on configuring. Under configure, Google Analytics is the first item ( I should have changed the sort order) but when I select it, it goes to Store. I can't get to the configure. I would change the sort order, but I don't know where that is. Stuck again, but my site isn't down!

Okay - I fooled it by putting the Gid=XX in the menu bar and it took me to the SGA configure screen! Now everything is working so I love this, but it was a rocky start!

Limitless:

I didn''t have any luck with it under 'Tools' either.

Registering it under 'Configuration' and it shows properly.

I re-register this the page under Admin/Configuration using the updated analytics in the Free Add-Ons download but still no luck.

When I click Simple Google Analytics it displayed the My Store information.

Any help.