Simple Google Analytics - Support

voltage:

Thanks, but if I am going to spend $20, I'd rather just pay someone $20 to set it up for me.

That's an option as well :). I have installed it for many others and find constantly that they have mis-configured their analytics account 95% of the time.

I developed the workbook over 175 plus hours and several months to document exactly what is needed to make it run correctly and to learn how to use Google Analytics as a tool to increase conversion.

It takes much more time (as you have personally found) to get Google Analytics properly and COMPLETELY installed on a website (if you are to achieve the maximum benefit it provides, which should include funnels, conversion tracking, and goals as part of it).

The time it takes me to debug other Google accounts is far greater than simply reading the workbook. :) I would have to think that you have already spent over $20 of your own time to determine what the issue could be right?

That is the beauty of the workbook. It saves you time, headaches, and with the first sale from your store easily pays for itself. :)

For more information that may help you determine what the issue is you may be interested in the following article:

http://www.zencartoptimization.com/2007/08/10/google-analytics-demystified-part-4-conversion-tracking/

Let me know if you have any further questions, and thanks!

voltage:

When I compared the code that was showing up on my checkout_success page to the code that google was telling me to copy and paste, I noticed a few small discrepencies. For example this code for the google_conversion_label was different. (I however have no idea what this means.)

Sooo, I turned off the tracking in the admin, and hard coded the sucker in the tpl_main_page for the checkout success page. I have now verified that the code shown is EXACTLY the same code google is telling me to show, but yet, it still fails verification. . . .

Voltage,

Something you need to keep in mind here is that Google does not need to "verify" the Conversion Tracking code. Once you turn it on from within your AdWords account, and put the tracking code in place (of which the contribution does for you) you're all set.

The only tracking code that Google actually verifies is the Google Analytics tracking code (which is different and separate from Conversion Tracking code).

If you are looking at a "verification" error, I would venture to guess you are logged into your Google Analytics account and NOT your "Google Adwords" account (of which conversion tracking is a part.)

If you can't get Google to verify the initial tracking code (from the "Analytics side") then the tracking code for Conversion Tracking (which comes from the AdWords side) will not work.

They are totally separate entities, yet they work together to complete one desired function -- tracking conversion of your paid search campaigns.

Make sense?

i'm having trouble with the analytics module. i've installed the module, updated the SQL, pasted the php code into /includes/templates/[your_template]/common/tpl_main_page.php

but, when i reload my website, the UA number is XX-XXXXXX, not the number entered in the module in admin.

any ideas what's going on?

zc1.3.7, FYI.

thanks.

cudaboy71:

i'm having trouble with the analytics module. i've installed the module, updated the SQL, pasted the php code into /includes/templates/[your_template]/common/tpl_main_page.php

but, when i reload my website, the UA number is XX-XXXXXX, not the number entered in the module in admin.

any ideas what's going on?

zc1.3.7, FYI.

thanks.

Works fine on 1.3.7 so that shouldn't be the issue.

When you ran the SQL patch, did it give you 37 statements processed successfully? Did any errors along the way show up?

Hi econcepts,

Thank you for the explanation of your ebook. I am intrigued. I thought it was just a more in depth explanation of how to install analytics on zencart.

I do have one final question though. It appears it is now picking up traffic and capturing ecommerce sales. Therefore both parts of this mod seem to be working. However some strange behavior I have observed is that it is not capturing any adwords tracking. Zero. When I click on traffic sources and adwords, it shows my two campaigns and it says zero. But I know this isn't right (I feel it in the pocketbook if you know what I mean).

I am pretty sure this is not a zencart error, but I was wondering if anyone has any recommendations? Google's help is about as helpful as the help for Microsoft products.

Thanks in advance.

Voltage (and all other analytics users),

Long post here ... good stuff ... questions answered. Hang in there and read on. :)

Your specific question is answered and a detailed explanation of what the Google Workbook really holds inside is also revealed.

voltage:

Hi econcepts,

Thank you for the explanation of your ebook. I am intrigued. I thought it was just a more in depth explanation of how to install analytics on zencart.

