Thursday, 17 January, 2008

Tutorial: Analyzing trends through Web Analytics

-Akshay Ranganath

After a long break from the field of analytics, I am back to it! I was just waiting for the data to be collected on my blog to take this further.

In this article, I'll try and explain the importance of trends and how you can derive valuable actionable (and curious) data from the metrics. The way the article is written is how the thought process went on in my mind. So, it's not like a tutorial but a pointer on "how to think analytics"!


All the data for this blog has been take from my personal blog titled Life Unraveled. The blog has been in existence for since 2004. The analytics tool that has been used is Google Web Analytics.

Questions addressed

The trends addressed are for the following two main metrics:

  1. Visitors who arrived from Referring Sites (1)
  2. Visitors arriving through an organic search (2)

Two time periods were used for comparison:

  • Period 1: November 1st to December 15th
  • Period 2: December 16th to January 15th

I know the two periods are not the same - but, I realized that only after I'd collated the metrics! So, please bear with me. Ideally, the periods should be of equal duration.

Following is the results from the data collected. Please see the attached excel sheet for the collection of complete data.

Referring Sites

Referring sites mainly have been Orkut and Blogger. So the comparison is for the three:

Metric Overall
Visits 36 (8) 16 (4) 9 (1)
Pages/visit 2.39 (1.12) 1.79 (1) 2.78 (1)
Avg Time on site 5 m 11 s (7 s) 2 m 39 s (0) 8m 59 s (0)
% New visits 47.22 (75) 68.75 (75) 0 (0)
Bounce rate 66.67 (87.5) 68.75(100) 77.78 (100)

Overall, this category has shown a four-fold increase in the number of visit and about 2 times improvement in the length of stay on site. The loyalty too has increased with fewer and fewer people 'bouncing-off' the site. All of this is good. The questions to answer here are:

1. Blogger has given me 9 visits with an average time of 9 minutes on the site - these guys are really interested in my site. But, who are they? And how did my blog feature on the blogger's site? If I can crack this, I'll be able to increase the volume and my audience.

2. Orkut has started to perform well. The feature of adding the blog RSS feed to the Orkut profile has proved to be a success. Yet, considering that I have almost 100+ contacts and I am still getting just 16 visits from Orkut (with about 10 new visitors), it is not so good. Somehow, the positioning of the feed URLs does not seem to be very prominent or visitors to Orkut are just interested in scrapping me and nothing else. I need to do more marketing of my blog on Orkut - after all these are the people who know me well - and technically should be on my blog for a longer duration of time!

Search Engine Referrers

Search engine and google are synonymous and this was true on my blog too. For the entire period of Nov 1st to Jan 15th, just one query had come from AOL - and this was the one I had tried! All of the visitors who entered the blog through search had used Google.The metrics for users entering from Google looked like this:

Metric 1st Nov - 15th Dec
16th Dec - 1st Jan
Visits 50 169
Pages/visit 1.28 1.45
Avg Time on site 0m 26 s 1 m 50 s
% New Visits 94 93.49
Bounce Rate 90 79.88

The overall number of keywords too had increased from 43 to 133. My blog had suddenly been noticed by Google. The best part is the combination of 'time on site' and 'bounce rate' combination. It shows that a visitor once having landed on the blog spent an average of 2 minutes (at least gave me a chance!) instead of simply moving away - as was happening in the previous time frame. The obvious question was - What were the keywords that were sending so many people to the site and how were they performing?

The search keys and the performance is attached as the excel sheet. If you look at it, I've classified it as the top 10 search keywords. The top 10 have been split into two groups:

  • top keywords by visits and
  • top keywords by average time on site

The reason for this classification was to gain a better perspective over the performance of the search terms. Just because more people land on my site by entering a particular keyword does not tell me much. But, patterns of key words where people entered a particular search key - and stayed on my site for a long time: these are the type of audience that I need to chase. Others, I need to improve.

Search Keyword analysis

The results for the search keywords are here in the excel sheet.

Analysis for period Nov 1st to Dec 15th

From the keyword analysis for the first period, (Nov 1st to Dec 15th), two things stand out:

  1. The term chankya neeti has performed very well - it has brought in 4 visits. On an average, these visitors have been on the blog for about 5 minutes. This implies they liked the search result and read the blog.
  2. By the 4 term, the average time on site drops to 0. This implies people were not happy with the results and they left almost immediately after hitting the site. Most of these search has been for the quotes on the book By the river Piedra, I sat down and wept. Somehow, the blog is not displaying the expected result.

Analysis for period Dec 16th to Jan 15th

Comparing this with the next period, there is a drastic change:

  1. The total no of search keys have increased from 43 to 143. Almost 30 of the key terms have given me an audience who have spent at least a minute on the blog - a drastic improvement!
  2. The most successful key (high visits + longer time) have now changed. Now they are for the quotes from the book The Zahir , etc.
  3. Comparing keys sending most visits v/s keys that lead to longer time on site, it is revealing that top quality key-terms have been one-off. Rather than the blog appearing consistently for a particular key, people are discovering the blog by chance. This is a good way to identify keys for Search Engine Optimization.

