Using Google Analytics to reduce PPC cost

Posted on January 12, 2012 by rajan

Are you tired of spending a lot of money on keywords to drive traffic to your site?

Well the solution to this can be as simple as just closely monitoring your Google Analytics data. This data can help you lessen your expenses when you are bidding your keywords in Google Ad words.

Let me show you how this can be done: Continue reading →

Tracking QR Codes with Google Analytics

Posted on January 4, 2012 by yoshika

Measuring online marketing campaigns was always possible but measurement of offline marketing to understand how it affects the online visibility of a particular company was a challenge.

But now this gap is almost filled by the introduction of QR codes, seen by most of us in magazines, newspapers, TV commercials etc.

QR code or “quick response” is the code which can be easily scanned by mobile devices and quickly direct the person to the required website. This code helps in accessing the resource instantly. This way we can measure how offline campaign is leading traffic to online platforms.

But how will we attribute the visits coming from QR code to a particular website? It is as simple as campaign analytics and be easily done using URL builder, provided by Google for Google analytics users.

Here are some steps which will help us track visitors through QR codes: Continue reading →

Measurement Plan and Campaign Analytics

Posted on December 14, 2011 by swathi

Big enterprises that run massive campaigns end up making a crucial mistake at the very beginning and that mistake is not making a measurement plan for the campaign.

At the end of each campaign, the stakeholders are drowned with reports from marketing, sales, merchandising and campaign managers. They are flooded with all kinds of metrics like CTR, CPC, visits, video views, photo uploads, discount coupon downloads, Facebook fans, Twitter mentions…. the metrics and reports are never ending and none of them tell you in plain simple language if your campaign was a hit or not!

‘Measurement plan is a document that states all the metrics that determine the success of a campaign.’ Simply put, a measurement plan acts as a target or even as a benchmark (if you have run similar programs in the past) for your campaign.

Here is an outline of what a measurement plan should ideally contain: Continue reading →

Why Analytics and Adwords Conversions differ?

Posted on December 8, 2011 by chaitanya

Every month after I send the monthly report to my client he always comes up with one question, “Can you please see why Analytics and AdWords are reporting different numbers for PPC leads? Which one is correct and what is causing this discrepancy?”

I am sure this question would have crossed through many of our minds too. Due to several reasons, data collected by javascript and cookie creation cannot be 100% correct. There can be many possibilities here. Continue reading →

Building ‘Data Blocks’ with Omniture Excel Client

Posted on November 29, 2011 by rajan

We analysts are in love with Microsoft Excel as it helps us view and manipulate data in numerous ways to gain more insights.

Most of the analytics tools give us the data we require, but consuming it on Excel is even better.

Omniture Excel Client helps you get your data on to your Excel sheets by a click of a button. Yes, it’s one powerful Excel addin which can pull data from SiteCatalyst on to your Excel.

What’s the benefit of this? You can access your data just by building data set blocks for one time and use it whenever you want by just refreshing the data set. Also, you can have direct interaction which means you need not edit the data block to change any filters. Continue reading →

Tracking Visitor Traffic via ‘Bookmarks’

Posted on November 24, 2011 by chaitanya

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.

Continue reading →

Data Visualization with TREEMAPPER

Posted on November 17, 2011 by swathi

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. Continue reading →

Macro to separate Branded and Non-Branded Keywords

Posted on November 9, 2011 by basavanna

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. Continue reading →

Launching ‘Omniture Discover’ without logging on to ‘Site Catalyst’

Posted on November 3, 2011 by rajan

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? Continue reading →