The Workbook is much more than just a "how to install" manual. That is only one part of it (because if you don't have analytics installed correctly and completely, it does you no good at all.)

The main basis of the Google Workbook is to teach users of Google Analytics how to install it properly and then how to use the major key metrics it provides to help increase conversion of your website. That is where most people fail at using Analytics.

Many people install an analytics package just to "gather data" for review. However, the truth is, that data is no good if you don't know how to actually read and use it to help you make changes that will lead to an increase in conversion. This is the key, and one that is all to often overlooked by most website owners. Many don't realize that the answer to many of their questions is found in the data gathered from analytics.

Interpretation of that data is key. Instead of just "looking at numbers", you must begin to understand what those numbers are actually telling you about your website, your customers, and your products. Only then can you begin to understand what needs to be done to increase conversion.

voltage:

I do have one final question though. It appears it is now picking up traffic and capturing ecommerce sales. Therefore both parts of this mod seem to be working. However some strange behavior I have observed is that it is not capturing any adwords tracking. Zero. When I click on traffic sources and adwords, it shows my two campaigns and it says zero. But I know this isn't right (I feel it in the pocketbook if you know what I mean).

I am pretty sure this is not a zencart error, but I was wondering if anyone has any recommendations? Google's help is about as helpful as the help for Microsoft products.

I can understand that comment about the Google help. It is tough. That is yet another reason I developed the Workbook. the Workbook explains everything in upfront and "non-technical" terms that anyone can understand and follow (translated for "all of us" is a good way to put it.)

More than likely, you have not tied your Analytics account to your AdWords account. If you haven't done this, and specified that the two should work together, you will not see any AdWords data in your analytics reports.

Again, this goes back to "just setting up analytics" by installing the Simple Google Analytics module, and "correctly setting up COMPLETE Google Analytics (which includes the installation of the Simple Google Analytics module along with many other features available only through your actual Google Analytics, or AdWords account).

There is a LOT more to setting up analytics than many people want to think. Not to rehash, but this is the basis of the Google Workbook and this particular issue (linking your AdWords account to your Analytics account) is covered there as well.

I hope that helps explain it a bit more to you (and the other readers out there). It is so tough to go through all the little details that "could be" it was just easier to put it down in a workbook with screenshots and step by step examples.

A large number of users of Simple Google Analytics have already downloaded and seen the benefit of the Workbook and I think once other users understand the Workbook is far more than an "installation guide" they too will see the benefit it can have for their website. :)

Let me know if you have any further questions about your analytics install or the Workbook.

cudaboy71:

i'm having trouble with the analytics module. i've installed the module, updated the SQL, pasted the php code into /includes/templates/[your_template]/common/tpl_main_page.php

but, when i reload my website, the UA number is XX-XXXXXX, not the number entered in the module in admin.

any ideas what's going on?

zc1.3.7, FYI.

thanks.

Just to make sure this is closed out. We have been talking via PM and the issue is now resolved. See below:

Posted by cudaboy71:

Evidently i upgraded in the wrong order or something. i was sure i put in the UA number. but, lo and behold i just checked and it had reverted back to XXX-XXXXX.

it's all working great now.

FYI, i bought your analytics book this afternoon. lots of good stuff in there i didn't know, but thought i did. well worth the $20. thanks for all the hard work on it.

-bob

Im very tired now, been Reading Forum posts SQL'n and FTP'n all day....

ZEN 1.3.7

SQL 5.0.24

All installed SQL upload fails

39 statements processed.
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

AND No button on Config....

Any ideas????

Have a good one

Richie

JMS_Music:

Im very tired now, been Reading Forum posts SQL'n and FTP'n all day....

ZEN 1.3.7

SQL 5.0.24

All installed SQL upload fails

39 statements processed.
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Error ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

AND No button on Config....

Any ideas????

Have a good one

Richie

Just for kicks, try to run the SQL by copy and pasting from within the Admin.

The error you are getting means that whatever method you are trying to use to run the SQL, it is not finding your "configuration_group" table (comes with zen cart installs).

It is looking for "zen_configuration_group" and there is no such table in your installation apparently. Do you know off hand what the name of the table is on your end? It looks like you gave it the prefix of "zen_' according to the install error.

Im not putting a table on my end!!!!! :-)

Hi econcepts thanks for the reply! Got to say its your fault that I am up to my neck in this... downloaded the first book loved the ideas and now am in the process of moving things and changing colours as you advise (and as a customer I would prefer to see)

At the moment I am trying to get the ADDED TO CART (.messageStackSuccess,) to drop next to the add to cart button... love that idea :-)

