Google Analytics..

[Kev@Flexi.Net]

The following seems to work for us:-

/cgi-bin/os000003.pl?SEQUENCE=3&ACTION=Next%3e&ORDERNUMBER=

You might have to change os000003 to os000001 in this to make it work for you.

This is the receipt page and should record the actual orders placed

Regards

Are you using ssl or the java applet to take payment? We're using ssl here and I never see that page being accessed. The receipt page is simply cgi-bin/os000001.pl with the values sent as post data.

Has anyone successfully managed to get the goal set up in Google Analytics yet?

I've managed to get the full details including each product, shipping, vat etc into the e-commerce tracking form for GA but now I just want to be able to use it! lol

Kev

[brian.mc]

Are you using ssl or the java applet to take payment? We're using ssl here and I never see that page being accessed. The receipt page is simply cgi-bin/os000001.pl with the values sent as post data.

We use Actinic SSL. The URL I quoted in my original post was for the receipt page (with the actual order number tagged on the end). However, since then I have come across the following in Google Analytics Help which seems to address the problem:-


"The URLs for each step in my Defined Funnel Path are identical. How can I track each step as if it were a unique URL?

You may wish to track visitors' progress through a funnel which has the same URL for each step. For example, your sign up funnel might look like this:

Step 1 (Sign Up)
www.mysite.com/sign_up.cgi

Step 2 (Accept Agreement)
www.mysite.com/sign_up.cgi

Step 3 (Finish)
www.mysite.com/sign_up.cgi
To get around this, you can call the urchinTracker Javascript function within each step (probably within an onload event) as follows:

urchinTracker("/funnel_G1/step1.html")
urchinTracker("/funnel_G1/step2.html")
urchinTracker("/funnel_G1/step3.html")
Then, set up each step of your funnel as follows:

http://www.mysite.co.uk/funnel_G1/step1.html
http://www.mysite.co.uk/funnel_G1/step2.html
http://www.mysite.co.uk/funnel_G1/step3.html
Note that the path/filename argument to urchinTracker() need not represent an existing path or filename. The argument to urchinTracker simply provides a made-up page name to which Google Analytics can attach page views."

[Kev@Flexi.Net]

Ah, that could help a lot! Thanks.

Now the only problem is working out how to call the urchinTracker reliably on each stage!

Is the the urchinTracker() a seperate function to the standard tracking function? If so then this will make things much simpler! :-)

Kev

[PAULCOOKSON]

order total

hi,
i can pass the nqv order total from the receipt page but is there a nqv for the order total less shipping and tax?

i know this will have been answered already but i cant find the answer here or in the aug.

thanks.

[Bruce]

There is no NQV for the order total less tax and shipping. You can however pass the sub-total to teh affiliate...

open up Orderscript.pl and find the lines

@Response = ActinicOrder::FormatPrice($nTotal, $::FALSE,
$::g_pCatalogBlob);
if ($Response[0] != $::SUCCESS)
{
return (@Response);
}
$::s_VariableTable{$::VARPREFIX.'NUMERICORDERTOTALCGI'} =
ACTINIC::EncodeText2($Response[2]);

Then modify its first line to

@Response = ActinicOrder::FormatPrice($nSubTotal, $::FALSE,
$::g_pCatalogBlob);

Save the file and upload.

Actinic is not able to provide any detailed support for script changes made. If you find that there is a problem, an original copy of the script can be found within the 'Original' folder in your installation. Copy this into your site folder.

Kind regards,

[BPJSURF]

I have been reading through the countless forums on Google adword tracking, google analytics reporting and it seems like there is a mass confusion on how the tracking works and how to properly implement the tracking.

We have some expereince with the Urchin reporting tools which is teh technology behind googles new free reporting. An we have the urchin ecommerce reportings working with Actinic version 6 and version 7 sites using Urchin UTM and Urchin advanced ecommerce reporting. Our tool is actually integrated into the Actinic cart and tracks all aspects of sales and conversion.

I have not had time as of yet to get a close look to see if our advanced ecommerce reporting tool will port directly to the new free google service but I am curios to see if we can make it work. I registered for google reporting tool but I have not received the invite so I have no vehicle to properly test our tools in Google analylicts.

