Alex's Notes

traffic modeling

Facebook Marketing Experiment: Exponential Profit Machine?

by Alex Frakking on Nov.11, 2009, under Marketing, traffic modeling

Is it possible to start a self-reinforcing loop of Facebook advertising resulting in exponential revenue growth? Sure!

  1. Make a facebook page
  2. Promote it with Facebook ads > get fans
  3. Use page status updates to drive traffic to your site > monetize the landing page
  4. Invest the earnings in more Facebook ads > goto step 3

This basic cycle is possible with with any form of advertising, but does it work any better on Facebook than it does with TV ads or Adwords? The big difference is that once you have earned a Facebook fan, you can reach them many times until they unsubscribe from your page. This makes Facebook page marketing more like time-tested email marketing.

Facebook social games are a great example of a similar cycle. The addictive games keep users returning daily, and monetize this traffic with virtual currency and often scammy offers. The cycle is reinforced with paid Facebook ads and social advertising (mostly personal status updates).

But these games are social, interactive, and fun. The tight integration between the game platform, social platform, and ad platform has lead to domination of online gaming. So how fast can a Facebook page grow, if it only monetizes weakly through a non-interactive landing page?

Facebook page growth: not good

The below graph is one possible answer to "how fast can a page grow" with this strategy. After an initial $100 investment in Facebook ads to build a starting fan base, you can expect to be making US$800/month in ad revenue after two years. Of course, all this would be plowed back into Facebook ads, and you’d still be out $100. The calculation parameters are explained further below.

alexfrakking_facebook_page_growth

 

In this base case, each fan will "pay" for their acquisition cost after 6.3 months, or after 100 status updates have been made (at the rate of 4 per week). The characteristic (doubling) period is 18 weeks.

Better cases

I graphed a rather pessimistic case so that nobody is even tempted to actually try this. But like all cases of exponential growth, the outcome is highly dependent on the factors that determine the exponential growth rate. Here, those factors are cost per fan, CPM of the external site, and fan clickthrough rate.

If you reduce your cost per fan from 15 cents to 13 cents, the fan growth rate would double. Or if 20% of the fans clicked-through instead of 15%, you would make $4000/mo in ad revenue instead of $800. And of course if you extended the base case to the 3-year mark, ad revenue would hit $5,380/mo.

The most likely improvement is in landing page monetization. The assumed $5 CPM is possible with a good general-content site, but a site for a more lucrative market can bring much higher CPM through higher CPC ads and affiliate programs. According to this model, a site with $10 CPM would make $80,000/mo by the 2-year mark.

This model is probably reasonable for under $1000/mo revenue. Beyond that, the cost per fan would escalate since you simply wouldn’t be able to buy enough ad impressions at that low price ($0.12 CPC) to maintain exponential growth.

Base case parameters

eCPM – How much you can earn per thousand visitors to your landing page. Depends entirely on your visitor demographics an interests, and resulting from your Facebook page targeting and fan page topic. Assume $5 CPM and 2 pageviews per visitor, making US$10 per thousand fan visits.

CTR – Click-through rate of your status updates. Depends mostly on how intriguing your content is. I’ve seen between 5 and 30 percent of total fans click-through to a status link. Assume 15 percent.

CPA – Cost for acquiring one Facebook fan. While it might cost about $0.12 per click with a fan conversion rate of about 40% (meaning $0.30 per fan), social actions (Facebook page recommendations and status updates of joining fans) can at least double the value. Assume overall cost per fan of $0.15. I’ve also assumed a fan attrition rate of 0.2 percent per week.

 

2 Comments :, , more...

Spacial Diffusion of Facebook in the U.S.

by Alex Frakking on Feb.12, 2009, under traffic modeling

fb_us_diffusion

This map is courtesy of Google Insights for Search and Inside Facebook (original screenshots with commentary). The geographical diffusion of an innovation is difficult to predict in itself, but its aggregate effect is captured by growth models like the logistics equation. This specific type of growth is classified as contagious diffusion.

