5 Web Analytics Softwares (apart from Google)

The following softwares are also recommended for web analytics (or analyzing traffic to your website)

1) Index Tools (acquired by Yahoo in April , thats 2 months ago) and now reportedly free .It is considered comparable in most features to Omniture , the market leader (see below)

http://www.indextools.com/products/features.html

2) Omniture

The leading professional web analytics software. The only caveat is the premium cost.

http://www.omniture.com/en/products/web_analytics

3) Get Clicky

getclicky.com

4) Sitemeter (Small , useful for counting traffics, not useful for graphics rich sites)

www.sitemeter.com

5) Microsoft’s Answer (Adcentre -Analytics)

http://advertising.microsoft.com/advertising/adcenter-analytics

So here are 5 alternative ways to Google Analytics and thus have more , better control over your data.

The actual software used should be dependent on

your budget,

anticipated traffic and

subject matter domain of website.

Google’s fine print

Just read the fine print in Google Analytics,

Google’s (and its wholly owned subsidiaries’) total cumulative liability to You or any other party for any loss or damages resulting from any claims, demands, or actions arising out of or relating to this Agreement shall not exceed U.S. $500.”

“TERM and TERMINATION . Either party to the Agreement may terminate it at any time and for any reason.

Well , thats just standard legal clause right. Wrong.

It happened to me once when my gmail account got de activated for 1 day, as I wrote to larry@google.com and sergei@google.com , asking to stop their recruiter for spamming me.  If they (or any Googler) are reading this , please stop here right now, forgive me and I shall repent ………………………………………………………..for I need that gmail account still.

Anyways Google Analytics remains the best for tracking website performance.You can check website performance in terms of page views,time per page, location of visitors, trends in recency .frequency and duration of visits

Unfortunately it does not give you access to raw data from your own website, but gives you views , and slices of data .

The fine print says Google CAN use that data but you cant since, a record level data can be used for identifying customers using i.p addresses.

