This is the second post in a series where we explore Entities in the Social Analytics Lab API. Through this series of posts, we will provide details on how the Entities can be used to accomplish some basic scenarios in the Social Analytics lab.

In this scenario we’ll look at identifying top threads for one of the lab datasets. To accomplish this, you will  need three Entities in our API (pictured below):

 

Filters

Filters are a central concept in storing and retrieving data in the Social Analytics Lab. You could think of the set of filters as a list of topics available in an Social Analytics Instance. For example, the Windows 8 lab includes the following filters:

Id

Name

1

DataAcquisition: Windows 8

2

DataAcquisition: Windows 8 on Twitter

3

DataAcquisition: Windows 8 on YouTube

4

Subscription Filter for @g_win8slice

6

Windows 8 and Tablet PCs

7

Windows 8

8

Non-Twitter

10

Windows 8 on Facebook

11

Windows 8 and Applications

12

Windows 8 Design and User Experience

13

Windows 8 and Applications 2

 

Notice that three of the Filters are labeled as Data Acquisition Filters. Filters can control what activity from social media channels is tracked in an instance of Social Analytics or it can be simply a materialized view over the social data tracked in an instance. With our permissions model for filter definitions, control over what Social Data is tracked in an instance can be controlled while giving many users permissions to define filters that are views over the data.

MessageThreads

We define a MessageThread as a post and all of its replies within a channel. MessageThreads are the primary unit of activity we use to track social channel activity. If you examine the MessageThreads entity, you’ll find a collection of measures described an aggregated view of the thread, including:

  • Replies
  • Answers
  • Likes
  • Retweets
  • IsQuestion
  • IsAnswered
  • PositiveSentiment
  • NegativeSentiment

The Replies field is a total of all replies of all types in the thread, so you don’t want to sum Replies and Answers etc., or you’ll be double-counting.

FilterResultCaches

FilterResultCaches represents what MessageThreads relate to all filters, and is one of the most useful Entities for analyzing Social Analytics data. Using the following LINQ Query in LinqPad:

(
from f in FilterResultCaches
orderby f.MessageThread.Replies descending
where f.FilterId == 6
&& f.MessageThread.Replies > 1
&& f.LastUpdatedOn > DateTime.Now.AddDays(-7)
select new
{
f.MessageThread.Replies,
f.Site.Name,
f.MessageThread.PositiveSentiment,
f.MessageThread.NegativeSentiment,
f.MessageThread.LastReplyContentItem.Title,
f.MessageThread.LastReplyContentItem.HtmlUrl,
}
).Take(10)

we can find the Messagethreads with the most replies during the last 7 days in the “Windows 8 and Tablet PCs” filter:

Replies

Name

PositiveSentiment

NegativeSentiment

Title

HtmlUrl

126

twitter.com

0

0

RT @TheNextWeb: If the Kindle Fire nearly runs Windows 8, why do we need quad-core Android tablets? http://t.co/fcXyxiU1 by @alex on @TN ...

http://twitter.com/RenoYuuki/statuses/138211182040449024

33

twitter.com

0

0

RT @blogtweetz: Nokia Tablet To Debut in Summer 2012 - Powered By Windows 8 ! http://t.co/EniexIKY via @Dazeinfo

http://twitter.com/epremierleague/statuses/138931098318155776

13

twitter.com

0

0

RT @9to5mac: How well does Mac OSX run on Samsung’s Windows 8 Tablet? [Video] http://t.co/tvOJVmSj

http://twitter.com/carlst3/statuses/139378162495791106

7

twitter.com

0

0

RT @Indiferencia: Nokia lanzará tablet con Windows 8 en junio de 2012 http://t.co/54Wf3Rza

http://twitter.com/endamo/statuses/138029411483131905

6

twitter.com

0

0

RT @Entiendelas: Nokia lanzará tablet con Windows 8 en junio de 2012 http://t.co/bMvT7gXr

http://twitter.com/Lacangri1412/statuses/137750579417055232

6

twitter.com

0

0

RT @dehaaspeter: BCG: Windows tablet populairder dan iPad van Apple : http://t.co/P4GedXkY #windows8

http://twitter.com/OscarMinkenberg/statuses/139273712657637376

5

twitter.com

0

0

RT @OfficeTH: โอ้วว้าว...!Win8 Tablet บน Nokia จะเฝ้ารออออ!!! http://t.co/4lFOjLmO

http://twitter.com/opal_monkey/statuses/138607317817114624

4

twitter.com

0

0

RT @LeaNoticias: Nokia lanzará tablet con Windows 8 en junio de 2012 http://t.co/DjOAGG9k

http://twitter.com/daichu_/statuses/138098502550040576

4

twitter.com

1

0

RT @Indiferencia: Nokia lanzará tablet con Windows 8 en junio de 2012 http://t.co/54Wf3Rza

http://twitter.com/arknglzintetico/statuses/138627023793954817

4

twitter.com

0

0

RT @freddier: Tablet Samsung con Windows 8 [pic] http://t.co/cyENejTk #techdayschile

http://twitter.com/GustavoRiveraMX/statuses/138723108952612864

 

The results include our calculated Positive and Negative Sentiment. The values indicate the number of content items in the MessageThread with 80% or more confidence that the tone is either positive or negative.

Check out our next blog post to find out more about what you can do with the entities in the Social Analytics Lab.

Also, please let us know what questions you have or other interesting discoveries you find in the labs.