The graph indicates relative search volume, not Facebook members or site traffic. Search volume might correlate better to membership growth than total members because I would guess new members are more likely to search for information about Facebook than current users are.

The map suggests that after an initial surge in search volume in a region, volume drops and then slowly builds again (California is a good example). This is just Google normalizing the data for total search volume; the Insights graph below shows only growth in California.

facebook_california_search

1 Comment more...

Is Canada Facebook-Saturated?

by Alex Frakking on Feb.10, 2009, under traffic modeling

There’s no doubt about it: Canada loves Facebook. Toronto was the first city to break the one million user mark, and in some cities non-Facebook users are in the minority. Members have made their influence felt on both provincial and national level politics, prompting government to treat Facebook as a serious political tool. This article examines evidence that Facebook is reaching saturation levels in Canada.

Canadian Facebook growth – finished already?

Various mathematical models exist for explaining population growth. The logistic function is a natural model to apply here. It describes a system where the population rate of growth is proportional to:

  1. the current population (facebook members), and
  2. the remaining resources (non-members who will eventually join)
Differential form of the logistics equation:
logistic_equation
N(t) = number of Facebook users at time t
r = rate of growth
K = saturation level

Initial logistic growth is nearly exponential, which applies if site growth is driven mostly by referrals (one person tells two friends, who each tell two other friends, etc.). Followed by a nearly linear period of rapid growth, growth slows to reach a saturation value. At this point everyone who is willing and able to join has already done so.

The graph below shows the basic logistic function fitted to actual Facebook member data. The best fit results in a saturation value of 11,069,190 members, or 33.0 percent of the Canadian population. It clearly suggests Facebook membership — currently at 32.9 percent — has little remaining growth potential.

graph_canada_growth

Facebook Market Estimation

The 33 percent saturation value represents everyone who is both:

  1. technically capable of joining, and
  2. sufficiently influenced to create a membership.

The first requirement can be considered a technical coefficient. 78 percent of Canadians are “current internet users” (CIP study), accessing the internet at least once in the past three months. 72 percent of Canadians fall between 13 and 64 years of age, where 13 is the lower cut-off for registering on facebook. The below graph of age distributions show that Facebook has low popularity with the 60 to 64 age group, so 64 will be considered the maximum age of potential  members. The current technical coefficient becomes 78% * 72% = 56.2%.

graph_age_distribution

The second component is a social coefficient. This represents the fraction of the entire population who would like to register, either because they feel it would benefit them (internal motivation), or because of recommendations by friends, family, and media effects (external influence). The social coefficient can be found assuming a national saturation value of 33 percent:

Market Potential = (Technical Coefficient) * (Social Coefficient) * (Population)
(Market Potential) / (Population) = 33% = (56.2%) * (Social Coefficient)
Social Coefficient = 58.7%

A Facebook saturation levels of 33 percent implies a social coefficient of almost 59 percent. This value will rise if Facebook develops a higher perceived-value among non-members (which will happen due to network utility effects), or if external influences increase.

What if everyone wants to join Facebook? A social coefficient of 100 percent means the technical coefficient is the only limitation, and Facebook saturation might occur at 56.3 percent of the Canadian population.

Canadian City Projections

Edmonton, Alberta – a nice city

We can’t be certain that members of a Facebook city network actually live in the stated city, making a meaningful comparison of users to city population difficult. This is especially true with large metropolitan areas and where city boundaries meet. Edmonton makes a good sample city, being a large but isolated city with a greater metropolitan population of 1,081,300.

graph_edmonton_growth

Growth in Edmonton differs fundamentally from the national growth data. The initial growth rate is very high, and no exponential growth is seen in the data. Exponential growth may have happened prior to the first point (April 24, 2007), however the inflection point — the point where accelerating growth becomes decelerating growth — also happened before the first data point. Consequently the growth is not S-shaped, and a logistics function cannot model it.

Instead we’ll use a model where growth rate is proportional to:

  1. a constant value, and
  2. the remaining resources (non-members who will eventually join)
