Online Analytics -June Dershewitz

June Dershewitz

One of World’s Leading and Well Known Authority on Web Analytics

1) What’s the latest trend you see in Online Analytics over the next year and next three to five years.

I strongly believe that web analytics is on its way to becoming business analytics. In the early days we were solely focused on analyzing clickstream data, but in recent years we’ve relaxed our definition of web analytics to include things like voice of customer
and offline outcome data and multivariate testing. More and more I hear people talking about how online customer interaction fits in with the overall goals of the business rather than as an isolated island of activity. In the future I think we’ll see less of a distinction
between traditional business intelligence and what we currently consider to be the separate field of web analytics.

2) Tell us how you came in this field of work, and what factors made
you succeed.

I entered the field of web analytics in 1999. Like many people who got their start at that time, it happened totally by chance. I had applied for a job as a web developer, but the interviewer thought I’d be perfect for another open position – as a web analyst. I took it just to see what it was like. Here it is a decade later and I’m still in web analytics – so I guess you could say it worked out.

Why is web analytics is a natural match for me? Well, I’ve always felt quite comfortable

[Read more...]

How to do Logistic Regression

Logistic regression is a widely used technique in database marketing for creating scoring models and in risk classification . It helps develop propensity to buy, and propensity to default scores (and even propensity to fraud ) .

This is more of a practical approach to make the model than a theory based approach.(I was never good at the theory ;) )

If you need to do Logistic Regression using SPSS, a very good tutorial ia available here

http://www2.chass.ncsu.edu/garson/PA765/logistic.htm

(Note -Copyright 1998, 2008 by G. David Garson.
Last update 5/21/08.)

For SAS a very good tutorial is here -

SAS Annotated Output
Ordered Logistic Regression. UCLA: Academic Technology Services, Statistical Consulting Group.

from http://www.ats.ucla.edu/stat/sas/output/sas_ologit_output.htm (accessed July 23, 2007).

For R the documentation (note :Still searching for R ‘s Logistic Regression ) is here
http://lib.stat.cmu.edu/S/Harrell/help/Design/html/lrm.html
-

lrm(formula, data, subset, na.action=na.delete, method=”lrm.fit”, model=FALSE, x=FALSE, y=FALSE, linear.predictors=TRUE, se.fit=FALSE, penalty=0, penalty.matrix, tol=1e-7, strata.penalty=0, var.penalty=c(‘simple’,'sandwich’), weights, normwt, …)

For linear models in R -
http://datamining.togaware.com/survivor/Linear_Model0.html

An extremely good book if you want to work with R , and do not have time to learn it is to use the GUI
rattle and look at this book

http://datamining.togaware.com/survivor/Contents.html

Finding Outsourcing Vendors through Consultants

Consulting companies are limited to biases as most outsourcing companies (in India ) atleast have a big degree of ex consultants.

So each consulting company seems to have a prid quo quo arrangement or a favourite partner.

Outsourcing companies themselves have a lot of churn/attrition in senior management. So nearly everyone knows what the other rates /details are.

The industry average attrition is 40% and thats the annual growth as well.

The best way to choose a consulting/outsourcing company is to

a) ask for previous case studies as for your EXACT process

b) ask them about billing/salaries ratio for their staff for the outsourcer.

c) Ask about risk manaagement or change control processes in place for terminating or transitioning ownership, or even scenarios for changing vendors .

Why Do Indian BPO companies struggle more than Indian IT companies ?

1)different sales cycle and methods of evaluation- cost is the reason to outsource in BPO, capability AND cost is the reason to seek technology outsourcing. Sales cycle are longer and much bigger in IT companies, while BPO companies have a shorter sales invetment hence push for faster sales than a long sales cycle with mega deals

2)consultants are very good at generic processes, outsourcing requires a detail orientation and dealing with lower middle management to get the transitions requirements done correctly….

3) Most BPO’s hire the bottom half of top consulting firms or star salesmen who used to be stars. Sad but true .Ex consultants join PE funds if they are good, start ups if they are ok, BPO’s get the worst in that lot as they pay the least. Same for technology salesmen .

