example
Windows only: Free application Tableau Public creates beautiful visualizations from your data and lets you publish them to the web, where users can interact with your charts and graphs with live updates.
The video above provides a great overview of how the tool works. Essentially, you import your data into the desktop Windows application, then play around with different charts, graphs, or other options until you find the visualization or visualizations that best fit your data. When you’re happy with what you’ve put together, you can save the outcome to the web, which uploads the charts to the Tableau Public servers. From there you can embed it on any web page YouTube-style), and users can drill down into the data to their heart’s content.
Here’s an example of Tableau Public in action from a post on the Wall Street Journal:
Tableau Public is a free download for Windows, and looks like a great tool to try out next time you’re looking to make your otherwise boring data come to life. Update: Somehow I managed to miss the fact that Tableau Public is only free on a trial basis; its actual price tag is extremely hefty. (Though if you’re a student you can get it for as little as $69.)
Double Update: Actually, looks like Tableau Public is free after all! Straight from the horse’s mouth:
“People can download the free tool and publish their visualizations of their data for free. Tableau Public includes a free desktop product that you can download and use to publish interactive data visualizations to the web. The Tableau Public desktop saves work to the Tableau Public web servers – nothing is saved locally on your computer. All data saved to Tableau Public will be accessible by everyone on the internet, so be sure to work only with [publicly] available (and appropriate) data.
When people want to analyze their private or confidential data (particularly data in data warehouses and other large databases), then they may want to consider our commercial products.”
The iPod Touch Is This Generation’s Tamagotchi
Source: http://feeds.gawker.com/~r/gizmodo/full/~3/SM6HjEBs9Ok/the-ipod-touch-is-this-generations-tamagotchi
All these wonderful things we’re learning today, from data! First, we find out that Android is a guy thing. Now, we discover that the iPod Touch shares more demographics with glittering vampires than smartphones. iPod Touch: Kid stuff.
The age distribution makes a lot of sense, especially with the direct available comparison of the iPhone: the iPod Touch is a good gift, a plausible purchase, and a good investment for a young person right now. An iPhone with a $70-a-month minimum contract is a tougher sell, either to parents, or to kids mostly supported by their parents.
And these kids don’t just buy different gadgets than adults—they use them differently, too. For example, they looooove apps:
But they’re stingy little bastards, these kids: 
Buying an app can be tough without a credit card, so again, this isn’t shocking. But it does poke a little hole in the idea of the iPod Touch as a massive moneymaker for Apple. Hardware sales are tremendous and highly profitable, sure, but once the devices are in users’ soft little baby hands, they don’t keep raking it in like the iPhone does. [AdMob]
![]()
"We Are Not Prepared"

