Simple Google Analytics - Support

Whoops, let me check that. Thanks Shrimp-Gumbo!

Yep, that was it! Thanks!

So now where does one find the Analytics tracking info? In the Google account? Don't mean to sound dumb but my client suddenly decided to use Adwords and frankly I've always avoided it in favor of other methods. So I installed this update but have no idea how to confirm it is passing info.

Thanks again,

Mark

Thanks for the Contrib, i just posted a question on another thread, and just found this now.
Just logged into google and i get a green tick with my domain and it says Receiving Data, which was working before as well, but the problem i have is i cant get conversion tracking to work or goal conversion, any ideas on how this could be setup

Thanks!!
Samantha

mrblaq:

First, run this query

SELECT configuration_group_id
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;
```Otherwise, if it does return a number, you'll then need to run the following queries to see what may be deleted.  Replace <number> with what was returned above
> 
> ```
SELECT * FROM configuration WHERE configuration_group_id = <number>;
SELECT * FROM configuration_group WHERE configuration_group_id = <number>;
```If any rows are returned by those two queries, you'll need to back up those lines before running the googleanalytics.sql script.

I ran the first query and got this:
    **SQL query:** 

SELECT configuration_group_id
FROM configuration_group
WHERE configuration_group_title =  'Google Analytics Configuration'
LIMIT 0 , 30     
      **MySQL said: **
#1146 - Table 'midwest_mydb.configuration_group' doesn't exist 



any suggestions?

keylesslocks:

I ran the first query and got this:
SQL query:

SELECT configuration_group_id
FROM configuration_group
WHERE configuration_group_title = 'Google Analytics Configuration'
LIMIT 0 , 30
**MySQL said: **
#1146 - Table 'midwest_mydb.configuration_group' doesn't exist

any suggestions?

I noticed the same thing. If I prefix the table name with zen_ I get the expected results. I'm working with an install that was set up by my designer so I don't know for sure. I did see (back in message 373 of this thread) that the zen_ is supposed to be automatically added but it isn't for me...

Be that as it may, this is a great mod, Eric. I'm amazed at the work you've done - THANKS!

Mark

Does this work with Cross-channel Campaigns (conversion tracking)? I've set it up manually by editing the define_main_page.php, but that "Google Site Stats" link looks stupid in the middle of the page. It would be nice if it was in the footer, but only showed up on the main page.

Hello,

Just installed Simple Google Analytics v 1.2.1 and had a problem configuring the account number. Google would say code is not found on page although I could see it in the page source.

I think I found out the solution and I guess the installation readme could be more specific on this point. I hope Eric Leuenberger reads this message and will fix the doc.

The readme says the Analytics account has to be configured in zencart admin section for Google Analytics. Analytics account number is something like UA-1234567 and using this in zencart config leads to the error reported above.

The point is that Google tells me to insert JS code that uses UA-1234567-1 (notice the final -1) and zencart generates the code without the last part.

Now the solution: use the account number you can see in the JS code Google ask you to insert in your page. If you have only one profile it will probably end in "-1", but if you have more, this number may be different.

Hope this helps.

mewell:

I noticed the same thing. If I prefix the table name with zen_ I get the expected results. I'm working with an install that was set up by my designer so I don't know for sure. I did see (back in message 373 of this thread) that the zen_ is supposed to be automatically added but it isn't for me...

Be that as it may, this is a great mod, Eric. I'm amazed at the work you've done - THANKS!

Mark

Duh- I didn't know you could apply patches via Admin/Tools/Sql Query Executor. I've been trying it all through PHP MyAdmin

Mark

internetoutfitter:

I just upgraded version 1.1 of the Simple Google Analytics mod to version 2. I did it by the book with no errors and it appears the code is in the pages on https://www.rv-accessory-store.com but Google Analytics doesn't acknowledge it.

Can anyone give me some ideas? I'm perplexed.

Thanks,
Mark

Make sure you provide Google with the proper URL to check for the tracking code at -- and don't forget the trailing slash.

shrimp-gumbo-mmmhhh:

I think it would be good to have the tracking in the popup_shipping_estimator.html page.... any ideas of how to do this?

Shrimp

Two things.

1. To add it to that page (since it does not use the standard tpl_main_page.php file) you would need to add it to that page along (manually).

2. I would NOT put the shipping estimate into a pop-up anyhow. It hurts conversion as mentioned in my 20 Ways book and at this link:

Shipping Estimate in a Pop-Up? Why it Hurts Your Conversion, and What You Can do to Fix it.

internetoutfitter:

Yep, that was it! Thanks!

So now where does one find the Analytics tracking info? In the Google account? Don't mean to sound dumb but my client suddenly decided to use Adwords and frankly I've always avoided it in favor of other methods. So I installed this update but have no idea how to confirm it is passing info.

Thanks again,

Mark

You find the analytics in your Google Analytics account.

You will NOT get Adwords data integrated with your Analytics account though unless you link the two. The Google Analytics Workbook describes how to accomplish this process in detail with screenshots.

Sam_uk:

Thanks for the Contrib, i just posted a question on another thread, and just found this now.
Just logged into google and i get a green tick with my domain and it says Receiving Data, which was working before as well, but the problem i have is i cant get conversion tracking to work or goal conversion, any ideas on how this could be setup

Thanks!!
Samantha

A few things:

1) Conversion Tracking is only used in conjunction with Adwords. You must have an Adwords account to track that. Then, you must tie your Adwords account to your Analytics account to see the data within your Google Analytics reports.

2) Goals need to be manually setup from within your Google Analytics account, or they will not work. The tracking code merely records the data to each goal (once setup within your account).

The Google Analytics Workbook goes into great detail on these elements and more. You might benefit from getting a copy. It can be a confusing task without some clear guidance and screenshots.

Hope that helps!

mewell:

I noticed the same thing. If I prefix the table name with zen_ I get the expected results. I'm working with an install that was set up by my designer so I don't know for sure. I did see (back in message 373 of this thread) that the zen_ is supposed to be automatically added but it isn't for me...

Be that as it may, this is a great mod, Eric. I'm amazed at the work you've done - THANKS!

Mark

Although the SQL queries posted might help, I would be wary of trying to rum them because they make installation a whole lot harder.

Here is the best route to take.

If you are installing NEW for the first time
You should make sure you have the latest copy of the module to start with (version 1.2.1). It contains the updated code that does NOT delete anything incorrectly from your configuration.

If you already installed the module and noticed any configuration data missing then do this:
You may notice that after installing OLDER versions of module (pre 1.2.1) -- and under certain circumstances -- it deletes the following configuration keys:

PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

If you fall into this category, then you can fix it by running the following SQL query from within your admin.

INSERT INTO configuration VALUES ('', 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);

INSERT INTO configuration VALUES ('', 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);

INSERT INTO configuration VALUES ('', 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, '2007-03-19 17:57:39', '2007-03-19 17:57:39', NULL, NULL);

ONLY INCLUDE the next line if you had Image Handler installed, otherwise, it is safe to leave out.
INSERT INTO configuration VALUES ('', 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, '2007-06-06 16:47:03', NULL, 'zen_cfg_textarea_small(');

That should get it all corrected.

swingandmiss:

Does this work with Cross-channel Campaigns (conversion tracking)? I've set it up manually by editing the define_main_page.php, but that "Google Site Stats" link looks stupid in the middle of the page. It would be nice if it was in the footer, but only showed up on the main page.

Yes, this works with Conversion Tracking. The graphic should not show up anywhere on the page as the code included here will not display a graphic (based on other methods) and if it did, it would show in the footer footer of the page PROVIDING you installed the module correctly and in the proper location (according to the instructions).

As far as "Cross Channel" Tracking goes, that gets setup from within your Google Adwords account and is not affected in any way by the tracking code the module inserts.

What I mean is, it is possible to have Adwords Conversion Tracking installed and configured using this module, BUT not have Cross Channel tracking installed (because that is a feature that you must configure and activate from within your Google Analytics account).

In the event you need to add code to the page for Cross Channel tracking, it should be added near the code inserted for this module found in the bottom of the "tpl_main_page.php" file.

Hope that helps.

moktar:

Hello,

Just installed Simple Google Analytics v 1.2.1 and had a problem configuring the account number. Google would say code is not found on page although I could see it in the page source.

I think I found out the solution and I guess the installation readme could be more specific on this point. I hope Eric Leuenberger reads this message and will fix the doc.

The readme says the Analytics account has to be configured in zencart admin section for Google Analytics. Analytics account number is something like UA-1234567 and using this in zencart config leads to the error reported above.

The point is that Google tells me to insert JS code that uses UA-1234567-1 (notice the final -1) and zencart generates the code without the last part.

Now the solution: use the account number you can see in the JS code Google ask you to insert in your page. If you have only one profile it will probably end in "-1", but if you have more, this number may be different.

Hope this helps.

I'm reading (I'm Eric). :)

The instructions are a foundation for installation. It is kinda a given that you should use the entire tracking code that Google provides to you.

In a future release I'll be more specific on that part for the three or four people that have had that problem. Keep in mind though that if you've read any of my articles on this topic (specifically Google Analytics Demystified: Part 2 - Vanilla Google Analytics) you'll notice I preach that the tracking number oftentimes includes a trailing "-1".

That number can even change depending on whether you setup multiple profiles for one Analytics account. It could be "-2"; "-3"; "-10" or as many profiles as you setup.

Hope that helps. :)

econcepts:

Two things.

1. To add it to that page (since it does not use the standard tpl_main_page.php file) you would need to add it to that page along (manually).

2. I would NOT put the shipping estimate into a pop-up anyhow. It hurts conversion as mentioned in my 20 Ways book and at this link:

Shipping Estimate in a Pop-Up? Why it Hurts Your Conversion, and What You Can do to Fix it.

Thanks for the information. I have found your information quite helpful.

econcepts:

Yes, this works with Conversion Tracking. The graphic should not show up anywhere on the page as the code included here will not display a graphic (based on other methods) and if it did, it would show in the footer footer of the page PROVIDING you installed the module correctly and in the proper location (according to the instructions).

As far as "Cross Channel" Tracking goes, that gets setup from within your Google Adwords account and is not affected in any way by the tracking code the module inserts.

What I mean is, it is possible to have Adwords Conversion Tracking installed and configured using this module, BUT not have Cross Channel tracking installed (because that is a feature that you must configure and activate from within your Google Analytics account).

In the event you need to add code to the page for Cross Channel tracking, it should be added near the code inserted for this module found in the bottom of the "tpl_main_page.php" file.

Hope that helps.

Thanks Eric. Yes, I'm talking about Cross Channel tracking that has already been set up within my Adwords account. It requires different code that is placed in the specified landing page, which should be the tpl_main_page.php. I've done that but was looking for a more elequant method as the code shows up in the middle of the page, i.e. after the main section but before the footer. I was just wondering if you had a better method of doing so with this addon.

In a somewhat related note, does your addon only display the conversion tracking code on the success page? If so, and it doesn't actually display the "Google Site..." code, then I'll take a look at how you've done so and modify the main page for the Cross Channel conversion traking code.

When I installed this the SQL patch refused to install, I had to turn all of the VALUES('' into ```
VALUES(NULL

Anyone else have this issue?

swingandmiss:

In a somewhat related note, does your addon only display the conversion tracking code on the success page? If so, and it doesn't actually display the "Google Site..." code, then I'll take a look at how you've done so and modify the main page for the Cross Channel conversion traking code.

Yes, you are correct here. It only displays the conversion tracking on the checkout success page. That is the key page you want to track anyhow if running AdWords campaigns as it is indicates money has been made -- and after all, the only way to determine how effective an Adword campaign is (revenue wise) is to compare it to a revenue generating "action" (such as is the case with the "checkout success" page).

banswidthjunkie:

When I installed this the SQL patch refused to install, I had to turn all of the VALUES('' into ```
VALUES(NULL

> 
> Anyone else have this issue?

Good point to make to everyone here. MySQL 5+ doesn't like "blank" values in areas. It prefers "NULL". If anyone is using MySQL 5x and has this problem, you'll want to add the "NULL" in place of any "blank" spot in the SQL query.

In the next release of Google Analytics, I'll update the SQL query to include the "5x" compatible code.