Building a Social Media Listener with SharePoint

Designer 2007Ken Efta, Principal Consultant, Allyis, Inc.

Going Where the Conversation Is Why SharePoint? Listener Demo and DVWP Deep Dive Beyond SharePoint Designer: Cold-Booting a

Health and Wellness Site with Social Content

Taking it even further How will SharePoint 2010 help?

Agenda

Charlene Li and Josh Bernoff, Groundswell Conversations are happening about your

company, brand, industry, interests RIGHT NOW

You can’t control those conversations, but you’re making a mistake if you don’t listen up and engage

Customers are asking for ways to reach out

Why Social Media?

First, some business context SharePoint didn’t matter. But then it really

began to matter. SharePoint—and specifically the Data View

Web Part—as a heuristic and prototyping tool

Bringing the conversation home:◦ Integrating social experiences into process and

workstyle◦ Discovering, surfacing, and embracing the

conversations already happening

Why SharePoint?

Demo: Sashiko

First, some business context SharePoint didn’t matter. But then it really

began to matter. SharePoint—and specifically the Data View

Web Part—as a heuristic and prototyping tool

Bringing the conversation home:◦ Discovering, surfacing, and embracing the

conversations already happening◦ Integrating social experiences into business

process and workstyles

Data View Web Part and Social Media API Endpoints

Your data sources in SharePoint Designer◦ Twitter:

http://search.twitter.com/search.atom?q=SharePoint&rpp=8

◦ Google Blog Search: http://blogsearch.google.com/blogsearch_feeds?hl=en&q=SharePoint&num=10&output=rss

◦ YouTube: http://gdata.youtube.com/feeds/api/videos?q=SharePoint

◦ Pre-aggregated sources: Yahoo Pipes

Social Media API Endpoints

May require applying for an API key May require some pre-processing

Flickr: http://api.flickr.com/services/rest/?method=flickr.photos.search&tags=SharePoint&api_key=c5215ed49dae49985be8355a0b10346f&per_page=10&page=1

SlideShare: http://www.slideshare.net/api/2/search_slideshows?q=SharePoint&api_key=S1BypFRz&ts=1241475228&hash=c788ca9b486cf54686836e3d59c047eccec062b9 Hash = SHA1 (sharedsecret + unix timestamp).

Social Media API Endpoints

Demo: Building a Twitter Data View Web Part

Not truCast or Radian6 Read-only snapshot at one point in time

(anecdotal)--no trending or engagement analysis

No sentiment analysis No social media volume or statistical analysis No reputation or influencer measurement No authenticated interactivity with Social

Media APIs No real-time update without page refresh

What this listener doesn’t do

Demo: Cold-Booting a Health and Wellness Site with Social Content

Imports content from Social Media properties into a SharePoint list

Interface for RNs to review and approve content

Stopword scanning and flagging Can do a general scan and import –OR- Can query social media properties based on

managed profile properties (e.g. a twitter handle) and search terms or #tags.

Social content alongside of editorially-prepared content

Beyond Listening

Use Excel Services to surface trending calcs Leverage KPI lists (define targets and

measure against them) AJAX/JQuery to asynch refresh results .Net Development to more fully integrate

APIs Integrate with Search and MySites Develop a library of rich social content

based on specific context and criteria you set

Taking it further

Scalable Lists Sandboxed Solutions Rich organizational collaboration tools with

MySites Activity feed and status updates Ominpresent ratings, note board, and

tagging Enterprise Wikis DVWP and CQWP improvments

How SharePoint 2010 will help

Questions