Category Archives: analytics

2013: My year on Indian e-commerce sites

Just had this idea of checking and analyzing how much money I spent on various e-commerce sites and doing what. So here’s a quick post sharing the same with the hope that it might be of interest of people running various e-commerce sites or thinking of doing so in future.

In the year 2013 I swiped card/availed COD across Flipkart, Jabong, Myntra, Amazon etc. Here’s quick glance of my purchases

1) Flipkart – Items Purchased: 58, Amount Spent: Rs 50,218

items purchased on flipkart
Split of items
Split of amount spent
Average price of a book I purchased on Flipkart is Rs 299 and average price of a footwear is Rs 876 (3 shoes and 4 sandals/flip flops)

2) Amazon.in – Items Purchased: 7, Amount Spent: Rs 6,598

Great thing about Amazon is that it already provides you an option to see all the purchases you made in that year
Search Order HistoryHere’s the split of purchases (6 books worth Rs 1,599 and a Kindle worth Rs 4,999)

Split of purchases on Amazon.in

3) Jabong – Items Purchased: 1, Amount Spent: Rs 1280

*I actually bought two items but had to return one for poor quality (return process was super smooth though)

Purchased a clothing item worth Rs 1280 during GOSF

4) Myntra – Items Purchased: 2, Amount Spent: Rs 3854/-

Purchased two clothing items worth Rs 3,854/- during GOSF

5) Others

a) Yepme: Items Purchased: 2, Amount Spent: Rs 998/-
b) Inkfruit: Items Purchased: 7, Amount Spent: Rs 3,738/-
c) Shopclues: Items Purchased: 1, Amount Spent: Rs 42/-
d) Bookadda: Items Purchased: 1, Amount Spent: Rs 667/-
e) Purplle.com: Items Purchased: 1, Amount Spent: ~ Rs 2500/-

Summary (Items Purchased: 80, Amount Spent: Rs 69,895/-, Spent some 8K during GOSF, alone, Spent some 11K on online bill payments/recharges)
item_vs_amount

A peak into my mind as an online shopper
1) Convenience very important but not more important than discounts. Moved my bill payments online. I do all my bill payments and DTH recharges on Paytm
2) Almost all my purchases have been via desktop (haven’t got myself to buying things via apps/mobile site yet.)
3) I’ve crossed the chasm from COD to swiping cards. I now prefer to pay online for most of my purchases. I don’t hesitate to swipe card for my first purchase on sites I’ve heard good deal about (Myntra, Jabong, Shopclues etc). Earlier my first purchase on a new site was on COD
4) I got comfortable enough to made a big ticket purchase (bought a laptop for around 30K from Flipkart)
5) Discounts/Offers have an influence on my purchase behaviour (both on pre-decided buys and impromptu purchases). I spent some
6) I trust most sites to deliver goods on time, offer quality goods and a customer friendly return/exchange policy
7) Flipkart’s scan (barcode) and search feature is quite handy for a quick online vs offline price comparison
8) I’ve grown to compare prices across sites before buying anything. I definitely use mysmartprice to compare book prices
9)  Wishlists and notifications are a great way for me to store items and decide when to purchase
10) As a heavy user I’ve figured some hacks to avail the max discount on certain items across some sites;-)

 

The Conversion Funnel – Part One

The concept of conversion funnel is quite old and surprisingly still not as widely used/referred to.  Be it an e-commerce website or a social network, there are two, rather three aspects of workflow and analytics

  1. Getting customers – Acquisition
  2. Getting them to do “something”  –  Conversion
  3. Getting them do “something” again and again – Retention

For e-commerce sites aka pipes the conversion is applicable for customers only, while for social networks and other sites aka platforms where value is created and consumed by two parties we have to keep in mind conversion for both of them to be able to achieve the end goal.

Let’s consider a job portal and see what the conversion funnel for it will look like.

  1. Visit to home page
  2. Visit to job category page
  3. Visit to job listing page
  4. Apply to job

Note: All these steps don’t necessarily need to be followed in the same order. For ex:  A visitor can land directly at a job listing page via Google search

The above mentioned four points are the simplest way to accomplish task of applying for a job but there could be a lot of other variants which though complex/indirect but would still reach to same goal.  For instance instead of clicking on a job category page link the user does a search and goes to search listing page. One way to look at such alternate paths is to create a funnel for each one of them

conversion_funnel_jobssite1

These are some of the possible routes (for ex: some visitors would neither search or browse and just exist from home page itself). In best case scenario you should know precisely the split of people who searched, browsed and  existed. Further, you should create separate funnels or each search and browse loops.

