action
Source: http://feeds.gawker.com/~r/lifehacker/full/~3/VXZVXiFgV6Y/tableau-public-brings-your-boring-data-to-life
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:
Dashboard at 570

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.”
Tags: action, application, basis, best fit, charts and graphs, computer, confidential data, content, Dashboard, data warehouse, desktop, desktop product, desktop windows, Download, everyone, example, fact, FREE, free application, free tool, gawker, heart, horse, interact, interactive data, Internet, Journal, life, life windows, live updates, MakeUseOf, mouth, nothing, outcome, overview, page, post, price, price tag, Product, public, public servers, public web servers, Source, Straight, student, Tableau, TAG, time, tmpPost, Tool, trial, trial basis, update, use, video, visualization, visualizations, Wall Street, wall street journal, Web, Windows, windows application, Work, YouTube-style
By defining “digital” as not the technology, device, or channel, but rather the habits and expectations of modern users, we are able to make practical decisions about which marketing tactics, technologies, devices, and channels to use to match these users’ habits and expectations. If you know their habit is to search, then you wouldn’t blow your whole budget on TV ads and have nothing for them to find online when they search. if you believe they expect to be able to find information from their iPhones, then you wouldn’t make your whole site high bandwidth, flashy, and Flash because they wont be able to view it at all.
Thank you all for your comments and retweets.
acfouBranding is dead; targeting is dying; social media is not media – if you believe this new definition of “digital” – http://bit.ly/TTTPC
Tags: acfou, action, Adtraction, arkley, article, baltix, bandwidth, behavior, belindaangRT, BennaPReading, brand, Branding, budget, changing behavior, channel, ClickZ, conversation, course, DaGood, DCSRT, decisions, definition, device, digital, flash, fsdigitalA, glenngabeA, Good, habit, HamiltonWallaceA, HeidiPatmoreRT, high bandwidth, information, interview, iphones, jacqueswarrenNot, jeanaandersonI, jonnylongdenRT, Jussipekka, kathymbaird, konsultantasRT, Listen-up, losing, marketers, marketing, marketing tactics, measure, Media, MJinNYCRT, mktmobileA, MPPR, nails, New, nothing, online, ow, post, POV, pull, RAJ, randymatheson, randymathesonDo, RaynaNyc, Read, ROI, SgtWiggidyA, site, team, technology, technology device, Thought, tinyurl, Tues, tv ads, whole budget, wont
godaddy superbowl ad spending led to sharp spikes in search volume every February for the last 5 years straight. Other advertisers who spent on Superbowl ads have similar lift in search volume from the TV advertising.

Source: Google Insights for Search
If you believe that lift in search volume indicates interest and intent and if you consider that each 30-second ad cost $3 million in 2009 (WSJ: NBC Super Bowl Ads to Cost $3 Million) and assuming GoDaddy’s ad did not air more than once, they spent $3 million to get their ad in front of a TON of people and to get people’s attention. Those people who saw the ad and were interested enough to take action went online and searched for more information by typing godaddy into search (see lift in search volume during February of each year) .
If we assume that it took $3 million to generate a certain lift in search we can use multiples to calculate the media dollar equivalent of any lift in search — for example, if godaddy spent $3 million to get X lift in search, then a 2X lift in search would have required $6 million of media (in a very very simplified back of the envelope estimate; it usually would cost more than 2x to get that lift) — i.e. it would have cost at least $6 million in superbowl ad media dollars to achieve a 2X lift in search volume.
So, if we now compare search volume on megan fox side by side with godaddy search volume, we will see that in Feb 2009 Megan Fox was indexing at 21 while godaddy was indexing at 12 (this is normalized to a scale of 0 – 100). So search volume on megan fox indicates she was getting the equivalent value to $6 million of super bowl media ad spend – FOR FREE — roughly 2X the search volume of godaddy in the same time period.

