Importing Google Analytics into Excel – Text to Columns Function!

Importing Google Analytics data into Excel seems to be, for me at least, a chore but the Text to Columns function in the Data tab makes it easy. Import the data, in this example Content data, as a CSV file into Excel, open it and arrrgh, unholy mess which seems unusable.  

an-unholy-excel-messAn unholy excel mess…

But, select the Content data (which is all stuffed into one column) and then click on Text to Columns in the Data tab.  After checking ‘Delimited’, check other ‘.’ and comma.

excel-text-to-columns

This will hopefully make some more sense of your data, and spread it out into separate columns. You’ll probably have to sort out some of the data manually, but it will certainly be faster than copy and pasting the data direct from GA. I probably should get out more.

Campaign Tracking with Google Analytics – Banner Ads

The university recently ran an ‘open house’ campaign, where we opened the doors of the university for potential students to have a look around and, hopefully, choose to come and study with us.

We used, among other things, banner adverts to reach out to the students on a bunch of different websites. There were two vendors, one sold us space on a newspaper site and the other sold us space on about a 100 sites focused on our target group (people aged 17-25).

This was the first time this university had tried this, so to measure the success we used the campaign tracking functionality in Google Analytics. This meant using the Google URL builder to add the appropriate tags to the landing page URL. So here’s the first tip – check with your advertising vendor that your URL will not be broken by whatever tracking software they are using.

The results were striking, they showed that the newspaper site (which cost by far the most) sent us the least traffic while the youth focused sites drove over a 1000 new visitors (which, you may say, sounds a little low – but it’s a start). So far, so what, as this kind of information is what we’d usually get from the vendor. However, we can do a few extra things, which we could not have done otherwise:

  • Judge how well the landing page performed for these visitors
  • Track the conversions of these visitors against goals of the website e.g. enrolment, pdf downloads, enquiries
  • Gather additional data, such as geographical location of the visitors and whether they were new to the site

This is all good stuff, as it puts another piece in the puzzle of where our website fits in with all the other marketing stuff we’re doing…

Google Analytics Online Course from Google

Google launched an online course for Google Analytics yesterday, definitely something which is needed and it could be really useful, for example, for bringing your organisations competency up to a basic, shared level. The conversion university support for this looks like a real good primer. 75% pass mark required and 50 dollars to take it; watch this space…