4) BPO is yet to mature in sales, pre sales processes and have a longer term view. It is a younger industry and I am sure IT outsourcing struggled in its initial days too.

5) Internal BPO HR practises-

Much higher levels of attrition in BPO lead to lower quality of delivery than in technology. Also experienced BPO delivery people,with zero sales experience, who stick around sometimes get to partner the new sales people onsite not because its good for the firm but only way to retain these people

6)Competition in BPO is quite ridiculous with rates touching 14-15 $ per hour for large deals, and quite many salesmen end up making discounts just to make that quarter or undercut the competition for strategic reasons.”

Margins are higher in IT companies in India .

Genpact and WNS are exceptions to this rule  due to sheer size and parental pedigree (GE and BA respectively), but most Indian BPOs/BTOs/KPOs less than 4000 people will suffer the above issues

Company Analysis using Yahoo Finance

bpoipo.PNG

Business Model-

The basic business model of Indian outsourcing companies is labor arbitrage and billing per hour rates are much much lower than the Indian IT companies.

This labor arbitrage model has suffered due to

high wage inflation in India,

high asset inflation in real estate prices, and

nearly 20 % fall in the dollar versus the rupee over the past one year. Revenues of this sector are mostly in dollars while costs are mostly in rupees.

Ownership-Most top management at atleast smaller outsourcing companies consists of ex consultants , who flocked to this sector after the decline in business consulting in 2001 economic downturn.

In the US , where nearly everyone who the company wants to retain is given stock options.

In the outsourcing sector, most stock options are very heavily concentrated in the hands of a few senior managers . This is unlike the Indian IT sector where even junior managers are given stock options.

Majority (or greater than 50 %) Ownership of nearly all Indian outsourcing companies is with non Indian promoters or PE funds .

Historic Post IPO Performance-

Valuations in the outsourcing industry for BPOs listed abroad but working in India can be calculated from this link. I did a basic analysis using yahoo finance at

http://tinyurl.com/29zuzx

 

 

IPO Analysis-

Only early stage VC, PE funds made money from Indian BPO/KPO ipo’s. International IPos of BPOs in India have destroyed value for most investors who bought it, except for EXL’s IPO.

It is thus more profitable to buy shares in Indian stock exhange than buy Indian company shares in an IPO listed aborad

Take a case study for the next Indian outsourcing company about to be listed on the NYSE.

CASE STUDY- PRE IPO ACTIVITIES BY INDIAN OUTSOURCING COMPANIES TO BOOST VALUATION

(BPO COMPANY ) is owned by An German, 1 American, 1Indians. It has been in operation since 2000, and it has slowly and steadily ramped up a 2000 strong employee company in 5 years

BPO COMPANY has the following approach to IPO’s . It has been plagued by high attrition of junior employees, relatively less diversification in the past but it needs to fix these before the IPO happens.

 

IPO FIX 1-ATTRITION NUMBERS

Since basic revenues are dependent on labor , the metric of attrition is closely tracked by potential investment bankers and prospective investors. The BPO company cliams to solve the industry wide problem by having the lowest attrition in the industry, despite having low average salary per employee and high revenue per employee.

BPO COMPANY claims to have lowest attrition numbers but it mis calculates many attrition as terminations and over calculates them as performance based go or grow exits.

IPO FIX 2 DIVERSIFICATION

The core business unit for BPO Company is business research which consists of writing content based on freely available sources . Newsletters writing and intranet content creation are also big revenue streams. Unfortunately most of them are under threat as free online tools on the internet enable both newsletters, and intranet installation for Content Management System.

As a low paymaster, it had significant problems ramping up non-business research business units like data analytics, which shrank from 50 to 3 in 2005-6. The legal outsourcing arm hasn’t reached any double digit numbers too.However by having these additional units, the BPO company can claim to provide wing to wing solution and aim for higher valuation.