INFORMATION RIGHTS AND PUBLICITY . Google and its wholly owned subsidiaries may retain and use, subject to the terms of its Privacy Policy (located at http://www.google.com/privacy.html , or such other URL as Google may provide from time to time), information collected in Your use of the Service.

BLAH BLAH BLAH…

Unless You notify Google otherwise in writing, You hereby grant to Google and its wholly owned subsidiaries a limited license to use Your trade names, trademarks, service marks, logos, domain names and other distinctive brand features (“Brand Features”) in presentations, marketing materials, customer lists, and financial reports.”

7. PRIVACY . You will not (and will not allow any third party to) use the Service to track or collect personally identifiable information of Internet users, nor will You (or will You allow any third party to) associate any data gathered from Your website(s) (or such third parties’ website(s)) with any personally identifying information from any source as part of Your use (or such third parties’ use) of the Service. “.

Agreed on enhanced graphics, and functional design is extremely good for a free software. But it does allow the big G to own more of your data, which they cross sell for advertising.

Now if only Windows /Microsoft started giving programs for free by using advertising in their softwares. or Yahoo launched a tracking software .

Need for Economists in Corporate India

Corporate India has been caught on surprise on many counts recently and most of them are macro economic events.

These have been namely credit rate hikes, inflation due to oil prices (consequent demand for better salaries and attrition) , market entry of new players and above all the rupee appreciation that shave off nearly 1000 basis points off the profitability of unhedged exporters.

Add to this the uncertainty in stock markets over remote events in the sub prime mortgage market in the United States that has actually led to many corporates getting below expectation results in their listing or Initial Public Offerings despite good fundamentals.

All these point to need for better corporate planning and strategizing for economic changes and events especially in a networked world.

Table 1-Top Macro Economic Events that caught corporate India by surprise and their impact

? Credit Policy Hikes by RBI 2006-2007 leading to expensive debt.
? Rupee Appreciation and RBI steps including curbs on ECB.
? Oil Prices and Inflation.
? US Mortgage Market, Effect on Global Equity Markets including India.
? SEZ Policy and impact on communities (this is more of socio-economic topic)

The primary impact of this has been exporters like Infosys missing their earnings guidance due to rupee appreciation, corporates like WNS having lower listed prices ,rising credit costs including for banks , and considerable rework of SEZ plans for corporates like Tatas and Reliance.

These are the biggest names in India, so the impact of lack of econometric planning and forecasting on smaller players is likely to be more.

Most corporates in advanced economies have business intelligence units and economic strategy and planning units. They are used mainly for forecasting sales using scientific quantitative methods like base driver models, time series models and regression models to predict and anticipate demand and align corporate supply and demand chains accordingly.

The usual audience for them is at CXO or Board level advisory positions.

In India while many corporates have started creating these units they are yet to gain the credibility and respect that they would have got in Western Companies.

Main reasons for these are as follows –
depth of Indian academia in application oriented research and their ability to adjust to corporate demands,
skepticism regarding modeling techniques most of which are complex for end users and corporate audiences ,
lack of investment in forecasting soft wares (like SAS , SPSS and even Excel/Solver ) and human resources in these units.

Most Indian corporates would rather hire five more sales managers than invest in two economists who would help create a much better forecast to help plan the corporate strategy.

This is partly due to historic mindsets and partly due to cultural risk aversion, as corporates engage in cost cutting, sales is looked upon as revenue units and planning units are cost centers. An additional complicating factor is that many companies still believe in push based sales, rather than pull based demand targets.

Table 2
Examples of Business Intelligence Units / Planning Units in Indian Corporates.

ICICI
Reliance
Muruguppa Group
Airtel

Examples of Business Intelligence Units / Planning Units in other countries.

General Motors
British Telecom
Nestle
Citigroup

An alternative for corporates unwilling to go into full fledged economics planning units is to become subscribers for customized content providers by third party providers.

This content could be in the form of business research, market research and segmentation studies, predictive models or even economics newsletters. The chief drawback to this is that due to the outsourcing and Knowledge Process Outsourcing boom, sales margins for third party content providers is much more when catering to the global market.

However even for the outsourcing sector it would be advisable to keep a foot in the domestic market, keeping in mind long term growth plans of Indian corporates and the ability to build domain expertise much better while catering to onshore Indian clients rather than offshore global clients. In the short term, these would be lower margins but it would help in building the domain expertise necessary for them to move up the value chain.

As the Indian economy is poised for sustained growth, the size and scale of this domestic demand for economics content would likely scale up manifold. Indian corporates should actually benchmark their demand planning and economic units from international players and partners

Predictive Forecasting in Commercial Applications

Most organizations tend to have a sales plan or forecast for the next 1 year.This is done for internal planning as well as give guidance to financial investment analysts covering the listed company.

However a lot of organizations use simplistic linear models of

1) either growth based on previous history (Last year Sales * Factor of forecast (e.g 10 % growth in sales) -TIME SERIES APPROACH

OR

2) growth based on macro economic causal factors (e.g economy is in recession hence sales will grow by 3 %) REGRESSION BASED APPROACH and

3) A consensus of industrial factors (We have spare capacity of 10 % so we will likely slash prices and have sales growth of 2 % but profit growth of -3%) DELPHI BASED APPROACH (this is also based on bottoms up market feedback and top down sales pressure).

A better approach is to combine all these approaches in one or different models .

This can help build a much more robust forecasting model for organizations using nothing more than simple combination of excel cells.

The following model assumes only seven factors and tries to build a stable and relatively easy to understand forecast model.

Forecasted Sales for this quarter =

Historic Sales for this quarter last year *A1

+ Historic Average Sales for this quarter for past three -five years (based on industry cycle ups -downs)*A2

+ Historic Sales for this quarter/Actual Sales of Last Quarter( for seasonal factors )*A3

+Causal Factor 1 ( Eg. Outsourcing is likely to grow by 15 % in this year) *A4

+Causal Factor 2 (Foreign Exchange Movement.Dollar is likely to depreciate by 10 %)*A5

+ Causal Factor 3 (Our bench strength is likely to grow by 3 % in this quarter)*A6

+ Percentage Error Factor *A7 (There will always be +-5 to15 % error in forecasts.Capturing this error also helps provide a feedback loop for planning).

Here A1- A7 are constants

In order to get actual values of A1-A7 , run this a regression (use the add-in and tools menu in excel) on actual data for past three years quarters (keeping last six months seperate)

Then run the actual equation on last two quarters and check for actual error. If error exceeds the comfort level (+-3 % for critical industries and +-15 % for harder to predict industries) . Iterate the last two steps till you get a good equation.

Then substitute in the 7 factor predictive model to build your simple and robust sales plan for this quarter.

Happy forecasting !!!

For beginners interested in software

1) For web development , get  into http://www.wordpress.org and its a pretty easy software to start making websites on.