The Policy Center’s vice-president reports “”The general consensus of the panel today was that we are not prepared to deal with these kinds of attacks.”
The nightmarish scenario that unfolded represented a worst-case example. As former secretary of Homeland Security Michael Chertoff noted, many cyberattacks can be stopped if individual cell phone or Internet users simply follow the best practices and use the right tools. Similarly, another participant pointed out that private Internet companies would not sit idly by as a virus ran amok.
A collapse of power across the U.S. also only took place when the simulation brought in factors such as high demand during the summer, a hurricane that had damaged power supply lines, and coordinated bombings that accompanied the cyberattack and subsequent failure of the Internet.
Still, the war game highlighted crucial issues about the government’s own reliance upon communications that might go down during a real-life scenario. One of the biggest problems was how the President ought to respond to a situation that caused damage like warfare but lacked an immediately identifiable foreign adversary. Smaller-scale cyberattacks have already complicated real-world diplomacy, such as the alleged Chinese cyberattacks on Google and other U.S. companies.
Ares Defense Blog questioned a curious missing element from the simulation, in that there was no mention of what happened to phone or Internet service in the rest of the world. Surely a nation that decided to launch cyberattacks against the U.S. would take safeguards to protect its own crucial communication services, which would possibly help U.S. officials narrow down the list of suspects.
Another question seemed more mundane but equally important — how would the government activate the National Guard with cell phone service down?
The Pentagon’s DARPA science lab recently pushed for a “Cyber Genome Program” that could trace digital fingerprints to cyberattack culprits. But identifying whether a cyber attack came from individual civilians, shadowy hacker associations or government cyber-warriors has proven tricky in the meantime.
[via Ares Defense Blog]
The numbers vary depending on who you ask or whose data you use
Bing search volume continues to drop despite tons of ads and cheating — redirecting traffic from live.com, msn.com, microsoft.com, and windows search (see also – http://bit.ly/7qDBEz) .
The Nielsen Company today reported December 2009 data for the top U.S. Search Providers.
MegaView Search data – including total searches, unique searchers, search share, and all other search figures – cannot be trended with search results prior to October 2009 due to recent methodology changes.

Searches represent the total number of queries conducted at the provider. Example: An estimated 6.7 billion search queries were conducted at Google Search, representing 67.3 percent of all search queries conducted during the given time period.
versus Oct 2009 numbers from hitwise

The Grand Unified Theory of Marketing(tm) – Digital String Theory
Just as physicists and mathematicians have been searching for the grand unified theory of the universe, I have been looking for a way to tie together the disparate disciplines of marketing and advertising, a way to correlate metrics from different industries that interrelate with marketing (e.g. market research, Nielsen, etc.), a way to put all past theories in context and perspective (Michael Porter’s Five Forces, Net Promoter, etc.), and a way to explain marketing successes and failures — all in one.
My method is the scientific method – which is simply put doing experiments and making observations that either support or refute hypotheses.
A grand unified theory will also need to be able to take into account phenomena such as social networks, etc. What are the organizing principles of such; what is the value? Why now?
Using digital tools — such as search volume trends — we can start to correlate marketing spend effectiveness across different forms of media and also different advertising and marketing techniques. The example below compares eTrade and Drobo. What is most embarrassing is that eTrade, a well known brand from the first dot-com heyday, spent lots of money creating and airing TV ads which it hoped would go viral. They even paid for Superbowl ads for the last 2 years to promote the “eTrade talking babies” as you see from the 2 spikes in search volume during February of 2008 and 2009. However, when compared to Drobo (a startup company that developed a very easily upgradeable back up hard drive array), it is shocking to note that Drobo spent NOTHING on advertising and relied entirely on word of mouth and an awesome product. And their search volume is not only larger than eTrade but also sustainably larger despite zero advertising and media cost. The “totals” even suggest that the volume under the curve of Drobo is 8X (EIGHT TIMES) that of eTrade.
So if you consider that eTrade spent millions of dollars to create the TV ads and even more millions of dollars to air them on TV in order to drive interest, demand, and hopefully new customers, then Drobo can be considered to have gotten the equivalent of 8X more dollars in advertising and media – for FREE using techniques and channels other than TV advertising. So what does that say about the relative value of TV advertising compared to these other, newer techniques?

godaddy vs megan fox

What viral videos look like; what non-viral videos look like — by the stats
The first 2 are viral videos – notice the shape of the “total views curve” (quick rise and approaches the max asymptotically). The last 2 videos are not viral, and supported by paid advertising and promotion. It is a straight line that grows steadily over time. The 2 examples of non-viral videos were chosen simply to have similar view counts as the first and second examples.
Viral video examples – notice the asymptotic curve towards the max on the total views chart.
Frozen Grand Central ImprovEverywhere viral video – 18 million views – added on Jan 31, 2009. ”Other/viral” gave it its first big boost and embedded views gave it another big push.

No Pants Subway Ride ImprovEverywhere viral video – 9 million views – uploaded January 13, 2009; got onto YouTube homepage and got a major boost from it.

NON-viral video examples – notice the straight line of the total views chart.


Perfect example of NON-viral video that had help with paid media – in this case, GoDaddy supported these videos with costly Superbowl ads — which led to nice bumps-up in total views.

In the case of Smirnoff’s Tea Partay, it was not supported by paid media so it took longer to grow and the shape of the curve is a nice blend between the straight line of a non-viral video and the asymptotic line of a viral video.

Finally, blatant ads don’t go viral – Sony’s grand central product demo stunt. And even if they are discussed in dozens of blogs it is not enough to get past the first tipping point.
Lift in search volume indicates that customers …
… saw the ad, recalled it, and thought it relevant enough at the time to make the effort to take action — search for more information about it (beyond the tidbit of info contained in the 30 second ad, print ad, radio spot, or banner ad).
But traditional ads are still very very costly and inefficient due to the extremely large media cost.
For example, at the extreme cost of a Superbowl ad, the following advertisers were able to drive fleeting (short-lived) lift in search volume: godaddy, etrade, sobe lifewater, dennys.




related: http://go-digital.net/blog/2009/03/lift-in-search-due-to-paid-tv-advertising/
About Me
Tags
Recent Posts
- iPad on Sale today – only 24% will buy, 76% will wait and see
- Change or Die [Music]
- A Predictable Failure: Kimberly-Clark Offering Kleenex Hand Towels
- 1024-bit RSA encryption cracked by carefully starving CPU of electricity
- 975
- Apple vs Microsoft vs Sony [Graphs]
- This Is Why that Amazing NASA Earth Image Looked So Familiar
- 972
- Please Euthanize This Big Boy Already – How Lack of Innovation Killed Another Giant
- 969
Popular Posts
- HP Mini 311 Nvidia ION Netbook Hackintosh'ed
- Facebook advertising metrics and benchmarks
- What is Web 3.0? Characteristics of Web 3.0
- Samsung 52 inch HDTV $9.99 at BestBuy - purchase receipt below (6:21a eastern time August 12, 2009)
- social media benchmarks
- The JKWeddingDance video was real; the viral effect was MANUFACTURED - Post 1 of 2
- How to manufacture a viral video sensation and make viral profits - Post 2 of 2
- Evian baby viral video has much higher ROI than Etrade baby superbowl ad
- The Grand Unified Theory of Marketing(tm) - Digital String Theory
- RTB - real-time bidding may make ad exchanges more efficient, but it still won't save display (ads)
Recent Articles by Dr. Augustine Fou
- The ROI for Social Media Is Zero - ClickZ
- What's Wrong With the Net Promoter Score - ClickZ
- The 22 Immutable Laws of Marketing No Longer Apply, Part 2 ...
- How to Do Social Marketing in Heavily Regulated Industries ...
- The 22 Immutable Laws of Marketing No Longer Apply - ClickZ
- 11 Most Popular Experts' Columns of 2009 on ClickZ - ClickZ ...
- December 27, 2009 - January 2, 2010 - ClickZ - News and ...
- ClickZ - News and expert advice for the digital marketer ...
Pages
Archives
- March 2010 (10)
- February 2010 (21)
- January 2010 (12)
- December 2009 (4)
- November 2009 (2)
- October 2009 (14)
- September 2009 (6)
- August 2009 (19)
- July 2009 (34)
- June 2009 (11)
- May 2009 (4)
- April 2009 (6)
- March 2009 (13)
- February 2009 (32)
- January 2009 (25)
- December 2008 (1)
- October 2008 (1)
- November 2007 (1)






