First post, but long time follower... :smile:

I installed Simple SEO about a week ago and it's been working perfectly - great mod! I also use Paypal IPN and have not had any trouble.

However, I did notice that my Adwords tracking has suddenly gone to 0. My Google analytics are still working fine, but the tracking of Adwords inside Google Analytics is now missing.

I'm wondering if this may have something to do with the gclid= ID tag from Adwords that may be getting messed up somehow...

I also have the Google Analytics mod installed.

Here's our website: www.craftaroo.com

If anyone else has had any problems or found a resolution I'd really appreciate your help.

Note: this is not a major problem. Adwords clicks are still getting through to the correct pages and everything else is working perfectly. Just wondering why Google Analytics has lost the tracking of Adwords impressions and clicks...

Thanks!
Chris

Hello all,

I've just installed Simple SEO and it has benn working great.

After playing with some links i came acros some minor mistake.

If i type domain.com/category-one-c-1 it works, but if i misspell url like domain.com/category-one-c-1x i get MySql mistake

1054 Unknown column '1x' in 'where clause'
in:
[SELECT categories_name FROM categories_description WHERE categories_id =1x LIMIT 1]

aslo get the mistake with product (if i type x behind product number)

1054 Unknown column '3x' in 'where clause'
in:
[SELECT d.products_name, p.products_type FROM products p, products_description d WHERE p.products_id =3x AND d.products_id= p.products_id LIMIT 1]