At the peak of her search volume in June 2009 (corresponding to the release of Transformers 2: The Revenge of the Fallen), she was indexing at 100 and godaddy at 7. This is 8x the index of godaddy of 12 during the Feb 2009 time period when they were airing their superbowl ads. This implies that she was getting the search volume that would have required the equivalent to a $24 million super bowl ad spend to achieve — again for FREE!

If you want to research futher, use the following link to bring up Google Insights for Search to see relative search volume
In February 2008, Megan Fox indexed at 8 and GoDaddy at 8. In 2008, Superbowl ad spots cost only $2.7 million — so she had the equivalent search volume as a paid advertising spending $2.7 million on a Superbowl ad.
In 2007, Godaddy indexed at 6 during Feb 2007 Superbowl. Megan Fox indexed at 43 during the July release of the first Transformers movie — this is an 8X multiple on Superbowl ads that cost $2.6 million — or $21 million
So the perfect “product placement” of Megan Fox in the two Transformers movies garnered her nearly $50 million worth of advertising based on search volume equivalency. This does not even take into account her sustained and increasing search volume, compared to most advertisers’ search volumes which drop right back down to pre-ad levels once the ad is finished airing.
Tags: 2009 superbowl ad rates, 6 million, account, action, advertisers, advertising, attention, Bowl, cost, cost of super bowl ads in 2007, cost of super bowl ads in 2008, cost of super bowl ads in 2009, dollar, dollar equivalent, envelope, equivalent, equivalent value, estimate, example, Fallen, Feb, February, fox, FREE, front, futher, godaddy, godaddy superbowl ad spending, google, index, information, intent, interest, July, June, lift, link, Megan, megan fox, Million, movie, NBC, online, peak, period, Placement, Product, release, Revenge, same time period, scale, search, search volume, search volume equivalency, side, Source, spending, spikes, Super, super bowl, super bowl ad, super bowl ads, superbow, superbowl, superbowl ad, superbowl ads, time, TON, transformers, tv advertising, use, value, volume, WSJ, X, year
… 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/
Tags: action, advertisers, banner, banner ad, cost, due, effort, etrade, example, godaddy, info, information, LifeWater, print, radio, radio spot, search, search volume, SoBe, sobe lifewater, Spot, superbowl, superbowl ad, tidbit, time, traditional ads, tv advertising, volume
Megan Fox – The Perfect Babe Product Placement



No, this post is not about Megan Fox. Well, yeah it is. But it’s about the MARKETING of Megan Fox.
Megan Fox has been around in films and TV since 2001 (see filmography below). But it wasn’t until 2007 when she starred in the first Transformers movie that she burst on the scene and became an overnight mega celebrity, especially online (see Google Search Volume chart). If you look at Ford’s search volume during the same period, there was NO lift in search that was detectable — there probably was some lift, but it is simply not detectable.
So Megan Fox went from very very little awareness to not only massive awareness, but also massive demand — people remembered her name and even took action (performed searches on her name). If some product placements would have had only 10% of the success of the “megan fox” product placement, they might actually justify the immense cost a bit better (millions of dollars paid by the advertiser to the movie makers to place products into the storyline of the movie).
And why is she “perfect,” in the marketing sense, of course? Her search volume has not only sustained but also continued to grow. She was not a flash in the pan that went away after the advertising/media dollars stopped or the public interest died off (see the snuggie and etrade search volume charts below).





transformer girl, second girl in transformers, other girl in transformers – Isabel Lucas





