Quote Originally Posted by JackA View Post
I am running zc 1.3.8a and MySQL 5.x

I read the installation instructions for a new install and followed them - I thought.

I installed this S-G-A mod, using the Tools > Install SQL Patch to install the mysql file, browsed to your .sql file on my HD and clicked Upload.

I then went to Admin > Configuration > Google Analytics and set things up, putting in my GA code, etc.

I see Adwords clicks, but I get no records in my Google Analytics reports. Is there something more I need to do with the mysql patch? When I "uploaded" it nothing appeared in the ZC text area that is labeled "Enter query". Was I supposed to do a copy/paste here? I know nothing about mysql queries.

Jack
Ref: http://artbeautiful.com
Jack,

A few things to note.

1) It is sometimes best to "copy and paste" the SQL patches into the Admin interface rather than upload files (which in the past have been shown to be rather shaky at times).

2) Seeing Adwords clicks does not mean you have the module installed. Adwords clicks are tracked from the GOOGLE side and triggered when a user clicks on your ad). Integration between Google AdWords and Google Analytics is what can happen with my mod (so that the Adword data shows in your Google Analytics reports).

3) Did you add the line of code to your "tpl_main_page.php" file as listed in the installation? I looked at your site, and the tracking code is not showing at the bottom of your pages. This means that you skipped Step 3 of the installation instructions which mentions that you need to add the following lines of code to the "tpl_main"page.php" file:

<?php
require($template->get_template_dir('.php',DIR_WS_TEMPLATE, $current_page_base,'google_analytics') . '/google_analytics.php');
?>

If you perform #3 above, I think you'll get it all working. :)