Differential form of simplified NUI model:
bass1_equation
N(t) = number of Facebook users at time t
a = rate of growth
K = saturation level

This is actually a special case of the Bass model for diffusion of innovations, and it fits the available data very well. The significance is that the member-proportional growth term r which causes initial exponential growth represents word-of-mouth effects, something seen when a product or service is spread predominantly by personal referrals and recommendations through existing social channels, as we might expect in the case of Facebook. Replacing this effect with a fixed-rate growth term (a) means that external influences dominate the growth. External influences typically models advertising; the more advertising, the higher the growth rate a. But it can also reflect “buzz” in a population, where everyone “knows” about something because of multiple rapid and pervasive communication channels. This model suggests that Facebooks’s rapid growth in Edmonton may have been due more to buzz (since Facebook hasn’t engaged in traditional advertising) than to interpersonal social interaction.

The Bass diffusion model also helps us predict Facebook saturation. The best-fit curve has a steady-state value equal to 55 percent of Edmonton’s population.

Halifax, Nova Scotia – most penetration, rapid growth

Of the 23 Canadian cities examined, Halifax leads the pack in Facebook penetration. 71 percent of the population appears to belong to the Halifax network, and its average population-adjusted growth rate was second-highest (slightly behind the smaller city of Kelowna, B.C.).

graph_halifax_growth

71 percent penetration seems impossibly high. Halifax’s age distribution leans slightly younger than the national average, with 74 percent between 13 and 64. Therefore the opt-in rate (“social coefficient”) is 96 percent (compared to the national 58.7 percent) assuming every resident has internet access.

The Bass model predicts that 85 of the population will eventually become members. This would require every resident age 10 to 75 to join.

Toronto, Ontario – biggest network

Toronto is currently the largest Canadian city network. The Greater Toronto Area encompasses several city networks, so the difficulties with matching members with their actual cities of residence are particularly bad here.

graph_toronto_growth

Because the earliest data point was already at half a million members, it’s possible a strong exponential growth occurred prior to that time. A different function that can model exponential growth was applied to test that theory. The resulting, albeit brief, “exponential” growth is seen in the graph at the lowest membership levels.

The modified logistics function (with exponent q) is commonly called the Non-Uniform Influence model (NUI). For 0 < q < 1 it represents a variable word-of-mouth effect; one which is important at first, but diminishes as member-base grows. Here, q = 1/5
nui2_equation
N(t) = number of Facebook users at time t
r = rate of growth
q = growth exponent
K = saturation level

Although Model 1 (Bass) fits the available data better, both models predict the same saturation level of 30 percent.

Montreal, Quebec – untapped potential

For its size, Montreal had far slower initial growth than any other examined city. Early growth exhibits clear acceleration, suggesting that word-of-mouth referrals played a bigger role than in other cities. Buzz may have been less, possibly because the French media gave less Facebook coverage than English media.

Montreal is currently near its peak Facebook growth rate. Despite Toronto having 50 percent greater population, the model predicts Montreal will become Canada’s largest city network by July 12, 2009.

graph_montreal_growth

Provincial Penetration

Could some provinces be far ahead of others in Facebook adoption? Since provincial data should be more reliable than city data (less ambiguity regarding networks borders), these trailblazing provinces could be a strong indicator of where the country is heading.

Penetration
Province Population
31-Jan-08
04-Feb-09
Yukon 31,530
-
67.5%
New Brunswick 751,527
24.5%
45.3%
Nova Scotia 938,962
38.8%
44.9%
Alberta 3,512,368
31.1%
39.6%
Ontario 12,891,787
30.0%
36.0%
British Columbia 4,428,356
28.9%
35.1%
Prince Edward Island 139,407
19.3%
34.3%
Northwest Territories 42,514
-
32.6%
Newfoundland and Labrador 508,944
26.2%
32.2%
Saskatchewan 1,010,146
24.4%
32.0%
Manitoba 1,196,291
22.7%
30.5%
Québec 7,744,530
12.3%
21.5%
Nunavut 31,152
-
2.4%

