Posted on

Zeald does NOT support GA ecommerce tracking

Dear Zeald,

you call yourself an ecommerce website builder – but you do not support the native ecommerce tracking features of Google Analytics – certainly the most popular web analytics package available in 2013.

This is an open letter to Zeald to try to convince you to consider supporting this feature, by default, for no extra charge for your existing customers. If you did support it, the thanks page for a conversion mite include calls to _addTrans, _addItem and _trackTrans, and would allow your clients to see the last traffic source before a conversion – whether it be from any source, Bing, Facebook, Yellow etc, not just Google Adwords. Not only that, but they would be able to see a plethora of multi-dimensional reports that could show average order value, top products, and feed the conversion value easily back into Adwords to enable true ROI calculations to be made for all traffic sources.

Once you have got this working – I’ll convert this blog post into a thank you message.

Yet I see no mention of support in your help files, only this one which is about a different tracking method that only works for Adwords:

Adwords Conversion Tracking != Google Analytics Ecommerce Tracking.

To help you get going, below is an example of what the tracking scripts look like:

<html><head><title>Receipt for your clothing purchase from Acme Clothing</title><scripttype="text/javascript">

  var _gaq = _gaq ||[];
    '1234',           // transaction ID - required
    'Acme Clothing',  // affiliation or store name
    '11.99',          // total - required
    '1.29',           // tax
    '5',              // shipping
    'San Jose',       // city
    'California',     // state or province
    'USA'             // country

   // add item might be called for every item in the shopping cart
   // where your ecommerce engine loops through each item in the cart and
   // prints out _addItem for each
    '1234',           // transaction ID - required
    'DD44',           // SKU/code - required
    'T-Shirt',        // product name
    'Green Medium',   // category or variation
    '11.99',          // unit price - required
    '1'               // quantity - required
  _gaq.push(['_trackTrans']);//submits transaction to the Analytics servers

    var ga = document.createElement('script'); ga.type ='text/javascript'; ga.async =true;
    ga.src =('https:'== document.location.protocol ?'https://ssl':'http://www')+'';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);

  Thank you for your order.  You will receive an email containing all your order details.

Posted on

Bidding by ROI Percentage in Adwords

UPDATE: on August 8 this year I posted this initial blog post, now I see Google is announcing the feature! Cool –

Feature request: Dear Google, I would love to be able to bid by target ROI percentage in Adwords. The idea would be to set a target at the campaign level using a percentage ROI you would like. I have a client who doesn’t want to run ads at less than 500% ROI, and this is something I am getting done using Google Analytics, but it is kinda tricky as I need to switch between GA and AW, boosting ad groups with high ROI, and pulling back on ad groups with poor ROI, working to increase the overall campaign ROI in order to acquire an increase in budget, and turn AW into a money printing machine.

ROI = return on investment.

ROAS = return on ad spend.


Thanks, Tom.

Posted on

Top 60 Australian Tourist Destinations

I just did a bunch of search phrase research into the subject of Coach Tours and other tourism tour related search queries while building up an Adwords campaign for Tour Sale Finder Australia, with a view to creating adgroups around each theme.

And here they are, sorted alphabetically:

Alice Springs
Alice Springs To Ayers Rock
Atherton Tableland
Australian Capital Territory
Ayers Rock
Blue Mountains
Broome To Darwin
Bungle Bungle
Byron Bay
Cape Tribulation
Cape York
Cradle Mountain
Darwin To Broome
Darwin To Perth
East Coast Australia
El Questro
Flinders Ranges
Fraser Island
Gold Coast
Great Barrier Reef
Great Ocean Road
Hunter Valley
Kakadu National Park
Kangaroo Island
Kata Tjuta
Katherine Gorge
Kings Canyon
Moreton Island
New South Wales
Northern Territory
Perth To Broome
Pinnacles Desert
Port Arthur
Port Douglas
Red Centre
South Australia
Surfers Paradise
Sydney To Melbourne
Western Australia

