Direct Visitors to my website were increasing daily and I was very much interested to know whether they were coming from the ‘Bookmarks’ already saved in their system or were all together new visitors. One fairly strong indicator of audience loyalty is whether or not people have saved your website address in their bookmarks folder.
Read More
Analysing huge datasets can be a problem sometimes. Which keywords get more traffic and have good conversion rate compared to others? Which traffic sources get the maximum qualified visitors to your site? Which page is good at driving visitors or which engages a visitor well?
You would often wish there was some visualization solution that could answer these question in one shot. My answer to this would be Treemapping! There might be better solutions but Treemapping works wonders for me !
To begin with, lets understand what are Treemaps?
Treemaps display hierarchical data as a set of nested rectangles. Microsoft has an ‘excel add-in’ which can help you create great Treemaps.
Read More
Whenever we start any ‘Keyword Analysis’, the first and foremost thing we need to do is to categorize the keywords into Branded and Non-Branded. Analyzing the keywords by categorizing them will give you more insights. If this categorization is done manually then this will take up a lot of time. So the best thing is to automate this process.
For this, we have written an excel macro, which will help you save time and concentrate on analysis.
Read More
Do you spend lots of time analyzing data with ‘Omniture Discover’? Are you tired of keying in your username and password every time you login to ‘Discover’?
Launching ‘Discover’ application after you login to your ‘Site Catalyst’ account is time consuming. We all know that if we log in from ‘Site Catalyst’, you are automatically logged in to ‘Discover’. But what if you are not logged on to your ‘Site Catalyst’ account? What if you don’t have the ‘Discover’ URL provided by your ‘Omniture’ admin? Can there be an easier way to access your site data?
Read More
This is the second post in the series of online tutorials which will help you convert your day to day excel usage into strategic functions that help draw out more from your analysis.
The following video talks about a function that lets you extract keywords from a search query. This helps in situations where the internal site search reports are not set up correctly in the analytics tool but the keywords still have to be reported upon.
Read More
We bring to you a series of online tutorials which will help you convert your day to day excel usage into strategic functions that help draw out more from your analysis.
The first in this series is the following video, which talks about a function that lets you count the number of words in a keyphrase. This will bring to light a number of stories about the keywords bringing traffic to a website. This is especially helpful for those who carry extensive Ad words and PPC campaigns.
Read More
Consider a scenario where you have a website and you also have an analytics code embedded into it. You check metrics everyday but always get stuck at one single question- ‘What are the benchmarks on which you should compare these metrics?’ i.e. how to measure your website metrics against market standards.
Basic terms such as ‘time spent’, ‘bounce rate’, ‘page views’ will be relevant for the website only if they can be compared against some reference value. To understand these terms and their relevancy to the website, two simple rules should be followed which will convert simple numbers into meaningful data.
Read More
The internet has become the new age knowledge center and blogs have become the new age information syndicates. Have a problem? The World Wide Web is sure to throw up millions of sources at you, with each blog looking fancier and more informative than the other. In such a competitive scenario, how does one make their blog stand out? What makes those few blogs have a subscriber base of thousands, whereas some quality blogs are left with no followers?
The problem is that most of these blog owners consider macro traffic volume as the absolute indicator of overall success, instead of realizing that more traffic need not mean more revenue, conversion and success. It needs to be realized that each website’s traffic is comprised of a variety of unique traffic sources and to identify these sources and their impact on the conversion rate and revenue, one should start by defining what can be called the ‘TRAFFIC ECOSYSTEM’.
Read More
Two weeks have gone by since Nabler and Webtrends organized the Web Analytics Wednesday meet. The event was a gathering of digital marketing and analytics experts and enthusiasts from all over Bangalore and cities like Chennai, Bhopal, Pune and even Singapore! It was good to see excitement within the digital community for this event. Around 120 people turned up and to make things even better, everyone was dot on time despite the notorious Bangalore traffic and rain! Though the title says Wednesday, it was held on a Friday to help everyone take out time from their busy work schedules. And what a great way it was to kick start the weekend. They were great 3.5 hours of networking, knowledge building and fun.
Read More
Taking forward the issue presented in the last post. I would like to present another instance with the maintenance of Google Analytics tags. Here the problem was due to negligence in the initial stages of GA tag implementation. The result was similar, misleading metrics that presented a completely false picture about the client’s website traffic.
The problem
The client is a leading bank in US, with over 119 years of experience in providing banking services, specializing in home loans and wealth management. We handle the Web Analytics reporting, Analysis and Implementation services for their website. I came across a particular issue related to the data shown in GA. There was certain abnormal data that was being shown in the client’s Google Analytics account.
Read More
