Wednesday, August 14, 2013

IRCTC's latest error message : 403 - Forbidden: Access is denied. Sub Code 107

IRCTC has managed to give yet another error message to annoy its users.

IRCTC- 403 - Forbidden: Access is denied. Sub Code 107 

IRCTC, India's monopoly train ticketing provider is already infamous for providing aberrant service to its users. They have even tampered the ClearTrip train booking service to require a IRCTC login. Now, they hae their website go completely down and are providing a forbidden error message.

Wednesday, August 07, 2013

Adsense Revenue by Keywords in Google Analytics

Setting up Google Analytics - Adsense Integration allows Adsense data to be viewed from Google Analytics interface. By default, the Adsense Report section contains the following tabs.
Adsense Report on a Adsense integrated Google Analytics Profile
The default data reports are limited to showing Page level revenue insights.
Overview Tab,
The "Adsense Page" tab shows the page level Adsense metrics such as Adsense Revenue, Adsense CTR, Adsense impressions, Adsense eCPM, Adsense Impressions etc.

Keyword level Adsense Revenue
It is important to know the keyword level revenue insights to be able to quantify how much each keyword for the website is contributing towards Adsense revenue.
For Page-wise keywords, this can be easily done by setting up selecting the "Secondary dimension" as Advertising>Keyword in the "Adsense Page" section of Google Analytics.

Page-wise Keyword Revenue in Adsense-Analytics integrated default report with Keyword secondary dimension
Even this does not show the individual keyword's contribution to the overall website rather than individual pages. Such a site wide keyword-revenue report is not available by default in Google Analytics. It needs to be set up as a custom report.
1. Google Analytics > Customization> New Custom Report
2. Select Adsense Revenue, Adsense Clicks, Adsense eCPM etc in "Metric Group"
3. Select Keyword in dimension drill-down.

The setup should look similar to below screenshot.
Adsense Keyword Revenue in Google Analytics - Custom Report Set up

We are good to go now. The report should as in below screenshot (except the yellow bar, of course!).
Adsene-Google Analytics Integration-Custom Report : Keyword wise revenue
Do comment if you need help/clarifications in setting this up.