If you are in possession of an google reporting account and are willing to work through some testing please contact me and I will see if we can quickly port our advanced Urchin ecommerce reporting tool into a simple installer for Actinic ecommerce. If it works I will give the receipiant the tools no charge.

thanks for your consideration

Brian Johnson

[BPJSURF]

Update for those who are interested.

Thank you for the assistance, for those of you who contacted me to assist in the testing of the Google analytics.

We have several open accounts and we are now working through the implementation of a new plug-in for Google analytics.

Unfortunatly our existing Urchin(now owned by Google) version 5 ecommerce reporting module will not just plugin as we had hoped. However we are in the process of building out a sample template, server side include and installation documentation so that Google analytics with ecommerce reporting can be installed and utilized by any Actinic ecommerce merchant.

I suspect we will need two weeks of testing and a week to vet the code and install. Once we have a working tool I will post an update again for those who are interested.

More details on functionality.
The ecommerce report will track both paid ad campaigns and organic search results which yeild sales. This means you will know which pages on your actinic site yeild results (in $$$$$ or pounds).
You can track specific ad campaigns and track 3rd party paid search results
(citysearch, Overture, Yahoo! shopping , shopping.com)

The ecommerce reporting tool will caputure information about products categories, buyer information (location) and site revenue.

Ecommerce reporting can be used in place of or concurrently with Googles Adword tracking.

Some technical issues to consider:
Thr Google analytics ecommerce tracking requires the addition of a Javascript and some log file tagging in the receipt page. This will slow the page down. If your using Overture tracking, Google adword tracking and the ecommerce reporting, there may be a performance issue to the browser with speed of the page. Be aware of this possiability.

The ecommerce tools will track the pages in checkout. You may have some orders which could be canceled, reversed or bogus but these orders will display in your ecommerce revenue summary and transaction reports.

Thanks again for the high level of interest, I expect we will have a plugin available shortly. If you have question please post here rather then write me directly so that all using the forum get the benefit of the questions and answers.

Brian

[Duncan Rounding]

Has anyone implemented this for the 4 order pages?

Has anyone implemeted this in GA funnels and got it working?

Duncan

We use Actinic SSL. The URL I quoted in my original post was for the receipt page (with the actual order number tagged on the end). However, since then I have come across the following in Google Analytics Help which seems to address the problem:-


"The URLs for each step in my Defined Funnel Path are identical. How can I track each step as if it were a unique URL?

You may wish to track visitors' progress through a funnel which has the same URL for each step. For example, your sign up funnel might look like this:

Step 1 (Sign Up)
www.mysite.com/sign_up.cgi

Step 2 (Accept Agreement)
www.mysite.com/sign_up.cgi

Step 3 (Finish)
www.mysite.com/sign_up.cgi
To get around this, you can call the urchinTracker Javascript function within each step (probably within an onload event) as follows:

urchinTracker("/funnel_G1/step1.html")
urchinTracker("/funnel_G1/step2.html")
urchinTracker("/funnel_G1/step3.html")
Then, set up each step of your funnel as follows:

http://www.mysite.co.uk/funnel_G1/step1.html
http://www.mysite.co.uk/funnel_G1/step2.html
http://www.mysite.co.uk/funnel_G1/step3.html
Note that the path/filename argument to urchinTracker() need not represent an existing path or filename. The argument to urchinTracker simply provides a made-up page name to which Google Analytics can attach page views."

[Big Game Hunter]

Analytics Works

Hi Duncan

We have manged to get it working using the normal google code. The goals work as the funnel. The e commerce side still doesn't work however. Here's our oder04.html code to see what we did:

<!-- Receipt HTML begin -->

<FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:ERROR</FONT>

NETQUOTEVAR:REFPAGE
<body onLoad="javascript:__utmSetTrans()">
 
<form style="display:none;" name="utmform">
<textarea id="utmtrans">UTM:T|NETQUOTEVAR:THEORDERNUMBER| WEB | NETQUOTEVAR:ACTINICORDERTOTAL/100 | 0.00 | 0.00 | NETQUOTEVAR:INVOICEADDRESS3 |
NETQUOTEVAR:INVOICEADDRESS4 | UK UTM:I | NETQUOTEVAR:THEORDERNUMBER | PRODUCT | NAME | SECTIONNAME | 0.00 | 1 </textarea>
</form>