AND then I will be making a nice BIG green "Action" Button hopefully in CSS but have to research that a little deeper :-) (waiting for a nice friendly answer with tips ;-)

SO back to the table on my end....

I tried both... Copy-Paste and upload ....

PHPMYADMIN tells me that the TABLE is called "configuration_group" so where did the ZEN come from and shall I just loose it from the SQL upload???

When this eventually kicks in I can buy the next book.... now theres an incentive!!! :-)

Thanks in advance for the input....

Richie

JMS_Music:

Im not putting a table on my end!!!!! :-)

Hi econcepts thanks for the reply! Got to say its your fault that I am up to my neck in this... downloaded the first book loved the ideas and now am in the process of moving things and changing colours as you advise (and as a customer I would prefer to see)

At the moment I am trying to get the ADDED TO CART (.messageStackSuccess,) to drop next to the add to cart button... love that idea :-)

AND then I will be making a nice BIG green "Action" Button hopefully in CSS but have to research that a little deeper :-) (waiting for a nice friendly answer with tips ;-)

SO back to the table on my end....

I tried both... Copy-Paste and upload ....

PHPMYADMIN tells me that the TABLE is called "configuration_group" so where did the ZEN come from and shall I just loose it from the SQL upload???

When this eventually kicks in I can buy the next book.... now theres an incentive!!! :-)

Thanks in advance for the input....

Richie

The "Zen" comes from within your install (of zen cart itself). When you run a script through the admin of zen, it automatically appends the prefix you determined when you setup the system the first time around to the front of any table name.

So, that prefix is not in the actual "upload file". It is put there by Zen Cart.

Make sense?

Dear developer of this excellent mod,

Just wanna inform you that the included installation sql patch will delete configuration_key with configuration_group_id = 0

The effected keys are

PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

Deletion of above keys will effect the proper functionality of Zen Cart.

surf7.net:

Dear developer of this excellent mod,

Just wanna inform you that the included installation sql patch will delete configuration_key with configuration_group_id = 0

The effected keys are

PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

Deletion of above keys will effect the proper functionality of Zen Cart.

Thanks and glad you like the mod, however, you are incorrect in your thinking.

It appears you are not reading or understanding the SQL language provided in the install correctly.

If you look at the SQL code closely, you'll notice that the configuration group id variable is set during the SELECT statement, and is set to the specific value "WHERE configuration_group_title= 'Google Analytics Configuration';".

That group id differs between sites and the variable is set as such to properly remove the correct configuration values as needed (and if present).

A number of contributions use this same logic as it provides a means for users to install a module into an "open slot" without conflicting with other configuration group ids on their system.

This module is in use by myself on many sites, and thousands of other Zen Cart users (look in the downloads section) without any problems relating to "proper functionality of Zen Cart."

In fact, just to be sure, I tested your concept (I always test), and the patch works just fine without deleting the configuration keys you mentioned above. :)

Surf7,

By the way. I went to your site, and looked at your "Malaysia E-Commerce Solution". Then looked at your demo site at http://demo.easyweb.com.my/.

I noticed that no where on your "E-Commerce solution" services page nor on the Demo site do you give credit to or even mention the cart is Zen Cart.

If you are going to be using Zen Cart as your "e-commerce solution", I would recommend giving them credit where credit is due and not masking it as if it was your own custom solution. A lot of hard work goes into this cart through the great community of developers, and a lot of users spend a great deal of time making sure it works for others. It's only right to give credit to the team that created it and not make it look like it is your own.

Just a thought.

econcepts:

Thanks and glad you like the mod, however, you are incorrect in your thinking.

It appears you are not reading or understanding the SQL language provided in the install correctly.

If you look at the SQL code closely, you'll notice that the configuration group id variable is set during the SELECT statement, and is set to the specific value "WHERE configuration_group_title= 'Google Analytics Configuration';".

That group id differs between sites and the variable is set as such to properly remove the correct configuration values as needed (and if present).

A number of contributions use this same logic as it provides a means for users to install a module into an "open slot" without conflicting with other configuration group ids on their system.

This module is in use by myself on many sites, and thousands of other Zen Cart users (look in the downloads section) without any problems relating to "proper functionality of Zen Cart."

In fact, just to be sure, I tested your concept (I always test), and the patch works just fine without deleting the configuration keys you mentioned above. :)