You can maybe spend say 10 $ a month so that you can buy some server space on http://www.bluehost.com and tinker with his own website /blog in the meantime.

For learning language CSS ,PhP and HTML are the way to go.

2) If you knows some languages already, try  to make a Facebook application , and then play with Google’s open social API,or game, as that will get his interest besides giving him a skill thats useful. Ipod developer’s kit is another hot area to experiment.

3)For designing software solutions I would recommend the Microsoft Certification program. Try  to learn 1 language like Visual Basic or into .Net programming.These platforms will still be useful in coming years.

4) For statistical/business software try  to learn a language called R, which is good for data mining (www.r-project.org) . its quite easy to learn and has a good graphical user interface too.

5)For software careers it is best to learn multiple types of softwares to hedge your bets.

For sustaining interest, you  can join and network with fellow programmers using bulletin boards especially boards on http://www.google.com for google code and microsoft developers area..

6) You can also download Ubuntu linux (www.ubuntu.com) , which is a free Linux based Operation System (like Windows) and  be more familiar in it. Also add openoffice from http://www.openoffice.org This gives you perspectives on open source software.

7)I recommend him getting summer internship in a software startup (especially any software company in Silicon valley or Bangalore) ,and with established companies (like http://www.google.com , http://www.facebook.com,www.infosys.com

Software developers are the un-sung heroes of today’s modern world!!!

All the best !

Easy Ways to Secure Network Data

 Easy ways to secure network data without letting your IT team into fooling you in more servers  or certifications than you need.

1 User login passwords can be cracked and even the encryption will eventually need a password too. Most people use rather easy to crack passwords anyways.

2  you can use or even insist on the password feature within office documents , and within zip documents, and within outlook pst files.

The actual practicality is that people rarely keep track of multiple document passwords, and once a password is known /guessed , it compromises the whole system ..say for an ex employee,keyboard loggers, other ways to read data directly from the hard disk etc.

That cant happen for encryption.

So I would first implement a strong password policy , which is the first step for any company. This means using special characters, characters,numbers and automatic changing of passwords after 1 month.

3 Also laptops should have desk locks provided and compulsory before going away from the desk.

4 The next layer is encryption for data using private key/public keys and for login to the desktop/laptop .An inexpensive encryption solution is to use PGP (Pretty Good Privacy ) for encryption. You can also have open source free encryption softwares .

5 Another layer is have closed circuit cameras or motion trigger alarms in the office activated after say 6 pm or after office hours.

6 Implement multiple solutions using a test control approach on various PCs and then evaluate usage for 1 month before deciding with the big contract.

7 ISO 27001 or BS7799 and certifications help make clients comfortable, but do not enhance data security in any special way given the huge costs.

8 Have training videos for social networking used by hackers or people breaking in to system. Eg. Calling Board numbers for cell phone numbers

9 Try and eliminate as much paper as possible. Printouts, faxes etc. A compnay I know replaced all paper with blue paper just to impress clients. Same principles applied when guards were checking senior management bags. No searches etc.

This is also good for environment too (Use that for impressing clients !), and its better to buy bigger monitors or have an encrypted wireless lan than  have tonnes  of paper too.

All systems can and will be broken given time and resources to deviants. Using these steps reduces the ease and probability of laptop loss escalated to data loss in wrong hands.

Ning with the Xing

Recently created a social network on www.ning.com.The site is quite cool , as it allows you to create your own social networks.

It has features for blogs,forum,ADS,rss and even Open Social Gadgets. You can view my bad attempt at creating a social network here …http://startupsindia.ning.com/

If you plan a more commercial venture the rates are even more decent,from the Ning Site

Run ads on your social network
You can use any ad serving service you’d like. You can also use this premium feature to protect your social network from showing any ads at all.
$19.95 per month
Use your own domain name
If you own your own domain name (also known as a URL or website address) and want to use it for your new social network, you can.
$4.95 per month
Remove Ning promotional links
This will remove the “Create Your Own Social Network” button from the top of your social network.
$7.95 per month
Increase your quota
If you are concerned that your new social network will exceed 10GB of storage and 100GB of bandwidth, you can purchase more storage and bandwidth from us.
$9.95 per unit per month

 ”

And I got interviewed on my views at another much better Ning Network called Analytic Bridge. You can view the interview here .And post comments .

http://www.analyticbridge.com/group/interviews/forum/topic/show?id=2004291%3ATopic%3A11703