Tags: action, advertiser, advertising media, awareness, Babe, bad girl in transformers 2, bit, celebrity, chart, cost, course, decepticon girl in transformers, demand, digitally empowered consumers, enemy girl on transformers, etrade, evil transformer girl, filmography, films, flash, flash in the pan, Ford, fox, girl, girl from transformer movie, girl from transformers 2, girl from transfromers movie, girl in transformers 2 movie, girl on transformers, google, hot chick transformers 2, hot girl in transformers 2, hot girl movie, hot girl on transformers movie, hot transformer girl, interest, Isabel Lucas, lift, marketing, massive demand, Megan, megan fox, megan fox pics, megan fox search volume, megan fox transformers movie, Megan Fox, movie, movie makers, name, online, other hot girl in transformers 2, Perfect, perfect babe, perfect babes pics, period, photos of Isabel Lucas, photos of megan fox, photos of other hot girl in transformers 2, pics of megan fox, Placement, post, Product, product placement, product placements, public interest, robot girl in transformers, robot girl in transformers 2, scene, search, search volume, sense, sexy other girl in transformers 2, sexy robot girl, sexy transformer girl, snuggie, storyline, success, the girl in transformers, the name of the girl on transformer, total babe, transformer, transformer girl, transformers, transformers 2, transformers 2 girl, transformers 2 hot girl, transformers girl, transformers girls name, transformers movie, transformers movie girl name, transformers movie star, volume, volume chart, volume charts, who is the hot girl in transformers 2, yeah
reducing the number of clicks between the inspiration and the action (purchase) usually helps reduce the precipitous drop off of people not completing the desired end-action. in-banner commerce means you can sell the item right in the banner. The user may already be registered with Amazon.com and have their card on file. This can be 1-click purchase in the banner itself — to take advantage of impulse purchases. This works especially well for low cost and low consideration products.
Tags: action, advantage, Amazon, banner, card, click, com, commerce, consideration, cost, drop, file, impulse, impulse purchases, in-banner commerce, inspiration, item, number, precipitous drop, purchase, right, user
List of 2009 Superbowl spots on AdAge.com
Lift in search is a great indicator of interest. Modern consumers may be inspired by TV ads, but they usually go online to do more research for themselves, to inform their own purchase decision. The following examples show the lift in search after Superbowl commercials or for launch of products like Subway Footlongs. The use of unique, made-up words makes it easier to detect lift in search (see related post: made up words are great for tracking buzz and search volume ). There is now a correlation between offline paid advertising and online behaviors of modern consumers that can be tracked and ultimately related to sales.
What is harder to do is track lift in search from smaller TV media buys or from terms which are generic — e.g. American Express OPEN, Proctor & Gamble’s TAG (men’s deoorant), etc. And furthermore, people may or may not remember the brand name itself and may type in a more general search query — e.g. “talking baby” instead of” e-Trade” or “dancing lizards” instead of “SoBe LifeWater.” And most people usually forget to type in special URLs specified in the ads. So the opportunity is to 1) use made-up words which can be used to detect lift in search and 2) search-optimize around other more generic terms that people may search for if they remembered the ad, but did not remember the brand name itself.
key learnings include:
1. only the superbowl TV ads generates enough awareness to drive lift in search volume detectable above the noise or normal levels
2. made up words are useful in correlating paid advertising and subsequent online actions (e.g. search) because most users forget or are too lazy to type special URLs
3. is is always better to have real analytics from the site to see when paid campaigns hit; site analytics will also reveal more information about users including demographic information, what they are looking for, and even whether they “convert” to a sale or a desired action — like print off a coupon, etc.
Notice the January spikes for several of the examples below — these are their Superbowl ads in action. But also notice how sharp the spikes are — most of them go back to prior levels within 1 – 3 days (see related post: the ephemerality of the Superbowl halo )
Source: Google Insights for Search









Tags: 2009 superbowl, action, adage, advertising, American, american express, amp, analytics, article article, article id, awareness, Baby, brand, buzz, com, correlation, dancing, decision, demographic information, deoorant, digital, E-Trade, Express, footlongs, Gamble, generic terms, indicator, information, interest, launch, LifeWater, lift, list, lizards, Modern, name, noise, offline, online, OPEN, opportunity, post, print, Proctor, purchase, purchase decision, query, research, sale, search, search and tv advertising, search query, search volume, SEO, site, SoBe, Subway, superbowl, superbowl commercials, TAG, track, Trade, tv ads, tv advertising, tv media, type, URLs, use, volume