<TABLE BORDER="0" CELLPADDING="10" CELLSPACING="0" WIDTH="600">
<TR><TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM">
<B><FONT FACE="ARIAL" SIZE="3">NETQUOTEVAR:YOURRECEIPT</FONT></B>
</TD></TR>
<TR><TD>

<P>
<FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:PRINTTHISPAGE
NETQUOTEVAR:NEEDTOCONTACT  NETQUOTEVAR:SENDSEPARATELY
<P>
NETQUOTEVAR:DOWNLOADINSTRUCTION
</FONT>
<BR>
<TABLE BORDER=0 ALIGN=RIGHT CELLPADDING=3>
	<TR>
		<TD VALIGN="TOP"><FONT FACE="ARIAL" SIZE="2">
			NETQUOTEVAR:COMPANYCONTACTNAME
			NETQUOTEVAR:COMPANYCONTACTTITLE
			NETQUOTEVAR:COMPANYNAME
			NETQUOTEVAR:COMPANYSTREETADDRESS1
			NETQUOTEVAR:COMPANYSTREETADDRESS2
			NETQUOTEVAR:COMPANYSTREETADDRESS3
			NETQUOTEVAR:COMPANYSTREETADDRESS4
			NETQUOTEVAR:COMPANYPOSTCODE
			NETQUOTEVAR:COMPANYCOUNTRY
		</FONT></TD>
		<TD VALIGN="TOP"><FONT FACE="ARIAL" SIZE="2">
			NETQUOTEVAR:COMPANYPHONE
			NETQUOTEVAR:COMPANYFAX
			NETQUOTEVAR:COMPANYEMAIL
			NETQUOTEVAR:COMPANYURL
		</FONT></TD>
	</TR>
</TABLE>
<BR CLEAR=ALL><BR>

<TABLE BORDER="0" CELLPADDING="3" CELLSPACING="2" WIDTH="570">
  <TR>
    <TH BGCOLOR="NETQUOTEVAR:CHECKOUTEM" WIDTH="50%"><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:INVOICETO</FONT></TH>
    <TH BGCOLOR="NETQUOTEVAR:CHECKOUTEM" WIDTH="50%"><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:DELIVERTO</FONT></TH>
  </TR>
  <TR>
    <TD VALIGN="TOP" BGCOLOR="NETQUOTEVAR:CHECKOUTBG">
	  <TABLE BORDER="0" WIDTH="100%" CELLPADDING="0" CELLSPACING="3">
		<TR>
		  <TD VALIGN="TOP"><FONT FACE="ARIAL" SIZE="2">
			NETQUOTEVAR:INVOICENAME
			NETQUOTEVAR:INVOICEJOBTITLE
			NETQUOTEVAR:INVOICECOMPANY
			NETQUOTEVAR:INVOICEADDRESS1
			NETQUOTEVAR:INVOICEADDRESS2
			NETQUOTEVAR:INVOICEADDRESS3
			NETQUOTEVAR:INVOICEADDRESS4
			NETQUOTEVAR:INVOICEPOSTCODE
			NETQUOTEVAR:INVOICECOUNTRY
			NETQUOTEVAR:INVOICEPHONE
			NETQUOTEVAR:INVOICEFAX
			NETQUOTEVAR:INVOICEEMAIL
			NETQUOTEVAR:INVOICEUSERDEFINED
			</FONT></TD>
		</TR>
	  </TABLE>
	</TD>
    <TD VALIGN="TOP" BGCOLOR="NETQUOTEVAR:CHECKOUTBG">
	  <TABLE BORDER="0" WIDTH="100%" CELLPADDING="0" CELLSPACING="3">
		<TR>
		  <TD VALIGN="TOP"><FONT FACE="ARIAL" SIZE="2">
			NETQUOTEVAR:DELIVERYNAME
			NETQUOTEVAR:DELIVERYJOBTITLE
			NETQUOTEVAR:DELIVERYCOMPANY
			NETQUOTEVAR:DELIVERYADDRESS1
			NETQUOTEVAR:DELIVERYADDRESS2
			NETQUOTEVAR:DELIVERYADDRESS3
			NETQUOTEVAR:DELIVERYADDRESS4
			NETQUOTEVAR:DELIVERYPOSTCODE
			NETQUOTEVAR:DELIVERYCOUNTRY
			NETQUOTEVAR:DELIVERYPHONE
			NETQUOTEVAR:DELIVERYFAX
			NETQUOTEVAR:DELIVERYEMAIL
			NETQUOTEVAR:DELIVERYUSERDEFINED
		  </FONT></TD>
		</TR>
	  </TABLE>
	</TD>
  </TR>
