Announcement

Collapse
No announcement yet.

Google Analytics Conversion Code Problem

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Google Analytics Conversion Code Problem

    I've got Google Analytics working all through my site but the ecom conversion is currently a problem.
    I need to somehow divide the NETQUOTEVAR:ACTINICORDERTOTAL variable by 100 as Analytics thinks "pence are pounds" and my data is 100 fold out of whack?!?

    Also does anyone know what the NETQUOTEVARs are that the below refer to? and do we actually need to use them?

    [sku/code]
    [productname]
    [category]
    [price]
    [quantity]
    [tax]
    [shipping]
    [city]
    [state]
    [country]
    [affiliation]

    #2
    Google Code

    That is quite a trick, i have the same question open & i have found this thread helpful so far..

    http://community.actinic.com/showthr...ogle+analytics
    Shannon
    Big Game Hunters
    Trampoline Specialists - Etoyszone Trampolines
    Trampolines and Outdoor Toys - Garden Games
    Table Tennis Table - Table Tennis Specialist Shop
    Trampoline Brand Information - Trampolines 4 Sale
    Climbing Frames - Wooden Climbing Frames
    Trampoline Specialist Blog
    Table Tennis Blog

    Comment


      #3
      arrrrrrgh!

      I've tried everything that i can think of...

      Here is how i've laid the conversion code out....

      -------------------------------------------------------

      <script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
      </script>
      <script type="text/javascript">
      _uacct = "UA-188152-1";
      urchinTracker();
      </script>

      <body onLoad="javascript:__utmSetTrans()">

      <form style="display:none;" name="utmform">
      <textarea id="utmtrans">
      UTM:T|[NETQUOTEVAR:THEORDERNUMBER]|[affiliation]|[NETQUOTEVAR:ACTINICORDERTOTAL]|[tax]|[shipping]|[city]|[state]|[country]
      UTM:I|[NETQUOTEVAR:THEORDERNUMBER]|[sku/code]|[productname]|[category]|[price]|[quantity]
      </textarea>
      </form>

      --------------------------------------------------------------

      From previous experience with tracking code i've tried altering the variable like below and tested each.

      [NETQUOTEVAR:ACTINICORDERTOTAL/100]
      [NETQUOTEVAR:ACTINICORDERTOTAL / 100]
      ['NETQUOTEVAR:ACTINICORDERTOTAL/100']
      ['NETQUOTEVAR:ACTINICORDERTOTAL / 100']

      But it's not working, this time!!!

      Can anyone help before i head-butt my computer
      Last edited by mungholio; 30-Nov-2005, 09:14 AM. Reason: spelling

      Comment


        #4
        You could try |[NETQUOTEVAR:ACTINICORDERTOTAL]/100|
        Bill
        www.egyptianwonders.co.uk
        Text directoryWorldwide Actinic(TM) shops
        BC Ness Solutions Support services, custom software
        Registered Microsoft™ Partner (ISV)
        VoIP UK: 0131 208 0605
        Located: Alexandria, EGYPT

        Comment


          #5
          This is how conversion tracking is dealt with by Actinic...

          It is possible to add markup to the Actinic's receipt page in order to support an affiliate program. The markup is generally specified by the affiliate program, but a typical example would be:
          <IMG SRC="https://www.server.com/log.cgi?amount=[order-amount-here]&orderid=[order-id-here]">
          Translating this into a Actinic ready line, you would get:
          <IMG SRC="https://www.server.com/log.cgi?amount=NETQUOTEVAR:MYORDERTOTAL&orderid=NETQUOTEVAR:THEORDERNUMBER">
          The NETQUOTEVARs available to an affiliate program of this nature are:
          NETQUOTEVAR:THEORDERNUMBER - order number (already existed in earlier versions)
          NETQUOTEVAR:FORMATTEDORDERTOTALHTML - the order total formatted in the appropriate currency and encoded for HTML display
          NETQUOTEVAR:FORMATTEDORDERTOTALCGI - the order total formatted in the appropriate currency and encoded for CGI
          NETQUOTEVAR:ACTINICORDERTOTAL - the order total formatted in the Actinic internal format (integer number in currency base unit)
          NETQUOTEVAR:NUMERICORDERTOTALCGI - the order total partially formatted in the appropriate currency and encoded for CGI. This value include decimal and thousand separators, but leaves off the currency symbol.
          To use these values insert the appropriate variables into Act_Order04.html and upload. Example markup follows:
          Total: NETQUOTEVAR:FORMATTEDORDERTOTALHTML
          <IMG SRC="https://www.server.com/log.cgi?amount=NETQUOTEVAR:ACTINICORDERTOTAL&orderid=NETQUOTEVAR:THEORDERNUMBER">
          <IMG SRC="https://www.server.com/log.cgi?amount=NETQUOTEVAR:FORMATTEDORDERTOTALCGI&orderid=NETQUOTEVAR:THEORDERNUMBER">
          <IMG SRC="https://www.server.com/log.cgi?amount=NETQUOTEVAR:NUMERICORDERTOTALCGI&orderid=NETQUOTEVAR:THEORDERNUMBER">
          This markup will be expanded in the receipt page. For example:
          Total: &#163;481&#46;96
          <IMG SRC="https://www.server.com/log.cgi?amount=48196&orderid=GM03GNBW900028">
          <IMG SRC="https://www.server.com/log.cgi?amount=%a3481%2e96&orderid=GM03GNBW900028">
          <IMG SRC="https://www.server.com/log.cgi?amount=481&#46;96&orderid=GM03GNBW900028">

          Hope this helps,
          Bruce King
          SellerDeck

          Comment


            #6
            You need to do that division in JavaScript. Here's my (untested) idea:
            Code:
            <form style="display:none;" name="utmform">
            <textarea id="utmtrans"></textarea>
            </form>
            <script language="JavaScript" type="text/javascript">
            <!--
             var realprice = NETQUOTEVAR:ACTINICORDERTOTAL / 100;
             var line1 = 'UTM:T|[NETQUOTEVAR:THEORDERNUMBER]|[affiliation]|' + realprice + '|[tax]|[shipping]|[city]|[state]|[country]'; 
             var line2 = 'UTM:I|[NETQUOTEVAR:THEORDERNUMBER]|[sku/code]|[productname]|[category]|[price]|[quantity]';
             document.getElementById('utmtrans').value = line1 + '\n' + line2;
            //-->
            </script>
            Note that the above will fail if you have any single quote ( ' ) characters in your variables. Another way that mey be better is (again untested)
            Code:
            <form style="display:none;" name="utmform">
            <textarea id="utmtrans">UTM:T|[NETQUOTEVAR:THEORDERNUMBER]|[affiliation]|###VALUE###|[tax]|[shipping]|[city]|[state]|[country]
            UTM:I|[NETQUOTEVAR:THEORDERNUMBER]|[sku/code]|[productname]|[category]|[price]|[quantity]
            </textarea>
            </form>
            <script language="JavaScript" type="text/javascript">
            <!--
             var realprice = NETQUOTEVAR:ACTINICORDERTOTAL / 100;
             document.getElementById('utmtrans').value = document.getElementById('utmtrans').value.replace(/###VALUE###/gm, realprice);
            //-->
            </script>
            Norman - www.drillpine.biz
            Edinburgh, U K / Bitez, Turkey

            Comment


              #7
              You are the King Norman!

              I've tested your first code snippet and it seems to work - the result comes through / 100!!!!

              Analytics will take a day or 2 to pull the ecom info accross but it should be fine.

              Cheers

              Comment


                #8
                Still being funny !?!

                The correct information is pulled through into the text field on the receipt page, but after doing several test tranactions online and then waiting for Analytics to update, no transactions have appeared in the online Ecommerce Summary.

                It could be either the modified code (from norman) or Analytics itself playing up, (which i hear isn't out of the realms of impossibility). Any Ideas???

                Also; does anyone know what the relevant NETQUOTEVARs are for the below

                Transaction line variables:
                [order-id] Your internal unique order id number
                [affiliation] Optional partner or store affilation
                [total] Total dollar amount of the transaction
                [tax] Tax amount of the transaction
                [shipping] The shipping amount of the transaction
                [city] City to correlate the transaction with
                [state/region] State or province
                [country] Country

                Item line variables:
                [order-id] Your internal unique order id number (should be same as transaction line)
                [sku/code] Product SKU code
                [product name] Product name or description
                [category] Category of the product or variation
                [price] Unit-price of the product
                [quantity] Quantity ordered

                So far i've got:

                NETQUOTEVAR:THEORDERNUMBER = order-id
                NETQUOTEVAR:ACTINICORDERTOTAL = total

                Comment


                  #9
                  Hi,

                  NETQUOTEVAR:THEORDERNUMBER = order-id
                  NETQUOTEVAR:ACTINICORDERTOTAL = total
                  No Variable = affiliation
                  NETQUOTEVAR:TAX1 = tax
                  NETQUOTEVAR:SHIPPING = Shipping
                  NETQUOTEVAR:INVOICEADDRESS3 = City
                  NETQUOTEVAR:INVOICEADDRESS4 = State/Region
                  NETQUOTEVAR:INVOICECOUNTRY = Country
                  NETQUOTEVAR:PRODUCTREFERENCE = Product SKU Code
                  NETQUOTEVAR:SECTIONNAME = Category
                  NETQUOTEVAR:COST = Unit Cost
                  NETQUOTEVAR:QUANTITY = Quantity

                  Please be aware that not all variables work in every template so some of the above will not work on the receipt page (such as product specific variables), which is where I assume you are trying to put them.
                  ********************
                  Tracey
                  SellerDeck

                  Comment


                    #10
                    Nearly...

                    Hi Tracey,

                    Thank you for the varibles...

                    These ones work:

                    NETQUOTEVAR:INVOICEADDRESS3 = City
                    NETQUOTEVAR:INVOICEADDRESS4 = State/Region
                    NETQUOTEVAR:INVOICECOUNTRY = Country

                    Theses ones don't:

                    NETQUOTEVAR:TAX1 = tax
                    NETQUOTEVAR:SHIPPING = Shipping
                    NETQUOTEVAR:PRODUCTREFERENCE = Product SKU Code
                    NETQUOTEVAR:SECTIONNAME = Category
                    NETQUOTEVAR:COST = Unit Cost
                    NETQUOTEVAR:QUANTITY = Quantity

                    Also you didn't provide one for: [product name] - is there one?

                    Here's what i've currently got nearly working (using Norman's code - above, and the varibles provided by Tracey)...

                    -------------------------------------

                    <body onLoad="javascript:__utmSetTrans()">

                    <form style="display:none;" name="utmform">
                    <textarea id="utmtrans"></textarea>
                    </form>
                    <script language="JavaScript" type="text/javascript">
                    <!--
                    var realprice = NETQUOTEVAR:ACTINICORDERTOTAL / 100;
                    var line1 = 'UTM:T|[NETQUOTEVAR:THEORDERNUMBER]|[affiliation]|' + realprice + '|[tax]| [shipping]|[NETQUOTEVAR:INVOICEADDRESS3]|[NETQUOTEVAR:INVOICEADDRESS4]|[NETQUOTEVAR:INVOICECOUNTRY]';
                    var line2 = 'UTM:I|[NETQUOTEVAR:THEORDERNUMBER]|[sku/code]|[productname]|[category]|[price]|[quantity]';
                    document.getElementById('utmtrans').value = line1 + '\n' + line2;
                    //-->
                    </script>

                    -----------------------------------------

                    Well... when i say nearly working, i mean that the correct information comes through to the receipt page but doesn't yet go through to Google???

                    Does anyone have any ideas?

                    Comment


                      #11
                      Hi,

                      Also you didn't provide one for: [product name] - is there one?
                      Sorry, missed that one - NETQUOTEVAR:PRODUCTNAME but I don't think this will work on the receipt page either.
                      ********************
                      Tracey
                      SellerDeck

                      Comment


                        #12
                        You were right, NETQUOTEVAR:PRODUCTNAME doesn't work.

                        Also, putting multiple products in the shopping cart doesn't create extra UTM:I lines.

                        Very Frustrating!

                        Comment


                          #13
                          google analytics

                          please help.

                          i have installed google analytics and still have the following problems:

                          no sales data appearing

                          I have installed the goal data and this is working correctly.

                          Does any body have the coding that needs to go into order template 4 that will activate the analytics?

                          cheers in advance.

                          Giles

                          Comment


                            #14
                            Me too

                            I've got it all working except the template 4 code:

                            This is as far as i've got...

                            -------------------------------

                            <body onLoad="javascript:__utmSetTrans()">

                            <form style="display:none;" name="utmform">
                            <textarea id="utmtrans"></textarea>
                            </form>
                            <script language="JavaScript" type="text/javascript">
                            <!--
                            var realprice = NETQUOTEVAR:ACTINICORDERTOTAL / 100;
                            var line1 = 'UTM:T|[NETQUOTEVAR:THEORDERNUMBER]|[affiliation]|' + realprice + '|[tax]| [shipping]|[NETQUOTEVAR:INVOICEADDRESS3]|[NETQUOTEVAR:INVOICEADDRESS4]|[NETQUOTEVAR:INVOICECOUNTRY]';
                            var line2 = 'UTM:I|[NETQUOTEVAR:THEORDERNUMBER]|[sku/code]|[productname]|[category]|[price]|[quantity]';
                            document.getElementById('utmtrans').value = line1 + '\n' + line2;
                            //-->
                            </script>

                            -----------

                            But there it still doesn't work?

                            Is there anyone from Actinic whos got this working - is there something that needs to be done differently with Actinic in Mind?

                            Comment


                              #15
                              Please have a read of this thread, http://community.actinic.com/showthread.php?t=17591 - check page 2

                              Kind regards,
                              Bruce King
                              SellerDeck

                              Comment

                              Working...
                              X