I have run this code again in phpmyadmin

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;

and it indeed deleted:

PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX
IH_VERSION (from Image Handler Addon)

My MYSQL version is 5.0.21 and the phpmyadmin is 2.8.1

I have run it again in MYSQL 4.1.22 and phpMyAdmin - 2.10.0.2. still the same problem.

Please note that, if run the above code in a database that has "Google Analytics Configuration" in configuration_group table, then the above will only delete the keys in configuration table with configuration_group_id equals to the Google Analytics configuration group ID.

OK I lost myself there.... anyway, the point is: if you run the above code for new installation of Google Analytics, then it will delete the 4 keys mentioned above.

Did you test run the code on a database already has Google Analytics installed?

I have reported this problem to other addon developer as well. So far, I managed to discover these addons are effected:

Google Sitemap
GOOGLE BASE FEEDER
Testimonials Manager
RSS Feed

Some have already releasing a fixed.

econcepts:

Surf7,

By the way. I went to your site, and looked at your "Malaysia E-Commerce Solution". Then looked at your demo site at http://demo.easyweb.com.my/.

I noticed that no where on your "E-Commerce solution" services page nor on the Demo site do you give credit to or even mention the cart is Zen Cart.

If you are going to be using Zen Cart as your "e-commerce solution", I would recommend giving them credit where credit is due and not masking it as if it was your own custom solution. A lot of hard work goes into this cart through the great community of developers, and a lot of users spend a great deal of time making sure it works for others. It's only right to give credit to the team that created it and not make it look like it is your own.

Just a thought.

Hi econcepts,

Please look properly at the bottom of left side bar of...

http://www.surf7.net/services/ecommerce/index.php
http://www.surf7.net/services/ecommerce/pricing.php
http://www.surf7.net/services/ecommerce/demo.php
http://www.surf7.net/services/ecommerce/client.php
http://www.surf7.net/services/ecommerce/order.php
http://www.surf7.net/services/ecommerce/resources.php

It has Powered by [ZEN CART logo]

There is no requirement that I must put link to Zen Cart on every web store I created. However if view the source code, you can see...

<meta name="author" content="The Zen Cart™ Team and others" />
<meta name="generator" content="shopping cart program by Zen Cart™, http://www.zen-cart.com eCommerce" />

To view source code of any web page, please follow these steps.

1. In Mozilla Firefox, go to View > Page Source or Ctrl + U
2. In Internet Explorer 7, go to Page > View Source

Please note that I am not selling Zen Cart but rather selling support services. I am not sure how do you come to conclusion that I am masking it as if it was my own custom solution. All my customers will see Zen Cart logo smack right on the top left when they login to their admin.

FYI, I did contribute to Zen Cart with my fair share of contributions. I also help out in discovering errors made my other developers like you. I hope you are not offended that I pointed out your errors. If you do, please let me know and I will not announce it in the forum.

Anyhow, great products.

P/S - If you discover errors in my contributions, please point it out to me. I'll be more than happy.

No harm meant surf7, and thanks for your contributions to the community. :)

I also appreciate when errors in contributions are pointed out as that is one way of making the whole Zen Cart software better for all of us.

I just wanted other users to know that the error you pointed out in your original post is not an error at all and in fact the SQL syntax works just fine as is. It causes no issues with deleting improper key values from the core of zen cart stores.

I tested it before release, and just tested it again here before I posted the reply to make sure that is the case. If there was an error in the code, I certainly would correct it, however in this case there was none.

See you round the forums!

econcepts:

It causes no issues with deleting improper key values from the core of zen cart stores.

You mean these three keys PRODUCTS_OPTIONS_TYPE_SELECT, UPLOAD_PREFIX, TEXT_PREFIX are not deleted when you run the sql patch?

surf7.net:

You mean these three keys PRODUCTS_OPTIONS_TYPE_SELECT, UPLOAD_PREFIX, TEXT_PREFIX are not deleted when you run the sql patch?

Nope. Not at all. :)

Just for kicks. Tried it again here a third time, and they are not deleted. :)

econcept, why you don’t answer my Emails?

I bought your e-book and it create lots of problem in my web sites?

You should keep some kind of customer support for your product.
For start send me new zip file of the program, as the one I got missing icons, and maybe most likely some files