Google Analytics Bounce Rate V/s Exit Rate

Bounce rate and Exit rate are 2 metrics whose definitions and names often manage to confuse analysts and this is one of my favorite topics to talk about in my Google Analytics trainings.
Let's start by Understanding official definitions of both.

Bounce Rate: The percentage of single-page session (single page sessions / total sessions ) %

Exit Rate: The percentage of exits from the property that occurred out of the total pageviews. (exits / pageviews )%

Read more...

Google Analytics Heatmap Calendar

  • Published in Tools

Few days ago I publushed a top about Google Analytics calendar heatmap and my few of my friends asked about availability of this feature on web / browser interface of Google Analytics. Altho this feature is not available right now on GA browser interface I hope Google includes this in GA roadmap. 

In the mean while you can use this spreadsheet add-on.

Using this Add-on is really easy.

  1. Install Google Analytics Calendar Heatmap Add-on on your google drive
  2. Click on Add-Ons >> GA Calendar Heatmap >> HeatMap config
  3. Fillow instructions on configuration sheet to provide details requested in column B
  4. Click on Add-Ons  >> GA Calendar Heatmap >> Build HeatMap

With this Add-on you can plot any GA metric as Calendar HeatMap for week.

If you wish to customize this Add-on you can find sourcecode ongithub

 ScreenShot of HeatMap

smallt

Read more...

Google Analytics Bulk URL Builder Spreadsheet Add-on

  • Published in Tools

Google Analytics Bulk URL Builder Spreadsheet Add-on is 1st tool published by me and hope it helps marketers in saving their time and effort. Install Add-On from chrome store

Why?

I have used several URL builders and the it always felt counterproductive to tag one URL at a time when a typical web campaign needs several URLs to be tagged with changes in landing page, creative, audience, etc. I have been using a macro in excel to get over this challenge but Google Spreadsheet Add-On gave me a way to share the same functionality with others.

How?


There are 7 columns in this tool, column 1 to 6 are input columns and column 7 is output column.

 

URl builder

Landing Page / Application ID: In this column landing page of your webiste (e.g. http://theniks.com/contact) or if you are running app install campaigns your application id. (e.g com.myntra.android) should be provided. 

Source: In this column source of the campaign should be provided (e.g. Google, Facebook, email, etc).

Medium: In this column medium of the campaign should be provided (e.g. CPC, CPM, CPI, email, etc).

Campaign: In this column name of the campaign should be provided (e.g. Brand Campaign, xmas campaign, Deewali campaign, etc).

Content: In this column banner theme of the creative should be provided (e.g. beach, snow, discount, headline of text ad, etc).

Term: In this column keyword which triggered the click should be provided (e.g. {keyword} for AdWords).

Although only Source is mandatory its recommended to have at least Source . medium and campaign.

Destination URL: This is output which you can use in your campaigns as landing page. 

 

Read more...
Subscribe to this RSS feed