
Creating a consistent brand all through many all social sites one of the best ways to maximize the value of a character or brand campaign.
Ryan Summers and I created a presentation on how to track users across various social media sites using mostly free tools. It was given at Web Analytics Wednesday in Portland, Oregon.
A few weeks before the MITX awards ceremony, ISITE Design created a short video called “El Consultador” as an introduction to other agencies.
The El Consultador campaign generated diverse social data. This created issues with tracking data from multiple social media sites across problems with social media is that these is no singular way to gather and rank all of the data over time. Tools like Radian6 and Trucast are in use by larger agencies and businesses, but there exist an increasing amount of free tools for data visualization and engagement reporting that are available online.
This Powerpoint was made for an audible presentation. I collaborated with Ryan Summers of ISITE design on it and presented it at Web Analytics Wednesday. I will attempt to explain the results/processes in a textual manner here.
We used analytic data from Flickr, Youtube, Vimeo and Twitter to determine the most successful aspects of the campaign.
On Vimeo:
http://vimeo.com/2309025

On YouTube:
http://www.youtube.com/watch?v=Xz6jt_aSFg0

On Flickr:
http://flickr.com/photos/elconsultador/
(Workers at ISITE design superimposed the Consultador face onto a variety of characters in pop culture).

On Twitter:
http://twitter.com/elconsultador

——
We determined a number of Key Performance Indicators of the social media campaign.
-Direct awareness of ISITE design agency
-3rd part mentions
-Social media followers (number of Twitter followers, comments on YouTube, Vimeo, Flickr).
-Direct communication
We used YouTube reports to track the engagement with the video campaign.
-Age Demograpics
-Gender Demograpics
-Discovery Sources
-Timeline Trends
The campaign was viewed predominately by 26-45 year old males and mostly during and around the date of the MITX awards. This is the demographic it was aimed at.
Vimeo is a high-quality Video sharing site with a limited but very engaged traffic demographic. We used Vimeo data to find more about who engaged with the campaign and compared it to YouTube data.
Flickr has a reporting tool for image views over time for every image. The data can be accessed with a premium Flickr account. We used this data to determine the most viewed (strongest/most impactful) pictures associated with El Consutador on the El Consultador account, and which images should be associated with the campaign on other sites (if future campaigns needed to be implemented).
We used data from Google Analytics for the page on which El Consultador existed on the ISISTE Webpage. Data was tracked from the “El Consultator” and “MITX” keywords. New visitors and direct traffic were also analyzed.

The campaign was picked up by three prominent bloggers, including Chris Brogan, Davaid Armano (VP of Experience Design with Critical Mass), and C.C. Chapman (Prominent figure in the community of podcasting, new media, cofounder of the Advanced Guard, a marketing company which focuses on utilizing social media and other emerging technologies).
Blogs linking to the campaigns were not found via inlink searches in Yahoo! Site Explorer, but with an intelligence feed created in Yahoo! Pipes (see below)
Custom intelligence feeds are useful for checking overall propagation of data. Yahoo! Pipes provides a free custom way to aggregate data across Google blog search, Google news, Technorati, Flickr, and Twitter.

———
I presented an extended set of tools and data visualization methods for Twitter. Links for all of them are here:
Reports/Demographic Research:
Summize
http://tweetstats.com/

TweetVolume
http://tweetvolume.com/

Twitter Mobile (vs. Twitter in browser)
http://m.twitter.com/home
Neoformix Twitter Stream Graphs
http://www.neoformix.com/Projects/TwitterStreamGraphs/view.php (I provided a live demo of this).

