Sunday, June 19, 2011

mCommerce - Definition

Definition
Let's look at definition in wikipedia.
"Mobile Commerce is any transaction, involving the transfer of ownership or rights to use goods and services, which is initiated and/or completed by using mobile access to computer-mediated networks with the help of an electronic device."
 and Wikipedia also provides products and services available.

  • Mobile ticketing
  • Mobile vouchers, coupons and loyalty cards
  • Content purchase and delivery
  • Location-based services
  • Information services
  • Mobile banking
  • Mobile StoreFront
  • Mobile brokerage
  • Auctions
  • Mobile Browsing
  • Mobile Purchase
  • Mobile marketing and advertising
It's a very broad definitions. In different context, mobile commerce can mean different things. In my understanding, three products are mostly often referred as mobile commerce, mobile purchasing (in the context of retailing), location-based services (in the context of mapping of services) and mobile banking (in the context of payment).
So, it's important to specify the context when the term mCommerce is used.

Where will the jobs be?
Back to my interest, where will the job be? 
  • mobile purchasing: Yes. If mCommerce is considered as a special case of eCommerce. There are much improvement to be done for mCommerce, such as improvement on webpage design for small screen. It seems all technologies are there, but you still need to tweak them. 
  • location-based services. Yes. It's exciting to introduce one news important factor into traditional marketing. For example, product listing would be more specific when sellers know exactly where customers are.
  • mobile banking. Maybe not. Definitely it represents huge business value. Like credit card, it will enable transactions that are previously time consuming, such as payment with touch of mobile in supermarket.

mCommerce

Introduction: why am I interest into eCommerce
I started to be fascinated about the word since yesterday night. It starts from a job posting by Toys'R'Us. One of the requirement is to manager update of iPad app. Then I checked the iPad app for Toys'R'Us. I felt impressed. Browsing of products was intuitive. Designing of website is kids friendly. And then I used "Discvr apps" (one of the amazing app to visualize connection between apps and find news apps based on known apps) to explore related mCommerce apps, I was surprised to see so many retails shops has built apps in iPad, Target, Stop'N'Shop and etc.
Categories of products that has built apps in iPad
I was thinking if there are still some products not covered, and that would be an opportunity. My starting points is fixed basket of CPI.
Housing: 
   Existing apps like Realtor.com that provides information of house for sale
Transportation: 
   Existing apps like CarZen that provides spec/price of cars
Foods and beverage: 
   all sorts of online grocery shops that sells foods 
   Yelp that provide feedback on restaurants
   McDonald's provide an app to indicate all its branches around location
Recreation
   Disney provides apps for waiting time in its Theme park.
Medical care
   MGH has its own to promote its brand. Not that commercialized, but it's a start.
Appreal
   Lots of catalogers now have their iPad version. Cheaper and nicer (including some video of products)

There are lots of space for improvement, but one fact is obvious that all sellers are taking channel of mobile seriously and they start to work on it.

What I can do for these sellers
  • Develop apps: write process/documents to develop apps in screens of 4-5 inches instead of 17 inches. That's where MS fits in.
  • Collect customers' needs and translate into apps: marketing stuff
  • How eCommerce help to cut cost and drive revenue: strategy stuff


Thursday, June 9, 2011

A few thoughts about CPI in China

After I've read the book of "Principle of macroeconomics", I started to look into problems of macroeconomics around me. For US, most import problems are unemployment and trade deficit. For China, most important problem is inflation.

When I looked into CPI is China, I found it tricky in several aspects.

1. Weight of Items in the fixed basket is not transparent.
People estimate from published monthly that weight of items might be

  • Food  30.5%
  • Tobacco, Liquor and Articles  3%
  • Clothing 8.5%
  • Household Facilities, Articles and Services 5.5%
  • Health Care and Personal Articles 7.5%
  • Transportation and Communication 12.3%
  • Recreation, Education and Culture Articles 12.3%
  • Residence 20%
Compare with US CPI weight, Food is the biggest components in CPI, while residence is relatively small. In US, Food takes around 15%, and residence around 40%. Basically it reflects reality in China. Normal people is not rich, so lots of expenditure are needed for foods. And most of people are living in rural areas so that they can enjoy low cost of residence. That's why high price of commercial residence property is not reflected in CPI yet. With the development of Chinese economy, CPI weight in China is expected to be close to that in US.

