Over the past few days I have been wondering if the new dashboard capabilities in Microsoft Dynamics CRM 2011 would enable me to create a dashboard that monitors activities on various social media sites. Monitoring social media sites is important for small, medium and larger businesses. By doing this a business can keep track of the conversations that people in social communities are having about their brand or service, or even about their competitors.
I imagined myself to be an owner of a small business that sells shoes and other footwear, and asked myself this question: what are the things that I would like to track. Some of the things that came to mind were -
I then looked around to find ways in which such information could be displayed on a CRM dashboard. Fortunately, the solution was not too hard to find. There are several web sites that provide social media widgets free of use. One just has to grab the HTML\Java Script code for these widgets and add them into a CRM Web resource. Having done that we are ready to create a "Social Activity Dashboard" - we just have to add these web resources on the dashboard.
Some of the most useful widgets for monitoring social activity can be download directly from Twitter. These widgets provide a real time update into profile pages, and search keywords. The widgets solve the problem by providing the data., so these are good candidates for our dashboard.
In addition to the live data from Twitter, we also need to be able to do some basic analysis such as retrieving the keywords that people are talking about, and the activity timeline for various search terms that I as a shoe business owner may be interested in. Looking around the web I found that the Fuse Labs gadgets from Microsoft provide me a rich set of aggregation capabilities.
I found the following two Twitter widgets interesting for our Social Activity Monitor Dashboard. These are downloadable from http://twitter.com/about/resources/widgets.
Twitter Profile Widget:
I used this widget to get live updates about a profile, in this case Nike - one of the brands that I as a business owner would deal with.
Twitter Search Widget:
I used this widget to get live updates regarding the search keywords that I as a business owner was interested in - in this case my search keywords were Nike, Adidas, and Puma.
Fuse Labs Gadgets:
The gadgets from http://fuse.microsoft.com/ provide the ability to aggregate information from Twitter and provide some basic analytics regarding the social media conversations. These are available at - http://fuse.microsoft.com/project/SocialGadgets.aspx
Fuse Labs Gadget - Tag Cloud
This gadget provides a tag cloud for the keywords provided by the user. I used the keyword "Shoes" to generate this tag cloud gadget
Fuse Labs Gadget - Comparison
I used this gadget to provide a comparison across conversations in the 3 brands that I deal with - Nike, Adidas, and Puma.
The next task is to create the web resources after the widgets have been identified. The widgets from Twitter, and Microsoft Fuse Labs allow the HTML code for these widgets to be downloaded, and embedded into custom applications. I downloaded the code for these widgets and embedded them into CRM Web resources. After creating the web resources, creating the dashboard was easy. For details on how to do this see http://blogs.msdn.com/b/crm/archive/2010/10/12/tracking-your-data-using-microsoft-dynamics-crm-dashboards.aspx.
The Solution package for the Social Activity Dashboard shown above can be downloaded from the following codeplex site - http://crmsocialdashboard.codeplex.com/. If there are more interesting ways in which social information can be consumed, please mention it in your comments.
A Twitter widget does not make CRM social. What you are showing is brand monitoring. What would be more interesting is to make the link between a customer, whether they are high value and why, what their social activity is and whether there is a correlation between them being a high-value customer and their social activity and social graph, and whether they have people in their social graph that would likely be potential customers.
Let's move beyond the Twitter widget towards providing business value
Now were talking!
Fantastic write up on leveraging free gadgets to build out dashboarding within crm toolset. Now that you have actionable analytics you can then just leverage windows workflow foundation to fire of processes in response to the information captured to drive consistent behavior within your organization.
Awesome post ;-) One of the challenges we look at working with social data, is how to summarize realtime data and give people a sense of an overview of what's important, and when in time important things happen.
Yes we are just at the beginning of what UX makes it easy for people to understand massive amounts of data, and how to build the widgets, backend, etc. so that we can quickly customize and query data wrt time and moments when there is a significant change in activity. The social networks are also figuring out how to make this data available.
It is great to see how you've added this so quickly, and we'd love to hear more on how its used and how to add more value.
We have taken this idea and configured it to fit in with the industry we target, namely the Construction Industry. It works great, shows a social overview of feeds related to the construction industry and can be tweeked easily to fit in with any of the customers and prospects we talk to in relation to their target sectors/products etc.
I think the RTW broke your solution - has anyone else had this problem?
Yes RTW broke this great solution. Now get TWTR undefined error. Hope to see a fix soon.
Anyone can help me in facebook integration with mscrm 2011....
how to do ????
if anyone knows plz mail me at firstname.lastname@example.org
thanks in advance ......
Wasn't there an add-on for MS Dynamics CRM 4.0 called Social Networking Accelerator that provided such functionality? Isn't that available anymore for 2011 or do I just not see the difference between this implementation and the functionality offered by that accelerator?