Twitter Stream Graphs are a simple way to rsearch keyword volume associated with a brand or campaign. Neoformix also tracks keywords over time, meaning that one can see when a certain keyword became popular.
——–
Future Suggestions:
More Flickr photos could be linked to all of the other accounts, such as Flickr, Youtube, and Vimeo. Linking together social media campaigns in a more robust fashion will affect CTR’s by making the campaign spreadable across various demographic profiles and types of social media users.
——-
Amber Case is a Cyborg Anthropologist who studies new media and the relationship between humans and computers. She enjoys data visualization (click for more info on conference tracking), search engine optimization (ask), and how marketing works in the online ecosystem.
She graduated from Lewis & Clark College in May 2008 with a degree in Sociology/Anthropology and wrote her thesis on cell phones and the effect of technology on cultural constructions of space and privacy.
You can follow her on Twitter @caseorganic, or drop her an E-mail at caseorganic[at]gmai[dot]com. She’s spoken at various conferences including MIT’s Futures of Entertainment 3, Inverge: The Interactive Convergence Conferece, Ignite Portland, and Ignite Boulder.
She also blogs at Nerdabout.com and http://www.blog.makerlab.org, a Portland new media incubator. She founded CyborgCamp, an unconference on the future of humans and technology. She is also involved with building and studying electronics with DorkbotPDX.
People are searching for things all the time on the web. If you’re a blogger looking to write good content, it is a good idea to get out there on the net to find what people are searching for. There are a few tools for doing this, but I wanted to isolate one of them and play with it for a minute.
@marknunney posted a link on Twitter about a “new tool from Wordtracker for content ideas”, so I clicked over to the site and read the following:
“People often type complete questions into search engines: if you find these questions and answer them, you could get some great search traffic”.
Below it was a box for entering in a word, so I tried a few words out. The results were amusing enough for me to want to share them. Further analysis follows.
![]()
I found the results for the word ‘life’ to be what one might expect. Right now, people are wondering about life insurance. However, the ‘color of life in ancient egypt’ is something that is phrased in such as strange way that it could warrant further research — especially since it was looked up 156 times. At #6, ‘what is the meaning of life’ is asked. I guess life insurance and ‘how time of my life was chosen for american idol’ were more important.
![]()
My personal favorite is #13 — ‘how to summon a real life dragon’. I bet if someone were to write a post on that, they’d get lots of hits. Maybe lots of Diggs too. I’m not sure how I’d go about researching that one. It’s probably better than trying to write a post on #8 — ‘how to ruin someone’s life’.
How does E-mail work? Apparently people are asking this question. But there is an important trend happening elsewhere in these question results. That would be the address of one (or rather two) ‘cole sprouse’. They happen to be identical twins, and are, according to the Cole Sprouse Wikipedia article, “known for their roles in the film Big Daddy…and for portraying the title characters on Disney Channel sitcoms”. Good luck finding their E-mail address, as well as the address of Prince Harry, Zac Efron and Jamie Spears.
![]()
But you can write about how to E-mail pictures, or #9’s ‘who invented E-mail’. That one actually seems particulary interesting. The narrative histories of everyday things are always a joy to read about.
‘How to write a business plan?’ Can’t one just download a template from Microsoft Word or something? That question is really a broad one. It depends on what kind of business one wishes to start. #3’s ‘how to start a cell phone business’ is pretty good. #10’s ‘what is the best business opportunity’ is a really intense question that cannot totally be answered. #11’s ‘how to start a web design business’ is actually very answerable by a variety of sources such as Design Float and Smashing Magazine.
![]()
#8’s ‘how to start a business with no money’ is interesting. I think it’s never been easier — and more difficult. It’s probably time that’s the big issue. Taking a lot of time really works. A cell phone business might manifest as an online reseller of cell phone accessories.
I was confused by these search results. I didn’t think they’d be this broad, or this ill-informed. Are Google founders Larry and Sergey that obscure? I wonder what sources Wordtracker is using for its search queries.
![]()
It might also be interesting to create a post on the founders of Google just to see what happened to it. I’m sure Wikipedia and Google have this question answered already.
I queried Yahoo! just to see what would happen. Very similar to Google’s results, except there was a question of what Yahoo stood for. I’m actually wondering that myself right now (goes off to find the answer).
![]()
The answer as to what Yahoo! stands for comes from About.com’s ‘Internet for Beginners’. The answer is that “Yahoo! (spelled with an exclamation mark) is short for “Yet Another Hierarchical Officious Oracle”. Apparently, “The original name: “David’s and Jerry’s Guide to the World Wide Web”, was appropriate, but not exactly catchy“. You can read the rest of Paul Gil’s Yahoo! article for the whole story.
The search results for money really surprised me. I had no idea that so many people wanted to know about ‘what presidents are on money’. I wonder what demographic asks this question the most. Is it youth? Is it due to a bet? Is it a homework assignment? Perhaps it is to clarify the use of slang words.
#2 and #3’s ‘how much money does it cost to open a bar’, and ‘how can kids make money’ are interesting. I’m wondering if more kids than parents searched for that phrase and if there a way to tell. As for #2, a lot of people seem to dream of owning and running their own bars.
![]()
I thought that #7’s ‘how to make money’ would be higher up on the results than that, but apparently the presidents on money trumps that. It’s also a much easier niche to write for than the seedy ‘how to make money’ post. #8 and #9’s ‘millionaires who give money to help’, and ‘millionaires who give free money’ make a lot of sense. Those questions make me wonder how many millionaires out there actually give money out to strangers who ask for it over the Internet. Generally, processes and charities are involved. Darn! Perhaps Google or a blogger will write about another way?
Puppies. They’re somewhat irresistible. So irresistible that a lot of people question just how large they’re going to get, apparently. It would be useful to make a site that gave information on how large any breed of puppy was going to grow. It would be complete with a puppy weight calculator, to answer question #3 as well. One would simply have to enter in the breed and the age of the puppy and the Internet robots would do the rest. Hooray for calculators.
![]()
I wonder how many new pet owners typed in #7 after watching their new puppy pee on their freshly installed carpet? Is there any way to tell? Perhaps they should’ve just stuck to drawing a puppy instead of owning one, like those who searched for #4’s ‘how to draw a puppy’.
This was wild. I did not expect to get results on horoscopes, tarot cards or reading palms. I’m not sure what I expected originally, but it wasn’t this. I thought people liked books more than daily horoscopes. My college experience has given me some explaination for these results. Everyone in my dorm was obsessed with reading their horoscopes to each other. Some of them even printed out astrological charts. I didn’t participate.
![]()
But result #6 makes a lot of sense in this respect. Aside from horoscopes, ‘To Kill a Mockingbird’ is one of those books that’s assigned to the majority of school districts across the United States. I’m assuming a lot of kids didn’t want to purchase the book, lent it to someone else, forgot it at home or at school, or were looking for a quick way to read a chapter before an annoying quiz after lunch or homeroom period.
What *is* RSS? Oh man. It is probably the greatest thing since the last iteration of really cool stuff that people enjoyed. It allows the quick and easy access of content without having to browse for it. I recommend watching RSS in Plain English instead of searching for RSS in Google. It’s an extremely short video by the Common Craft show. Totally sweetopian.
![]()
Hmm…#13’s ‘how do i find my twitter rss fed url’ is curious. Not only is fed spelled incorrectly, it is searched for 7 times. I’m sure there’s a great tutorial on this out there somewhere. …Or is there? I suppose that’ for random people to find out.
These were not surprising. ‘What does seo stand for?’ Search engine optimization, of course. How does one ‘become a certified seo?’ Well gee whiz, that’s a hard one. Probably from showing it on your own site, and the sites of your clients. And by not selling links from bad sites. Also, by educating people thoughly about your techniques.
![]()
‘How to set up seo?’ Go through a standard checklist on your website, checking for alt tags, title tags, a sitemap, ect. I like the free Website Grader from HubSpot for a really quick website check and grade.
I wondered about numbers next, so I checked out an the number six. Purely arbitrary (by arbichance? arbitration?). I was amused to find such a long phrase at the top of the question results. ‘The six basic fears and how to eliminate them’. That is totally a book by Sharry Harris. #2’s ‘what are the six terms of geography’ totally sounds like a query taken directly from a homework assignment.
![]()
#3’s ‘what are the six parts in a business letter’ has reminded me to re-examine my business letters for the correct number of parts. Perhaps I can do that while developing a six pack while using Six Sigma techniques.
‘What is Twitter?’ Ahh…if only there were an easy way to explain that. ‘How to use twitter’ is even more complicated. See, it is the emptiness of a vessel that gives it use-value, and Twitter is an empty vessel. The question of ‘What are you doing’ is never fully answered. Thus, how to use Twitter is like telling someone how to use a vase. The emptiness gives it many uses, whereas a tutorial can only give a finite amount of use-cases.
![]()
Finding the Twitter RSS feed URL is another matter. Simply scroll down to the bottom left corner of your Twitter page and click on RSS. Or you can right click to ‘copy the address’ to place it elsewhere with ease.
So Unicorns are very important to the state of the world. They give us a fantastic antithesis with which to view things. I assumed that I would get different results because of this mindset, but I did not. The number one search for unicorn relates to finding free Unicorn pictures to color. That is a total let-down.
![]()
I guess people are interested in drawing Unicorns, though. Perhaps they’ll make some awesome viral Unicorn videos when they get older. Like Charlie the Unicorn.
WordTracker’s new tool is pretty fun, but I’m not sure how terribly useful it really is. I think you’re the judge for that.
————-
Amber Case is a Cyborg Anthropologist and Internet Marketing Consultant from Portland, Oregon. You can follow her online @caseorganic.
Adam Duvander started off by explaining that Portand Web Innovators is around three years old now. That makes it one of the cornerstones of the Portland Tech scene.
Scott Kveton told us his ideas on the state of current social networks. His charisma and ability to explain and parse complex ideas, systems, and trends was interesting and enjoyable to watch. I estimate around 30+ people showed up, and many interesting questions were raised from the audience.
Oh yeah…and there was lots of Bacon.
In case you missed it, the entire event was archived. Yes — every moment of the presentation can be viewed, thanks to @brampitoyo and @maestrojed.
Scott Kveton is a digital identity promoter, open source contributor, and VP of Open Platforms for Vidoop.
>>
Scott Kveton’s Blog
BaconGeek
Twitter Scott Kveton
Vidoop
—-
Amber Case is a Cyborg Anthropologist from Portland, Oregon. She enjoys tech events and the minds of people who attend them. You can follow her on Twitter @caseorganic.