2. CPI is not taken serious in China
CPI is supposed to be an important indicator to reflect real interest, but in China few people cares about CPI because of
  • Method to calculate CPI is not transparent. Weight, data collection and etc. Nothing is revealed on website
  • Data manipulation by National Bureau of Statistics in China. Some National Bureau of Statistics in China is the tool of government to achieve some kind of target.
Currently, increment of CPI in China is around 5%. Government expect to lower CPI through policies. To be peculiar, the government set price ceiling to control price. It is totally against mechanism of market. The following situation is expected to be seen
  • Short supply of goods. Shortage of power supply this year is due to that.
  • Unreasonable distribution of resource/profit among industries. 
In the end, I just hope government could be wiser and follow the rules in economics.

Wednesday, June 1, 2011

Real Estate Bubble and when it's over

What does real estate bubble relate to me?
I don't plan to buy house in US in the near future. But yesterday's published Case Shiller showed home price has dropped last quarter and invests are afraid of real estate bubble will impact whole economics so bad that there would be another round of recession. Then private sector will be very cautious to hire people and i will have small chance to be employed. It means I need to investigate into it.

What is real estate bubble and how this real estate bubble is triggered?
let's look at definition of real estate bubble in Wikipedia.
A real estate bubble or property bubble (or housing bubble for residential markets) is a type of economic bubble that occurs periodically in local or global real estate markets. It is characterized by rapid increases in valuations of real property such as housing until they reach unsustainable levels relative to incomes and other economic elements, followed by a slide in price levels over a number of years.
The figure of price index since 1988 explains how it increase rapidly and fall due to unsustainability. (dot line for index, while solid line for growth)
Khan explain the reason for bubble well in his video "The housing price conundrum". Summary of his video is that, price is based on supply and demand. From 2000 to 2006, demand effected by population and income almost stagnate, while  supply of new house increase slightly. Real reason behind hiking of previous home price is constraint for mortgage is loosen, while stimulates demand.

Which price level is normal level? or when home price will stop dropping?
From 2000 to 2006, there are lots of people who were not qualified to buy house actually bought house. Now these houses face foreclosure and these excessive supply lower current prices.
We can derive that, when these house which were bought by unqualified owners are all bought by current qualified house buyers, price will be back to normal. That's the base of the calculation. Also we need some addtional assumption,

  • 1990-1999 is baseline. Sales unit increase proportionally to population
  • 2000-2006 is the up hill of bubble time. Rational (or expected) sales unit is supposed to increase proportionally to population, but actually buyers bought more. The difference is excessively bought house.
  • 2007-Near future is the down hill of bubble time. Level sales unit stays at the level of 2008-2010, which is below rational (or expected) sales units. Now buyers are buying houses accumulated in 2000-2006.

From the calculation, in 2011, all accumulated excessive house will be bought by current buyers so price is supposed to be stable possibly Q2 of 2011. Radical reaction of stock market (2.34% of Dow) reflects only emotions of panic investors.

What does it relate to me?
Things will be better tomorrow. I will find a job. I have faith for that.
Maybe I should long stock index for a few days. Investors will realize bubble is almost over soon.

P.S. Risk the calculation
Whole calculation is sensitive to slope of sales unit. Several facts could affect the calculated slope.

  • income increase in 1990-1999, while it decrease in 2000-2009. So calculated slope might be larger than real one
  • 1990 and 1991, US just recovered from last recession, sales unit might be lower than expected. So calculated slope might be larger than real one.

When calculated slope is adjusted lower due to these facts, time need to be back to normal level might be longer. If calculated slope is only half original one, we need to wait till beginning of 2013 to return to back-to-normal level.

Correlate of Google Lab

Google can still be innovative. That's the one piece of proof.

What is Google correlate?
The story starts from Google trends. Google trends lists pattern of key words in time series.
It's natural to think it in a reverse way. If we know pattern, can we also get key word from the pattern? The answer is Yes with conditions. These patterns are supposed to be existing in Google database.
Next, if both are achievable, we correlate keys words that share same or similar patterns.

