Tracking Engagement, KPI’s Across Multiple Social Media Sites – El Consultador

Fictional character creation is a useful tool in creating an intriguing narrative that captures attention, especially since the character can be easily adapted to fit different digital spaces, such as Video, Microblogging, and Image sharing sites. Media diversity  is also useful in building and unifying online communities that access with media in separate channels.el-consultador-isite-design

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.

Profiles Created for the El Consultador Campaign

We used analytic data from Flickr, Youtube, Vimeo and Twitter to determine the most successful aspects of the campaign.

On Vimeo:

El Consultador on Vimeo

On YouTube:

El Consultador on YouTube

On Flickr:
(Workers at ISITE design superimposed the Consultador face onto a variety of characters in pop culture).

El Consultador on Flickr
On Twitter:

El Consultador on Twitter

Key Performance Indicators

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

YouTube Reports

We used YouTube reports to track the engagement with the video campaign.

Data tracked included:

-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 Stats

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 Reports

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).

Google Analytics

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.

El Consultador on Google Analytics

Social Nodes

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)

Tracking Overall Data

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.

El Consultador Intelligence Feed


Data Visualization and Tracking for Twitter

I presented an extended set of tools and data visualization methods for Twitter. Links for all of them are here:

Reports/Demographic Research:

El Consultador on TweetStats

El Consultador on TweetVolume

Twitter Mobile (vs. Twitter in browser)

Neoformix Twitter Stream Graphs (I provided a live demo of this).

El Consultador Stream Graphs

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 and, 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.

Wordtracker Experiment | Finding Out What People Search For

Wordtracker Labs Logo

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.

Find Questions People are Asking

Results for Life

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.

Life Wordtracker Results

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’.

Results for E-mail

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.

E-mail Wordtracker Results

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.

Results for Business

‘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.

Business Wordtracker Results

#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.

Results for Google

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.

Google Wordtracker Results

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.

Results for Yahoo

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).

Yahoo Wordtracker Results

The answer as to what Yahoo! stands for comes from’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.

Results for Money

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.

Money Wordtracker Results

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?

Results for Puppy

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.

Puppy Wordtracker Results

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’.

Results for Read

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.

Read Wordtracker Results

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.

Results for RSS

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.

RSS Wordtracker Results

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.

Results for SEO

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.

SEO Wordtracker Results

‘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.

Results for Six

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.

Six Wordtracker Results

#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.

Results for Twitter

‘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.

Twitter Wordtracker Results

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.

Results for Unicorn

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.

Unicorn Wordtracker Results

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.

Final Verdict

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.

Social Network Spaghetti | Portland Web Innovators at Vidoop

Tonight was an event associated with Portland Web Innovators called Social Network Spaghetti. It happened at 7pm at Vidoop in Downtown Chinatown.

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.

Video chat rooms at Ustream

Scott Kveton is a digital identity promoter, open source contributor, and VP of Open Platforms for Vidoop.


Check out more Scott Kveton

Scott Kveton’s Blog
Twitter Scott Kveton


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.