Yukon is clearly in the lead, with 67.5 percent of its 31,530 population having facebook profiles. While examining the possible reasons for this are beyond the scope of this casual analysis, we can rule out Yukon’s age distribution as a factor. While 76.5 percent fall between 13 and 64 (higher than the national average of 72), that distribution is heavily skewed to the right.

On the other end is Quebec with only 21.5 percent penetration. If Quebec follows Montreal, this French province will be a significant growth market within Canada. One barrier may be the 15 percent gap in internet access between English-speaking and French-speaking Canadians. Furthermore, a 2007 study concludes that social networking sites in general have a greater appeal for English-speaking Canadians (43%) than for French-speaking Canadians (24%).

Conclusions

Using a logistics model applied to limited data, the Canadian Facebook saturation level was found to be 33 percent. However this data is a superposition of all city data; when cities were examined individually a saturation level above 50 percent was common. Three provinces were found to have current penetrations greater than 40 percent, with Yukon at 67.5 percent. This raises the possibility that national saturation could eventually reach such levels.

Quebec was found to have a very low penetration, but strong growth potential. Despite a smaller population, Montreal should surpass Toronto as the largest network by the summer of 2009.

About the Data

Facebook doesn’t publish membership numbers on the city or provincial level, so the data in this article was culled from various other sources. Because of the uncertainty of the data (low resolution, network counts versus facebook.com/advertising numbers) this casual analysis focuses more on trends than absolute numbers.

Historic provincial data: http://www.canadianmarketingblog.com/archives/2008/02/facebook_stats_primer.html
Historic city data: http://www.thoughtballoons.net/index.php/2008/04/28/one-year-look-facebook-growth-canada/
Historic Canadian data: http://blog.facebook.com/blog.php?post=2398302130
http://themeaningofweb.com/facebook-user-profile-canada-2008/
All current data: http://www.facebook.com/advertising
Population data: Wikipedia

Upcoming related articles:

  • The social network adoption curve
  • What’s powering your network: network utility functions
6 Comments more...

Website Traffic Modeling – Part 1 – Introduction

by Alex Frakking on Jan.14, 2009, under traffic modeling

Have you ever wondered:

  • How fast can my website grow?
  • How long will it take to make good money on traffic?
  • What are the most important factors for website traffic growth?
  • How much should I spend on website advertising?

traffic_mashup
Over my next few posts I’ll develop a practical method for modeling website traffic that can answer all of those questions, and more!

The web is barren of information on traffic prediction, maybe because it’s so challenging. The main problems are:
2009_1_14

  • It’s difficult to model the qualitative aspects of a site: quality of content, site appearance, navigation, domain name, etc.
  • Visitors can arrive in different ways and for different reasons
  • Small inputs can have a large effect (’digg effect‘, viral content, etc.)

The number of unknown and unquantifiable variables makes accurate prediction impossible, especially in a site’s early life. But there are still benefits for trying, including:

  • Insight regarding important parameters for site growth (should I advertise more, focus on loyalty, or encourage referrals?)
  • Rapidly testing ‘what if’ scenarios (what if conversion rate is half the expected value?)
  • Planning infrastructure (when will I approach my bandwidth limit?)
  • Something to show investors

The Easy Way

easyProbably the easiest way to predict growth of a new website is to look at other sites. Find one that offers a similar product/service in the same market, and see how their traffic has grown (try Alexa or Google Trends for websites). For many small sites (ecommerce, online directories, blogs, etc.) it’s reasonable to assume that if you do what they did, you could get similar results. If you know what they’ve done in the way of advertising and link-building you’ll know how much effort is required to approach their traffic level.

This approach takes little thought and no math, but has two drawbacks:

  • There may not be a comparable website
  • It doesn’t help you understand the growth

In Part 2 I’ll review basic growth models and how to extrapolate your existing traffic!

1 Comment :, , , , , , , more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!