Features
This product provides two interesting features.
  • One is to search for similar pattern with input key-words/drawing/user-data. With it, we can find associated rule for products. (just one of many applications)
    Here is one test i've done. I inputed "macbook". it lists bunch of garbage related key words, like "buy macbook", "apple macbook". There are also useful info, like "magsafe" (accessory), "macbook pro keyboard" (accessory), "macbook battery" (accessory), "logmein" (access software for different OS?), "freenas" (more storage on cloud?), "lenovo laptop" (comparison before purchase?) and some unexplainable words.
  • The other is to search trends distribution on geo. It's a function should included in trends, but not.
    Here is one test i've done. I inputed "tornado". The area impacted by tornado is clearly shown.
How does it related to my job searching
It's fun, but I should not spend too much time on that. Here is the area it might help me on job searching, distribution of job across different states in US.
Key words "finance job": more finance job in NYC and around NYC
Key words "marketing job": almost everywhere
Key words "IT job": it's a little bit surprise. I thought CA might have lots of IT job. Maybe it's due to two reasons, one is CA is weak in hiring, the other is IT is a support function now. it could hire people anywhere. and some states show growth in hiring.


Thursday, May 26, 2011

"Marketing Engineering" - Digest 5

Study of cases
  • Chapter 3: Segmentation and targeting
  • Case problem: 
  • Case solution: 
    • Use logit model to derive relationship between propensity to buy with their preference on features
    • Cluster customer based on propensity to buy. Focus on competitive customer (slight prefer ABB product instead of competitors) and switchable customers (slight prefer ABB's competitor product instead of ABB's and ABB is the second)
    • Based on the formula, find independent variable with statistic significance
    • Investigate impact of these key drives to competitive customer and switchable customers and figure out how to win loyalty of customer and how to reduce customer churn rate
  • Why the author put this case after the chapter
    • Customer segmentation based on propensity to buy is very useful to identify customers that worth sales' efforts on them
  • How can the case be implemented into real situation
    • It might not be easy to identify a few variable that really represent customers' attitude toward the product. The starting point might a find key variable from lots of variables through ANOVA.

"Marketing Engineering" - Digest 4

Study of cases
  • Chapter 3: Segmentation and targeting
  • Case problem: 
    • How to segment customers based on data of segmentation basis (data about customer preference on product features and price)
    • How to categorize customer to different segment based on data of segmentation descriptor (data about customer demographics) 
  • Case solution: 
    • Cluster analysis (KNN maybe) to segment customers based on data of segmentation basis.
    • Based on cluster information, use discriminant analysis (multi regression maybe) to derive formula to categorize cluster
  • Why the author put this case after the chapter
    • Emphasize the difference between two variables, basis and descriptor
    • Emphasize segmentation should focus on customer needs instead of profiles
  • How can the case be implemented into real situation
    • Though data of segmentation descriptor can be get easily, data of segmentation basis designed and collected purposely.
    • For different purpose of segmentation, different data of segmentation basis should be collected. Here lists some in the book
      • for position studies
        • product use
        • product preference
        • benefits sought
        • a hybird of the variables above
      • for price decisions
        • price sensitivity
        • deal proneness
        • price sensitivity by purchase/use patterns
      • for advertising decision
        • benefit sought
        • media use
        • psycho-graphic/lifestyle
        • a hybrid
      • for distribution decision
        • store loyalty and patronage
        • benefits sought in store selection

"Marketing Engineering" - Digest 3

Topics:
Back to the book of "Marketing Engineering". Look at the book, I'm not sure if I will read the book from cover to cover. Case in the book seems practical. And algorithm looks useful as well, but time consuming to dive into since I don't have the software with the book. Maybe the easy thing to do is to go through cases at the end of each chapter and figure out the idea behind it.

Framework
The following framework is designed to construct the study of cases after each chapter.
  • Chapter
  • Case problem
  • Case solution
  • Why the author put this case after the chapter
  • How can the case be implemented into real situation
Study of cases
  • Chapter 2: Tools for marketing engineering: market response models
  • Case problem: 
    • How to spend promotion budget? 
    • The relationship between promotional spending and sales units are given and the price and cost of each unit are provided
  • Case solution: 
    • Use Adbudg model to curve fit the relationship between promotional spending and sales units.
    • Maximize profit based on the derived curve.
  • Why the author put this case after the chapter
    • Emphasize saturation of sales due to promotional spending
  • How can the case be implemented into real situation
    • One challenge to implement it is that relationship between sales units and promotional units. 
      • What if it is a new products?
      • What if it is a new promotional method?
      • One possible answer for this might be to get the relationship through trials and errors
    • The other challenge is that parameters in promotional spending might be more than one
      • maybe it is the problem of strategy for advertising