I guess there should be some kind of checking if $_GET[c,p... and other variables are numbers or not.

How can that be done?

Regards

Guys, I'm in Houston and if you read the news, you know we have power outage here. And it's possible that, even when we got our power back, it may take a while for the internet to come back. So I apology for not being able to get back to you as soon as you may expect. I will, spend some time everyday when I get internet access (and power) at a friend's house to reply as many questions as possible.

Cobra, thanks for reporting that.
I believe that the alpha version I posted a few posts earlier should address that problem. If not, I will have it in place in the next version.

Regards.

cobra7:

Hello all,

I've just installed Simple SEO and it has benn working great.

After playing with some links i came acros some minor mistake.

If i type domain.com/category-one-c-1 it works, but if i misspell url like domain.com/category-one-c-1x i get MySql mistake

1054 Unknown column '1x' in 'where clause'
in:
[SELECT categories_name FROM categories_description WHERE categories_id =1x LIMIT 1]

aslo get the mistake with product (if i type x behind product number)

1054 Unknown column '3x' in 'where clause'
in:
[SELECT d.products_name, p.products_type FROM products p, products_description d WHERE p.products_id =3x AND d.products_id= p.products_id LIMIT 1]

I guess there should be some kind of checking if $_GET[c,p... and other variables are numbers or not.

How can that be done?

Regards

You may want to "view source" your site, and the check the google analytics code at the very end of your page. It is very possible that the module uses zen's href link, if so we just need to add an exception in admin.

christo:

First post, but long time follower... :smile:

I installed Simple SEO about a week ago and it's been working perfectly - great mod! I also use Paypal IPN and have not had any trouble.

However, I did notice that my Adwords tracking has suddenly gone to 0. My Google analytics are still working fine, but the tracking of Adwords inside Google Analytics is now missing.

I'm wondering if this may have something to do with the gclid= ID tag from Adwords that may be getting messed up somehow...

I also have the Google Analytics mod installed.

Here's our website: www.craftaroo.com

If anyone else has had any problems or found a resolution I'd really appreciate your help.

Note: this is not a major problem. Adwords clicks are still getting through to the correct pages and everything else is working perfectly. Just wondering why Google Analytics has lost the tracking of Adwords impressions and clicks...

Thanks!
Chris

YOu may want to clear cache again and see if that fixes. I dont use that module, so it's hard for me to actually figure out why the error happens until I really see it (and checking the error code etc....)

If that still does not fix the problem, I suggest you set up at test site online and send me over the info, I will check it for you.

Regards

ckosloff:

Me again, sorry for repetitive posting.
I am testing further the contrib, and did find an error.
If you go to my site you will see that all products have lots of color attributes.
It would be impossible for me to publish all colors full size, so I use a contrib called "Attribute pop-up (large images)".
Now, this doesn't work with SSU, I am positive because I get the images in the popup back when turning SSU off in Admin.
Sorry, but cannot load this contrib yet on the live site until I make sure that it won't cause any disruption.
If you would I can post a snapshot of error.
One more thing: in module manager, the contrib still shows as beta 2.5, even after updating database.
Thanks.

yellow1912:

YOu may want to clear cache again and see if that fixes. I dont use that module, so it's hard for me to actually figure out why the error happens until I really see it (and checking the error code etc....)

If that still does not fix the problem, I suggest you set up at test site online and send me over the info, I will check it for you.

Regards
Yellow,
Sorry to hear about your hurricane-related problems.
I live in South Florida, so I know what you are talking about.
Regarding this issue, I tried everything: clearing cache, upgrading database, restarting comp, etc., no joy.
The module is available in the downloads area:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=616
I will set up an online test site but you have to give me some guidelines on what you want: a top-level domain, a sub-domain, etc.
Thanks for continuing support.

You can set it up any way you want. For example, if you have a store at site.com, you may want to set it up at test.site.com or at site.com/test

Regards

yellow1912:

You may want to "view source" your site, and the check the google analytics code at the very end of your page. It is very possible that the module uses zen's href link, if so we just need to add an exception in admin.

First of all, I've been watching the news here from Hong Kong and my thoughts go out to you and everyone there in Houston. I hope you're ok - it certainly looks devastating from here...

I appreciate your help with this, thanks yellow1912...

OK... Here's the 'view source' from the footer of the site.

<script type="text/javascript">
<!--
if(!gaJsHost) {
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
}
//-->
</script>
<script type="text/javascript">
<!--
if(!pageTracker) {
var pageTracker = _gat._getTracker('UA-removed-1');pageTracker._initData();pageTracker._trackPageview();
}
//-->
</script>

I'm not sure what the exception to add might be... maybe something with ga.js?

I do know that the gclid passed from the web ad gets translated in the URL from:

www.craftaroo.com/catalog/index.php?main_page=product_info&cPath=14_15&products_id=115?gclid=CPyGo9ef3pUCFblahblahblahblah

to:

http://www.craftaroo.com/catalog/stickers-3d-c-14_15/party-masks-3d-sticker-p-115/gclid/CPyGo9ef3pUCFblahblahblahblah

Is there a way to disable the gclid URL attribute 'SEO-ization' the same way you handle the zenid attribute?

Take care,
Chris

How many ways to have a mental breakdown......
Yellow I sooo need your help please..
After having a weekend away (much needed) after spending weeks building and installing my 3 shops ... (multisite, hover etc etc) I totally demolished them in the space of about 30secs and deleted the backup at the same time. Lesson learned never let your cat walk across your keyboard when you make tea.....:censored:

I've tried redoing the whole lot today and sod it I'll be happy with the one site as it needs to open this weekend, the rest i'll do on another server as I just have had a total melt down....

My brain is on shut down as i cannot sort this out
this is what is in the url

http://www.fairyalchemy.co.uk/shop/cSSU_ID_DELIMITER3_5/njztrsfSSU_ID_DELIMITERpSSU_ID_DELIMITER1
I use expression to work in and it has access problems due to the .htaccess but i can work round that if need be.. I know its prob not to difficult but with my last two brain cells threatening divorce i'm stumped.......

xxx:shocking:

Go to admin-extras-ssu manager-clear cache.> FairyAlchemy:

How many ways to have a mental breakdown......
Yellow I sooo need your help please..
After having a weekend away (much needed) after spending weeks building and installing my 3 shops ... (multisite, hover etc etc) I totally demolished them in the space of about 30secs and deleted the backup at the same time. Lesson learned never let your cat walk across your keyboard when you make tea.....:censored:

I've tried redoing the whole lot today and sod it I'll be happy with the one site as it needs to open this weekend, the rest i'll do on another server as I just have had a total melt down....

My brain is on shut down as i cannot sort this out
this is what is in the url

http://www.fairyalchemy.co.uk/shop/cSSU_ID_DELIMITER3_5/njztrsfSSU_ID_DELIMITERpSSU_ID_DELIMITER1
I use expression to work in and it has access problems due to the .htaccess but i can work round that if need be.. I know its prob not to difficult but with my last two brain cells threatening divorce i'm stumped.......

xxx:shocking:

@chhristo: which GA module are you using?

I have your latest version and the problem is still there.

Ragards.

yellow1912:

Cobra, thanks for reporting that.
I believe that the alpha version I posted a few posts earlier should address that problem. If not, I will have it in place in the next version.

Regards.

yellow1912:

@chhristo: which GA module are you using?

I'm using this one:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=891

I was using another, but this one had better integration for the eCommerce part of GA. More info/version below...

Name

Google Analytics Integration

Version Date

v 2.2.1 01.09.2008 01:23

Author

Andrew Berezin http://eCommerce-Service.com

Description

This module allow you to integrade the advanced e-commerce Analysis provided by the
Google service named Google Analytics as described here:
http://www.google.com/analytics/

Support forum

Support topic on forum: http://www.zen-cart.com/forum/showthread.php?t=43907

This will be addressed in the upcoming version (which will support link alias as well)

cobra7:

I have your latest version and the problem is still there.

Ragards.

I have installed this on my demo site and waiting for the data to come in to see how it turns out

Regards> christo:

I'm using this one:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=891

I was using another, but this one had better integration for the eCommerce part of GA. More info/version below...

Name

Google Analytics Integration

Version Date

v 2.2.1 01.09.2008 01:23

Author

Andrew Berezin http://eCommerce-Service.com

Description

This module allow you to integrade the advanced e-commerce Analysis provided by the
Google service named Google Analytics as described here:
http://www.google.com/analytics/

Support forum

Support topic on forum: http://www.zen-cart.com/forum/showthread.php?t=43907

yellow1912:

I have installed this on my demo site and waiting for the data to come in to see how it turns out

Regards

Really appreciate it, thanks Yellow1912.

Just to clarify, I get all the analytics data in Google, including the eCommerce info, just fine. It's only the Adwords info inside GA that is missing...

Have a look here http://www.craftaroo.com/AdwordsGrab.jpg for a screengrab of the GA screen showing the Adwords drop in data collection.

Hope this is all clear...

Thanks!
Christo

Chris,
where do you have this:
http://www.craftaroo.com/catalog/stickers-3d-c-14_15/party-masks-3d-sticker-p-115/gclid/CPyGo9ef3pUCFblahblahblahblah
In the worst case, we can just have SSU treats ga the same and zenid, which is not a problem.

yellow1912:

Chris,
where do you have this:
http://www.craftaroo.com/catalog/stickers-3d-c-14_15/party-masks-3d-sticker-p-115/gclid/CPyGo9ef3pUCFblahblahblahblah
In the worst case, we can just have SSU treats ga the same and zenid, which is not a problem.

Hmmm... actually I don't have that...

My apologies if you already know this info, but I'll explain here for clarity:

When someone searches on Google for certain keywords, our Craftaroo ad appears on the right side as a 'sponsored' link.

If someone clicks on that link, Google passes variables to our website so that the Google Analytics code in our footer can tell where the click came from (which ad campaign, medium, source, etc.) These variables take the form of gclid=blahblahblah.

So, Google generates the gclid=blahblahblah code and includes it in the link to Craftaroo, it's not generated anywhere inside Zen Cart or within Craftaroo.

My guess is that the SEO module is affecting the gclid variables being passed from Google so that the Analytics module cannot recognize it anymore. As you said, perhaps we just need to treat it like the zenid to keep it in the format "?gclid=blahblahblah" rather than "/gclic/blahblahblah"?

Thanks!
Chris

Hi Chris,

If the link is, like you said, generated by Google, then there is no way we can change the way it works. And also, if it is created by Google, there is no reason why it wouldnt understand the link generated by itself.

Interesting. Perhaps you can pm me the keywork I need to search so that the ads will show up, and then I can investigate the problem? (I promise I wont click on that ads :p)