Using Google Analytics to track Social Media

02.17.10 Posted in Google Analytics, Social Media, Web Analytics by Barry

Not all traf­fic is equal, and the abil­ity to seg­ment and under­stand vis­i­tors helps us eval­u­ate web­sites even better.

Advanced seg­ments in Google Ana­lyt­ics is not new, and has been around since back in 2008, here’s a quick one sim­i­lar to a setup I’ve used to jusify ROI on Social Networks.

Advanced Seg­ments

Fire up Google Ana­lyt­ics and look for the Advanced Seg­ments on the left hand side.

Cre­ate a new seg­ment with the Source dimen­sion and the Reg­u­lar Expres­sion condition.

Here’s what I’m using but you can eas­ily add any social net­work you want into this pipe: twitter|technorati|wikipedia|stumbleupon|netvibes|bloglines|linkedin|facebook

Report­ing on this seg­ment allows you to analy­sis based on key met­rics like bounce rate and time on site (both sur­pris­ingly good)

Intel­li­gence

Report­ing is one thing, but how about an alert — sent to you. While not real time, and per­haps not as good as BLVD Sta­tus — Google Ana­lyt­ics does allow you to setup some trig­gers. Here’s how…

Reuse the same pipe from above

Here I’m using a really basic vis­i­tor trig­ger, but you can use any avail­able met­ric from Google Ana­lyt­ics, like rev­enue, bounce rates etc.

Google Ana­lyt­ics is extremely pop­u­lar, but shiny reports and graphs are no replace­ment for know­ing what data is actu­ally use­ful. Set­ting up a few sim­ple seg­ments is a good what to under­stand what makes vis­i­tors tick.

Do you have any good Google Ana­lytic tips? why not share them below.


Top Websites in Ireland — January 2010

02.15.10 Posted in Web Analytics, Websites by Barry

Google had updated their data on Irish web traf­fic for Jan­u­ary 2010, and just like the infor­ma­tion col­lected for Decem­ber 2009 — I’ve exported as much as pos­si­ble for shar­ing.

Top Irish Websites

(View all web­sites)

While I’ve said before that this does not fully con­clude what web­sites actual traf­fic is, it does offer an indi­ca­tion and when com­par­ing with Dec 2009 will show changes.

For exam­ple, Face​book​.com is still the high­est vis­ited web­site with iden­ti­cal num­bers to Decem­ber, apart from page views which has now grown from 1.4B to 1.9B — has face­book become more sticky? the rise of younger mem­bers with their love of Far­mville type appli­ca­tions would be a good indi­ca­tor of this happening.

I’ve been asked a few times on what exactly is use­ful about the data extracted from Google, per­son­ally I’ve been using it as part of com­peti­tor analy­sis, select­ing all web­sites in the indus­try I work in as a basis of under­stand­ing our place in the mar­ket. As a web only busi­ness — this is extremely impor­tant. I don’t reply solely on Google, but com­bine a num­ber of sources and assump­tions to deliver a more robust evaluation.

Has any­one dis­cov­ered some­thing or found a use for the Google traf­fic stats?


Website revenue increased by 5% with split testing

02.11.10 Posted in Ecommerce, Web Analytics by Barry

Inter­est­ing blog over on Get Elas­tic in their series of con­ver­sion opti­mi­sa­tion for the Offi­cial Van­cou­ver Olympics store.

They ran a sim­ple split test with 2 ver­sions with over 2000 trans­ac­tions in a 3 week period. Although they did not get a sig­nif­i­cant design win­ner, they did choose the above design as it achieved the following:

  • Vari­a­tion A con­verted (GWO) 3.14% bet­ter than con­trol variation
  • Vis­its with Vari­a­tion A resulted in 12.54% less Bounce Rate
  • Over­all site Con­ver­sion Rate was increased by 0.59%
  • Aver­age Order Value was increased by 5.16%

They also cal­cu­lated that rev­enue would increase by 5.78%. One of the great things about web ana­lyt­ics is that it can help remove the guess­work involved in web­site evo­lu­tion & can auto­mate test­ing which makes a real rev­enue improve­ment for ecom­merce web­sites.