Wednesday, May 25, 2011

Summary of my knowledge about statistics or hypothesis test in particular

Reason for summary
I feel it's time to stop looking into more statistics or hypothesis test in particular. Anyway I'm not going to work as a statistician. I should position myself as marketing analyst with solid knowledge of statistics and capable of conducting complicated hypothesis test for marketing test.

List of my knowledge about hypothesis test

  • parametric testing
    • one sample test (z test and t test)
    • two sample test (mean test and standard deviation test)
    • one way ANOVA
    • two way ANOVA (full factorial design and fractal factorial design - Taguchi method)
  • non parametric testing (normal distribution test)

The next question is what is the value to marketing. Maybe it is easy to explain it in design of experiment. hypothesis test is one step of design of experiment
Marketing campaign can be considered as one type of experiment with input as marketing mix (4P, price, place, promotion, and product), output as goals (revenue, profit, market share and etc) and market itself as black box. After you have insight about the market, you might find a few key factors. You will try to find the optimal combination to maximize your goal with minimum cost. That's where hypothesis test comes in and help it.

Application,
One interesting application might be in Google ads optimization. Here is an very interesting youtube video to find the best ads with different heading, first description line, second description line and url. One thing to note is that, in practice, people care about the optimal level of the factor, rather than know the factor really has impact on the experiment.

P.S. From tomorrow, I need to focus more on marketing strategy and cases instead of techniques in statistics. Don't be a nerd.

Buzz words in job requirement - Taguchi method

The first time I heard "Taguchi method" is in the six sigma course. It's not covered by the intense course. But the professor did mention it several times.

I kept on searching for details about the method. It seems not well defined even in Wikipedia. Maybe the term itself is not clear or accurate. The exact term might be "Taguchi method in design of experiments". If that is the case, I think "Taguchi method" is just orthogonal analysis in fractal factorial design.

the Idea
In simple English. "Taguchi method" is the method to use smallest runs of experiment, which neglects effect of combination of factors.
If effect of combination of factors is not our interest, we can use 8 runs of experiment to represent an experiment with up to 7 facors, which is far more effective than full factorial case, 27=128

Design of experiment
I'm not sure if should use this as a heading. It covers lots of topics and Fisher even wrote a book about it in 1935. Here I will copy the rule of thumbs about options in design of experiments from one online document
as the summary of this blog.
When do we use which method?
  • Option 1: Factorial Design
    • Small numbers of variables with few states (1 to 3)
    • Interactions between variables are strong and important
    • Every variable contributes significantly
  • Option 2: Taguchi Method
    • Intermediate numbers of variables (3 to 50)
    • Few interactions between variables
    • Only a few variables contributes significantly
  • Option 3: Random Design
    • Many variables (50+)
    • Few interactions between variables
    • Very few variables contributes significantly

Buzz words in job requirement - fractal factorial design

Here is the buzz word I used in my experience as project officer in charge of an experiment. To relate the experience to marketing test, I have to use to some buzz words. "fractal factorial design" seems complicate, and the professor of six sigma mentioned the course. So, it must be useful somewhere in some way.

First of all, definition from Wikipedia.
In statistics, fractional factorial designs are experimental designs consisting of a carefully chosen subset (fraction) of the experimental runs of a full factorial design. The subset is chosen so as to exploit the sparsity-of-effects principle to expose information about the most important features of the problem studied, while using a fraction of the effort of a full factorial design in terms of experimental runs and resources.
There are key terms here, "fraction" and "full factorial design".

"full factorial design" is the way to list all the combination of change in each factors to take all factors and combination and factors into consideration.
For an experiment with 2 factors, source of errors/difference in observation comes from X1, X2 and X1X2
For an experiment with 3 factors, source of errors/difference in observation comes from X1,X2,X3,X1X2,X1X3,X2X3,and X1X2X3
It's simple. But when number of factors increases, runs of experiment increase exponentially. it's 2n. In some cases, it's extremely expensive to conduct the full factorial design.