NETQUOTEDEL:MOVINGSTATUS
  <TR>
    <TD COLSPAN="2" BGCOLOR="NETQUOTEVAR:CHECKOUTBG"><FONT FACE="ARIAL" SIZE="2"><B>NETQUOTEVAR:MOVINGNEXTMONTH</B> NETQUOTEVAR:MOVING</FONT></TD>
  </TR>
NETQUOTEDEL:MOVINGSTATUS
</TABLE>
<BR>
<TABLE BORDER="0" CELLPADDING="3" CELLSPACING="2" WIDTH="570">
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:DATETEXT</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" COLSPAN=2><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:CURRENTDATE</FONT></TD>
  </TR>
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:ORDERNUMBERTEXT</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" COLSPAN=2><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:THEORDERNUMBER</FONT></TD>
  </TR>
NETQUOTEDEL:DELIVERYINSTRUCTION
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:DELIVERYINSTRUCTION_LABEL</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" COLSPAN=2><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:DELIVERYINSTRUCTION_TEXT</FONT></TD>
  </TR>
NETQUOTEDEL:DELIVERYINSTRUCTION

NETQUOTEDEL:PAYMENTPANEL
  NETQUOTEDEL:PAYMENTSENTSEPARATE
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:PAYMENTMETHODTITLE:</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" COLSPAN=2><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:PAYMENTMETHODNAME</FONT></TD>
  </TR>
  NETQUOTEVAR:PURCHASEORDERNUMBER
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:CREDITCARDTYPETITLE:</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG"><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:CREDITCARDOPTIONS</FONT></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG"><FONT FACE="ARIAL" SIZE="2">&lt;&lt;&lt; NETQUOTEVAR:SELECTONE</FONT></TD>
  </TR>
  <TR>
	<TD NOWRAP BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:CREDITCARDNUMBERTITLE:</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" NOWRAP COLSPAN=2 VALIGN=BOTTOM><BR><FONT FACE="ARIAL" SIZE="2">______________________________________</FONT></TD>
  </TR>
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:CREDITCARDISSUENUMBERTITLE:</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" COLSPAN=2><FONT FACE="ARIAL" SIZE="2"><BR>_________</FONT></TD>
  </TR>
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:CREDITCARDCCV2TITLE</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" COLSPAN=2><FONT FACE="ARIAL" SIZE="2"><BR>_________</FONT></TD>
  </TR>
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:CREDITCARDSTARTDATETITLE:</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" COLSPAN=2><FONT FACE="ARIAL" SIZE="2"><BR>____________</FONT></TD>
  </TR>
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:CREDITCARDEXPDATETITLE:</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" COLSPAN=2><FONT FACE="ARIAL" SIZE="2"><BR>____________</FONT></TD>
  </TR>
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:SIGNATURETITLE:</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" NOWRAP COLSPAN=2 VALIGN=BOTTOM><BR><FONT FACE="ARIAL" SIZE="2">X______________________________________</FONT></TD>
  </TR>
  NETQUOTEDEL:PAYMENTSENTSEPARATE
  NETQUOTEDEL:PAYMENTOTHER
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:PAYMENTMETHODTITLE:</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" COLSPAN=2><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:PAYMENTMETHODNAME</FONT></TD>
  </TR>
  NETQUOTEVAR:PURCHASEORDERNUMBER
  NETQUOTEDEL:PAYMENTCREDITCARD
  <TR>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTEM"><B><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:CREDITCARDTITLE:</FONT></B></TD>
	<TD BGCOLOR="NETQUOTEVAR:CHECKOUTBG" COLSPAN=2><FONT FACE="ARIAL" SIZE="2">NETQUOTEVAR:CREDITCARDTYPE</FONT></TD>
  </TR>
  NETQUOTEDEL:PAYMENTCREDITCARD
  NETQUOTEDEL:PAYMENTOTHER
NETQUOTEDEL:PAYMENTPANEL

</TABLE>
</LEFT>
<BR>

