Google Adwords ROI Tracking

[Bsnrjones]

I am trying to get the ROI tracker the Google is providing to work. I looked over at the oscommerce forums and someone provided a way to do it, but it is not working for me. I think it has something to do with BTS.

Here is the post over there:
http://forums.oscommerce.com/index.p...p;#entry240251

I cannot get the Google logo box to show up or have anything tracked.

Any ideas?

Burke

[chrismole]

You need to copy the code Google Adwords provides for conversion tracking into catalog/checkout_success.php. It's that simple. It worked for me. You should not have to edit any of the php code in the page.

[Bsnrjones]

Thanks, I finally figured it out. I was wanting to be able to carry over the order total, so the ROI tracking would work correctly at Google. It finally worked when I figured out which file to put it in. I am finally getting the hang of the BTS system!

[kmazumdar]

Can you please give more details on the placement of google ROI Tracker?

Thanks
Kmazumdar

[nfmg]

Hmmm, I seem to be having problems with the google conversion tracker too. Google's instructions say to have the code in the head, just before the body tag, but I don't see how that could be done.

I just pasted the javascript in the html template.

When I process an order after clicking on a google adwords ad, I see the conversion tracker - "Google Site Stats", but no conversion data is showing up in our reports.

Edit: Doh! I guess there is conversion data, just not in the reporting period I was looking at, which is still strange, but a different sort of problem. Thx anyhow.

[betagirl]

I'm having a problem understanding where precisely to put the code for Google's Conversion tracking. I'm using osCMax 2.0 - and I think it's the BTS that is throwing me.

Also, I want to get the subtotal value so here's what I've done so far:

in /catalog/checkout_success.php I've added the following code just before // BOF: MOD - PWA: Added a check for a Guest checkout and cleared the session -

//added for Google
$Query = "select sum(value) as total_value from " . TABLE_ORDERS_TOTAL . " where class = 'ot_subtotal' and orders_id = '" . $HTTP_GET_VARS['order_id'] . "'";
$result = tep_db_query($Query);
$row = tep_db_fetch_array($result);
$subtotal = $row["total_value"];

And in checkout_success.tpl.php I've added this code just before the image link to "continue" -

	                <!-- Google Code for Purchase Conversion Page -->
					<script language="JavaScript" type="text/javascript">
					<!--
					var google_conversion_id = xxxxxxxxxx;
					var google_conversion_language = "en_US";
					var google_conversion_format = "1";
					var google_conversion_color = "666666";
					if (subtotal) {
					  var google_conversion_value = subtotal;
					}
					var google_conversion_label = "Purchase";
					//-->
					</script>
					<script language="JavaScript" src="https://www.googleadservices.com/pagead/conversion.js">
					</script>
					<noscript>
					<img height=1 width=1 border=0 src="https://www.googleadservices.com/pagead/conversion/xxxxxxxxxx/?value=subtotal&label=Purchase&script=0">
					</noscript>

Are these placed correctly? I cannot test as the client does not currently have any AdWords campaigns active. However, I added " <? echo $subtotal ?>" after the Google code in checkout.success.tpl.php to see if the value carried through, and it does not appear to.

???? I'm stuck. Any suggestions as to what I'm doing wrong?

Thanks so much!

EDIT: doh. So I made a slight change to the code on /catalog/checkout_success.php and now all is working fine. Turns out, this part of the query ----

$HTTP_GET_VARS['order_id']

needed to be -----

$orders['orders_id']

And now all is groovy - the variable and correct amount gets through. Hope this perhaps helps someone else.