Simple Google Analytics - Support

[netmeg]

Just wondering - (and I apologize if this has been asked before) but what's the function of the Target Address option ?

[econcepts]

Just wondering - (and I apologize if this has been asked before) but what's the function of the Target Address option ?

Target address is used with the e-commerce tracking. It allows you to determine which address you want the transaction "hooked" to for reporting purposes.

Your choices are:

Customers (address)
Delivery (address)
Billing (address)

[econcepts]

After working through all the questions in the forums regarding Google Analytics, one common theme among users is "how do I install it", and how can I add "Conversion Tracking" as well?

Up until now, the only way to add Conversion Tracking was to manually add the code.

That has now changed. I decided to re-work the original Simple Google Analytics contribution to address several issues I continue to hear.

1) "How do I install it" (I have updated the instructions to help assist in this and give more clarity)

2) How do I add Conversion Tracking?

This new version (1.1.0) now provides the ability for users to configure Google Conversion Tracking directly from within the Admin section.

I have also reworked a few of the previous items to include more "instruction" on what each item is, what you use it for, and how you use it. There were many questions like "What is the Target Address?" ; "What is the SKU/Code?" etc...

These are all answered in the new version as well.

How to Download the new version 1.1.0

You can download the new version complete with Conversion Tracking support by going to the following link in the Zen Cart downloads section:

http://www.zen-cart.com/index.php?ma...roducts_id=412

Where to get more information on the newest release

To get more information on this newest release, along with screenshots and some helpful tips on installing it, you can go to:

http://www.zencartoptimization.com/2...sion-tracking/

Enjoy!

[alan_powerbrixx]

Hi, Eric (econcepts),

Thanks for rolling the Conversion Tracking into the mod.

I am converting my site from hand-inserted GA and Conversion codes, to the simple-google-analytics mod. When I install the sql patch, I get the error display shown below between the "****" marks, and my Google Analytics menu in Admin stops just before the Conversion Tracking settings shown on your site's screen shot. Is this a problem on my site, or am I just on the "bleeding edge" of your new addition?

My host provides MySQL 4.1.22-standard, not version 5. Is that the problem? We're running Zen Cart 1.3.7. This install was to our test site which we keep permanently in maintenance mode and not viewable by the public at large.

****

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Yes', 'No'), ')' at line 1
in:
[INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate Conversion Tracking', 'GOOGLE_CONVERSION_ACTIVE', 'No', 'This element enables you turn on or off Google Conversion Tracking.

Please Note: Conversion tracking is used to track the effectiveness of Google AdWords paid search campaigns. If you are not running any paid search campaigns, then you should leave this set to "No".

If you are running Google AdWords (paid search) campaigns, then turning this on will place the proper conversion tracking code on your checkout success page and enable you to start tracking conversions.

Turning this on requires you to enter your unique Google Conversion Tracking ID in place of the "XXXXXXXXXXX" number shown in the next section.

For more hints and tips on how to use Google Analytics to increase sales from your store, visit ZenCartOptimization.com

Do you want to turn on Google AdWords Conversion Tracking?
', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('Yes', 'No'), ');]
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.

****

[econcepts]

Alan,

Which SQL patch are you using? There is one for "upgrading only", and one for "new (fresh) installs".

Let me know that and I'll take a look at that SQL syntax.

I've tested both here on a similar platform, and it works fine.

Again, let me know which patch you are using so I can look at that file.

Thanks!

By the way, the only report I have heard of (with SQL syntax in general) from PHP 4.x to 5.x is that in some cases, 5.x does not like items qualified as such '' and would rather them come across as 'NULL'.

That shouldn't be an issue with you though as you are on a 4.x version (and I have only heard it on a few 5.x version installs).

[alan_powerbrixx]

Eric,

Thanks for looking at this. Being a new install, I'm using the googleanalytics.sql file, using Admin > Tools > Install SQL Patches, and clicking Browse next to Upload File to browse to this file on my local disk. After that, the Upload button brings me to the error noted in the previous post.

[econcepts]

Alan,

Can you copy and paste the contents of the SQL patch into the Admin and run it that way (rather than upload).

Let me know how that works while I look into this one. I have a feeling that the upload function may be choking on a few of the quotes that are in the copy.