Google Analytics Integration

[a_berezin]

Lawbird123,
Can I see menu and Google code? You may PM me both.

[mizt]

Let me get a sale or two and get to make sure everything is working. But it seems to be good. Give me a paypal address to donate too. Thank you for your time w/ this contribution.

[a_berezin]

Donate to zen dev team.

[kernphilip]

i get the following error when I try to apply the sql patch. Any ideas why?

 
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 'customers', 'delivery', 'billing'),'), (NULL, 'Affiliation', 'GOOGLE_ANALYTICS_A' at line 1
in:
[INSERT INTO zac_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 (NULL, 'Analytics Account', 'GOOGLE_ANALYTICS_UACCT', 'UA-XXXXXX-X', 'Enter your Google Analytics account number', @t4, 1, NOW(), NOW(), NULL, NULL), (NULL, 'Target Address', 'GOOGLE_ANALYTICS_TARGET', 'customers', 'What adress (City/State/Country to correlate the transaction with) use in Analytics transaction?', @t4, 2, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('customers', 'delivery', 'billing'),'), (NULL, 'Affiliation', 'GOOGLE_ANALYTICS_AFFILIATION', '', 'Optional partner or store affilation', @t4, 3, NOW(), NOW(), NULL, NULL), (NULL, 'Use sku/code', 'GOOGLE_ANALYTICS_SKUCODE', 'products_id', 'Using as Product SKU code', @t4, 4, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('products_id', 'products_model'),');]

[a_berezin]

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!

mizt
Don't use upload sql-patch - use Copy/Paste to run sql-patch;
or
http://www.zen-cart.com/forum/showthread.php?t=58654

[kernphilip]

well manualy copying it in made no difference at all, but once I made the changes to sqlpatch.php it worked like a charm!

[a_berezin]

You must copy/paste original sql-patch.

[Wacheena]

I'm having trouble setting up a Google Analytics goal to track conversions and dropoffs during the process. I want to track users from the login page, through the order confirmation page and see where they leave. Currently I have the following steps defined in Google Analytics, and even though there I have received orders, Google Analytics says that I've never had a conversion. I'm using Paypal for payment processing:

1. http://store.evolvinghealth.com/inde...ain_page=login
2. http://store.evolvinghealth.com/inde...ckout_shipping
3. http://store.evolvinghealth.com/inde...eckout_payment
4. http://store.evolvinghealth.com/inde...t_confirmation
5. http://store.evolvinghealth.com/inde...eckout_process

I set up the steps to use Match Type: Head Match to deal w/ session variables, and I checked each page to make sure that Urchin code is getting executed.

Does anyone see any issues with the way I have set up the steps in my process? Has anyone else had success setting up funnels and conversion goals in Google Analytics?

[samad64]

checkout confirmation should be your goal.. not a step. google will not track conversions unless there's a goal.. basically they track how many people get to the goal and then calculate the conversion rate using that

P.S. Checkout_process shouldn't be on there.. its not really used for tracking purposes

[Wacheena]

I use PayPal for payment processing, so checkout_confirmation isn't the end of my goal because the user needs to visit paypal and then return before the order is complete. After completing payment on Paypal, I have defined the goal as payment_process.

It looks like my customers are being tracked all the way to when they are sent to paypal, but not afterward. Is there an issue defining a goal where the user goes to a different site and then returns before completing the goal?

Thanks Zenners!