Posted on

Using Formulas For Find & Replace in Excel

Now this is what I call a spreadsheet!

Here you can see an 8,000 row spreadsheet in Excel 2007 which is being used to prepare a bulk upload into Google Adwords editor, for use in the Adwords campaign for Fetch RV Rental Spain, one of my companies many motorhome hire websites.

It’s here mostly because of the cool “trace dependants” arrows in blue, many they look trippy. But the other reason I am posting this, is to provide some help and guidance for other search marketers out there on some tips and tricks for doing really large campaign rollouts in AW editor.

Those tips are underneath, here is the screenshot:

Trace Dependants in action
Trace Dependants in action

Adgroup names
These have been made using the following function: =CONCATENATE(D$1, ” – “, B8106)
What this does, is generate brand new adgroup names according to what’s in constant cell D$1 (“Bilbao”) and attached onto the end of this whatever is in the B column which shuffles through the various campaign geotargetting settings. You can see “UK/IE Targets” here, but further down this changes to “EU Target” later on down the sheet.

Instead of using the GUI part of Excel like a normal person (you know – Find and replace), I’ve used the dynamic version of the same: The substitute function. This one looks like this: =SUBSTITUTE(K13, $G$2, $D$2). So it takes cell k13 (“barcelona camper hire”), then looks for G2 (“barcelona”) and swaps it for D2 (“bilbao”). Very tidy.

Ad Creative – Titles and Descriptions
Again the substitute function is deployed: =SUBSTITUTE(S7, $G$1, $D$1)
Same story here, we are taking a line from the existing creative, search and replacing it so a creative like this:

Hunt Down The Best Barcelona Camper
Rental Deals. Book Online and Save

is automatically turned into this:

Hunt Down The Best Bilbao Camper
Rental Deals. Book Online and Save

This works pretty well but can cause problems if you reach the 25 or 35 character limits.

Ad Creative – Display URL and Destination URL
These work in the same way as the other replacements, but I have nested a further layer of substitutes, to remove the space and convert that into an underscore.
Display URL: =SUBSTITUTE(CONCATENATE(Y7, “/”, $D$1), ” “, “_”)
Destination URL: = SUBSTITUTE(SUBSTITUTE(AA7, $G$2, $D$2), ” “, “_”)

The Display URL uses a concatenate to simple join the placename to the end, but also to put a / slash in between. The destination url uses two substitutes, one to swap out the keyword for one which could have a space in it, and then another set to replace the space with an underscore.

Posted on

Linking multiple Analytics accounts to Adwords

Some handy info here from the GAAC* Program Google Group.

The question was posed that while it is true that you can link several adwords accounts to one anaytics account by having these accounts pull in the “cost data” from many Adwords accounts, people were wondering whether it is possible to link several analytics accounts to one adwords account?

The answer provided was that the “linking” that adds the AW cost source to GA and lets you see GA data from within the AW interface, works in certain regards on a 1-1 basis only.

Adding cost sources, though, can be done from multiple AW accounts to multiple GA accounts, all you need is a skillful Google account manager to do that for you. After this has been done, you can, as you probably already know, go in every profile of every GA account you have added a cost source
to and apply/unapply it. This type of setup can be seen below with a live screenshot of an Analytics account with 2 cost sources attached but only one of them “applied” with the tick:

Apply Cost Data GA
Apply Cost Data GA

One important thing to bear in mind though: Only the first (primary) adwords account you link will enable you to pull analytics goals to adwords. The others will be secondary cost sources. This primarily linked GA account would be the one that appears when you click the GA tab in Adwords:

Google Analytics tab in Adwords
Google Analytics tab in Adwords

In some cases it is crucial “who to link first” i.e. first linkage you do manually and second via account manager – just make sure the first linked account is the main GA+AdWords activity in order to best integrate.

*GAAC stands for Google Adwords Certified Professional.