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.

Monday, July 08, 2013

Google rolling out favicons in adwords ads

Sometime back, there was news that Google was testing favicons for ads served through adwords. There were reports that ads on search result pages were getting the favicons.
Finally, Google has rolled out the ads on adsense ads served on third party website via display network.
Adsense ads with favicons
By rolling this out, Google is allowing website owners to provide more of their branding on their ad copies.

Sunday, July 07, 2013

Bus operators in Indian Metros - A Comparison

Buses take up over 90% of the public transport in Indian cities. To entice people to make use of public transport, the facilities and services offered by the public transport authorities should be improved. In this context, the need to compare and analyse the performance and statistics of the major bus operators in metro cities becomes essential.
Bangalore Metropolitan Transport Corporation(BMTC), followed by Delhi Transport Corporation(DTC operates the maximum number of buses in India.
Bus fleet strength of bus operators in major metros
 Chennai (MTC) has the lowest number of buses among the four major metros.
Daily distance covered by the buses in a day(in lakhs)

Staff per bus
BMTC has average of 5.2 employees per bus. Comparatively, 6.47 employees per bus. Obviously, MTC has invested unnecessarily in an ineffective workforce, since BMTC is able to operate efficiently with its ratio. MTC needs to improve employee efficiency and also increase the number of buses in its fleet.

An Analysis of MTC

As visible from below graph, MTC's fleet strength has been increasing year over year, even if at a slower pace than other bus operators.
 Even as the fleet strength is increasing, some mysterious impairment is causing the distance covered by a bus per day and the passengers transported per day to decrease to 2008 levels.
One would normally expect the passengers carried per day and the distance covered per day will increase when the bus fleet strength increases.
Potential reasons could be,
1. Mismanagement of resources
2. Heavy increase in traffic impeding bus operations
3. Dominance of share autos
4. Increased ticket fares
(3 & 4 updated, thanks to  comment from saratchandra kakarla)
Whatever be the reason for the downfall, it is in the best interests of the people that the MTC should find the source of problem and address it to provide a better service to the country.

Nevertheless, it is a good initiative that the Chennai and Bangalore bus operators have published their performance details on their websites.
MTC Performance 
BMTC Performance
It would be beneficial if other bus operators too published their performance details.

Myntra buying Youtube masthead often? seems to be on the Youtube's masthead banner often these days.
Rather than customizing the banner with rich content as most advertisers do,  Myntra chooses to have a simple image banner as below.
In a related news, Myntra is supposedly looking forward to raising $100 million in another round of funding.

Wednesday, May 15, 2013

Nokia India betrays early Lumia 920 buyers

Nokia India has managed to betray loyal Nokia buyers who bought the Lumia 920 as soon as it arrived on the market.

Nokia Lumia 920 was available in the Indian market in second week of January and users who were long expecting a Windows 8 phone from Nokia bought it as soon as it landed. It was a huge disappointment to the buyers that the wireless charger was not part of the standard accessory even as wireless charging feature was trumped as one of the unique selling points of Lumia 920.

In May 2013, after 5 months, Nokia has announced that they will give the charger for free with the purchase of a new Lumia 920.
The question is, what about the early loyal Nokia buyers?
Nokia should have announced the offer earlier.
Or should allow existing owners to avail the offer or atleast offer a large discount for existing users to buy the wireless charger.

Nokia Australia and Nokia UK had earlier announced a free wireless charger to existing Lumia 920 users.
What's stopping Nokia India from doing the same?

Nokia has let down its loyal users.
Will Nokia make up with its loyal customers?

ps: For those looking for availing this offer, visit the Nokia India store or any of the Nokia showrooms.

Wednesday, March 13, 2013

Kissan Tomato ketchup and recipes on Youtube India homepage

Kissan (Hindustan Unilever) has taken Youtube India's masthead ad.
The ad is for Kissan' Tomato ketchup and features a mini flash game wherein a kid running away from food needs to be captured and brought to the dining table.
After few unsuccessful attempts, the user is advised to put the sauce on the breakfast (chapathi) after which the kid automatically comes and eats the chapathi.

Kissan Ketchup's Youtube India masthead ad
Kissan is promoting their tiffin recipes in this ad campaign which in turn promotes their ketchup and fruit jam.
By promoting the recipes, more users will be encouraged the products more often.
Interesting concept and implementation by Kissan's marketing team.

Video of the ad implementation:

View video on Youtube

Agency : Unknown
Ad type: Youtube India home page masthead
Landing page: Youtube video page
Lead capture:  No online lead capture. (To get tiffin recipes, give missed call on 093203 93203 . Also promotes Kissan's Facebook,YouTube and Twitter pages. )
Campaign response: To be updated shortly

 Kissan got overwhelming response in their earlier Kissanpur campaign.

Thursday, March 07, 2013

Sony Music India's song trailer strategy for Tamil film Kumki

Usually Indian film songs were much sought after. Music studios with the music rights ensured that the songs are not freely available online, so that they can make money by selling the music cds.
But, ad-ridden song piracy websites usually made huge volumes of ad revenues by giving away the songs online for free.

The music studios used to complain to file hosting services and tried to take the audio files down, but the pirates always re-uploaded the files somewhere else. This used to be the usual trend.

But, Sony Music India changed the trend, when they made available online, the full songs of Kumki on YouTube. Their strategy was super-hit since these videos served as trailers to the movie itself, since the songs were published online months before the movie hit the theaters. The videos promoted the movie in a big way by showing stills from the movie in addition to the lyrics.

The Youtube page screenshot for the Youtube record breaking song

At this time of writing.the songs on Youtube had the following views.
Soi Soi song - 20 million views
Sollitale Ava Kadhala song - 10 million views
Onnum Puriyala song - 9.5 million views
Nee Yeppo Pulla song - 4.4 million views

The Song lyrics in the Youtube video

These Youtube videos, in addition to promoting the film, contains links to Flipkart Flyte, iTunes and Ovi store for purchasing high quality MP3s.

Promotional still within the song - making it a "song" trailer for the movie
This digital marketing strategy should be applauded for the innovative approach and execution. In fact, the search engine strategy also worked well with this implementation and drove visitors to the official website.

Kumki songs - SEO benefits for Sony Music's Youtube profile

Saturday, February 09, 2013

Top 10 Infrastructure companies in India

Top infrastructure companies in India, their founders and their history.

Construction Week online had published the Top Infrastructure companies list in India based on various parameters such as equity, corporate filings, marker perceptions etc. This article examines the top 10 infrastructure companies, their founders, history and notable projects.

1. Larsen & Toubro

Started in : 1938
Order book value: Rs. 1,30,000 Crores
Founders: Henning Holck-Larsen and Soren Kristian   

The two Danish engineers came to India and set up their small office at Mumbai. Their office was so small that both of them cannot be inside at the same time.

Henning Holck-Larsen (1907 - 2003)
Soren Kristian Toubro (1906 - 1982) 

Notable projects:

L&T - Gujarat Refinery for IOCL
L&T - Fertilisier plant for NFCL, Kakinada
L&T - Many critical components for PSLV

L&T - Krishnagiri-Thopur,Tamil Nadu - Krishnagiri bypass by LnTIDPL

L&T - Panipat Elevated Corridor by LnTIDPL

L&T - Coimbatore By-pass,Tamil Nadu by LnTIDPL

2. Jaiprakash Associates

Started in: 1979 
Order book value: Rs. 55,000 Crores
Founder: Jaiprakash Gaur

Jaiprakash Gaur

Notable projects:
Jaypee Group - 1450MW HEP at Sardar Sarovar Dam,Gujarat

Jaypee Group - Yamuna Expressway

Jaypee Group - 1000 MW Karcham Dam on River Satluj, H.P.

Jaypee Group - Cement Blending & Gridning Unit at agheri, UP

3.  Lanco Infratech

Started in: 1979 
Order book value: Rs. 31,016 Crores
Founders: Amarappa Naidu, Venkata Rama Naidu and Venkata Ratnam Naidu 
In 1960, the three brothers,  laid the foundation of LANCO by starting a transport business with one truck (a converted bus) inherited from their father L.V. Subba Naidu.
(founder's photo unavailable)

 Notable projects:
Lanco Infratech -Devihalli Highways

Lanco Infratech - Udupi Power Corporation Ltd (UPCL) at Yellur in Udupi district

4. Reliance Infrastructure Limited

Started in: 2002
Order book value: Rs. 28,000 Crores
Reliance Infrastructure limited was renamed from Reliance Energy in 2008. Reliance energy was formed by acquiring Bombay Suburban Electirc Supply (BSES)

Notable projects:
Reliance Infrastructure -Delhi Airport Express

Reliance Infrastructure - Nanded Airport

Reliance Infrastructure - 2 x 250 MW Coal based Thermal Power Station at Dahanu, Maharastra

5. GMR Infrastructure

Started in: 1978
Order book value: Rs. 24,000 Crores
Founder: Grandhi Mallikarjuna Rao
G M Rao established the GMR business empire starting from a single jute mill in Rajam, located at Srikakulam district of Andhra Pradesh in 1978.

 Notable projects:
GMR - Hyderabad Airport
GMR - Delhi Airport - Interior view

6. Punj Lloyd

Started in: 1978
Order book value: Rs. 23,938 Crores
Founder: Atul Punj

Atul Punj, third generation in their family business, started the pipeline division of Punj Sons Private Limited in 1982 which was later incorporated as Punj Lloyd Engineering Private Limited in 1988. The company was rechristened Punj Lloyd Private Limited in the following year and subsequently became Public Limited in 1992.
Atul Punj

Notable projects:
Punj Lloyd - Bangalore Metro Rail

Punj Lloyd - Heera field redevelopment for ONGC

Punj Lloyd - 4 x 250 MW Thermal Power Plant Station, India for Jindal Power Ltd

Punj Lloyd - 5MW Solar power plant at Bap, Rajasthan

Punj Lloyd - 500 MW (2x250 MW) Chhabra Thermal Power Project

 7. IVRCL Limited

Started in: 1987
Order book value: Rs. 21,550 Crores
Notable projects:
IVRCL - India's largest desalination plant at Minjur, Chennai

IVRCL - Metro Rail at Byappanahalli Elevated Metro station for Bangalore Metro Rail Project (BMCRL)

IVRCL - Transmission Line , Jammu & Kashmir

IVRCL - Veeranam Water Supply Scheme, Tamilnadu

IVRCL- Kumarapalayam-Chengapalli NH BOT road project

8. Hindustan Construction Company

Started in: 1926
Order book value: Rs. 17,007 Crores
Founder: Walchand Hirachand

Walchand Hirachand, the son of a cloth merchant in Sholapur, Maharashtra, dared to dream big. As a nationalist, he found British rule offensive and resolved early in his life to fight it - not by joining the political struggle but by breaking the rules that forbade Indian businessmen from entering areas of enterprise that challenged British monopolies. By the end of his life, he left behind an empire that is considered the foundation of modern transportation in India.

Walchand Hirachand - Founder of Hindustan Construction Company

Notable projects: 
HCC - Koodankulam Power Plant

HCC - Mumbai Pune Expressway

HCC - Bandra Worli Sealink

9. Nagarjuna Construction Company Limited

Started in: 1978
Order book value: Rs. 17,000 Crores
Founder: AVS Raju

NCC Founder - AVS Raju

Notable projects:
NCC Limited - DMRCL Metro Line, New Delhi

10. Gammon India

Started in: 1922
Order book value: Rs. 15,100 Crores
Founder: John C. Gammon

John C Gammon

Notable Projects:
Gammon India - Hebbal Interchange, Bangalore

Gammon India - Gateway of India, Mumbai