Simple Google Analytics - Support

Centec2b:

Hello reference my original post #1600. I am assuming the problem is within my setup on the test system, rather than a code error, due to the overwhelming number of successful users.

But it still seems odd that no one else has had a problem

To try and locate the problem I have updated to the latest version of xampp for win 32 1.7.4

Rewritten the code into a new sql file

Neither have any beneficial effect

I guess the next step is to try and cross reference against other SQL instructions

I have an odd feeling I am going to kick myself when the reason for the error becomes apparent!

Centec2b

There shouldn't be any issues with the original install code (if you are using Simple Google Analytics.)

Copy and paste it into the zen cart Admin (don't use phpMyAdmin and don't 'upload' it in the zen admin ... copy and paste is the way to go.)

If you changed the SQL file, you might have made a mistake in the coding (is an apostrophe missing near this line TYPE=M' ?)

I've never heard of this issue and there are a lot of users.

raider1016:

i believe i have added everything correct. I receive no errors of any kind and even analytics says its receiving data. In fact, my traffic dropped to 0 so i know its not calculating my traffic. Also, when i view my source code on any page in the site, i cannot see any code relating to google analytics.

i am using the "iC_AcadameV1.2" template along with the latest version of Zen Cart.

i also had to copy the "html_header" into my iC_AcadameV1.2 template folder because it was not there.

Anyone got any ideas?

Send a url to look at. The only way you will not get any traffic recorded is if you either did not install the tracking code on the pages, or if you installed the tracking code but did not use the tracking ID for the account you are looking at.

This install works with any template and all version of zen cart so it should work on yours.

econcepts:

There shouldn't be any issues with the original install code (if you are using Simple Google Analytics.)

Copy and paste it into the zen cart Admin (don't use phpMyAdmin and don't 'upload' it in the zen admin ... copy and paste is the way to go.)

If you changed the SQL file, you might have made a mistake in the coding (is an apostrophe missing near this line TYPE=M' ?)

I've never heard of this issue and there are a lot of users.

Good Evening Eric

Thank you for this guidance

I have made progress (some)

It would appear that the folks at MySQL are evolving the language and the term > TYPEhas been replaced by > ENGINE although from what I understand there should be backwards compatibility

However when I had tried several times copying and pasting into the install SQL patches with a copy of a new SQL file and it still failed, I used phpMyAdmin and I installed the SQL instructions with ENGINE substituting for TYPE and it installed ok

On looking at the database entries I noticed several errors where foreign language punctuation had been used and corrected by hand (eg French ç).

I found references to this MySQL language change at

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

and

http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html

The system now shows up in Admin and the only remaining problem is the same as #1593 ie the main page is blank.

I checked the error log as suggested and it is saying

[07-Sep-2011 00:51:29] PHP Parse error: syntax error, unexpected '{' in xxxxxxxxxxxxxxxx/common/tpl_main_page.php on line 1

I have checked the file but I am blowed if I can see this error. I have uploaded the file and if anyone can put me right on this I would be grateful.

In conclusion thank you Eric and All for the help and assistance - I wouldn't have got this far by myself

Running ZC v1.3.9h. Does Simple Google Analytics also work with the COWOA mod?

AdamT:

Running ZC v1.3.9h. Does Simple Google Analytics also work with the COWOA mod?

Yes. Works with all modules on the market, free and paid.

econcepts:

Yes. Works with all modules on the market, free and paid.

Great, TY. Got this installed :)

So I have an Adwords conversion ID entered in the Admin, and if I force load the checkout success page I can see the script in the html. If I click one of my Adsense banners (which begins the Google tracking cookie), can I then just paste the checkout success URL in the browser and go to that page for Adwords to record a conversion? Or do you actually have to do a full text checkout and pay to do a test?

Centec2b:

Good Evening Eric

Thank you for this guidance

I have made progress (some)

It would appear that the folks at MySQL are evolving the language and the term has been replaced by although from what I understand there should be backwards compatibility

However when I had tried several times copying and pasting into the install SQL patches with a copy of a new SQL file and it still failed, I used phpMyAdmin and I installed the SQL instructions with ENGINE substituting for TYPE and it installed ok

On looking at the database entries I noticed several errors where foreign language punctuation had been used and corrected by hand (eg French ç).

I found references to this MySQL language change at

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

and

http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html

The system now shows up in Admin and the only remaining problem is the same as #1593 ie the main page is blank.

I checked the error log as suggested and it is saying

I have checked the file but I am blowed if I can see this error. I have uploaded the file and if anyone can put me right on this I would be grateful.

In conclusion thank you Eric and All for the help and assistance - I wouldn't have got this far by myself

A blank page typically means there is an error in your PHP somewhere. This is most often do to incorrectly copy and pasting the code required to run the module into the templates on your site. To resolve that issue you need to go back and make sure each and every element is copy and pasted exactly as shown and that you did not copy over any other code on your site (which may cause accidental removal of PHP tags that make other portions of your page run.

Another thing to keep in mind. If you tried to install this via PHPMyAdmin then you need to make sure you manually inserted your database prefix (if using any) to each of the commands. When you sue the built in Zen Cart patch tool it automatically does this for you, but with PHPMYAdmin you need to adjust the code to find your correct table prefix.

The file you uploaded looks ok. Make sure you take a look at the html header file as well and ensure you didn't accidentally remove anything there when copying code in.

What version of MySQL are you using? I'm running this (and tested installs on) many many machines with MySQL 5.+ and it goes without flaw each time (no alterations to SQL code etc..., no running through PHPMyAdmin, etc...)

How do you track conversions on individual products and their prices?

econcepts:

A blank page typically means there is an error in your PHP somewhere

Another thing to keep in mind. If you tried to install this via PHPMyAdmin then you need to make sure you manually inserted your database prefix (if using any) to each of the commands.

What version of MySQL are you using?

The good news is it is working!

The annoying thing is I cannot say why it is now working!!

I have stared at this code till I am blue in the face - I can only think there was some minor error which I corrected unnoticed.

I am using MySQL 5.0.92

As for the information the analytics reveals - hmmm thats another story!

Eric thank you for this help - it is appreciated

Centec2b

AdamT:

How do you track conversions on individual products and their prices?

So long as you have ecommerce tracking turned on within Google Analytics, my module here automatically records it for you within that same area. If you want to track conversions from PPC then you need to also turn on and add your Adwords conversion tracking ID too.

Centec2b:

The good news is it is working!

The annoying thing is I cannot say why it is now working!!

I have stared at this code till I am blue in the face - I can only think there was some minor error which I corrected unnoticed.

I am using MySQL 5.0.92

As for the information the analytics reveals - hmmm thats another story!

Eric thank you for this help - it is appreciated

Centec2b

Great. Glad to hear you got it working. :)

I'm running ZC 1.3.9h.
Just upgraded SGA to the latest version with the hopes it would start tracking where sales came from, but still no luck.
It works perfectly other than that.
My site is https://www.funkimunkibadges.co.uk
However ALL sales show up as being from referrer 'funkimunkibadges.co.uk' which I know is incorrect.
I use Paypal Express checkout, but some people also check out with my default ZC checkout process as well (which still ends up with Paypal).
I'm hoping I'm missing something simple.

econcepts:

So long as you have ecommerce tracking turned on within Google Analytics, my module here automatically records it for you within that same area. If you want to track conversions from PPC then you need to also turn on and add your Adwords conversion tracking ID too.

Yeah I want to track Adwords conversions, which I'm doing now with your plugin (but it only tracks a single conversion amount). How do you set up the Adwords code for different products/amounts with the plugin? I know Analytics does this by turning "eCommerce store" to yes, but doing it through Adwords is my question, since I'm trying to figure out my ROI in Adwords when people click my banners.

To my knowledge Analytics doesn't track Adwords conversions, as Analytics and Adwords are different Google products. Maybe I'm missing something?

I checked my site through woorank and it says my google analytics was missing. can someone explain to me step by step on how to add it. I am new to zc and siteworx.

hello econcepts

I just wanted to install simple google analytics on my 1.3.8a shop for the first time.

But I don't get through the SQL part. When I get to the first "Insert Into ..." statement, then I get the following message:

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO configuration_group VALUES (NULL, '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.

can you please help me.

thanks Daniel

CreepyD:

I'm running ZC 1.3.9h.
Just upgraded SGA to the latest version with the hopes it would start tracking where sales came from, but still no luck.
It works perfectly other than that.
My site is https://www.funkimunkibadges.co.uk
However ALL sales show up as being from referrer 'funkimunkibadges.co.uk' which I know is incorrect.
I use Paypal Express checkout, but some people also check out with my default ZC checkout process as well (which still ends up with Paypal).
I'm hoping I'm missing something simple.

It should work as the module only creates the link to Google (which is the primary system that then records where the traffic came from.)

It sounds like there may be a setting on your Google Analytics side that could be affecting the traffic. What do you have set (within Google Analytics) as the root (default) url / page of the site?

AdamT:

Yeah I want to track Adwords conversions, which I'm doing now with your plugin (but it only tracks a single conversion amount). How do you set up the Adwords code for different products/amounts with the plugin? I know Analytics does this by turning "eCommerce store" to yes, but doing it through Adwords is my question, since I'm trying to figure out my ROI in Adwords when people click my banners.

To my knowledge Analytics doesn't track Adwords conversions, as Analytics and Adwords are different Google products. Maybe I'm missing something?

The conversion tracking should work for any conversion amount (it is dynamic) so long as you did not set Google to track a 'static' amount (did you set the conversion value to '0'? You should do that for it to look at my dynamic values.

You can track Adwords within Google Anlaytics (as well as outside of it) but you need to connect the two accounts together (Adwords with Analytics). My Google workbook goes through the steps on how to accomplish this.

gpsupps10:

I checked my site through woorank and it says my google analytics was missing. can someone explain to me step by step on how to add it. I am new to zc and siteworx.

Download the Simple Google Anlaytics module. Follow the readme for first time installs. Make sure you don't miss step 3 of the install.

If the code is missing on your site, you likely missed the lines of code needed to insert it into your page.

dzuberbu:

hello econcepts

I just wanted to install simple google analytics on my 1.3.8a shop for the first time.

But I don't get through the SQL part. When I get to the first "Insert Into ..." statement, then I get the following message:

---

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO configuration_group VALUES (NULL, '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.

can you please help me.

thanks Daniel

Daniel,

I got your PM, check that and let me know what turns up.

I was wondering if you will be adding the Site Speed functionality to your mod?
analytics.blog spot dot com/2011/05/measure-page-load-time-with-site-speed.html