How many twitter users are there in Ireland?

01.22.10 Posted in Social Media, Web Analytics by Barry

Sim­ple ques­tion, not so sim­ple answer.

I asked last night from twit­ter for some esti­mates and most replies were in the 40,000 – 50,000 mark.

My esti­mate is 150,000 and here’s why…

Fol­low­ing on from from my post on Irish web­site usage, I’ve drilled down a lit­tle fur­ther to see how accu­rate or not the Google Ad Plan­ner data is and to see if there’s any insight into how many users from Ire­land twit­ter has.

Damien Mul­ley found stats that Ire­land counts for 0.52% of total Twit­ter users, putting us 17th in the world. Although the report cal­cu­lated loca­tion with “pro­pri­etary tech­nol­ogy to infer geog­ra­phy based on user dis­closed infor­ma­tion which does not rely on Twitter’s geo-location API.” and may not be as use­ful as it appears, but it’s a good start­ing point and with the lack of any­thing else, let’s run with it.

The stats taken from Google Ad Plan­ner show 200k Unique Vis­i­tors (UV) from Ire­land in Decem­ber, which is 6.9% reach of total web users (2.9M) — generating a mam­moth 15M page views. Again from Ad Plan­ner, tak­ing the total twit​ter​.com unique vis­i­tors and Irish spe­cific traf­fic, we see around 0.27% of all twit​ter​.com traf­fic orig­i­nat­ing from Ireland.

Of that 200k UV, you could assume that the total num­ber of Irish twit­ter users to be as high as 400k because more than half of all users (55 per­cent) use a Twit­ter app, but I doubt if we’re look­ing at such a huge amount and the Ad Plan­ner data cov­ers the UV for the full month and I’d expect that users would use the web inter­face occa­sion­ally through­out a month.

So cal­cu­lat­ing total Irish twit­ter users is prov­ing a lit­tle tricky, mainly due to Twit­ter not pub­lish­ing total account numbers.The esti­mated twit­ter usage is at 18 mllion in the US, Inter­est­ingly Ad Plan­ner shows 19 mil­lion UV from the US dur­ing Decem­ber 2009. Again using the Syso­mos report, the US con­tributed 50.88% of total twit­ter users. So assum­ing total twit­ter accounts in the 36 mil­lion region — would it be fair to say that Ire­land has 184,000 users?

Let’s hit up Google for some more stats — this time using some search strings to see is <a target=“_blank” href=“http://www.google.ie/search?q=intext:” bio+*+”+intext:“location+*+“ireland””+site:twitter.com””>“Ireland” indexed in users bio’s which returns 128,00 results, although I’m not con­vinced of that rel­e­vance as the page list­ings end after about 900 results, some­thing dis­cussed at We are Social’s blog.

Time to go back and look at the ini­tial 200k fig­ure, this time using Google Trends for a daily break­down. The pro­file below ties in with what I would expect a 200k monthly UV web­site to look like, run­ning between 30-40k daily uniques.

Twit​ter​.com usage dur­ing Decem­ber 2009

And look­ing fur­ther back to see where we are in terms of growth, which is pretty steady from the start the year peak­ing in early June.

Twit​ter​.com usage over last 12 months

So being fairly con­fi­dent of the traf­fic stats from Google which ties in with the research from Syso­mos, I’m going to esti­mate that there are 150,000 Irish twit­ter accounts, by com­par­i­son there are over 1.2M Face­book users in Ire­land (source: Face­book advertising)

While the twit​ter​.com web­site has 200k esti­mated UV from Ire­land, I’m also con­sid­er­ing that there is a dupli­ca­tion in that num­ber. Also vis­i­tor num­bers would never be equal to accounts as some of that may be search traf­fic as twit­ter status’s are now included in Google search results.

So am I over-estimating usage? or does the dor­mant accounts dwarf the active users result­ing in skewed num­bers, but that’s a whole other story, until then I’m going to run with 150,000


Top Websites in Ireland — December 2009

01.18.10 Posted in Web Analytics by Barry

