Category Archives: Data Analysis

How to select the best Excel charts for data analysis and reporting

Learn how to select the best Excel charts for your data analysis and reporting within 15 minutes. Learn about the various data types that can be visualised....

How to get Not Provided keywords in Google Analytics

Learn to get back 'Not provided' keywords in Google Analytics through these easy to use but powerful pro tips....

Bounce Rate Optimization in Google Analytics – Complete Guide

If people are not sticking around your website then it is highly unlikely that they will make a purchase or complete any other conversion. ...

How Google identify and measure social media engagement

  A long time ago, in a galaxy far far away, there exist a social media analytics company called ‘PostRank‘. It was launched in mid 2007 and was acquired by Google in June of 2011. PostRank Analytics was one of my favorite analyti...

Key Performance Indicators (KPIs) – Complete Guide

Introduction to Metric In the context of web analytics, a metric can be a number or ratio. So we can have ‘number metrics’ and we can have ‘ratio metrics’. Number metrics are in the form of numbers. For example: Visits, Pageviews, Revenue ...

Understanding Data Sampling in Google Analytics

Understand data sampling in Google Analytics. Learn to find and fix data sampling issues. Learn about data tables, single day & multi day processed tables....

Complete Guide to Direct Traffic Analysis in Google Analytics

Direct traffic is increasing day by day and if you don’t do anything about it now, then one day all you will see in your analytics reports will be direct traffic: little to no referral data, just direct traffic and your favourite ‘not provided’...

Google Analytics Tutorial – Understanding Traffic Acquisition

    Google Analytics is a powerful tool. But just like any other tool, it is only as good as the person using it. While some people are able to gain great insight through its creative usage, others are not able to move beyond page views and...

Making Good Marketing Decisions Despite Faulty Analytics Data

Google Analytics (GA) data is not very accurate and sometimes can lead to dangerous conclusions if you are not very careful. Don’t get me wrong, I am a big fan of Google Analytics. In fact I am two times GAIQ certified for this very reason. But at...

Google Analytics Mistakes that kill your Analysis & Conversions

Learn about the Common Google Analytics Mistakes that kill your Analysis, Reporting and Conversions....

Understanding the Analytics behind Google Adwords

  Index #1 Introduction to Adwords Auction #10 Ad position #2 Types of bids in Adwords Auction #11 Quality Score #3 Cost Per Click (CPC) Bidding #12 Google Ad Rank Algorithm #4 Cost Per Thousand Viewable Impressions (vCPM) Bidding #13 Secret to...

How to Analyze and Report above AVERAGE

Nobody wants to be average and yet we all love averages. That is why our analytics reports are all jam packed with averages: In order to analyze and report above average we first need to stop being obsessed about all the metrics which are ‘average...

Google Analytics Not Provided Keywords Analysis – Ultimate Guide

Google has been hiding keyword referral data from searches made by logged-in users since October of 2011. With every passing day, more and more searches are made by logged-in Google users. We therefore can no longer ignore the impact of ‘not provid...

7 Powerful KPIs to Measure your Link Building Outreach

    We all know how time consuming outreach for link building can be. We also know that time is money and majority of us charge per hour. Therefore it becomes very important that we measure our outreach efforts and reduce outreach cost. Thi...

Google Universal Analytics Data Trend Analysis – Complete Guide

Analysing data trends is an age old and powerful tactic which is used to measure the performance of marketing campaigns over time and to predict future outcomes.   We do trend analysis to get answers to questions like: 1. What are my top sellin...

You are doing Conversion Tracking all wrong. Here is why

The first question you may ask after reading the headline is, how it can be possible that my conversions tracking is all wrong? “Conversions always matter. If my website is getting conversions and I am tracking them then it is impacting the busines...

Google Analytics Direct Traffic – Most kept Secret

  Today I am going to reveal one of the most kept secret in Google Analytics which will fundamentally change the way you look at revenue and conversions generated through direct traffic for good. What you probably don’t know is, how Google at...

Exploring Google Analytics Pivot Tables

  Pivot tables are hidden gems in Google Analytics reports. They are extremely powerful data summarization tools and are commonly used in spreadsheet programs like Microsoft Excel. Through pivot tables you can quickly summarize data in desired f...

Analyzing and Reporting Conversion Rate in Google Analytics

The goal conversion rate of a website is 61.99%. Ok good. But what insight you can get from it and what action you can take? The short and sweet answer is ‘nothing much’. “Google Analytics add the conversion rate of each individual Goal and ...

What You Should Know about Historical Data in Web Analytics

Historical data in web analytics is important because it help in optimizing marketing campaigns but when interpreted incorrectly can result in monetary loss....