Thankyou all who attended the event and making it a big success. I will share pics and videos soon.
Web Analytics Wednesday
August 1st, 2010 Written by: Mayank BehlDiscussion is on online marketing, web analytics, concepts related to SEM, SEO, Analytics, SMO, e-commerce, payment gateways. WAA Country Manager, Mr. Trinadha Kandi is the guest speaker. Entry is free. (M)09652163298, mayank.behl@gmail.com
Segment your Goal Funnel in Google Analytics
June 10th, 2010 Written by: Mayank BehlWhat is a Funnel?
Your goal funnel is the set of required pages leading up to your final goal, such as a purchase. You may be familiar with the Funnel Visualization report in Google Analytics (GA). It shows you how many visitors go to each step and how many leave the funnel at that step. You can spot trouble points with your funnel and take steps to correct the issue. Here’s what the report looks like:

The Problem:
While you can segment goal metrics such as goal completions, starts and values in GA, you can’t segment the Funnel Visualization report. You can’t see how different types of visitors may leave the funnel at different steps. For example, you may just want to see where new visitors abandon your goal funnel, compared to returning visitors. When you look up at Advanced Segments in the top right of the Funnel Visualization report, here’s what you see:

The Horizontal, Segmentable Funnel
I want to show you a method that will allow you to see your goal conversion funnels in any report, segmented however you want. I’m going to name it the “Horizontal Funnel” since we’ll be viewing it left to right, instead of top to bottom.
Let’s start with what you’ll get, using this method.
The traditional GA Goal Funnel report shows
1. Number of visits to each step in the funnel
2. The percentage of visits that continued to the next step
3. Where exiting visits went.
With the Horizontal Funnel method you’ll see
1. Number of visits to each step in the funnel.
2. The percentage of visits that did not continue to the next step
You don’t get to see where exiting visitors went. . .but you WILL be able to:
1. Apply Advanced Segments
2. See the funnel for multiple segments in the same report
Let’s look at an example of what a traditional e-commerce funnel that looks like:
Shopping Cart –> Address Info –> Payment Info –> Review Order –> Thank You
In the image below, the values outlined in blue are the visits to each step, and the values outlined in orange are the exit rate between steps.

It’s like a regular funnel, just flipped on it’s side, using goals, first steps in funnels, and custom reports – more detail below. As you can see, this is in a keyword report. So, the funnel can be seen in-line in the report, for whatever segments you want; in this case for individual keyword phrases. And you can apply Advanced Segments or Secondary Dimensions to the report.
That’s the “what”. Now for the “how”.
1. Create the Goals
For each step in the funnel, we create a separate goal in GA. This provides the values in blue: how many visits touched each step. Now we want to be able to get the values in orange, the exit rate between steps. In each of the goals following the first step in the conversion process, we create a funnel. Each funnel contains a single step which is the Goal URL for the preceding goal. That’s the key. The preceding goal becomes the Funnel Step 1 URL for the next goal.

2. Create the custom report
Now that the goals are set up we can create the custom report we need to view the data. To set up the report we are going to use two different metrics, Goal Completions and Abandonment Rate.
The Goal Completion metric is the number of visits in which a particular Goal URL was visited at least once.
The Abandonment Rate metric is the percentage of visits that started the funnel (saw Step 1), but did not complete the goal.
In our Goal #17, we made the Funnel Step 1 = Goal #16 Completion. So, Goal #17 Abandonment Rate = percentage of visits that saw Goal#16 but did not complete Goal #17 = Exit Rate between the 2 goals. In this example the first step in the funnel is in Goal Slot #16, so Goal 16 Completions goes first. The second step was in Goal Slot #17, so we place Goal 17 Abandonment Ratenext, followed by Goal 17 Completions.
Then Goal 18 Abandonment Rate, followed by Goal 18 Completions.
And so on.