IPO FIX 3-RETENTION The company announced promotions to all levels, thus giving many people double promotions within 6 months..This is planned to help smoothen attrition numbers just before the IPO. It also announced ad hoc raises to people, out of turn of normal bi yearly appraisal cycles.

It increased top management ranks internally by disguised promotions by 15 % just to beef up size from outside (we have 30 VP’s now)!!!

IPO FIX 4 -REGULATORY ARBITRAGE

The Indian ITES sector has the least level of regulation in India due to

1) it is a new sector 2) it has a lot of influential money players 3) it creates a lot of jobs.

BPO company uses this regulatory arbitrage in many ways. An example is as follws-

As per Indian law the company needs to give a certain amount of casual leaves.BPO company has a 5 day working week.

What BPO COMPANY does is it makes the last Saturday in every month a working Saturday on which it gives mass casual leave to the whole company as a cost saving measure to give casual leaves as a legal requirement to 1800 people.

1500 people go on a casual leave on the same day!

 

IPO FIX 5 – PRE ANNOUNCEMENT OF BIG CONTRACTS

It is currently negotiating with clients like consulting companies, for stake sales. This is expected to give a big contract announcement just before the SEC ordered silence period. It will also give it some nature of captive business as most of these big contracts are actually build operate transfer contracts with very few exit penalties for the client. The client also owns the infrastructure.

BPO Company thus creates off-balance sheet employees for the international client, and recognizes this revenue as a steady source of revenue for BPO company.

IPO FIX 6- SMALL STAKE PURCHASES

It bought a company called PLUTO for beefing up the balance sheet nearly 9 months before the IPO announcement, but has mixed results on level of output delivered as this is supposed to be a panel of experts, and expert outsourcing is difficult. However by a small acquistion it demonstrated abilty to integrate companies .

IPO FIX 7 -PRICING

By working at 15 $/hour, and overstaffing in the name of training (or free resources ), the profitability margins are very low but client volume remains high

 

IPO FIX 8- SALES COMMISSION

. Sales happen because company pays an industry maximum of 20 % to Client Executives on commission. However both these thinsg are unsustainable in the long run, so it gives some employees a L1 visa to act as sales agents in the US, thus locking attrition and sales costs at the same time.

IPO FIX 9-UTILIZATION AND RECRUITEMENT

BPO COMPANY is known for chronic stretches, and has aimed to be a player known for GOOD TRAINING ground in recruitment so it can take engineers from DCE, IIT and makes them work hard till 3-4 yrs, but at a low salary. These people (average age <25) burn out or move on in 3 yrs, thus enabling replacement by younger staff. The historic churn in employees is something that is not monitored , except for the last year before IPO.

IPO FIX 10- NEW OFFICES

BPO company claims to have international presence to reduce percpetions of country risk

By building 2 new domestic offices in past six months, and

2 new international offices in last year.

Nearly 80 % of the company is within 1 site, and business continuity plans and data disaster management are not tested due top cost of working from an off site location for a day.

IPO FIX 11- COST AND PR MANIPULATION

MARKETING-

BPO company creates a big public relations and proposal writing team, which is much disproportionate to size of BPO COMPANY as compared to other organization like the listed company GENPACT (G).

Activities includes modifying wikepedia to claim credit for inventing the term KPO, and dummy sites for search engine optimization.

OPERATIONAL Transport costs are actually paid by the employees of the company as rs 4000 per month cut form their pay. this enables the company to additionally cliam having lowest cost per employee of transport.

 

CASE STUDY RESULTS-

BPO company completed a 300 million IPO in Mid 2008, rewarding it’s PE holders,owners, and its key stake holders. Under pressure to meet quarterly results, BPO company started squeezing salary costs again, depending on young demographics of India to provide a supply of cheal labor, on the job training ,a nd client management by claiming this is an industry wide practise.

Due to dollar depreciating further, BPO company began shifting some Indian employees to this locations, but after asking them to sign a bond for continued employement.IPO was followed by the exit of key senior managers who then started up their own companies.