Home Dashboard Directory Help

Codename "Social Analytics" 

Social Analytics Lab  

Microsoft Codename "Social Analytics" is a suite of Azure services for developers and end-users enabling businesses to integrate the social web into their business applications. Our goal is to enable businesses to build connections and communities among customers, influencers, and their employees; to support customer needs for high value information guided by peers and experts/influencers; to engage in conversations and respond to buzz around hot topics; and to make the voice of community actionable across the product lifecycle.

The Social Analytics Lab is an early preview of social media data we have created so that you can use our web-based Engagement Client and API and give feedback based on your experience.

Getting Started  

In the Social Analytics Lab, you have your choice of two topics:

Windows 8
What's the buzz around the latest Windows 8 news and rumors? Tune into tweets, blog posts and other social media content about the next release of Microsoft Windows.
Bill Gates
Find mentions of Bill Gates in online conversations ranging from global health to the history of the software industry.

Ready to start monitoring the conversation? Start by requesting access to get an invitation.

After receiving your invitation, you will be able to see a real-time stream of social media content in the Social Analytics Engagement Client.

Social Analytics API  

The Social Analytics API let you directly access social media data for either of the topics in the Social Analytics lab. After requesting access to one of the Social Analytics topics here, you can access data by one of the following methods:

Using PowerPivot 

1. Open a PowerPivot window and select "From Azure DataMarket" in the Get External Data menu.
2. Use the appropriate URL for your Social Media dataset:
3. You can find your Account Key under My Account in DataMarket.
4. Click Next to load a list of tables and views.
5. Select the item(s) that you want to import and click "Finish" to start downloading data.

Using LinqPad

1. Click "Add connection"
2. Select "Microsoft DataMarket Service" and click Next
3. Use the approriate URL for your Social Media dataset:
3. You can find your Account Key under My Account in DataMarket.linqpad-step3
4. Click "Ok" to load the data into LinqPad. Once the tables and views are loaded you can begin creating queries.
Sample Code for Visual Studio



Here is an example of code that you can paste into Visual Studio and modify to suit your needs.

  1. Create a new project in Visual Studio
    • Select "Visual C#" as the language and "Console Application" as the project template.
    • In the "Name:" field enter "SocialAnalyticsExample"
    • Click "OK"
  2. Create a new Service Reference
  3. Copy and paste the sample code into Program.cs (replacing everything that was there)
  4. Replace the "" string with your Live ID Replace the "" string with your Account Key (not your Live ID password)  

Sample Code

//Social Analytics API

//Sample code to call REST based Social Analytics API

//Set the REST based URL
string url = "https://api.datamarket.azure.com/Vancouver/VancouverBillGates/ Filters()?$top=10";

//Create httpweb request and set the method
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(uri);
request.Method = "GET";

//Call DataMarket basic authentication
request.Credentials = new NetworkCredential("DATAMARKET_USER", "ACCOUNT_KEY");

//Get the response back
using (WebResponse response = request.GetResponse())
HttpWebResponse res = (HttpWebResponse)response;
Stream dataStream = response.GetResponseStream();
StreamReader reader = new StreamReader(dataStream);
string responseFromServer = reader.ReadToEnd();

//Display the response

// Additional Samples

//1. To retrieve top 5 keywords for last 30 days for particular filter, you use the following URL & specify the filterID you want:

//2. To retrieve top 5 sites for last 30 days for particular filter, you use the following URL & specify the FilterID you want:

For more information about our API and code samples, see the Social Analytics Lab API Documentation.

Submit Feedback  

If you have a suggestion for us, or discover a bug, we want to hear about it.

Visit our Feedback Center to send us an idea or file a bug.

You can find a list of Known Issues here.