All posts by Dawn

Keyword CSV Files and Searching: 2 Minute Yahoo Pipes Demo

It’s been a while since I’ve posted a 2 minute Yahoo Pipes video, but I had an opportunity to do a guest post on the Yahoo Developer Network blog (yay!), and I thought that a 2 minute screencast would be the best way to demonstrate my pipe.

This 2 minute demo takes a series of keywords from a CSV file and uses Yahoo Pipes to run each keyword through various searches. This technique can be very powerful when you search multiple services, but I’ve simplified the process to make it easier to understand the fundamentals of the technique by running the list of keywords only through Twitter search.

Here’s a quote about the technical details of the pipe from the Yahoo Developer Network post:

Technical Details and More Information:

  • The Demo Pipe. A copy of the Keyword CSV demo pipe – click “View Source” to see the modules.
  • Fetch CSV Module. Enter the URL of the CSV file (make sure that it already exists in a publicly accessible location) along with information about column names and separation characters as needed.
  • Loop module with URL Builder. Loops through each element in the CSV file and builds a search URL formatted for RSS output. In this case, we used Twitter search.
  • Loop module with Fetch Feed. Loops through each URL built in the previous step and fetches the feed associated with the item.
  • Sort Module. Sort by date in descending order to make sure things are sorted in a logical manner.
  • Pipe Output. The final module in every Yahoo Pipe.

I’ve created many Yahoo Pipes, and most of them have been published on my Yahoo Pipes and RSS Hacks page where you can also learn more about my Yahoo Pipes Training course on May 7th.

Related Fast Wonder Blog posts

Get a Discount on My Introduction to Yahoo Pipes Class

With only a week left, there are still seats available in my Introduction to Yahoo Pipes class on May 7th. If I was selling mattresses or cars, I would probably have some kind of giant clearance sale to get rid of the excess inventory, right? Why should my Yahoo Pipes class be any different? OK, OK, I promise to be less annoying about it.

Here’s the deal, register now with the discount code ‘bigsale’ to get 30% off the regular price. In other words, you can get in for $70 (student, freelancer, or not currently employed) or for $105 for the corporate types if you meet the early bird deadline of May 5th!

The Details:
When: Thursday, May 7, 2009 from 3:00pm – 5:00pm
City: Portland, OR
Location: WebTrends 851 SW 6th Ave., Suite 1600 (no remote attendance)
Learn more: Prerequisites, Course Outline and Information

Register for the course

Social Media Users Are Older and More Business-Like Than You Think

I had an interesting conversation with a client recently who was expressing doubt about whether their audience, less technical business professionals over 40, was participating in any meaningful way in social media. As a result of this conversation, I spent some time digging into the data, and I wanted to share what I learned.

Your Competitors Are Investing in Social Media

Companies are continuing to invest more money in social media, which will continue to fuel the growth of social media technologies. At least some of your competitors have plans to invest more resources and increase spending on social media. Here are a few examples from eMarketer and Forrester.emarketing1 emarketing3

emarketing2

forrester

Twitter Users Are Trending Older

According to Nielsen, Twitter is growing rapidly and people using Twitter tend to trend older than you might expect with 35 – 49 year-olds making up almost 42% of the traffic to Twitter.com.

twitter growthtwitter age demo

Nielsen has also found that the majority of Twitter users access it from work:

“Twitterers (a.k.a. Tweeters) are not primarily teens or college students as you might expect. In fact, in February the largest age group on Twitter was 35-49; with nearly 3 million unique visitors, comprising almost 42 percent of the site’s audience. We found that the majority of people visit Twitter.com while at work, with 62 percent of the combo unique audience accessing the site from work only versus 35 percent that accessed it from home only.”

comScore has also noticed a similar trend in Twitter users:

“18-24 year olds, the traditional social media early adopters, are actually 12 percent less likely than average to visit Twitter (Index of 88). It is the 25-54 year old crowd that is actually driving this trend. More specifically, 45-54 year olds are 36 percent more likely than average to visit Twitter, making them the highest indexing age group, followed by 25-34 year olds, who are 30 percent more likely.”

twitter-chart2

Facebook Users Are Trending Older

According to Nielsen:

While social networks started out among the younger audience, they’ve become more mainstream with the passage of time. Not surprisingly the audience has become broader and older. This shift has primarily been driven by Facebook whose greatest growth has come from people aged 35-49 years of age (+24.1 million). From December 2007 through December 2008, Facebook added almost twice as many 50-64 year old visitors (+13.6 million) than it has added under 18 year old visitors (+7.3 million).

facebook_growth

According to Inside Facebook:

Looking at Facebook US audience growth over the last 180 days, it’s clear that Facebook is seeing massive increases in adoption amongst users 35-65. The fastest growing demographic on Facebook is still women over 55 – there are now nearly 1.5 million of them active on Facebook each month.

The biggest growth in terms of absolute new users over the last six month came amongst users 35-44. Over 4 million more US women 35-44 and nearly 3 million more US men 35-44 used Facebook in March 2009 compared to September 2008.

Online Community Participants Also Increasing in Age

online community ages

There you have it. A big data dump of various research into social media and online community age demographics. If you know of other research, please feel free to share them in the comments.

Related Fast Wonder Blog posts:

Companies and Communities Available in Paperback

Those of you who have been holding out for a dead tree version of Companies and Communities: Participating without being sleazy are now in luck. Companies and Communities is now available as a 130 page paperback book for $15.99. It’s small, light and easy to carry around with you or read on the plane.

For anyone who needs an extra incentive to order it, you can get $3.00 off from now until May 2 by using this discount code: QYW8QS6W to get it for $12.99. I’ll even sign it if you can catch me at Beer and Blog or other local tech events. 🙂

I’ve also lowered the price of the PDF eBook to $9.99, and you can also get it on the Kindle for $9.99.

As always, I appreciate any feedback about the book (typos, additions for future versions, etc.).

Companies and Communities eBook 1/2 Price Sale for Innotech

Thank you to everyone who attended our panel today, and especially to those of you who asked great questions! As a special thank you, I am offering an Innotech 1/2 price sale for my eBook.

For the next 3 days, you can get my Companies and Communities: Participating without being sleazy eBook for 1/2 price in honor of Innotech using this discount code: emspdx.

Companies and Communities is focused on helping your company get real business value out of participating in online communities and social media. This 80 page eBook contains practical advice and suggestions for how companies can engage with online communities and social media sites. It is available as a PDF download for $9.99 using the discount code above instead of the normal price of $19.99.

The eBook includes:

  • Guiding Principles
  • Blogs and Blogging
  • Twitter
  • Social Networks (Facebook and MySpace)
  • Custom Corporate Communities
  • Community Management
  • and more

Want to Help with BarCampPortland – May 1 and 2?

BarCampPortland is right around the corner on May 1 & 2, and we need your help to make it successful!

  • Donate! We’re a little short on money to feed people at Barcamp. By donating a few bucks, you can help us buy some food for the event.
  • Sponsor! These events can’t be successful without our sponsors. Contact Todd Kenefsky (kenefsky on gmail) if you would like to sponsor a portion of the event.
  • Volunteer to help. BarCampPortland is an event run entirely by volunteers. Contact  klint at renegadefuturist.com if you can spare a few hours on Friday or Saturday to help.
  • RSVP. Don’t forget to RSVP for the event on Upcoming.
  • Follow us on Twitter: Up to the minute breaking updates about the event as @BarCampPortland

You can learn more about the event by visiting the BarCampPortland wiki.

Related Fast Wonder Blog posts: