A Page To Be Proud Of

(An interview with Seby Kallarakkal, Founder and CEO, Nabler Web Solutions – by D. Murali. Published in Hindu Business Line on June 17, 2010.)

Should a marketer worry about varied streams of data portraying seemingly different stories? “I would think not,” says Seby Kallarakkal, the founder and CEO of the Bangalore-based Nabler Web Solutions Pvt Ltd. Having data from other marketing streams would actually help a Web analyst draw the right conclusions, he reasons during a recent interaction with BrandLine.

“Let me give you an example. We were studying data for a Web site and found a big spike in traffic. A few days later, the traffic went back to the old level. There was nothing on the Web site that could explain this sudden jump. Then we got some additional data — the dates on which the customer had run a TV ad. The jump in traffic coincided with the airing of the TV ad. After a few days, the TV ad stopped. And gradually traffic on the site also dropped.”

6 Pillars Of A Good Web Analytics Report

They say if your business is not online, it is as good as non-existent. Of all the business websites, less than 20% employ web analytics to track the performance of their site. One needs to remember that what a company needs from their website and what purpose the website actually serves may vastly differ. If you have a website, it is most crucial to study the visitor experience and analyze the data generated. The data gathered, however, can be overwhelming and vast and therefore knowing what information is worth tracking and what isn’t becomes extremely important if you want to use web analytics effectively.

The following seven points are crucial to create a significantly insightful web analytics report:

9 Reasons Why You Should Start Analyzing Your Website Traffic Now

Are you still stuck with your old and dingy website that you keep updating, but you do not know the results of all the changes that you spend time and resources on? Today’s global business, with suppliers, vendors, investors, prospects, customers, and employees spread all over the world, cannot afford to miss out the details of how people are interacting with their online presence. Web analytics is not only meant for big businesses with huge websites, today, even single-person enterprises are utilizing the benefits of web analytics to take intelligent and informed online marketing decisions. Doing online marketing without measuring its effectiveness is an exercise in futility.

If you are not analyzing your website’s performance, you are missing many facts and insights that can help you increase your online profitability. Here is our list of top 9 rationales for you to get into web analytics ASAP:

Motion Chart in Excel

- Contributed by Kamesh M

We all know that using a Bubble Graph one can show three different dimensions of data i.e, X-axis, Y-axis and the Size of the Bubble to represent an additional dimension of information for the given time period. With a small set of data this may not prove beneficial but is pretty much helpful to visually represent a large segment of data. It gives a quick impression of how the large data relate to each other in terms of for example volume, position, placement, etc among many other possibilities. All that saying, it however shows only for a certain defined time such as for a week or a month of data.

The same bubble chart can however be tweaked at large to show how the relation continues over a moving time range – say across the three months in a quarter or across twelve months in a year, which is better known as ‘Motion Chart’. And all that using the very common MS Excel itself. When the data has to be shown for different time periods using the same graph it could become a bit challenging. The idea is to show how the bubbles change with time or say any other dimension. In simple words, this can be done by using a scroll bar that would allow control the progression or the change.

Web Analyst Job, at Nabler Web Solutions (Location: Bangalore)

Company Profile:
Nabler is India’s first pure play web analytics company. We are looking for web analysts who are excited about analytics and the Internet. We analyze data for some of the best brands in the world and work on a range of tools including Site Catalyst, Coremetrics, WebTrends, ClickTracks and Google Analytics. The selected candidate will get an opportunity to work directly with the customers. He or she will get a chance to analyze not just web data, but a mix of traditional and online media.

Job Title:
Web Analyst

Job Profile:

  • - 2+ years experience in analyzing websites
  • - Expertise in one of the following tools – WebTrends, Site Catalyst, Coremetrics, NetInsight
  • - Experience in handling customers directly in the area of providing web analytics services
  • - Excellent written and spoken communication
  • - Should have an analytical mind
  • - Should be based out of Bangalore
  • - Should have very good hands-on experience in creating powerpoint slides
  • - Should be a power user of Microsoft Excel
  • - Should have an eye for detail and quality

Key Responsibilities:

  • - Interfacing with the customer, understanding the requirements and delivering on time (Some of our customers are in the US and you might have to stay back on some days till about 10 PM to talk to them)
  • - Providing insights on the data being reported
  • - Delegating work to colleagues when situation demands
  • - Building reports and analyses using powerpoint or Excel

We are located close to the outer ring road, in a place called HRBR layout or Kammanahalli in Bangalore.

If you meet our criteria, you would be called to our office to do some hands-on analysis and reporting. If you like what you are doing and if we like how you are doing, we’ll get you on board.

If interested, kindly send your updated resume with the following details at hr@nabler.com.

  1. Name:
  2. Email ID:
  3. Contact Number:
  4. Best time to call:
  5. List web analytics tools that you are familiar with:
  6. Rate yourself on SQL / MS Excel / MS Powerpoint on a scale of 1 to 5:
  7. Have you interacted with customers directly while providing the service of web analytics (yes / no)
  8. Current CTC:
  9. Expected CTC:

Child Profile Access in Webtrends

- Contributed by Mukesh Sharma

Ever wondered how you could give access to a particular child profile to a user

In the newer version of Webtrends, v8.5, there are pre-defined roles like Administrator, Report Manager and Report User. There is also a provision to define your own role. Question is can you solve the problem of assigning child profile access using these added functionalities?

Here’s a scenario – you have one profile under which you have 10 different child profiles. You need to give access to one of the child profiles to one user without him/her being able to view other child profiles. How do you do it?

Heres the solution to the above problem without using the above said roles.

  1. In the left pane of your Webtrends application, Under Administration > Application Settings > User Management. Click on Users
  2. Click on New user
  3. Under the General tab fill in all the required fields like the login name, First name, Last Name, Email
  4. Under User Authentication select the second option (Use WebTrends authentication based on the password provided below) so that once you are finished you can login with the users’ credentials and check if you have given access to the correct child profiles
  5. In Action Rights, give View permission for Custom Report and Templates
  6. Give create permission for Export To Microsoft® Excel (MDB Database) and Export Word, CSV, PDF Reports
  7. In Profile Rights, give View permission to the Main Profile under which you have different child profiles.
  8. Let the Template Rights and Preferences have default values.
  9. Now go back to Reports & Profiles under Administration. Expand the Main profile to which you have given View Permission.
  10. Click on Edit Child profile, the child profile to which you want to give access to.
  11. click on Profile Access tab.
  12. Give View Reports permission to the user.
  13. Logout from your webtrends id and login using the users credentials you just created and check if the correct child profile access has been given to the user.

On a concluding note, is this the best way to give access? Well researching on any new tool is definitely fun!

TIME IS PRECIOUS: Don’t use it as ‘Reporting SLAVE’ but as ‘KING Analyst’

- Contributed by Saagar Shinde

Most of the web-analyst in world does reporting-analysing on Daily & Weekly basis. Most of the time they have to go through the painful process – Visiting Google Analytics (GA), going to different profiles, selecting the required reports & then export or copy-past reports/data into the respective dashboards/reports. It’s becomes a hassle when your client asks for an ad-hoc, while you are busy with your weekly or monthly reporting. Seems more like, the web ‘analyst’ has become a clown in the office juggling between ‘n’ number of reports at the same time! It is important to manage time appropriately while using option called ‘Custom Reporting’ in GA. Custom Reporting means to ‘design, a kind of report which fits your need’ as defined by GA. Here, you can also create a report and use it the rest of your life. ‘Custom Reporting’ somewhat helps you to transform into ‘KING Analyst’ from being a ‘Reporting Slave’. Most people don’t use ‘Custom Reporting’, a perfect and thoughtful gift from Google Analytics to those who value time. They don’t use it because they proibably are ignorantor they love their old ways or they just prefer spending the day collecting data. Ok that is the theory bit, now miving to some real time reporting, Let’s make a Report which can be used weekly or monthly & then see how we can schedule it.

4 Steps / 4 minutes to save your precious time & effort:
(Ofcourse also to shed that shameful tag of being a Reporting Slave!!!)

I hope most of you are familiar with GA, a boon to web those seeing analytical help in the online space, which comes free of cost & user friendly.
1. Click on “Create new custom report”

2. Let’s make a report for “Engagement by Medium”. You can use 10 metrics in a tab. If you need any more metrics then add into Second Tab.


Remember you can make the simplest report & also the most complex one. Simple Reports needs common sense & Complex reports needs some smartness. Also remember we are doing this for significant purposes i.e. to save time.

3. You can click on ‘Preview Report’ tab to view it before its actual report generation. This will help you to make any changes if required. If you have previewed the report and are satisfied then click on ‘Create Report’ & Boooom! You have created the custom report & now you can view it. Note that you can use different advanced segments also for the same and it further facilitates date comparison if needed.

4. You can export the report in the format as per your requirement or schedule it. You can schedule the reports to different members in your team.

It is so simple to create custom reports & schedule it. Next time make sure you don’t waste your time by visiting your GA account & downloading it. It will be in your Inbox. Also note that you can use a similar subject line for your report. This will help you to filter the reports from your Inbox. If you ever get suspicious about your data which you have received, you can always do a quick quality check for authenticity of numbers by logging in to your GA account.
This time gained can help you change yourself from being a mere ‘Reporting Slave’ to a ‘KING Analyst’! You can invest your time for analysing the data you have received, ultimately giving your outputs, suggestion, advice, etc. Hope you enjoyed ‘the Custom Reporting which is so common still uncommon with Web Analysts’. You can comment below about your experience with ‘Custom Reporting & Scheduling reports’.
Not sure about all the tools in the industry but Omniture also provides you with such privileges.

Representing graphs more meaningfully: A Dashboard Trick

 - Contributed by Gunjan Aggarwal

A layman who would look at the above graph, at his first glance would tell that the Paid Search had not performed well in the initial months, or HE/SHE would think that there must be some changes happened in the Paid Search Section in the month of June which in turn shows hike from July onwards
Through this trend in first glance you will say that Paid Search didn’t yield any visitor in the month of April, May and June. But the fact is Paid Search Campaign started in July.
Now how to show trend line starting from July onwards is a trick.
Goto your Data Source

In the Paid Search Section Replace the “0” for which the data is not available with the formula “=NA()”.

By making a minor change in the data source the Graph can be depicted in more meaningful manner as shown below:

A person looking at the above graph would understand that the Paid Search has started from July onwards.

If you need a sample report on any of these dashboard tricks, please leave your email id in a comment. And we will mail it over to you.

Web – Numbers, Data and analytics

- contributed by Sowparnika Gopal

Any technology savvy person can very well define the term logs. Logs are nothing but records. Records that gives an impression about your activity, be it your own computer, the attendance at your work place, time spent on your tasks or anything… When you have a record of any activity; it is called, Logging in your activity. These logs act as data. These are saved with a purpose. If you want, you can go back to them and analyze them to conclude what you have been doing, what you should have been doing and what could be done.

We shall discuss here, about such data, that we get from websites, how we derive numbers out of them and how we analyze them. Here, the term for the logs, is Web logs. They log in activity on your website. This can be further analyzed to derive meaningful conclusions on what visitors have been doing on your site, what you wanted them to do and what could be done, to get them do what you want them to do. Converting the data into information is the ideal objective of the analysis, and that’s what we shall try and focus on here.

What can web analytics measure?

Numbers are easy to derive. Technology-driven world has made numbers so simple and easy to derive. When we talk about analytics we mean numbers, that helps solve your website-related problems and that which will help improve your current web performance. The basic thing about web analytics is the analysis of a series of records which can be crushed to get meaningful data and interpretations. When we talk of records where our data in question is saved, we are talking about

  1. Log files
  2. Page tagging

Well if you are a business person intending to do get your website analyzed, I don’t think I should really get into the technical details at this point of time. We shall do it a little later, But to begin with, let’s do this. Now that you know what web analytics means, let’s see what it can do to businesses.

When you have a business, you have a website to support it. And when you have a website, you have to define your purpose of having it.

Ok, I’m asking you… What is the objective of your website?

Now, if the first answer that comes to your mind is something along the lines of…, because the generation is such that everyone needs a website.

Then, you need to relook at if you need a website at all. There is more to a website that just having a presence on the World Wide Web.

A website can serve different purposes. Be it, providing information, online marketing of your products or services, lead generation or actual sales. When you provide information on your website you are actually making it easier for someone seeking the information. It may be anyone. But you are making it easier for them to know you. It is a step shorter than waiting for someone to know about you from god-knows-where?! When they learn about you, they will decide what they want to do next. Would they approach you for a need that suits them, or decide to just know and leave? So, it is necessary that you provide all that you think the others need to know about you on your website.