Some of the improvements that I could think of were these:

  1. People search 'alchemist' were disappointed. They did see the quotes from the book - but it is not organized. Hence, they left the blog.
  2. Top quality results have been for those blogs where the title and the URL are meaningful. For example, the book review blog for Social Intelligence has the title Book Review: Social Intelligence and the URL as By being consistent it has got a good quality audience

The above metrics then implied that my blog had started to get a better attention from Google - since searches were more often throwing up my blog. Yet, some of the keywords were not leafing audience who liked the site. This implied either that the content was confusing google or it was not optimized for the right kind of keywords. So, now, I have to read through the blogs, check the title and URLs and optimize the blog so that it starts to gain a better performance.


The pattern analysis for two time-period for just a personal blog threw up a huge list of questions and some startling results. Imagine how it could unlock the areas for improvement if this had been a commercial grade high-visibility web site!

Just before I sign off - I found that there were 9 visits from a same person in Tech Mahindra reading all the blogs regarding matrimonial.. hmm. i wonder who this was? And - one person from Millington, NJ searching for my name on google had landed and remained for almost 10 seconds on my blog! Any clues who these people were?? :-)


Referring Sites: The web site where a link to the current blog was placed. Users clicked on this hyper link and arrived at my blog

Organic Search: Process of entering a search keyword and arriving at a site by clicking on one of the search results. This is used to compare against the paid search.

Reference site for analytics

Life Unraveled -

Web Analytics results(excel sheet) -

Article: Lessons on corporate blogging

-Akshay Ranganath

In his article, Lessons from Corporate Blogging , Nicholas Carr, the author of the controversial paper, 'Does IT Matter ' puts in his thoughts over corporate blogging. Here's what he has to says:

  1. Set some sensible and hygienic ground rules - don't be too stifling but, at the same time, don't allow anything and everything on the corporate blog
  2. Remember that a blogger can create a huge audience - and the blog is associated with the blogger. Not the corporate. So when the blogger moves, the blog moves. The corporate could have some potential repercussions.
  3. Align the blog with the business strategy. Don't blog for blogging sake. Dell being a 'direct-to-customer' leverages listenting to its customer through the blogs.
  4. When getting started, try with a narrowly focused blog - and then open the flood-gates. Apple successful did this.

Check out the complete article at BusinessWeek.

Lessons in Corporate Blogging . What your company can learn about keeping an online journal from the likes of Dell, Microsoft, and Apple

What my guts tells me about future of media?

-Akshay Ranganath

There was a wonderful article on how where the Media as a space is headed. This is an article by a VC about how he sees his kids use the new media and what he can derive from their usage.

In short, he feels:

  1. DVDs will be big mainly for the TV shows - it delivers more bang for bucks than movies.
  2. Movies are cool in theatres - still
  3. Books are still read - the old way. Reading online is still not a comfortable idea. Surprisingly magazines are a huge hit and they should be growing more..
  4. Radio and Newspapers are not so important anymore. Sure people use them a bit - but, they are not the primary source for entertainment and news respectively.
  5. Social Networking is big, games on all kinds of devices are big and teens have no problems to seamless switch between devices.

The tile of my post is a paraphrase of the article.From the Indian experience, here's what I feel will be happening in India:

  1. DVDs are now getting big - mainly due to Laptops, DVD players and most importantly, Moser Baer's chape DVDs. Considering tickets in Bangalore now cost anywhere from Rs 200 to Rs 500, its a big burden on the family. Maybe it's affoardable for a Double Income No Kids (DINK) family, but, for others its a no-brainer decision to go for DVD. Considering that we are now getting DVDs of latest movies (I got "Jab We Met" DVD just 2-3 months after the release) it is going to be a big business for movie makers.
  2. Books are still read - if in doubt just check the pirated books available on the foot paths!
  3. Games are in and so is FM radio. Yes - we are a bit late in catching up with the personal entertainment field - but, lately, Mobile devices have turned into personal music systems. Just see the people plugged into music in any of the BMTC buses.. iPod though is still rare. Unless you are a Cognizant employee, you'll probably not be sporting one :-)
  4. Adoption of email and internet is growing - but driven by different factors as compared to West. From the way my parents use internet for surfing matrimony sites and contacting prospects, I beilive the older generation is adopting technology more for fulfilling the traditional filial responsibilities rather than for simply staying in touch. Similarly, they are still not too comfortable with FM radio - preferring the "K" soaps on Telly, Breaking News on NDTV, et. al and newspaper for all opinions. Considering the profliage of news channels and coupled with never ending analysis, they are simply digging their own grave by driving away people who want to get a general feel of happenings - fast.
  5. Orkut is the best Social Media site. Facebook is a fab. LinkedIn is gaining ground. Recruiters are now targeting prospects via Orkut. This could act as a big turn off if the trend continues.
  6. Mobile phone usage which was a big fab is now turning into more of a utility - and hence, the Average Revnue Per Subscriber (ARPU) could reduce. So, Mobile phone companies will push features like collaboration gaming, song downloads, etc more.

Well, these are my thoughts at the beginning of the new year. Do let me hear your thoughts.

What My Kids Tell Me About The Future of Media -