<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Microsoft Codename "Social Analytics"</title><link>http://blogs.msdn.com/b/microsoft_codename_social_analytics/</link><description /><dc:language>en-US</dc:language><generator>Telligent Evolution Platform Developer Build (Build: 5.6.50428.7875)</generator><item><title>Microsoft Codename "Social Analytics" - Lab Phase is Complete</title><link>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2012/06/21/microsoft-codename-quot-social-analytics-quot-lab-phase-is-complete.aspx</link><pubDate>Thu, 21 Jun 2012 22:23:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10322757</guid><dc:creator>Social Analytics Team</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://blogs.msdn.com/b/microsoft_codename_social_analytics/rsscomments.aspx?WeblogPostID=10322757</wfw:commentRss><comments>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2012/06/21/microsoft-codename-quot-social-analytics-quot-lab-phase-is-complete.aspx#comments</comments><description>&lt;p&gt;&lt;span style="font-size: medium;"&gt;The Microsoft Codename "Social Analytics" lab phase is complete.&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;"&gt;Here is what we wanted to learn from this lab:&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;span style="font-size: small;"&gt;How useful do customers find this scenario?&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style="font-size: small;"&gt;API prioritization: We wanted to understand which features developers needed to implement first and how easy it is to implement these (for example, content&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;item display, how to modify filters, etc.).&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style="font-size: small;"&gt;API usability: Were our APIs hard to use, easy to use, consistent with existing methods, or did they add to the concept count?&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;&lt;span style="font-size: small;"&gt;We have received a lot of useful feedback which will shape our future direction.&amp;nbsp; We would like to thank everybody who participated for their valuable feedback!&lt;/span&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10322757" width="1" height="1"&gt;</description></item><item><title>Lab Bonus! Enhanced Sentiment Analysis for Twitter from Microsoft Research</title><link>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2012/02/02/lab-bonus-enhanced-sentiment-analysis-for-twitter-from-microsoft-research.aspx</link><pubDate>Thu, 02 Feb 2012 17:30:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10263315</guid><dc:creator>Social Analytics Team</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://blogs.msdn.com/b/microsoft_codename_social_analytics/rsscomments.aspx?WeblogPostID=10263315</wfw:commentRss><comments>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2012/02/02/lab-bonus-enhanced-sentiment-analysis-for-twitter-from-microsoft-research.aspx#comments</comments><description>&lt;p&gt;&lt;span style="text-decoration: underline;"&gt;What&amp;rsquo;s new?&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;In this release, we enhanced our sentiment software by upgrading to the latest version of code from the same Microsoft Research team we used in prior releases.&amp;nbsp; The major improvement in this version of their code is a new classifier specifically trained on Tweets.&amp;nbsp; The sentiment analysis code we used in prior releases from Microsoft Research was trained on short sentences and paragraphs.&amp;nbsp; We predict that the accuracy of sentiment analysis will improve in Social Analytics by using the classifier trained specifically on tweets for Twitter content items.&amp;nbsp; We will continue to use the sentence and paragraph classifiers on all other content.&lt;/p&gt;
&lt;p&gt;The tweet classifier was trained on nearly 4 million tweets from over a year&amp;rsquo;s worth of English Twitter data. It is based on a study of how people express their moods on Twitter with mood-indicating hashtags. We mapped over 150 different mood-bearing hashtags to positive and negative affect, and used the hashtags as a training signal to learn which words and word pairs in a tweet are highly correlated with positive or negative affect.&amp;nbsp;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;span style="text-decoration: underline;"&gt;How we use the sentiment software in Social Analytics&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;We use the MSR sentiment software to assess the tone of all content items as part of our enrichment process.&amp;nbsp; &amp;nbsp;When the assessment is complete we store both that ranking and the reliability of that assessment the these 2 fields respectively; CalculatedToneID and ToneReliability.&amp;nbsp;&amp;nbsp; Our API and sample client Silverlight UI will expose content item as either positive or negative if the sentiment engine scores the item with a reliability percentage over a certain threshold we determine.&lt;/p&gt;
&lt;p&gt;Here is a simple explanation of the three fields&amp;nbsp;related &amp;nbsp;to sentiment in the ContentItem table:&lt;/p&gt;
&lt;table border="0" cellspacing="0" cellpadding="0"&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td valign="top" width="187"&gt;
&lt;p&gt;&lt;b&gt;Field&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="570"&gt;
&lt;p&gt;&lt;b&gt;Description&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="187"&gt;
&lt;p&gt;&lt;b&gt;CalculatedToneID&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="570"&gt;
&lt;p&gt;The sentiment (or tone) of the content item as determined&amp;nbsp;by the sentiment software:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;div style="padding-left: 30px;"&gt;3 = Neutral&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;div style="padding-left: 30px;"&gt;5 = Positive&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;div style="padding-left: 30px;"&gt;6 &amp;nbsp;=Negative&lt;/div&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="187"&gt;
&lt;p&gt;&lt;b&gt;ToneReliability&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="570"&gt;
&lt;p&gt;The reliability of the tone calculation as determined by&amp;nbsp;&amp;nbsp; the sentiment software.&amp;nbsp; The reliability thresholds are currently 80%&amp;nbsp;for positive sentiment and 90% for negative sentiment.&amp;nbsp; If we&amp;rsquo;re below&amp;nbsp;the reliability threshold, the CalculatedToneId will be set to neutral.&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="187"&gt;
&lt;p&gt;&lt;b&gt;ToneID&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="570"&gt;
&lt;p&gt;If a user sets the sentiment manually in our UI or thru an&amp;nbsp;&amp;nbsp; API call, the tone they set is stored in this field.&amp;nbsp; If ToneID is set,&amp;nbsp;we show ToneID rather than CalculatedToneID in the UI and return it in API&amp;nbsp;calls.&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;&amp;nbsp;For more details on this Microsoft Research project, check out&amp;nbsp;&lt;a href="http://research.microsoft.com/tweetaffect"&gt;http://research.microsoft.com/tweetaffect&lt;/a&gt;&amp;nbsp;!&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10263315" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/Azure/">Azure</category><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/SQL+Azure/">SQL Azure</category><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/Social+Analytics/">Social Analytics</category><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/SocialAnalytics/">SocialAnalytics</category></item><item><title>Enhanced Analytics and Sentiment Analysis Arrive in Social Analytics</title><link>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2012/01/30/what-s-new-announcing-a-update-to-the-microsoft-codename-social-analytics-lab.aspx</link><pubDate>Mon, 30 Jan 2012 17:06:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10261787</guid><dc:creator>Social Analytics Team</dc:creator><slash:comments>5</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://blogs.msdn.com/b/microsoft_codename_social_analytics/rsscomments.aspx?WeblogPostID=10261787</wfw:commentRss><comments>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2012/01/30/what-s-new-announcing-a-update-to-the-microsoft-codename-social-analytics-lab.aspx#comments</comments><description>&lt;p&gt;We are proud to announce an update to&amp;nbsp;the &lt;b&gt;Microsoft Codename &amp;ldquo;Social Analytics&amp;rdquo; Lab. &lt;/b&gt;&amp;nbsp;This update&amp;nbsp;builds on the services&amp;nbsp;we announced in October by&amp;nbsp;providing the following new capabilities:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;Enhanced analytics in our API&lt;/li&gt;
&lt;li&gt;Sample usage of the enhanced analytics in the Engagement Client - 5 new analytic widgets&lt;/li&gt;
&lt;li&gt;Improved sentiment analysis for Tweets&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;&lt;strong&gt;1. Enhanced Analytics:&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;Our existing API now provides richer analytics views of social data.&amp;nbsp; This makes it easier to find&amp;nbsp;top conversations, contributors, keywords and sources related to any filter with a simple ODATA query and returns&amp;nbsp;conversations related to these calculations&amp;nbsp;to your application.&lt;/p&gt;
&lt;p&gt;Here&amp;rsquo;s a sample* ODATA query returning the top 5 keywords found in a filter for the past 7 days:&lt;/p&gt;
&lt;p&gt;&lt;a href="https://api.datamarket.azure.com/Vancouver/VancouverBillGates/GetTopKeywords?TimeIntervalSize='day'&amp;amp;TimeIntervalCount=7&amp;amp;TimeIntervalEnd=&amp;amp;FilterId=4&amp;amp;ResultsLimitTo=5"&gt;https://api.datamarket.azure.com/Vancouver/VancouverBillGates/GetTopKeywords?TimeIntervalSize='day'&amp;amp;TimeIntervalCount=7&amp;amp;TimeIntervalEnd=&amp;amp;FilterId=4&amp;amp;ResultsLimitTo=5&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;You can start investigating the details of the API by going to &lt;a href="https://connect.microsoft.com/BusinessPlatform/Downloads/DownloadDetails.aspx?DownloadID=39340"&gt;this link&lt;/a&gt;.&amp;nbsp; If you are new to Social Analytics,&amp;nbsp;check out our API overview &lt;a href="https://connect.microsoft.com/BusinessPlatform/socialanalytics"&gt;here&lt;/a&gt;.&lt;/p&gt;
&lt;p&gt;* Note: You will need to use your existing credentials for the lab to use this sample code.&amp;nbsp;(Look at the API section&amp;nbsp;&lt;a href="https://connect.microsoft.com/BusinessPlatform/socialanalytics"&gt;here&lt;/a&gt; for details)&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;2. New Analytics Widgets in the Engagement Client:&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;See the new enhanced analytics in use in our sample Silverlight UI &amp;ndash; &lt;a href="https://connect.microsoft.com/BusinessPlatform/content/content.aspx?ContentID=27095"&gt;the Engagement Client&lt;/a&gt;.&amp;nbsp;&amp;nbsp; We built these 5 analytic widgets using the new analytic enhancements to our API. &amp;nbsp;&amp;nbsp;These widgets provide&amp;nbsp;the following analytic views&amp;nbsp;for any filter:&lt;/p&gt;
&lt;ol&gt;
&lt;li&gt;Top Conversations&lt;/li&gt;
&lt;li&gt;Top Contributors&lt;/li&gt;
&lt;li&gt;Top Keywords&lt;/li&gt;
&lt;li&gt;Volume&lt;/li&gt;
&lt;li&gt;Sources&lt;/li&gt;
&lt;/ol&gt;
&lt;p&gt;Here's an illustration of the new analytics in the sample Silverlight client:&lt;/p&gt;
&lt;p&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/5417.UIScreenBig_2800_Updated_2900_.jpg"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/5417.UIScreenBig_2800_Updated_2900_.jpg" /&gt;&lt;/a&gt;&lt;/p&gt;
&lt;ol&gt;&lt;/ol&gt;
&lt;p&gt;&lt;strong&gt;3. Improved Sentiment Analysis for Tweets&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;In this release, we snuck in&amp;nbsp;a little bonus!&amp;nbsp; We updated the sentiment engine with&amp;nbsp;minor enhancements to improve the analysis of sentiment in Tweets.&amp;nbsp;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;That's what's new in this release!&amp;nbsp;&amp;nbsp; In a few short months, we've made major progress on this experimental cloud service.&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Now it's time for you to try the updated lab and let us know what you think.&amp;nbsp; We're already working on the top feature request from our fall release - giving you the ability to define your own topics.&amp;nbsp;&amp;nbsp;We&amp;nbsp;plan on making that functionality part of&amp;nbsp;a&amp;nbsp;future release.&lt;/p&gt;
&lt;p&gt;For those new to&amp;nbsp;this Lab, please check out &lt;a href="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/10/25/announcing-microsoft-codename-quot-social-analytics-quot-lab.aspx" target="_blank"&gt;our initial blog post&lt;/a&gt; for an overview of&lt;strong&gt;&amp;nbsp;Microsoft Codename "Social Analytics"&lt;/strong&gt;.&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Here are&amp;nbsp;some additional links&amp;nbsp;from that post for your convenience:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;div style="padding-left: 30px;"&gt;&lt;a href="http://go.microsoft.com/fwlink/?LinkID=230530&amp;amp;clcid=0x409"&gt;Get started today&lt;/a&gt;&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;div style="padding-left: 30px;"&gt;Visit our &lt;a href="http://www.microsoft.com/en-us/sqlazurelabs/labs/socialanalytics.aspx"&gt;official homepage&lt;/a&gt;&amp;nbsp;and &lt;a href="https://connect.microsoft.com/BusinessPlatform/socialanalytics"&gt;Connect Site&lt;/a&gt;&amp;nbsp;for more information&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;div style="padding-left: 30px;"&gt;Connect with us in our &lt;a href="http://social.msdn.microsoft.com/Forums/en-US/category/windowsazureplatformctp"&gt;forums&lt;/a&gt;&amp;nbsp;&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;div style="padding-left: 30px;"&gt;Stay tuned to our &lt;a href="http://blogs.msdn.com/b/microsoft_codename_social_analytics/"&gt;product blog&lt;/a&gt; for future updates&lt;/div&gt;
&lt;/li&gt;
&lt;/ul&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10261787" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/Azure/">Azure</category><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/SQL+Azure/">SQL Azure</category><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/Social+Analytics/">Social Analytics</category><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/SocialAnalytics/">SocialAnalytics</category></item><item><title>Finding Top Handles</title><link>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2012/01/09/finding-top-handles.aspx</link><pubDate>Mon, 09 Jan 2012 18:48:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10254672</guid><dc:creator>Social Analytics Team</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://blogs.msdn.com/b/microsoft_codename_social_analytics/rsscomments.aspx?WeblogPostID=10254672</wfw:commentRss><comments>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2012/01/09/finding-top-handles.aspx#comments</comments><description>&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;This post is a continuation of a series of posts that provides details on how the Entities can be used to accomplish some basic scenarios in the Social Analytics lab. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;In this scenario we&amp;rsquo;ll look at identifying top participants for one of the lab datasets. To accomplish this, we need on two Entities in our dataset (pictured below):&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/3034.Handles.PNG"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/3034.Handles.PNG" width="134" height="228" /&gt;&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;br /&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Using these two entities we can discover who is most active in the conversations included in our dataset. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/strong&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Handles &lt;/span&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Handles are the primary element of a person&amp;rsquo;s identity for a site. You may have discovered (as mentioned in our &amp;ldquo;Boo&amp;rdquo; post) the ability to open a column in the Engagement Client for a person&amp;rsquo;s conversation. Handle is the entity used to track all content items for a person. The Bill Gates lab is already tracking over 199,000 handles.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Here&amp;rsquo;s a sampling of some handles from the Bill Gates slice:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/6545.BGHandles.png"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/6545.BGHandles.png" width="711" height="234" /&gt;&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;h1&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;HandleReferenceEntities&lt;/span&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/h1&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;We look for references to a handle in every content item that is processed for a dataset. In the Bill Gates dataset, we can find references to handles as authors and as mentions:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/6562.handlerefs.PNG"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/6562.handlerefs.PNG" width="711" height="197" /&gt;&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Although we process posts as an individual Content Items, our focus in Social Analytics is in aggregates at the Thread Level and above, which is why we attach MessageThreadId to just about everywhere that we use ContentItemId.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;h1&gt;&lt;strong&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Finding the top Handles &lt;/span&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/h1&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;With these two entities, we can easily find the top participants in the Bill Gates dataset over the last 7 days. We&amp;rsquo;ll use the following LINQ statement in LINQPad: &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;pre class="scroll"&gt;&lt;code class="csharp"&gt; (&lt;br /&gt; from h in Handles.Expand("HandleReferences").AsEnumerable()&lt;br /&gt; where &lt;br /&gt; h.HandleReferences.Max(hr =&amp;gt; hr.LastUpdatedOn) &amp;gt; DateTime.Now.AddDays(-7)&lt;br /&gt; orderby h.HandleReferences.Count descending&lt;br /&gt; select new&lt;br /&gt; {&lt;br /&gt; h.Id&lt;br /&gt; ,h.Name&lt;br /&gt; ,References = h.HandleReferences.Count,&lt;br /&gt; h.ProfileUrl,&lt;br /&gt; LastReference = h.HandleReferences.Max(hr =&amp;gt; hr.LastUpdatedOn)&lt;br /&gt; }&lt;br /&gt; ).Take(5)&lt;/code&gt;&lt;/pre&gt;
&lt;p&gt;The results:&lt;/p&gt;
&lt;p&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/3542.Top-Handle-References.PNG"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/3542.Top-Handle-References.PNG" /&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;This basic analytic provide a good starting point to understand your top participants and know who you might want to build relationships and who you might want to ignore as noise that&amp;rsquo;s not relevant to your interests. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Check out our next blog post to find out more about what you can do with the entities in the Social Analytics Lab.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10254672" width="1" height="1"&gt;</description></item><item><title>Finding Top Message Threads for a Filter</title><link>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/11/28/finding-top-message-threads-for-a-filter.aspx</link><pubDate>Mon, 28 Nov 2011 21:27:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10242161</guid><dc:creator>Social Analytics Team</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://blogs.msdn.com/b/microsoft_codename_social_analytics/rsscomments.aspx?WeblogPostID=10242161</wfw:commentRss><comments>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/11/28/finding-top-message-threads-for-a-filter.aspx#comments</comments><description>&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;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. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;In this scenario we&amp;rsquo;ll look at identifying top threads for one of the lab datasets. To accomplish this, you will &amp;nbsp;need three Entities in our API (pictured below):&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;h1&gt;&lt;span style="font-family: Calibri; font-size: small;" size="3" face="Calibri"&gt;&lt;/span&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;&amp;nbsp;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/2313.filtertopthreads.jpg"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/2313.filtertopthreads.jpg" /&gt;&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;/h1&gt;
&lt;h1&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Filters&lt;/span&gt;&lt;/span&gt;&lt;/h1&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;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:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;table border="1" cellspacing="0" cellpadding="0"&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;Id&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;Name&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;1&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;DataAcquisition: Windows 8&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;2&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;DataAcquisition: Windows 8 on Twitter&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;3&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;DataAcquisition: Windows 8 on YouTube&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;4&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Subscription Filter for @g_win8slice&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;6&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Windows 8 and Tablet PCs&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;7&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Windows 8&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;8&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Non-Twitter&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;10&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Windows 8 on Facebook&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;11&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Windows 8 and Applications&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;12&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Windows 8 Design and User Experience&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;13&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Windows 8 and Applications 2&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;&lt;span style="font-family: Calibri; font-size: small;" size="3" face="Calibri"&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;&lt;span style="font-size: small;" size="3"&gt;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.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;h1&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;&lt;span style="font-size: small;" size="3"&gt;MessageThreads&lt;/span&gt;&lt;/span&gt;&lt;/h1&gt;
&lt;p&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;&lt;span style="font-size: small;" size="3"&gt;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&amp;rsquo;ll find a collection of measures described an aggregated view of the thread, including:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Replies&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Answers&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Likes&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Retweets&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;IsQuestion&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;IsAnswered&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;PositiveSentiment&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;NegativeSentiment&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;The Replies field is a total of all replies of all types in the thread, so you don&amp;rsquo;t want to sum Replies and Answers etc., or you&amp;rsquo;ll be double-counting.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;h1&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;FilterResultCaches&lt;/span&gt;&lt;/span&gt;&lt;/h1&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;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:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;pre class="scroll"&gt;&lt;code class="cplusplus"&gt;(&lt;br /&gt; from f in FilterResultCaches&lt;br /&gt; orderby f.MessageThread.Replies descending&lt;br /&gt; where f.FilterId == 6&lt;br /&gt; &amp;amp;&amp;amp; f.MessageThread.Replies &amp;gt; 1&lt;br /&gt; &amp;amp;&amp;amp; f.LastUpdatedOn &amp;gt; DateTime.Now.AddDays(-7)&lt;br /&gt; select new&lt;br /&gt; {&lt;br /&gt; f.MessageThread.Replies,&lt;br /&gt; f.Site.Name,&lt;br /&gt; f.MessageThread.PositiveSentiment,&lt;br /&gt; f.MessageThread.NegativeSentiment,&lt;br /&gt; f.MessageThread.LastReplyContentItem.Title,&lt;br /&gt; f.MessageThread.LastReplyContentItem.HtmlUrl,&lt;br /&gt; }&lt;br /&gt;).Take(10)&lt;br /&gt; &lt;/code&gt;&lt;/pre&gt;
&lt;p&gt;we can find the Messagethreads with the most replies during the last 7 days in the &amp;ldquo;Windows 8 and Tablet PCs&amp;rdquo; filter:&lt;/p&gt;
&lt;table border="1" cellspacing="0" cellpadding="0"&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;Replies&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;Name&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;PositiveSentiment&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;NegativeSentiment&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;Title&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;HtmlUrl&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;126&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;twitter.com&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;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 ...&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;http://twitter.com/RenoYuuki/statuses/138211182040449024&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;33&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;twitter.com&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;RT @blogtweetz: Nokia Tablet To Debut in Summer 2012 - Powered By Windows 8 ! http://t.co/EniexIKY via @Dazeinfo&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;http://twitter.com/epremierleague/statuses/138931098318155776&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;13&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;twitter.com&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;RT @9to5mac: How well does Mac OSX run on Samsung&amp;rsquo;s Windows 8 Tablet? [Video] &lt;/span&gt;&lt;a href="http://t.co/tvOJVmSj"&gt;&lt;span style="color: #0066dd; font-family: Times New Roman;" face="Times New Roman" color="#0066dd"&gt;http://t.co/tvOJVmSj&lt;/span&gt;&lt;/a&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;a href="http://twitter.com/carlst3/statuses/139378162495791106"&gt;&lt;span style="color: #0066dd; font-family: Times New Roman;" face="Times New Roman" color="#0066dd"&gt;http://twitter.com/carlst3/statuses/139378162495791106&lt;/span&gt;&lt;/a&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;7&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;twitter.com&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;RT @Indiferencia: Nokia lanzar&amp;aacute; tablet con Windows 8 en junio de 2012 http://t.co/54Wf3Rza&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;http://twitter.com/endamo/statuses/138029411483131905&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;6&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;twitter.com&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;RT @Entiendelas: Nokia lanzar&amp;aacute; tablet con Windows 8 en junio de 2012 http://t.co/bMvT7gXr&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;http://twitter.com/Lacangri1412/statuses/137750579417055232&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;6&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;twitter.com&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;RT @dehaaspeter: BCG: Windows tablet populairder dan iPad van Apple : http://t.co/P4GedXkY #windows8&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;http://twitter.com/OscarMinkenberg/statuses/139273712657637376&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;5&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;twitter.com&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;RT @OfficeTH: &lt;/span&gt;โอ้วว้าว&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;...!Win8 Tablet &lt;/span&gt;บน&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt; Nokia &lt;/span&gt;จะเฝ้ารออออ&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;!!! http://t.co/4lFOjLmO&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;http://twitter.com/opal_monkey/statuses/138607317817114624&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;4&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;twitter.com&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;RT @LeaNoticias: Nokia lanzar&amp;aacute; tablet con Windows 8 en junio de 2012 &lt;/span&gt;&lt;a href="http://t.co/DjOAGG9k"&gt;&lt;span style="color: #0066dd; font-family: Times New Roman;" face="Times New Roman" color="#0066dd"&gt;http://t.co/DjOAGG9k&lt;/span&gt;&lt;/a&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;http://twitter.com/daichu_/statuses/138098502550040576&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;4&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;twitter.com&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;1&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;RT @Indiferencia: Nokia lanzar&amp;aacute; tablet con Windows 8 en junio de 2012 http://t.co/54Wf3Rza&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;http://twitter.com/arknglzintetico/statuses/138627023793954817&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;4&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;twitter.com&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;RT @freddier: Tablet Samsung con Windows 8 [pic] http://t.co/cyENejTk #techdayschile&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;http://twitter.com/GustavoRiveraMX/statuses/138723108952612864&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;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. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Check out our next blog post to find out more about what you can do with the entities in the Social Analytics Lab. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Also, please let us know what questions you have or other interesting discoveries you find in the labs.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10242161" width="1" height="1"&gt;</description></item><item><title>Finding Top Keywords with the Social Analytics API</title><link>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/11/15/finding-top-keywords-with-the-social-analytics-api.aspx</link><pubDate>Tue, 15 Nov 2011 00:28:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10237080</guid><dc:creator>Social Analytics Team</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://blogs.msdn.com/b/microsoft_codename_social_analytics/rsscomments.aspx?WeblogPostID=10237080</wfw:commentRss><comments>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/11/15/finding-top-keywords-with-the-social-analytics-api.aspx#comments</comments><description>&lt;p&gt;&lt;span style="font-family: Calibri; font-size: small;" size="3" face="Calibri"&gt;&amp;nbsp;&lt;/span&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;There are over 50 Entities and Service Operations available in the Social Analytics Lab API. Over the next few posts we will provide details on how the Entities can be used to accomplish some basic scenarios in the Social Analytics lab. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;The first scenario we&amp;rsquo;ll look at identifies top keywords for one of the lab datasets. To accomplish this, you only need two Entities in our API (pictured below):&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-family: Calibri; font-size: small;" size="3" face="Calibri"&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/7024.keyword-references.jpg"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/7024.keyword-references.jpg" width="130" height="213" /&gt;&lt;/a&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/4705.keyword-references.png"&gt;&lt;/a&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/4682.keyword-references.png"&gt;&lt;/a&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/5543.keyword-references.png"&gt;&lt;/a&gt;&lt;/span&gt;&lt;/p&gt;
&lt;h1&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Keywords&lt;/span&gt;&lt;/span&gt;&lt;/h1&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;The Keywords entity includes every keyword that has been defined or observed by our curation processes. After two weeks of activity on the Bill Gates Lab, we already have an inventory of over 10,000 keywords. New keywords observed in the Social Stream&amp;nbsp;are marked as New.&amp;nbsp;These new keywords are useful to consider when defining&amp;nbsp;filters (coming in a future version) to curate relevant conversations. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;With the following LINQ Statement in LINQPad, we can get a sample of the active keywords in the Bill Gates Lab:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;pre class="scroll"&gt;&lt;code class="csharp"&gt; (&lt;br /&gt; from k in Keywords&lt;br /&gt; where k.ItemStatusId == 10 //Active&lt;br /&gt; select new&lt;br /&gt; {&lt;br /&gt; k.Name,&lt;br /&gt; }&lt;br /&gt; ).Take(10)&lt;/code&gt;&lt;/pre&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;table style="border: 2px solid #000000;" border="2" cellspacing="0" cellpadding="0"&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;Name&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Vaccinations&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Stanford&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Philanthropic&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Germany&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;BillGates&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Global Health&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;Bill Clinton&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;UN Foundation&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;GatesFoundation&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;March of Dimes&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;&lt;span style="font-family: Calibri; font-size: small;" size="3" face="Calibri"&gt;&amp;nbsp;&lt;/span&gt;&lt;b&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;KeywordReferenceEntities&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;KeywordReferenceEntities are&amp;nbsp;the record of what Keywords are referenced in&amp;nbsp;Content Items and Message Threads. In our taxonomy, a Content Item is&amp;nbsp;a post of any kind, ranging from gestures such as Facebook likes to a Tweet to a Blog Post. A Message Thread is a summary of an original post in a feed and all responses to that post in the same feed.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;With the following&amp;nbsp;LINQ Statement in LINQPad, we can get a sample of Keyword References:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;pre class="scroll"&gt;&lt;code class="csharp"&gt; (&lt;br /&gt; from k in KeywordReferenceEntities&lt;br /&gt; select new&lt;br /&gt; {&lt;br /&gt; KeywordName = k.Keyword.Name,&lt;br /&gt; k.MessageThread.LastReplyContentItem.Title,&lt;br /&gt; k.MessageThread.LastReplyContentItem.HtmlUrl,&lt;br /&gt; }&lt;br /&gt; ).Take(10)&lt;br /&gt; &lt;/code&gt;&lt;/pre&gt;
&lt;table style="width: 613px;" border="1" cellspacing="0" cellpadding="0"&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td valign="top" width="114"&gt;
&lt;p&gt;&lt;b&gt;KeywordName&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="317"&gt;
&lt;p&gt;&lt;b&gt;Title&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="182"&gt;
&lt;p&gt;&lt;b&gt;HtmlUrl&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="114"&gt;
&lt;p&gt;Bill Gates&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="317"&gt;
&lt;p&gt;"&amp;Ocirc; Bill Gates, vamos dar um jeito na internet aqui do Brasil, hein?" http://t.co/flCjtGrx&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="182"&gt;
&lt;p&gt;http://twitter.com/13_levi/statuses/126703589409304576&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="114"&gt;
&lt;p&gt;Bill Gates&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="317"&gt;
&lt;p&gt;Em palestra paga por um banco americano Lula se supera: &amp;ldquo;Sem um dedo, fiz mais que Bill Gates e Steve Jobs&amp;rdquo;.&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="182"&gt;
&lt;p&gt;http://twitter.com/Thais_Grimald/statuses/126703689510551552&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="114"&gt;
&lt;p&gt;Bill Gates&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="317"&gt;
&lt;p&gt;Rapaz......Isso n&amp;atilde;o era pra hoje n&amp;atilde;o viu....At&amp;eacute; agora sem almo&amp;ccedil;ar! Se pudesse, mandava Bill Gates para junto de Jobs!&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="182"&gt;
&lt;p&gt;http://twitter.com/mbatistasilva/statuses/126703767683993600&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="114"&gt;
&lt;p&gt;Bill Gates&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="317"&gt;
&lt;p&gt;RT @GuidoFawkes: Nobody loves Bill Gates, but if he has funded a Malaria vaccine, it makes up for everything and is kind of more signifi ...&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="182"&gt;
&lt;p&gt;http://twitter.com/TadasLabudis/statuses/128649702337032192&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="114"&gt;
&lt;p&gt;Bill Gates&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="317"&gt;
&lt;p&gt;RT @GuidoFawkes: Nobody loves Bill Gates, but if he has funded a Malaria vaccine, it makes up for everything and is kind of more signifi ...&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="182"&gt;
&lt;p&gt;http://twitter.com/TadasLabudis/statuses/128649702337032192&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="114"&gt;
&lt;p&gt;BillGates&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="317"&gt;
&lt;p&gt;BillGates Bill Gates&lt;br /&gt;For those of us lucky enough to get to work with Steve, it&amp;rsquo;s been an insanely great honor. I will miss Steve immensely.&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="182"&gt;
&lt;p&gt;http://twitter.com/Carolina_S_O/statuses/126704102003572736&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="114"&gt;
&lt;p&gt;Bill Gates&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="317"&gt;
&lt;p&gt;BillGates Bill Gates&lt;br /&gt;For those of us lucky enough to get to work with Steve, it&amp;rsquo;s been an insanely great honor. I will miss Steve immensely.&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="182"&gt;
&lt;p&gt;http://twitter.com/Carolina_S_O/statuses/126704102003572736&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="114"&gt;
&lt;p&gt;endmalaria&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="317"&gt;
&lt;p&gt;RT @PATHtweets: Blog: Read commentary on 2011 @gatesfoundation Malaria Summit from our Malaria Control Program team. http://t.co/DSdlUoO ...&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="182"&gt;
&lt;p&gt;http://twitter.com/EVERY_ONE_CAN/statuses/126704433638805504&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="114"&gt;
&lt;p&gt;GatesFoundation&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="317"&gt;
&lt;p&gt;RT @PATHtweets: Blog: Read commentary on 2011 @gatesfoundation Malaria Summit from our Malaria Control Program team. http://t.co/DSdlUoO ...&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="182"&gt;
&lt;p&gt;http://twitter.com/EVERY_ONE_CAN/statuses/126704433638805504&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top" width="114"&gt;
&lt;p&gt;Bill &amp;amp; Melinda Gates Foundation Malaria Forum&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="317"&gt;
&lt;p&gt;Using information systems to track a killer parasite&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top" width="182"&gt;
&lt;p&gt;http://macepadiary.wordpress.com/2011/10/18/using-information-systems-to-track-a-killer-parasite/&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;&lt;span style="font-family: Calibri; font-size: small;" size="3" face="Calibri"&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Top Keywords for the Last Week&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Using these two Entities together, we can calculate the top 5 Keywords referenced in the last week for Bill Gates. Here&amp;rsquo;s the code:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;pre style="padding-left: 30px;" class="scroll"&gt;&lt;code class="csharp"&gt;&lt;/code&gt;&amp;nbsp;&lt;/pre&gt;
&lt;pre style="padding-left: 30px;" class="scroll"&gt;&lt;code class="csharp"&gt; (&lt;br /&gt; from k in Keywords.Expand("KeywordReferences").AsEnumerable()&lt;br /&gt; where k.ItemStatusId == 10&lt;br /&gt; &amp;amp;&amp;amp; k.KeywordReferences.Max(kr =&amp;gt; kr.LastUpdatedOn) &amp;gt; DateTime.Now.AddDays(-7)&lt;br /&gt; orderby k.KeywordReferences.Count descending&lt;br /&gt; select new&lt;br /&gt; {&lt;br /&gt; k.Id,&lt;br /&gt; k.Name,&lt;br /&gt; References = k.KeywordReferences.Count&lt;br /&gt; }&lt;br /&gt; ).Take(5)&lt;/code&gt;&lt;/pre&gt;
&lt;pre style="padding-left: 30px;" class="scroll"&gt;&lt;code class="csharp"&gt;&lt;/code&gt;&amp;nbsp;&lt;/pre&gt;
&lt;p&gt;and the results:&lt;/p&gt;
&lt;table border="1" cellspacing="0" cellpadding="0"&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;Id&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;Name&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;b&gt;References&lt;/b&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;9acbefab-156f-4039-98b9-0a56c2d359d6&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;Global Health&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;108&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;0db05e2f-233f-4155-93db-01a07c693017&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;philanthropic&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;102&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;d268a214-0033-4f89-b297-051f2fdf7029&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;Germany&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;91&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;f41b31fb-63ce-47bc-ab72-016a4e43803a&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;Stanford&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;68&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;a65d7774-59d7-42d5-a224-013b226cdcae&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;Vaccinations&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;td valign="top"&gt;
&lt;p align="right"&gt;&lt;span style="font-family: Times New Roman;" face="Times New Roman"&gt;35&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;p&gt;&lt;span style="font-family: Calibri; font-size: small;" size="3" face="Calibri"&gt;&amp;nbsp;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Check out our blog later this week to find out more about what you can do with the entities in the Social Analytics Lab. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size: small;" size="3"&gt;&lt;span style="font-family: Calibri;" face="Calibri"&gt;Also, please let us know what questions you have or other interesting discoveries you find in the labs.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10237080" width="1" height="1"&gt;</description></item><item><title>Bill Gates and Education: What are people saying?</title><link>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/11/07/bill-gates-and-education-what-are-people-saying.aspx</link><pubDate>Mon, 07 Nov 2011 22:39:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10234783</guid><dc:creator>Social Analytics Team</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://blogs.msdn.com/b/microsoft_codename_social_analytics/rsscomments.aspx?WeblogPostID=10234783</wfw:commentRss><comments>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/11/07/bill-gates-and-education-what-are-people-saying.aspx#comments</comments><description>&lt;p class="Publishwithline"&gt;After spending last week speaking with world leaders at the G20 Summit, Bill Gates kicked off this week by speaking with CNN&amp;rsquo;s Fareed Zakaria about education reform. We thought we&amp;rsquo;d check in with the Social Analytics Engagement Client to see how people are currently talking about Bill's views on education.&lt;/p&gt;
&lt;h4&gt;Starting with the most active conversations&lt;/h4&gt;
&lt;p&gt;Jumping into the stream of real-time content can be overwhelming, so we decided to start viewing the most active conversations using an Analytics Column for the &amp;ldquo;Bill Gates and Education&amp;rdquo; filter. This gives us a view of conversations with the most replies and retweets over the past 24 hours.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/2678.bg1.1.png"&gt;&lt;img style="border: 0px currentColor;" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/2678.bg1.1.png" width="321" /&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;@FareedZakaria&amp;rsquo;s tweet about improving teacher quality looks like it struck a nerve because there are 87 replies, so we decided to drill into that conversation by clicking on the&amp;nbsp;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/5556.bg1.2.png"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/5556.bg1.2.png" width="15" /&gt;&lt;/a&gt;.&lt;/p&gt;
&lt;p&gt;Browsing through the retweets and replies shows a wide variety of opinions on how to improve education, here&amp;rsquo;s a sample of what we found:&lt;/p&gt;
&lt;p&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/8561.bg1.3.png"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/321x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/8561.bg1.3.png" /&gt;&lt;/a&gt;&amp;nbsp;&lt;/p&gt;
&lt;h4&gt;Jumping into the Real-time Stream&lt;/h4&gt;
&lt;p&gt;After spending some time scrolling through the conversation that @FareedZakaria started, we decided to see what&amp;rsquo;s trending right now by creating a new Filter Column for the &amp;ldquo;Bill Gates and Education&amp;rdquo; filter. This column is sorted chronologically, so we see the most recent posts first, rather than the most active conversations. This view shows us that the &lt;a href="http://www.washingtonpost.com/blogs/answer-sheet/post/how-bill-gates-throws-his-money-around-in-education/2011/11/06/gIQAXqrasM_blog.html?t=1320672339"&gt;How Bill Gates throws his money around in education&lt;/a&gt; post from &lt;i&gt;Washington Post&lt;/i&gt;&amp;rsquo;s education blog is getting a fair amount of pass-along via Twitter:&lt;/p&gt;
&lt;p&gt;&lt;br /&gt;&amp;nbsp;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/4111.bg1.4.png"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/321x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/4111.bg1.4.png" /&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;This is just one example of how the Microsoft Codename &amp;ldquo;Social Analytics&amp;rdquo; Engagement Client can be used to see who is saying what about a particular topic. If you want to try it for yourself, we have set up filters for the following subtopics for Bill Gates:&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;Bill Gates and Education&lt;/li&gt;
&lt;li&gt;Bill Gates and Malaria&lt;/li&gt;
&lt;li&gt;Bill Gates and Technology&lt;/li&gt;
&lt;li&gt;Bill Gates and Microsoft&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;If you are looking for more information on using the Engagement Client, be sure to read &lt;a href="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/10/27/boo-surprises-in-the-engagement-client.aspx"&gt;Boo! Little Surprises in the Engagement Client&lt;/a&gt;, then dig in and let us know what you find in &lt;a href="http://social.msdn.microsoft.com/Forums/en-US/socialanalytics/threads"&gt;our forum&lt;/a&gt;.&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10234783" width="1" height="1"&gt;</description></item><item><title>Boo!   Little Surprises in the Engagement Client</title><link>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/10/27/boo-surprises-in-the-engagement-client.aspx</link><pubDate>Thu, 27 Oct 2011 16:56:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10230659</guid><dc:creator>Social Analytics Team</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://blogs.msdn.com/b/microsoft_codename_social_analytics/rsscomments.aspx?WeblogPostID=10230659</wfw:commentRss><comments>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/10/27/boo-surprises-in-the-engagement-client.aspx#comments</comments><description>&lt;p&gt;&lt;span style="color: #ff6600;"&gt;&lt;strong&gt;Happy Halloween!&amp;nbsp;&amp;nbsp;&lt;/strong&gt;&lt;/span&gt;&amp;nbsp; There are&amp;nbsp;many&amp;nbsp;features in the Engagement Client that you can explore on your own by clicking all the&amp;nbsp;controls or&amp;nbsp;by reading the "&lt;strong&gt;&lt;a href="https://connect.microsoft.com/BusinessPlatform/content/content.aspx?ContentID=26375"&gt;Engagement Client Quick Start Guide&lt;/a&gt;&lt;/strong&gt;".&amp;nbsp;&amp;nbsp; Some&amp;nbsp;controls are visible all the time and some are&amp;nbsp;cleverly exposed&amp;nbsp;when you roll your mouse over a post.&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Here are a few features that may not be as obvious as others which we think you will find useful:&lt;/p&gt;
&lt;ol&gt;
&lt;li&gt;Open Conversation in a New Column&lt;/li&gt;
&lt;li&gt;Tweet&lt;/li&gt;
&lt;li&gt;Go to Post&lt;/li&gt;
&lt;li&gt;Expand &amp;amp; Collapse Column&lt;/li&gt;
&lt;li&gt;Dismiss Filter Header&lt;/li&gt;
&lt;/ol&gt;
&lt;p&gt;Let's take a look at these!&lt;/p&gt;
&lt;p&gt;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;Open Conversation:&lt;/strong&gt;&lt;/span&gt;&amp;nbsp; This is one of our team's favorite features.&amp;nbsp; On each post, you'll see a conversation icon; it looks&amp;nbsp;the bubble with words over a cartoon character's head.&amp;nbsp;&amp;nbsp; If you click on that icon, a new column will open to the right in the Engagement Client.&amp;nbsp;&amp;nbsp; The column will be populated with all the posts, replies, comments, tweets, retweets and links associated with that conversation.&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; If you see a single bubble icon, that means the conversation is one thread (a single post with all its replies &amp;amp; comments).&amp;nbsp; If you see a double bubble icon, that means the conversation spans multiple channels (multiple posts across multiple channels tied together by a link to the same URL.)&lt;/p&gt;
&lt;p&gt;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/0312.conversation.png"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/0312.conversation.png" width="708" height="150" /&gt;&lt;/a&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="color: #000000;"&gt;This feature exposes one of the key components of "Social Analytics" which is the algorithm we've designed which ties a conversation together regardless of how many channels it spans or how many people participate in it.&lt;/span&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;Tweet: &lt;/strong&gt;&lt;/span&gt;&amp;nbsp; You can tweet, retweet,&amp;nbsp;and reply&amp;nbsp;to a tweet making it simple for you to not only find, but also participate in conversations from within the Engagement Client. The "Tweet" and "Register Account" controls are along the top of the Engagement Client main screen.&amp;nbsp; The first time you tweet, you will be prompted to register your Twitter account with us.&amp;nbsp;&amp;nbsp;&amp;nbsp;Our future plans include expanding our platform reach to Facebook and LinkedIn.&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/0412.Tweet.png"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/0412.Tweet.png" width="716" height="116" /&gt;&lt;/a&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/2133.Tweet.png"&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;"Social Analytics" uses the standard Twitter APIs to enable you to register your Twitter account and tweet right from within the Engagement Client.&amp;nbsp; For your security and protection, we use OAUTH V2&amp;nbsp; so that we never store your twitter password in our application.&lt;/p&gt;
&lt;p&gt;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;Go to Post:&lt;/strong&gt;&lt;/span&gt;&amp;nbsp; On the top right corner of&amp;nbsp;each post, you'll see an icon representing the channel or source where the post originated.&amp;nbsp; By clicking on the icon, a new window will open in your browser and it will take you to the post directly at its source.&amp;nbsp; This is particularly helpful for blog posts that you may want to read in full.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/5050.channel.png"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/5050.channel.png" /&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p style="text-align: left;"&gt;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;Expand &amp;amp; Collapse Column:&amp;nbsp;&amp;nbsp; &lt;/strong&gt;&lt;/span&gt;You can make any column double-wide by clicking on the expand column control at the top of the column.&amp;nbsp; If you open an "Analytics Column" you will notice that the default column size for it is double-wide.&amp;nbsp;&amp;nbsp;&amp;nbsp; Clicking the control again resets the column size to single-wide.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/7673.column.png"&gt;&lt;img style="float: left;" border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/7673.column.png" width="331" height="141" /&gt;&lt;/a&gt;.&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/6330.filter-2.png"&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;&lt;/strong&gt;&lt;/span&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;&lt;/strong&gt;&lt;/span&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;&lt;/strong&gt;&lt;/span&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;&lt;/strong&gt;&lt;/span&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;&lt;/strong&gt;&lt;/span&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;Close&amp;nbsp;Filter Selection:&amp;nbsp;&lt;/strong&gt;&lt;/span&gt; You can get more valuable real estate for viewing posts by clicking on the "Close Filter Selection" control at the top of the column.&amp;nbsp;&amp;nbsp; We built this feature at the request of one of our early adopter customers to increase the number of posts they could view.&amp;nbsp;&amp;nbsp; The filter header allows&amp;nbsp;you&amp;nbsp;to change filters in your column.&amp;nbsp;If you want to see filter headers again, you can click on the "Show Filter Setting" control to get&amp;nbsp;the filter selector&amp;nbsp;back on the top of the column.&amp;nbsp;&amp;nbsp; Here are both controls:&lt;/p&gt;
&lt;p&gt;&lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/1856.Filter.png"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/1856.Filter.png" width="329" height="145" /&gt;&lt;/a&gt;&amp;nbsp;&amp;nbsp;&lt;strong&gt;AND&lt;/strong&gt;&amp;nbsp;&amp;nbsp; &lt;a href="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/3326.filter-2.png"&gt;&lt;img border="0" alt="" src="http://blogs.msdn.com/resized-image.ashx/__size/550x0/__key/communityserver-blogs-components-weblogfiles/00-00-01-48-93/3326.filter-2.png" width="326" height="143" /&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Those are a few Halloween treats for you!&amp;nbsp;&amp;nbsp;&amp;nbsp; We are eager&amp;nbsp;for your feedback.&amp;nbsp; Tell us what you think by posting comments to this blog or to &lt;span style="color: #3366ff;"&gt;&lt;strong&gt;&lt;a href="http://social.msdn.microsoft.com/Forums/en-US/socialanalytics/"&gt;&lt;span style="color: #3366ff;"&gt;our forum&lt;/span&gt;&lt;/a&gt;&lt;/strong&gt;&lt;/span&gt;.&amp;nbsp;&amp;nbsp; We will use&amp;nbsp;your feedback&amp;nbsp;to guide the future direction of "Social Analytics".&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10230659" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/Azure/">Azure</category><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/SQL+Azure/">SQL Azure</category><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/Social+Analytics/">Social Analytics</category><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/SocialAnalytics/">SocialAnalytics</category></item><item><title>Getting Access to the Social Analytics Lab</title><link>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/10/26/getting-access-to-the-social-analytics-lab.aspx</link><pubDate>Wed, 26 Oct 2011 21:29:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10230369</guid><dc:creator>Social Analytics Team</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://blogs.msdn.com/b/microsoft_codename_social_analytics/rsscomments.aspx?WeblogPostID=10230369</wfw:commentRss><comments>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/10/26/getting-access-to-the-social-analytics-lab.aspx#comments</comments><description>&lt;p&gt;Are you curious about Microsoft Codename &amp;ldquo;Social Analytics?" Are you wondering how to get started? The&amp;nbsp;&lt;span style="color: #3366ff; text-decoration: underline;"&gt;&lt;strong&gt;Social Analytics Lab&lt;a href="http://www.microsoft.com/en-us/sqlazurelabs/labs/socialanalytics.aspx"&gt;&lt;/a&gt;&lt;/strong&gt;&lt;/span&gt; and&amp;nbsp;its documentation (on &lt;span style="color: #3366ff; text-decoration: underline;"&gt;&lt;strong&gt;Social Analytics Connect&lt;/strong&gt;&lt;/span&gt;) are available and ready to help you, as is our &lt;a title="Microsoft Codename Social Analytics Forum" href="http://social.msdn.microsoft.com/Forums/en-US/socialanalytics/threads" target="_blank"&gt;Social Analytics Forum&lt;/a&gt;.&amp;nbsp;&lt;bold&gt;Just go to the &lt;span style="color: #3366ff; text-decoration: underline;"&gt;&lt;strong&gt;Social Analytics Lab&lt;/strong&gt;&lt;/span&gt; to&amp;nbsp;register for the lab and follow the instructions there. I&lt;/bold&gt;n case you want to bypass&amp;nbsp;the lab page, just click on this&amp;nbsp;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;&lt;span style="text-decoration: underline;"&gt;shortcut&lt;/span&gt;. &lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;After you fill out and submit the access request form, we will send you an e-mail with detailed instructions.&amp;nbsp;Today you'll find the process relatively complicated, but we will continue to make improvements over time as we move toward the goal of enabling "one-click" access to rich social analytics.&lt;/p&gt;
&lt;p&gt;Here's a sample of what you'll hear from us&amp;nbsp;with some commentary &lt;span style="color: #ff6600;"&gt;&amp;lt;in-line&amp;gt;.&lt;/span&gt;&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;&lt;span style="font-size: large;"&gt;MICROSOFT&lt;/span&gt;&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;&lt;span style="font-size: large;"&gt;CODENAME &amp;ldquo;&lt;span style="color: #3366ff;"&gt;SOCIAL ANALYTICS&amp;rdquo;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;div style="text-align: left; padding-left: 60px;" align="center"&gt;&lt;hr align="center" size="2" width="100%" /&gt;Thank you for signing up for Microsoft Codename &amp;ldquo;Social Analytics.&amp;rdquo;&amp;nbsp;&lt;/div&gt;
&lt;p style="padding-left: 60px;"&gt;To start using Social Analytics data, visit &lt;a href="https://Win8.social.azure.com"&gt;https://Win8.social.azure.com&lt;/a&gt; and use your invitation code: xxxxxxxxxxx-xxxx-xxxx-xxxxxxxxxxx.&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;&lt;span style="color: #ff6600;"&gt;&amp;lt;"Social Analytics" is a cloud based service hosted in Windows Azure.&amp;nbsp; The invitation code&amp;nbsp;provides your Windows&amp;nbsp;LiveID&amp;nbsp;with access to the Windows Azure service. Enter it the first time you go&amp;nbsp;to &lt;a href="https://Win8.social.azure.com"&gt;https://Win8.social.azure.com&lt;/a&gt;&amp;nbsp; (or &lt;a href="https://BillGates.social.azure.com"&gt;https://BillGates.social.azure.com&lt;/a&gt; for the Bill Gates data).&amp;gt;&lt;/span&gt;&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;After entering your information and accepting the Terms of Use, you will have two ways to interact with social media data about Windows 8:&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;&amp;nbsp;&lt;b&gt;Browsing Real-time Social Analytics Data&lt;/b&gt;&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;We recommend familiarizing yourself with Social Analytics data via our web-based Engagement Client, which shows a real-time stream of social media content about Windows 8.&amp;nbsp; After logging in, select &amp;ldquo;Engagement Client&amp;rdquo; in the top navigation menu. You can &lt;a href="https://connect.microsoft.com/BusinessPlatform/content/content.aspx?ContentID=26375"&gt;find information about using the Engagement Client here&lt;/a&gt;.&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;&lt;span style="color: #ff6600;"&gt;&amp;lt;The Engagement Client provides a simple social media data browsing experience, oriented toward viewing most recently posted information.&amp;nbsp;The detailed information link shows you&amp;nbsp;a map of the Engagement Client describing each control and what it does.&amp;gt;&lt;/span&gt;&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;&lt;b&gt;Using Social Analytics API&lt;/b&gt;&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;When you are ready to start using the Social Analytics API with data about Windows 8, start with the following steps:&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;1. Get your account key &lt;a href="https://datamarket.azure.com/account/keys"&gt;here&lt;/a&gt;. &amp;nbsp;&lt;span style="color: #ff6600;"&gt;&amp;lt;We provide programmatic access to Social Analytics data through Windows Azure DataMarket. This step provides you with the secret (account key)&amp;nbsp;linking your&amp;nbsp;LiveID&amp;nbsp;to the Windows 8 data&amp;gt;&lt;/span&gt;&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;2. Copy your account key to use in LinqPad, PowerPivot or Visual Studio.&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;3. Review &lt;a href="https://connect.microsoft.com/BusinessPlatform/socialanalytics"&gt;instructions for using LinqPad, PowerPivot or C# to access your dataset&lt;/a&gt;&amp;nbsp;&lt;span style="color: #ff6600;"&gt;&amp;lt;We want you to be able to use the API as part of your usual development process. Let us know what we can do to make it simpler and easier for you to achieve your social web integration goals.&amp;gt;&lt;/span&gt;&lt;/p&gt;
&lt;blockquote style="margin-right: 0px;" dir="ltr"&gt;
&lt;p&gt;&lt;b&gt;Note:&lt;/b&gt; You may see an &amp;ldquo;Explore this Dataset&amp;rdquo; option on the DataMarket offer page. This explorer is not compatible with the Social Analytics source and should not be used to explore the data.&lt;/p&gt;
&lt;/blockquote&gt;
&lt;p style="padding-left: 60px;"&gt;For additional information, you can read the &lt;a href="https://connect.microsoft.com/BusinessPlatform/Downloads/DownloadDetails.aspx?DownloadID=39340"&gt;full API documentation&lt;/a&gt;.&amp;nbsp;&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;&lt;b&gt;Additional Resources&lt;/b&gt;&lt;/p&gt;
&lt;p style="padding-left: 60px;"&gt;Here are some other links that you may find useful:&lt;/p&gt;
&lt;ul style="padding-left: 90px;"&gt;
&lt;li style="padding-left: 30px;"&gt;&lt;a href="https://connect.microsoft.com/BusinessPlatform/socialanalytics"&gt;Information on using Social Analytics data services&lt;/a&gt;&lt;/li&gt;
&lt;li style="padding-left: 30px;"&gt;&lt;a href="mailto:SAContactUS@microsoft.com"&gt;Customer support&lt;/a&gt;&lt;/li&gt;
&lt;li style="padding-left: 30px;"&gt;&lt;a href="https://connect.microsoft.com/BusinessPlatform/Feedback"&gt;Report bugs or send us a suggestion&lt;/a&gt;&lt;/li&gt;
&lt;li style="padding-left: 30px;"&gt;&lt;a href="https://connect.microsoft.com/BusinessPlatform/content/content.aspx?ContentID=26520"&gt;List of Known Issues&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;That's basically it!&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;i&gt;&amp;nbsp;&lt;/i&gt;&lt;span style="font-size: xx-small;"&gt;&lt;i&gt;If you click on one these URLs and don&amp;rsquo;t have access, go to this&amp;nbsp;&amp;nbsp;&lt;span style="color: #3366ff;"&gt;&lt;strong&gt;"&lt;a href="https://yvrsignup.cloudapp.net/Home/Signup"&gt;&lt;span style="color: #3366ff;"&gt;shortcut&lt;/span&gt;&lt;/a&gt;"&lt;/strong&gt;&lt;/span&gt;&amp;nbsp;&lt;/i&gt;&lt;i&gt;to request access.&lt;/i&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;Play with the lab.&amp;nbsp; Enjoy!&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10230369" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/Azure/">Azure</category><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/SQL+Azure/">SQL Azure</category><category domain="http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/tags/Social+Analytics/">Social Analytics</category></item><item><title>Announcing Microsoft Codename "Social Analytics" Lab</title><link>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/10/25/announcing-microsoft-codename-quot-social-analytics-quot-lab.aspx</link><pubDate>Tue, 25 Oct 2011 22:39:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10230015</guid><dc:creator>Social Analytics Team</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://blogs.msdn.com/b/microsoft_codename_social_analytics/rsscomments.aspx?WeblogPostID=10230015</wfw:commentRss><comments>http://blogs.msdn.com/b/microsoft_codename_social_analytics/archive/2011/10/25/announcing-microsoft-codename-quot-social-analytics-quot-lab.aspx#comments</comments><description>&lt;p&gt;Today we are announcing the release of the &lt;strong&gt;Microsoft Codename &amp;ldquo;Social Analytics&amp;rdquo; Lab&lt;/strong&gt;. As the popularity of the social web continues to grow it has become increasingly important for businesses to keep their finger on the pulse of the social web. Social information provides businesses with new insights, and the social web provides a means to connect with customers and respond quickly to customer concerns or comments.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Microsoft Codename "Social Analytics" Lab&lt;/strong&gt; is an experimental cloud service that provides an API enabling developers to easily integrate relevant social web information into business applications. Also included is a simple browsing application to view the social stream and the kind of analytics that can be constructed and integrated in your application.&lt;/p&gt;
&lt;p&gt;You can get started with &amp;ldquo;Social Analytics&amp;rdquo; by exploring the social data available via the browsing application. With this first lab release, the data available is limited to two topics (&amp;ldquo;Windows 8&amp;rdquo; and &amp;ldquo;Bill Gates&amp;rdquo;). Future releases will allow you to define your own topic(s) of interest. The data in &amp;ldquo;Social Analytics&amp;rdquo; includes top social sources like Twitter, Facebook, blogs and forums. It has also been automatically enriched to tie conversations together across sources, and to assess sentiment.&lt;/p&gt;
&lt;p&gt;Once you&amp;rsquo;re familiar with the data you&amp;rsquo;ve chosen, you can then use our API (based on the &lt;a href="http://www.odata.org/"&gt;Open Data Protocol&lt;/a&gt;) to bring that social data directly into your own application.&lt;/p&gt;
&lt;p&gt;Do you want to learn more about the &lt;strong&gt;Microsoft Codename &amp;ldquo;Social Analytics&amp;rdquo; Lab&lt;/strong&gt;? &lt;a href="http://go.microsoft.com/fwlink/?LinkID=230530&amp;amp;clcid=0x409"&gt;Get started today&lt;/a&gt;, or for more information visit our &lt;a href="http://www.microsoft.com/en-us/sqlazurelabs/labs/socialanalytics.aspx"&gt;official homepage&lt;/a&gt;, connect with us in our &lt;a href="http://social.msdn.microsoft.com/Forums/en-US/category/windowsazureplatformctp"&gt;forums&lt;/a&gt; and stay tuned to our &lt;a href="http://blogs.msdn.com/b/microsoft_codename_social_analytics/"&gt;product blog&lt;/a&gt; for future updates.&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10230015" width="1" height="1"&gt;</description></item></channel></rss>