Now, when it comes to analytics, what strikes to me, is there a definite pattern in web analytics for a website that already exists? Let me just quickly jot down things in order as they come to my mind:

  1. Analyze the current status of the website
  2. Suggestions and basic changes on the site with respect to the design and layout
  3. Decide your source of data for analytics
  4. Decide your tool for analytics
  5. Configure your tool/s to match your requirements
  6. Drill the numbers from the tool selected
  7. Check with a small date range or even a day with the accuracy of numbers
  8. Set the Key Performance Indicator’s (KPIs) and, document where and how of the data points in the KPI
  9. Fish for numbers
  10. Check and recheck the authenticity of numbers
  11. Draw the trend lines wherever and whenever the data is available
  12. Analyze the numbers – Give reasons wherever possible
  13. Give suggestions based on your data
  14. Forecast your trend depending on the industry standards, activity on your site and past numbers
  15. Suggest marketing strategies that will boost your online activities
  16. Analyze the effectiveness of your suggestions and forecast
  17. Check if it meets your defined objectives, goals and targeted numbers

It is not necessary that all these steps are actually needed. For instance when I say forecasting your trend, you need to get into in-depth statistics to know how you can do something like that. It’s definitely not a matter of chance, that we can guess numbers!

Advanced Segmentation and Customer reports in Google Analytics

- contributed by Seby KallarakkalGoogle got it right again.

Web analytics world is going to be changed once again by Google Analytics. The sad part is that Yahoo was so close to take leadership position from GA, but got the timing wrong. From the time Yahoo acquired IndexTools, almost everyone was expecting Yahoo to launch it for free and beat Google at it’s game. For people who had used IndexTools and GA, getting IndexTools was a much awaited option. But Yahoo sat on this for too long. They also made the mistake of announcing without making it available to the public. And while Yahoo was preparing for the launch GA launched the revised version with the two killer features that differentiated it from Index Tools  – segmentation and custom reports.

I took a test drive of these two features in the beta mode and I must say that it seriously rocks. The UI is fabulous and the flexibility is amazing. Gone are the days when you had to create 50 profiles in GA because it didn’t allow advanced segmentation. So, GA has managed to shake up the web analytics tool industry once again. Now, customers would seriously think about their investments in the expensive web analytics tool. Granted, GA still doesn’t give real time data like the more expensive paid solutions. But I guess, it’s just a matter of time.

How does your website currently fare? – An eagle eye review

- contributed by Sowparnika Gopal

In an already existing site, first learn your current website activity. How USABLE is the site as of now? Well, let’s term this here as ‘Eagle Eye Review’. This will be the overall basic navigational review.

Eagle Eye Review should ideally include:

  1. Home Page Dissection
  2. This is an analysis of the home page in terms of the location of each link, the number of people clicking on each link, the part of the home page that best receives clicks, and the part that is most ignored.

    Once you have the dissection report ready, it will help you restructure the elements on your home page so that the most important things can be put in those areas which are most clicked and in the most effective ways. There will be lot of experiments before you can come up with one home page that best serves your decided objectives and goals.

  3. Routing Analysis
  4. This is also called navigational study. This is the study of the way in which the pages route the traffic to the other pages.

    It includes the study of the various navigational elements like the header tabs, the bread crumbs, right links, banners on inner pages, the visibility of links, inter-linking of pages, visibility of sections on the main header tab, the site map and anything that is to do with the navigation.

    This study can mainly involve the path analysis to the most important pages in the site, which will help you decide if that’s the right way you want your visitors to go.

  5. Panorama View
  6. This is a study of your design and layout. This will include the home page dissection as well as the dissection of every page that has a different look-and-feel.

    This study will involve giving the possible alternatives to the way the design elements, banners, tabs are placed in a website. The most effective way can be determined, after looking at the best possible presentation styles.

    Some of the factors considered in this study include the theme color of the site, color of the fonts, the way the fonts are distinguished depending on its importance, the degree of contrast of each text color and its visibility with respect to the background, the position and location of tabs, the basic layout and more.

  7. Error Reporting
  8. This will mainly involve review of errors on the site, the status codes of the pages, the broken links, bad copy, accessibility issues and browser compatibility check. These are some of the basic errors that can be tracked which have to be first corrected.

  9. Content Analysis
  10. This is another of those things that require a detailed study. There are some parameters in analytics that will help do the content analysis. At the initial stages, what can be measured is the bounce rate of the pages. Bounce rate is calculated as a ratio of single page visits to the number of landing visits to that page.

    Bounce Rate = Single Page visits to a page / Landing visits to the page

    Once you are able to identify the bounce rate of the pages, you should next see the stickiness of the page. If they have been on the page long enough, then they probably got what they wanted, and then decided to leave. Depending on the nature of each page, we can decide if the page and the content on the pages have served its purpose or not.