After you have all the goals in place in the Metrics section of the report, it’s time to move on to the Dimensions. In this case, we chose to dimension by Keyword. But you may wish to see your goal funnel report by City, State, Browser, Landing Page, or whatever is most appropriate for your situation.
That’s it. Happy Funnel Segmentation.
Web Analytics – Art or Science?
December 23rd, 2009 Written by: Mayank BehlIs web analytics an art or a science? Is it primarily a creative or a methodical endeavour? Is it left-brain or right-brain?
Or, is it both? Does it rely on some kind of balance between the two?
I initially started pondering this after reading Steve Jackson’s Cult of Analytics. The book primarily describes an organisational structure and process that can be used to put web analytics at the heart of an organisation. However, it goes much further than this in that it attempts to create an intensely rigorous system of scorecards that can be used to police the delivery of this framework. I also noticed similar thinking in Akin Arikan’s recent call to create an expert system for web analytics, which argues that web analytics should operate much like the field of medicine or mechanics, with concrete processes followed to the letter.
I can certainly see where they are both coming from, but something about this whole thing just makes me feel really uncomfortable. It is undeniable that web analytics is a form of science and computing (it’s got the word ‘analytics’ in it for a start!), but something inside me constantly cries out “no, there’s more to it than that, web analytics is about creativity and intuition and sales and the passion for opportunity!”. You might need the science and the tech in order to understand what’s happening, but can this ever really tell you what to do next? Doesn’t this require a fundamental and intrinsic understanding of business strategy that can’t be reduced to statistics and data; or made into some kind of rules-based process?
But if this is true, and web analytics is a balance between science and art; analysis and intuition – then today the field seems woefully lacking in the art and intuition. But why is this? Web analytics has a ‘tech’ heritage, but does this fit?
Web analytics originally ‘emerged’ from the field of IT, and was later integrated with the field of business intelligence. This produced a group of people with a huge amount of technical and analytical knowledge, but their role is to report things to other people. They don’t typically get involved with what that information is used for.
But web analytics IS the use of the information. You can’t divorce the information from what it needs to be used for. Anyone who has witnessed first hand an organisation where reporting is handled by IT and optimisation by marketing will know exactly how disastrous this can be. Separating the two creates an uncrossable chasm in the middle. You either need one person with both skill sets (unfortunately quite rare), or a well managed team with both camps working together.
Web analysis is not the same as traditional data analysis
The word ‘analysis’ in web analysis persuades most companies that they should fill their senior web analyst positions with hardcore data analysts. Some companies even go as far as employing people who have previously been analysing things like meteorological or geological data sets. However, whilst it is important to have at least some hardcore stats knowledge in a team, it isn’t necessary at the senior level.
Web analytics tools are easy to use, at least from a functionality perspective. The vast majority of the stats and number crunching has already been done by the software. Anyone who has crossed over from using something like SAS to something like Site Catalyst will understand this. It isn’t analysis in the same sense; it’s report viewing – so the ‘analysis’ is in fact the interpretation and translation of the reports into action, which starts to get much closer to marketing and general business performance than any kind of traditional analysis.
People only see the means, not the end
If someone came to your house to sell you double-glazing and spent an hour showing you the tools they planned to use, and talked about how the plastic was manufactured, you wouldn’t buy the windows! If, on the other hand, they talked to you about the reduction in noise, the increased warmth and the lower fuel bills that you would get, then you would be more interested, right?
For some reason, we have an endemic problem in this industry whereby people obsess over the analysis and data, and not the benefits of the analysis. This results in a perception of web analytics as boring and difficult to understand. If you are presenting recommendations of analysis to senior management, do you really even need to show the analysis? Web analytics is decision support, not a sleep-aid!
The problem then it seems, is that you often have senior people who are too scientific in their approach and lack the spark of commercial intuition and business acumen that can drive truly actionable analytics. This was less of a problem in the old days of data analysis for direct marketing because there were clearly defined process frameworks through which marketing folk could receive standard reports and make decisions based on those reports – but, and here’s the crucial point, there isn’t really anything standard about digital marketing!
I have always said that, one day fairly soon, the word digital will cease to exist; it’s a term used to describe the fact that some things are analogue and other things are digital, but already there isn’t so much left that can reasonably be called analogue. Therefore, if digital marketing simply becomes marketing, and digital business simply becomes business, and these things are as data-driven as we all hope they will be, then ‘analytics’ is a huge central discipline to an entire business operation – to reduce it as a discipline to a fixed process is like trying to create a fixed process for all aspects of the management of a business. Is this possible and, even if it were, is it not suffocating to the organic growth and development of the business?
Learn More Here
Google Analytics: Web Intelligence tips for Online Retailers
December 23rd, 2009 Written by: Mayank BehlGoogle analytics recently rolled out a new “Intelligence” feature which is a great attempt to solve this very problem. Google analytics now keeps track of “expected” data patterns on your site and can notify you via email or online reporting if there are any significant changes on your site activity. For example, intelligence feature could alert you if there was a 200% surge in visits from Twitter referrals during last 24 hours or let you know that bounce rates of visitors from India jumped by 40% last week. Instead of you having to monitor reports and comb through all the data, Analytics Intelligence alerts you to the most significant information to pay attention to, saving you time and surfacing traffic insights that could affect your online business.
Now you can also setup custom alerts to tell Google Analytics what to watch for. You can set triggers on pretty much any dimension & metric such as conversion or orders, and be notified by email when the changes actually occur. If you don’t have these features in your account yet, you should see them in next few weeks. I think this is a great addition and will really help you operate your online store with lot more intelligence and insights that would otherwise have taken significant amount of time to analyze.
Here are some specific examples of how online retailers can use these intelligence features effectively:
1. Understanding seasonality of the products – Setup alerts for changes in conversion rates for specific products or categories over a time dimension so that you can be notified when it is time to review your product assortment from seasonality and relevance perspective.
2. Understanding changes in zero search results – You can setup alerts that would inform you if the % of zero search results spikes above normal. This is usually an indicator that more customers are not able to find the products they are looking for. You can then evaluate the top searched keywords to find assortment gaps.
3. Understanding the effectiveness of PPC campaigns – Lets say you setup a PPC campaign that results in a drop in the conversion rate. This is typically an indicator that the PPC campaign is not driving productive traffic to your website. Setting up an alert in these cases would allow you to aggressively manage your Adwords and other marketing campaigns so that you can avoid throwing money on campaigns that are not very effective.
4. Impact of social media – You posted a new story on Digg which went hot last night. It would be nice to get an alert if the traffic pattern on your site changes due to your social marketing efforts.
5. Drop in conversion rate – Lets say your server receives a huge surge of traffic and the users are not able to complete checkout due to performance problems. Wouldn’t you want to be notified immediately so that you can take corrective action? You can setup an alert that notifies you whenever the conversion rate or the order volume on the site deviates from the expected range.
I think this is a great feature to provide you access to more real time, actionable insights that will not only help you make more informed decisions but would also point out operational problems on your website on a more realtime basis. And best of all, it is free!!
Learn More Here
Do You Need Heat Map
July 22nd, 2009 Written by: Mayank Behl![]()
Most tools tell you what visitors do on your page. Some tools give you the great opportunity of segmentation. Awesome. Some tools even allow you to use API, snyc to your adwords account, handle external data sources, let you do multivariate testing; some of them even provide behavioral targeting and predictive< behavioral targenting and some of them even fly you to the moon. And all you ask for is a what? A heatmap? Thats it? You, and i mean you, the super-clever entrepreneur. All you ask for is a heatmap? Wow. There are so many much more important questions to ask in your business, and you are on the right way when taking your time in selcting the perfect web analytics tool for your business. Take this time. Use it right. And forget about the heatmap.
Welcome to Web Analytics Blog
July 22nd, 2009 Written by: Mayank BehlHi. In this blog I will try to share insights on web analytics, SEM, SEO, optimization, e-commerce, affiliate marketing and much more. For any information write to me at: mayank.behl@gmail.com