I’ve men­tioned Google’s Ad Plan­ner before, debat­ing the use­ful­ness of it on Irish data.

The lack of any mean­ing­ful com­pet­i­tive intel­li­gence for Irish web usage has led me to delve a lit­tle closer into what the Ad Plan­ner data can do. For a more robust method, I use a mix­ture of tools but still think that with­out a Hit­wise equiv­a­lent, Google is the best source for fig­ures — regard­less if they are not accu­rate, they are at least will be con­sis­tently inac­cu­ate :)

So first off, How does Ad Plan­ner col­lect data?

Google Ad Plan­ner com­bines infor­ma­tion from a vari­ety of sources, such as aggre­gated Google search data, opt-in anony­mous Google Ana­lyt­ics data, opt-in exter­nal con­sumer panel data, and other third-party mar­ket research. The data is aggre­gated over mil­lions of users and pow­ered by com­puter algo­rithms; it doesn’t con­tain personally-identifiable information.

In addi­tion, Google Ad Plan­ner only shows results for sites that receive a sig­nif­i­cant amount of traf­fic, and enforces min­i­mum thresh­olds for inclu­sion in the tool.

So let’s break it down, and see where exactly they’re pulling this from.

1. Aggre­gated Google search data: This can include a num­ber of sources, but I’m guess­ing it’s mainly from Google​.ie and prob­a­bly also web­sites like Eir​com​.net (enhanced by Google search).

2. Opt-in Google Ana­lyt­ics: Unlikely to gain a huge amount from this, Most GA users I’ve spoke to have this dis­abled, prob­a­bly an Irish thing of not want­ing your neigh­bour to know what you’re doing.

3. Opt-in exter­nal con­sumer panel data: No idea what this would be, can’t see it being huge — pos­si­bly sim­i­lar to the method Comescore use to col­lect data

4. other third-party mar­ket research: Which could be: Search, Reader, Feed­burner, Adwords, Adsense, Check­out, Desk­top, Earth, iGoogle, Maps, Tool­bar, Blog­ger, Cal­en­dar, Docs, Gmail, Orkut and any­thing Google can collect.

Data col­lected on Irish web usage

So, with the data col­lec­tion being more com­pre­hen­sive than any­thing else avail­able here in Ire­land, I’ve manip­u­lated the tool to show all web­sites and dumped as much of what was avail­able for Decem­ber, which includes…

  • 4548 web­sites
  • 2.9 Mil­lion Unique visitors
  • 4.4 Bil­lion pages viewed
  • 99.4% Coun­try reach (of total Inter­net users)

Top 10 Websites

(View all web­sites)

One thing to bear in mind when look­ing through the list, is that the Ad Plan­ner tool is devel­oped to help assist in select­ing web­sites to adver­tise on, so the list throws up some anom­alies such as no Google​.ie (obvi­ously), as well as some ques­tions regard­ing the high usage of web­sites like live​.com, yahoo​.com microsoft​.com & mozilla​.com. I would con­sider these to be an amal­ga­ma­tion of the ser­vices they pro­vide (includ­ing sub domains) and prob­a­bly not users access the web­site directly, same goes for xtend​me​dia​.com & medi​aplex​.com.

It’s no sur­prise to see Face­book absolutely ham­mer­ing any other web­site, with 1.5m UV and 52% reach, in com­par­i­son bebo​.com with 560K UV and 19.6% reach.

To get into the top 100, you’ll need more than 74,000 Unique vis­i­tors for the month — and it’s good to see web­sites like boards​.ie & donedeal​.ie mak­ing the list and with it being Decem­ber — portablenorth​pole​.tv & met​.ie have peak traf­fic as well.

Feel free to fil­ter and play with the data here on Google Tables, One of the cool things you can quickly do, is fil­ter all .ie web­sites as well fil­ter for your own or com­peti­tor web­sites. I’ve left in all the Ad Plan­ner data includ­ing the cat­e­gories which might be of some use.

I’ll be fol­low­ing up with some extra insight on this over the next few days.


Search
Social Media Links
 
March 2010
M T W T F S S
« Feb    
1234567
891011121314
15161718192021
22232425262728
293031