hump

SeedTable Is A Stunning New Way To Interrogate CrunchBase

Source: http://techcrunch.com/2012/03/08/seedtable-is-a-stunning-new-way-to-interrogate-crunchbase-and-find-investors/

Screen Shot 2012-03-08 at 10.22.40

I have a love/hate relationship with CrunchBase. On the one hand, it has great information about startup tech companies. On the other hand, it relies on a wiki-like structure which means it is sometimes not updated as frequently or as accurately as old-style databases which used to employ people go over the data regularly. However, its wikiness means it can be free – pretty useful for the entrepreneur! Perhaps the real unsung hero of CrunchBase is its API which means third party developers can whip up new things with the data. The latest is SeedTable, a new project from Imran Ghory, a founder of CoderStack.

Ghory has built a brand new interface to CrunchBase which exposes a few things CrunchBase itself can’t right now due to the limitation of its interface. And it really is very good. A quick tip: start typing in the name of a city in the search box.

“I wanted to see how London was doing compared to other cities in terms of startups,” Ghory told me. In building SeedTable he realised it was also really useful for discovery, thus you could click London, then Consumer Web, then see who had backed those companies.

So we can now see the ‘Most Active Cities’ (in the last 12 Months) in terms of startup funding are San Francisco, New York and London. However, there are separate figures for Palo Alto and Mountain View, which suggests Silicon Valley remains head and shoulders above the rest overall.

Drilling down to a city, say London, we can see historic trends such as a big hump when many companies were founded in 2008-2011, and we can see VC, Angel and Exits tacking upwards.

One anomaly Ghory found was that companies often only add themselves to CrunchBase after they have funding, which throws their founding data out of whack. If people just entered super-accurate information, and did it early, we’d see better data. (Anyone can add anything to CrunchBase).

SeedTable also exposes the top Angel rankings by investment count in London. This includes The Accelerator Group, Stefan Glaenzer, Index Ventures, Eden Ventures, Seedcamp and Sherry Coutu. The same listing for most active VCs lists Index Ventures, Accel Partners, Eden Ventures, Balderton Capital and Pentech Ventures.

Of course, this only relies on CrunchBase, which needs to be maintained and updated.

When you get to places like Istanbul, CrunchBase starts to show its gaps, with far less data available, even though it’s clear the city is in a tech boom. At least the upward graph is there on founded companies.

SeedTable is an example of data being made a great deal more useful via interface. I can see myself using it almost as much as CrunchBase.


Tags: , , , , , , , , , , , , , , , , , , ,

Thursday, March 8th, 2012 news No Comments

Occasions and Holidays Drive Movie Box Office Sales, Not Advertising

Taking the top box office results for each of 52 weekends from the past 10 complete years (1998 – 2008; Source: IMDB.com) we see consistently that occasions like Valentines, Memorial Day, July 4th, and Thanksgiving show increased movie going activity. People have more time during these holidays to go to the movies and Valentines is a date+movie occasion. Also, during the summer, many people go to the movie theatre to escape the heat so there is an overall hump every year during the summer months — from Memorial Day to Labor Day.

movie-box-office-2


People go out during Valentines, Memorial Day, July 4th, and Thanksgiving. And they still spend what they planned to spend — 2 tickets for movie — they didn’t buy 2 more tickets and see a second movie on the same date or holiday weekend. ┬áIf they had several good movies to choose from (often, they don’t), they would choose to spend the finite dollars on the one movie they really wanted to see. The overall movie spending “pie” did not increase much, if any, year over year.

1998 $4,055,194,733 n/a

1999 $4,253,601,768 5%

2000 $4,496,554,005 6%

2001 $5,003,433,737 11%

2002 $5,489,974,199 10%

2003 $5,581,797,720 2%

2004 $ 5,697,299,530 2%

2005 $ 5,524,566,579 -3%

2006 $ 5,660,826,625 +2%

2007 $ 5,968,027,963 +5%

2008 $ 5,887,193,490 -1%

The chart below shows a red line which is the average of all 10 years. The 10 thin blue lines are the annual lines from1998 – 2008, inclusive and these are plotted as actual dollars. They come out right on top of each other.

movie-box-office-2-overlay

Movie advertising, which runs into the hundreds of millions of dollars a year, has failed to noticeably increase the overall spending year-round or even during specific times. The chart below shows the differentials (difference between an annual line and the 10-yr average line). These all hover closely in the +$50M and -$50M band. The amplitude of the 10-yr average (red line) is larger than $50M in the summer hump — implying that the average change in movie ticket sales due to normal seasonality is larger than the change in amplitude caused by ALL movie advertising combined.

movie-box-2-differentials

And the summer “hump” is due to actual demand (people going out to movie theatres, some to escape the heat) not due to advertising. The only effect of advertising is to share-shift from one movie to another — the total spending remains consistent and even seasonal variations are consistent — a “zero-sum game.”


All-Time USA Box office

Source: IMDB.com

Rank Title USA Box Office
1. Titanic (1997) $600,779,824
2. The Dark Knight (2008) $533,316,061
3. Star Wars (1977) $460,935,665
4. Shrek 2 (2004) $436,471,036
5. E.T.: The Extra-Terrestrial (1982) $434,949,459
6. Star Wars: Episode I – The Phantom Menace(1999) $431,065,444
7. Pirates of the Caribbean: Dead Man’s Chest (2006) $423,032,628
8. Spider-Man (2002) $403,706,375
9. Star Wars: Episode III – Revenge of the Sith (2005) $380,262,555
10. The Lord of the Rings: The Return of the King(2003) $377,019,252
11. Spider-Man 2 (2004) $373,377,893
12. The Passion of the Christ (2004) $370,270,943
13. Transformers: Revenge of the Fallen (2009) $367,614,540
14. Jurassic Park (1993) $356,784,000
15. The Lord of the Rings: The Two Towers (2002) $340,478,898
16. Finding Nemo (2003) $339,714,367
17. Spider-Man 3 (2007) $336,530,303
18. Forrest Gump (1994) $329,691,196
19. The Lion King (1994) $328,423,001
20. Shrek the Third (2007) $320,706,665
21. Transformers (2007) $318,759,914
22. Iron Man (2008) $318,298,180
23. Harry Potter and the Sorcerer’s Stone (2001) $317,557,891
24. Indiana Jones and the Kingdom of the Crystal Skull(2008) $317,011,114
25. The Lord of the Rings: The Fellowship of the Ring(2001) $313,837,577

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Wednesday, July 22nd, 2009 digital No Comments

Dr. Augustine Fou is Digital Consigliere to marketing executives, advising them on digital strategy and Unified Marketing(tm). Dr Fou has over 17 years of in-the-trenches, hands-on experience, which enables him to provide objective, in-depth assessments of their current marketing programs and recommendations for improving business impact and ROI using digital insights.

Augustine Fou portrait
http://twitter.com/acfou
Send Tips: tips@go-digital.net
Digital Strategy Consulting
Dr. Augustine Fou LinkedIn Bio
Digital Marketing Slideshares
The Grand Unified Theory of Marketing