We shall get into the details of each of these analyses in posts to come.

Web Analytics – Is it worth the trouble?

contributed by Francis Joseph

It has been almost four months since I was authenticated as a web analyst. The first few days of training and thereafter being on the job were tough. Not to say how confusing they were, considering all I could hear were these weird chants primarily focusing on visits and page views, coupled with visitors and other weird metrics.

I found these days and the man-hours spent during this time a complete waste. Not just to me, but to all those who were paying me, and, especially to those who were paying them. I could not, for once, see the point of how the numbers I was handling could help anyone, or push anything to the point of consideration based on what I was doing. It was all so redundant, the same figures. I was told that as long as the linearity of the graphs was maintained, both of us, pertaining to us analysts and the designers working with the content writers, were doing a good job.

Perfection was an obvious peak in traffic, when achieved by the site. The analysts had to get that on their monitors and present it to the people responsible, so that they could, maybe, get the line graphs embedded on a sheet of golden paper, and get diamonds stud in to mark the dates, and the date ranges I believed. Day-in and day-out I would work hours on, trying hard to cope with the numbers game, and to somehow get what was asked of me and more. But all the work I did never compensated for the inquisitiveness that had already set its roots deep inside me.

Then there was the revelation. Two months into the job and I was asked to take up this new project with one of our clients. The work was going to be limited but the experience that presented itself, promised a lot. This was my first time interacting directly with a client. A major project, invested money, invested expectations etc… I remember how there was an unexplainable frenzy in the office two days before the micro site was going live. There were people pointing to my cubicle, and in a way this presented me with a larger responsibility than what I was sure of having.

The micro site did go live and the log files were downloaded after 14hrs of hectic traffic (we presumed). The profiles were run, the data, keenly awaited. This turned out to be my first-hand experience to such amazing reactions. An accounts manager, responsible for the design of all the e-mail campaigns and the e-mail blasts was restless enough. A GTM who was curious enough, actually took the pain to come up and sit next to me for the final few seconds of the processing. But he was naïve in his attitude, assuring me that this session is again, going to be one of those involving staring at some numbers and then cautiously giving me a “uh-huh its ok”. But it was different this time. The chat was on, as the processing completed. 345 visits. “Not bad for the first day” said one, “Brilliant!” said another. The traffic source verification pointed out, how the mailing campaigns had all worked and managed to attract target customers for their first look on the site and examine its content. It even pin pointed which ones out of the targeted visitors had actually bothered to take a look.

With all the smiles around me, I felt as if I was the one who was directly responsible for these figures. With the thousands of dollars that was said to be invested in the whole project it was amazing to see that phase-1 was branded successful.

I could finally picture the power of Web-Analytics. I realized it is not just a tool wherein you get to know the performance of your web-site in terms of how many views, visits and visitors but if used properly it could act as the most comprehensive back end for your sales team. Which would now, other than just presume intent with interrelated Sudoku puzzles on demographics, have vital proof that distinguishes a visitor to a prospect customer. Data could help build future campaigns, and costs could be cut as focus could now shift to the ones who were surely believed to be interested in the product.

It provides the technology with the powers of converting a visit to your website which can be left unnoticed to a sale and a unique visitor to a Client. And as few believe, daily trends have no importance and trends need to be observed for longer periods of time, I found out how a situation as I found myself in, what was most important were daily trends(hourly if possible) as they were the only measure of success of massive campaigns.

Web-Analytics, for now may be a luxury to some, and for the more economically established companies due to the expenses related to setting up. But one thing for sure, at least in the retailing section, is that as the influence of the internet increases, and the attitude of the lackadaisical people, wanting work done with the click of a few buttons rather than wasting time on transit and encouraging physical or any psychological exertion, I am sure the now prevalent want for web-analytics will turn into a need for the same, as the site owners will want the knowledge of who wants what and how badly they would want it.

Welcome to Web Analytics India!

Hello there. Welcome to our blog. Since this is our first post, we thought it would be good to state our objectives and our target audience.

Our target audience is people who want to learn web analytics. They know the terms. They have used the tools to some extent, but they are fighting a lonely battle.

There are, of course, some brilliant blogs out there. So why bother with one more blog? That’s like asking why start a company? It’s fun. It’s challenging. And some where down the line, it could also provide great returns.

So here we go.