NETQUOTEVAR:THEORDERDETAILS
<IMG SRC="http://www.gardengames.co.uk/cgi-bin/affiliate/clickme2.cgi?amount=NETQUOTEVAR:FORMATTEDORDERTOTALCGI&id=NETQUOTEVAR:THEORDERNUMBER&enc=ENCPASS" height=1 width=1 border=0>
</TR></TD>
</TABLE>
<P>
<DIV ALIGN="CENTER">
	<INPUT TYPE=HIDDEN NAME=HOME VALUE="NETQUOTEVAR:HOME">
    <input type=SUBMIT name=ACTION value="NETQUOTEVAR:DONEBUTTON">  
<BR>
<BR>
<FONT FACE=ARIAL SIZE=1><Actinic:EXTRAFOOTERTEXT/></FONT>
</DIV>
<!-- Receipt HTML end -->

If you need to look at any other templates just let me know...

Cheers
Shannon

[Duncan Rounding]

Thanks, but which is the bit relating to Google Analytics?

[Big Game Hunter]

Thats What's Intresting..

That's the intresting part Duncan. We only put the tracking on Act Primary..

The tracking script was doubling in the check out area, that was the only code we used in the order templates. Act Primary uses the normal tracking script & thats the Act order 04 script...


You then set up the 4 goals in the separate goal sections. Then on goal 4 set up the 4 steps again in the cloumns so the dfined funnel will work. That's how we got ours working & so far it's accurate...

Oh yes one big thing to note here: In each Goal setting there is a box asking for a goal value. We used 1, but you can put whatever your value needs to be, just make sure it's not 0.

[Big Game Hunter]

Sorry, to answre your actual question. It was this piece of the code which is google code:

<form style="display:none;" name="utmform">
<textarea id="utmtrans">UTM:T|NETQUOTEVAR:THEORDERNUMBER| WEB | NETQUOTEVAR:ACTINICORDERTOTAL/100 | 0.00 | 0.00 | NETQUOTEVAR:INVOICEADDRESS3 |
NETQUOTEVAR:INVOICEADDRESS4 | UK UTM:I | NETQUOTEVAR:THEORDERNUMBER | PRODUCT | NAME | SECTIONNAME | 0.00 | 1 </textarea>
</form>

[Duncan Rounding]

So to make sure I understand fully...

You placed your normal Google urchin tracking code in Act_Primary and also added this code into order04.html:

<body onLoad="javascript:__utmSetTrans()">
 
<form style="display:none;" name="utmform">
<textarea id="utmtrans">UTM:T|NETQUOTEVAR:THEORDERNUMBER| WEB | NETQUOTEVAR:ACTINICORDERTOTAL/100 | 0.00 | 0.00 | NETQUOTEVAR:INVOICEADDRESS3 |
NETQUOTEVAR:INVOICEADDRESS4 | UK UTM:I | NETQUOTEVAR:THEORDERNUMBER | PRODUCT | NAME | SECTIONNAME | 0.00 | 1 </textarea>
</form>

Then what exactly did you set up in GA as your funnels and goal URLs?

Duncan

[Big Game Hunter]

That's it...

Now with the Goal process. You step up each major step of your checkout section as a Goal. For instance we used the first goal to track the Address Page. 2nd - Payment Details Page. 3rd - Secure Server. 4th. Reciept Page.

We used standard URL's in the goals such as this http://www.gardengames.co.uk/cgi-bin/ca000001.pl in each step. Obviously the last piece of that url thread changes as you going through your checkout, you set it up as such.

Now on Goal 4, if you looking to get your funnel working, you set up the steps within Goal the same way you set up the goals. ( hope that makes sense)

This then gives you shopping cart abondonment...

Does that make any sense... Still get used to trying to explain things on this forum. Hope it helps though..

[Duncan Rounding]

I think it makes sense - sorry to keep bouncing back.

In my case I have the following that I want to track for abandonment:
shopping cart ......./ca000001.pl
order 1................./os000001.pl?ACTION=Start (not tested this)
order 2................./os000001.pl
order 3................./os000001.pl
order 4................./ - as you described above

How can I differentiate between the three order pages? (or two if ?ACTION=Start works) They all appear as the same URL for me.

(A dropout between step three and receipt is the most important to me - ie payment)