Let’s say the home page had 100 visitors. Searched = 30, Browsed = 55, Exits = 15

The conversion funnel for search would look like

Visits (100) -> Search (30) ->  View job listings(10) -> Apply(2)

The conversion funnel for browse would look like

Visits (100) -> Browse(55)
1) ->  View job category page (15) -> View job listings(10) -> Apply(3)
2) ->  View job listings(40) -> Apply(5)

 

By considering  the drop off at each stage you would be able to pin point the problem. For instance if  only 1/3rd people are clicking to view job listings after search, maybe the search isn’t that efficient and needs to be worked upon. You could further zoom into this by dividing all searches into two categories.

  1. Searches for which some results were shown (20)
  2. Searches for which no results were shown (10)

In the above example only 20 searches had results against them, which means the click through rate for search is 50% and not 33% as perceived earlier. Now could consider improving this rate and on the side figure out how to reduce the cases in which no search results were shown.

Similarly from View listing to Apply. You can break this task into the below mentioned to be able to see the exact stage of drop off

View job listing -> Click Apply Button -> Login/Signup -> Apply

I’d end this post by stating that, you should try to use the workflows/flowcharts to identify various stages of a user goal and then analyze data across them to be able to identify the issues and fix them

To be continued…

First Google Analytics Conversion Univeristy Conference in India

I along with a few friends from Twitter attended the Google Analytics Conversion University Conference at Gurgaon. This was the first such conference by Google Analytics in India and we were lucky enough to be a part of it. The agenda of conference included introduction of GA for begineers, sharing more about their partnership programs, advanced features, adsense/adwords integration, webmaster tools and website optimizer.

The conference had about 100 attendees(or less?) from mostly, sem/ppc background. Folks from Digital Agencies and SEM companies formed the major chunk. Interestingly enough about one third of the attendees were from outside Delhi/NCR, with people from Mumbai and Kerala forming a considerable chunk. Most of the speakers too were from outside of Delhi with Jesse coming straight from Mountain View to present at the conference.

Given the professional and business oriented audience, the content was strictly focussed around getting most out of GA and eventually how you can use it to get more/spend less $$. The thing about analytics is that everyone knows it but not everyone does it, so the conference was a good reminder that you need to actually checkout the data being captured and use it to drive results.

Jesse made his point by saying “Not having goals on GA is like being a 35 year old guy who doesn’t have a job and doesn’t know what to do with his life, no goals” . So if you too haven’t configured goals in your GA, it’s time to do it and if you don’t know how to go about it, ping  me.

Tracking Bounce Rate, Outgoing Traffic, Custom Segmentation etc were some other things that I was reminded to spend some time on. BTW Are you tracking them ?

The best thing about Google Analytics(other than the fact that it works) is that its FREE, free not just for individuals but free for enterprises. Isn’t that cool ? Another great thing is that you as individual get access to the same set of features that an enterprise gets, i.e. it’s not that the free version has lesser features than paid enterprise ones.

Is it a good question to ask if Google Analytics is free, how does  Google benefit ?
Vivek, one of the speakers mentioned that amongst other things GA drives more money to adwords. Fair enough

All in all, GA conf @ Google’s gurgaon office was a fun event with great learning and networking opportunity.Good food and free wi-fi were nice addons.

You can also checkout people’s tweets by searching for hashtag #gacu

Thanks to the guys at getgaready for organizing it.

Conference Goodies

1) GA Tooth Brush: Yes, a Tooth Brush that reads “promoting good website hygiene”

GA tooth brush2) GA Thumb/Pen Drive:

GA Thumb Drive

3) GA Tee-Shirt:

GA Tee Shirt

Update: Here’s Tatvic’s presentation on Conversion Tracking from the conference

View more presentations from anilv13.

Google Analytics Conference in Gurgaon: 8th August

Hey Guys,

Wanted to share the news that there’s going to be a Google Analytics Conference under Google’s “Conversion University” in Gurgaon next month.

converation_university

The speakers for the conference include

conference_speakersYou can checkout the complete list here.

The event is completely FREE of charge. You can Register on the website and your attendance will be confirmed by email a week before the event. The invite is non-transferable and there will be no spot registration.

Here’s the agenda for the conference

conv_agenda

Date: 8th August

Place: Gurgaon

Venue:  Google India Pvt Ltd, 8th and 9th Floors, Tower C Building No.8, DLF Cyber City, Gurgaon, India.

Map:
http://www.getgaready.in/venue.html

Checkout  http://www.getgaready.in/ for more details