Dashboard liberation: Excellent Analytics moves Google application to Excel

Although it’s easy to bash Microsoft, over the years a handful to tricks have made me an avid fan of Excel. Pivot tables and relational look-ups (all hail VLOOKUP!) are two arrows in my web analytics quiver. I’ve just added another. If you work in Google Analytics a lot, you should too.

Excellent Analytics is a free Excel add-in that truly lives up to its name. It allows you to run queries to Google Analytics’ API right from Excel, and publish its results there.

Say goodbye to many of the “Save to Excel” hassles that used to come with wishing to share and chart Google Analytics results beyond its powerful-yet-limited dashboard.

Go to Excellent Analytics now and give it a try. You’ll need Windows Vista or greater, Microsoft Office 7, and Windows .NET Framework 4. Give yourself a couple of hours to install and learn the system. Then start publishing, charting and sharing. You’ll fall in love the way I did!

Thoughts on Likemind: Guerrilla Marketing was easier back when it was harder

Guerrilla marketing, a concept coined by Jay Conrad Levinson and made popular during a simpler pre-Internet age, was never as easy as it sounded. The Internet’s arrival as a marketing tool didn’t make guerrilla marketing less relevant. It did heap on potentially detrimental distractions.

I was reminded of this when Jon Mueller announced the topic of his presentation, set for this Friday morning at Milwaukee’s June Likemind meet-up. The title is DIY: The Fine Line Between Building and Killing an Idea. Jon acknowledges that modern technology grants us unprecedented power to launch an idea or market a business. In some ways it’s a Utopia to the Jay Conrad Levinson of that long series of guerrilla marketing books. Each explored a different facet using guerrilla warfare tactics to out-compete bigger and better financed competitors.

Jon’s talk will describe how technology has not made do-it-yourself (DIY) marketing necessarily more surefire. He’ll explore how digital marketing provides “distraction, an assumption of promise (if I use this, the result will be this), and a diminished true interaction between people.” In other words, the very technology that can be a DIY heaven can also be a marketer’s undoing.

Since Jon is general manager of the business book giant 800ceoread.com, I’m expecting him to be citing business books like the Guerrilla Marketing series — but also more recent books on the perils of the Internet age.

Most notably, I’m expecting him to touch upon the new book by Nicolas Carr, The Shallows: What the Internet Is Doing To Our Brains, which just came out, and

It contends that the web is changing how we think and make decisions — and not for the better. I hope you join Jon at the event. Here are the details. It’s free of charge, at 7 AM on Friday. It also may be outdoors, weather permitting!

Finally, I’d like to brag about a one-degree-of-separation moment I had a few days ago. I met a co-author of two of the Guerrilla Marketing books. Al Lautenslager (a.k.a., @GMarketingGuy) is based in Appleton, Wisconsin. It was interesting to chat with someone who is keeping Levinson’s ideas current, as is evidenced by a smartly done and decidedly DIY marketing website. I hope we keep in touch, Al!

Online surveys as brand awareness Trojan horses

Another offline marketing tactic goes online. For years, some face-to-face or phone surveys during election seasons have been used to start or intensify voter opinion. Most of us have heard of these tactics, but if you haven’t, here’s an example:

“Hello, I’m doing research on the local senatorial race. Here’s our survey question for you: If you learned that Senator Jones, who is up for reelection, regularly terrified kittens, how would that influence your vote? And here’s our follow up question: What if you learned he was even meaner to cute little puppies?”

Click to view the ad in contextOther surveys of this ilk are less nefarious, but they do have this in common: They claim to do one thing while accomplishing another. Think of them as Trojan horses, carrying awareness instead of seeking to measure it.

I thought of this technique when I saw this online ad — er — I mean, survey.

I have to say, it’s kind of brilliant.

171 pros offer practical advice in Age of Conversation 3

Back in 2008 I discovered that many of my favorite authorities on social marketing had contributed to a one-of-a-kind volume: The Age of Conversation. I was glad to endorse it as a reader.

Now I’m even more excited about Drew McLellan and Gavin Heaton’s latest project — as one of its 171 contributors. Age of Conversation 3 is published by the new digital publishing company Channel V Books. It’s available through all major online retailers, as a Kindle e-book, and in the ePub book format that woks with other major digital readers.

Here’s a quote for the publication press release:

Age of Conversation 3 captures the distinct shift from social media as a hypothetical consumer loyalty tool, as it was considered only a little more than a year ago, to its current state as a staple in the modern marketing toolbox …

“We have seen an incredible shift in the role of social media over the past three years. It has moved from an outlier in the marketing mix to one of the strategic pillars of any corporate marketing or branding exercise,” said Drew McLellan.

“And it doesn’t end there,” adds Gavin Heaton. “As the many authors of this new book explain, the focus may be on conversation, but you can’t participate in a conversation from the sidelines. It’s all about participation. And this book provides you with 171 lessons in this new art”.

The genesis for the series itself has all the makings of a thrilling read: regular correspondence between people around the world; a proactive collaboration between 15 countries; and two marketing professionals who have never met each other face to face, scrambling to learn how to publish a book from the ground up.