That's where "factual" comes. Number of runs does not increase when new variable comes in, but some combination of variable need to be compromised. Here is the example.
Conclusion of fractal factorial design, full factorial design is the dumb but expensive method. fractal factorial design is the cheap method with the trade off of cost.

P.S. I need to related it to the context of marketing. The technique can be used in design of marketing campaign test. For traditional marketing campaign, fractal factorial design might be necessary because it's expensive. But for online marketing campaign test, it seems full factorial design is possible.

P.S.2 Here is a youtube video that might be useful to explain fractal factorial design.

Buzz words in job requirement - ANOVA part 2

I am afraid there has to be ANOVA part 2 if change of more than one factor is conduct simultaneously. Another reason is that the title with part 2 is so cool. It sounds like a Kill Bill 2, Harry Potter and deathly hallows part2.

1. What problem can cool ANOVA part 2 can solve?
In one-way ANOVA, samples are different due to change of one variable. What if there are more than one factor/variable? In this case, there are 2-by-2 matrix, and each cell contains one sample with several observations.
In the context of marketing, imagine the marketer design a campaign with input of ads spending and discount level. He/she is not sure about how to fine tune the parameter, so he/she set different levels for each factor. impact of market is recorded. The question is if market really respond differently as factors change.

2. Idea of two-way ANOVA
Assume there are only two factors. And assume means of these samples are identical. Errors of each observation comes from four sources, factor A, factor B, interaction between A and B, randomness.
SSA, SSB and SSAXB are all compared with SSwithin. If they are relatively large, they causes difference more than randomness.

3. Formula of two-way ANOVA
Of course, there should be formula when there is no analyst supporting you. You can find formula here.

Buzz words in job requirement - ANOVA

One of the popular buzz word is ANOVA, which is acronym of analysis of variance.

1. What type of problem can be solved by ANOVA?
There are several samples, which could be generated by different methods. ANOVA can test if means of these sample are different. In the context of marketing, several campaigns are run among different countries and impact of the campaigns (revenue maybe) is recorded. ANOVA can test if impact of campaigns differs among different countries.

2. ANOVA v.s. t test of means by two groups
If there are only two groups, t test can be used instead of ANOVA for simplicity.

3. The idea of ANOVA
If means of the sample groups are assumed to identical, then error of each observation is due to two reasons. One is the error within sample, the other is between samples.
when SSA is relative larger than SSwithinwithin, we can say that means of different samples are different.

4. Formula of one-way ANOVA
Formula is always boring. You can find it here.

Tuesday, May 24, 2011

Buzz words in job requirement - A/B testing

Here are some other buzz words, A/B testing and multi variate testing.

This blog focuses on A/B testing because it's simple.

First of all, let's see the definition in Wikipedia.
A/B testing, split testing or bucket testing is a method of marketing testing by which a baseline control sample is compared to a variety of single-variable test samples in order to improve response rates. A classic direct mail tactic, this method has been recently adopted within the interactive space to test tactics such as banner ads, emails and landing pages.
If we can put the buzz word in the context of experiment instead of marketing or business, things are quite easy actually. The situation is that we need to find the optimal parameter for an experiment. The most simple thing we know is to change the parameter as many as time as we like, and compare the performance understand different value of the parameter. Of course, we need enough samples under each value of the parameter to see difference in a statistical significance way.

This is the dumbest way to optimize an experiment. But there are a few companies well know for A/B testing, listed by Wikipedia,
  • Amazon.com pioneered its use within the web ecommerce space. 
  • BBC.
  • Google. One of their top designers, Douglas Bowman, left and spoke out against excessive use of the practice.
  • Microsoft 
  • Playdom (Disney Interactive) 
  • Zynga 
  • eBay
It's a really dumb method. That is my conclusion for this blog.

P.S. Here is product tour of a company who help to optimize visual website through A/B testing. It might be helpful to understand A/B testing.
http://visualwebsiteoptimizer.com/features.php

Buzz words in job requirement - Email marketing

After searching for job days and days online, I have to say some employers are really obsessed with certain buzz words. I really doubt these are fundamental skill sets. In the following blogger, I'm going to list some of them and show my thoughts about them.

buzz word 1: email marketing

First of all, I didn't know what email marketing is before job searching. Here is the paragraph to describe it in Wikipedia.
Email marketing is a form of direct marketing which uses electronic mail as a means of communicating commercial or fund-raising messages to an audience. In its broadest sense, every email sent to a potential or current customer could be considered email marketing. However, the term is usually used to refer to:


  • sending email messages with the purpose of enhancing the relationship of a merchant with its current or previous customers, to encourage customer loyalty and repeat business,
  • sending email messages with the purpose of acquiring new customers or convincing current customers to purchase something immediately,
  • adding advertisements to email messages sent by other companies to their customers, and
  • sending email messages over the Internet, as email did and does exist outside the Internet (e.g., network email and FIDO).
OK. it's just a method of direct marketing. We receive spam email everyday with unrelated products. It's simple. What should we care if we need to do email marketing? 1. Selected customer. 2. Proper contents.

For the first one, targeting the right customer with the right product is always the key to lots of marketing/sales approach. Sending an email to irrelevant customers might cost the company little, but it could damage brand/image of the company.

For the second one, contents could be proper products/promotion. It still relates to customer selection. In addition, if the link for purchasing is provided in the email, success rate of the email marketing can be evaluated easily.

In essence, email marketing reflects three aspects, customer selection, customized promotion and close loop marketing. I feel that's the fundamental of email marketing. That should be areas employers care.

One example I think about is Groupon, which might be considered as an successful example of email marketing. But uniqueness of Groupon is that it matches local demand (customers in certain city) and local supply (sellers in certain city). Geo info is a very good filter for customer selection. Now Groupon has lots of copycat. We can see daily special of Expedia, but I really doubt that would be successful.

Sunday, May 22, 2011

"Marketing Engineering" - Digest 2

Still in Chapter 5: strategic market analysis: conceptual framework and tools

There are two important concepts: product life cycle and cost dynamics: scale and experience effects


digest 1: S shape in product life cycle
* the picture is not from the book


digest 2: existing other shapes in product life cycle
* the picture is not from the book
Cycle-recycle pattern has been observed in drug products by Cox in 1967 and in Boeing 727 and 747.

digest 3: experience effects
Cq=Cn(q/n)-b
where q= cumulative production to date
          n= cumulative production at a particular, earlier time
          b=learning curve
in practice, experience curves are characterized by their learning rate. Suppose that each tme experience doubles, cost per unit drops to 80 percent of the original level, then the 80 percent is known as the learning rate.
r=2-b*100

Saturday, May 21, 2011

"Marketing Engineering" - Digest 1

Marketing Engineering, Gary L. Lilien (Author), Arvind Rangaswamy (Author)
Bought in Amazon to prepare myself for possible interview for an marketing analyst position

Chapters read today. Chapter 5- strategy market analysis: conceptual framework and tools.

Thought 1: In simple English, think about big pictures before diving into data.Simple truth, but are not always reflected in actions. Big picture (in nowadays, is buzz word most of the time) here means corporate strategy, which might cover product innovation, markets to serve, personnel, R&D, and corporate image.

Thought 2: Rest of the chapter talks market forecasting, which totally makes sense because any manager focuses on pursuing big opportunity with limit resources. Here is the nice summary of classification of market forecasting approaches.

Judgmental Market and survey analysis Time series Causal or correlational analysis
Sales-force composite
Jury of executive opinion
Delphi methods
Buyer intentions
Product tests
Native methods
Moving averages
Exponential smoothing
Box-Jenkins method
Regression analysis
Economics models
Input-output analysis
MARMA

Digest 1: what method to use

  • use structured methods rather than unstructured methods
  • use quantitative methods rather than judgmental methods if enough data exist
  • use causal methods rather extrapolation methods, especially if changes are expected to be large
  • use simple methods unless substantial evidence exists that complexity helps
  • match the forecasting method to the situation

Day 1 - First day of unemployed

May 21st, the first day after MBA graduation and the first day of unemployed. I just can't believe the facts that I am unemployed. I have to write down something each to keep myself sane.
The topics can cover a wide range of subjects. Books, articles in journals and newspapers, movies and music. mainly, I guess.  And my thoughts of course. Things I'm willing to say.