Raising Money For Worthy Causes

This book is a good read as well. It’s also a way for its owners to do good works.

The first Age of Conversation raised nearly $15,000 for Variety, the international children’s charity. The next volume raised another $10,000 for the cause. McLellan and Heaton used a social marketing campaign tactic they called the “Conversation Bum Rush,” described in my March, 2008 post.

All profits from the sale of this volume are donated to the Make-A-Wish Foundation, a children’s charity nominated by me and a majority of the other 171 authors.

Find out more at the Age of Conversation blog. And feel free to join the Age of Conversation Facebook Fan Page.

The Authors:

Adam Joseph Priyanka Sachar Mark Earls
Cory Coley-Christakos Stefan Erschwendner Paul Hebert
Jeff De Cagna Thomas Clifford Phil Gerbyshak
Jon Burg Toby Bloomberg Shambhu Neil Vineberg
Joseph Jaffe Uwe Hook Steve Roesler
Michael E. Rubin anibal casso Steve Woodruff
Steve Sponder Becky Carroll Tim Tyler
Chris Wilson Beth Harte Tinu Abayomi-Paul
Dan Schawbel Carol Bodensteiner Trey Pennington
David Weinfeld Dan Sitter Vanessa DiMauro
Ed Brenegar David Zinger Brett T. T. Macfarlane
Efrain Mendicuti Deb Brown Brian Reich
Gaurav Mishra Dennis Deery C.B. Whittemore
Gordon Whitehead Heather Rast Cam Beck
Hajj E. Flemings Joan Endicott Cathryn Hrudicka
Jeroen Verkroost Karen D. Swim Christopher Morris
Joe Pulizzi Leah Otto Corentin Monot
Karalee Evans Leigh Durst David Berkowitz
Kevin Jessop Lesley Lambert Duane Brown
Peter Korchnak Mark Price Dustin Jacobsen
Piet Wulleman Mike Maddaloni Ernie Mosteller
Scott Townsend Nick Burcher Frank Stiefler
Steve Olenski Rich Nadworny John Rosen
Tim Jackson Suzanne Hull Len Kendall
Amber Naslund Wayne Buckhanan Mark McGuinness
Caroline Melberg Andy Drish Oleksandr Skorokhod
Claire Grinton Angela Maiers Paul Williams
Gary Cohen Armando Alves Sam Ismail
Gautam Ramdurai B.J. Smith Tamera Kremer
Eaon Pritchard Brendan Tripp Adelino de Almeida
Jacob Morgan Casey Hibbard Andy Hunter
Julian Cole Debra Helwig Anjali Ramachandran
Jye Smith Drew McLellan Craig Wilson
Karin Hermans Emily Reed David Petherick
Katie Harris Gavin Heaton Dennis Price
Mark Levy George Jenkins Doug Mitchell
Mark W. Schaefer Helge Tenno Douglas Hanna
Marshall Sponder James Stevens Ian Lurie
Ryan Hanser Jenny Meade Jeff Larche
Sacha Tueni and Katherine Maher David Svet Jessica Hagy
Simon Payn Joanne Austin-Olsen Mark Avnet
Stanley Johnson Marilyn Pratt Mark Hancock
Steve Kellogg Michelle Beckham-Corbin Michelle Chmielewski
Amy Mengel Veronique Rabuteau Peter Komendowski
Andrea Vascellari Timothy L Johnson Phil Osborne
Beth Wampler Amy Jussel Rick Liebling
Eric Brody Arun Rajagopal Dr Letitia Wright
Hugh de Winton David Koopmans Aki Spicer
Jeff Wallace Don Frederiksen Charles Sipe
Katie McIntyre James G Lindberg & Sandra Renshaw David Reich
Lynae Johnson Jasmin Tragas Deborah Chaddock Brown
Mike O’Toole Jeanne Dininni Iqbal Mohammed
Morriss M. Partee Katie Chatfield Jeff Cutler
Pete Jones Riku Vassinen Jeff Garrison
Kevin Dugan Tiphereth Gloria Mike Sansone
Lori Magno Valerie Simon Nettie Hartsock
Mark Goren Peter Salvitti  

Voice: The original rich media

I had a fun time talking to the group this morning at UnGeeked Elite. I spoke about the power of voice asset management. If you’d like to know more, here’s a post recently on our VoiceScreener blog, by our CEO, Kelly Fitzsimmons, describing Voice as an Asset (VaaA).

I promised to post a mind map of the post-presentation discussion. Here it is (click to expand):

Also, if you want to check out that TEC video, here’s my original post about it, Jeff Han’s demonstration of multi-touch screens. I was wrong in that it’s more slanted than vertical, as I had said in the presentation. I had seen another video of him demonstrating the screen somewhere else, and that one was more vertical, and shot more at a distance.

Finally, Jonathan Brewer, (@houseofbrew) of FirstEdge Solutions had dared me to show him that super-comfortable office chair I work on. Here’s the photo I just posted of it on TweetPhoto (click to expand):