Social CRM at its best – Leads or Cases in Dynamics CRM from Social Posts in Microsoft Social Engagement


Microsoft Social Engagement (MSE) provides a platform for capturing public posts from social media.

When you send a social post from MSE to a Dynamics CRM with the new Link2CRM feature, a new social activity record is created in Dynamics CRM. The rule framework in Dynamics CRM can automatically turn these Social Activities into other types of CRM records, for example into a lead, an opportunity, or a case. Below is shown a tweet linked to CRM as a Lead.

In this blog post I'll walk you through how the Link2CRM feature works as is (that is with no rules defined) and then show you how to automate the process using the Automatic Record Creation and Update Rules framework in CRM

Steps

  1. Connect MSE to CRM
  2. Use the new Link2CRM feature as is out-of-the-box (will create social activity)
  3. Take a closer look at the Social Activity Additional Properties field
  4. Manually convert Social Activity to Case
  5. Set up Rule, incl Channel Group/Property
  6. See automation at work
    x


(you can click the pictures for larger image)

x

Connect MSE to CRM

If you haven't done so already you need to connect your MSE to your CRM

Note: You may need to turn your pop-up blocker OFF in order for MSE be able to discover your CRM Online instance(s).

In MSE goto Settings -> Connections > click the "plus" sign

Picture 1: Ready to Add New Connection

In the "Add Connection" dialog pick CRM Online, the Location of your tenant, and let MSE discover your instances. Pick the instance and click Continue (6)

Picture 2: Point to your tenant and have MSE discover your instances

Notice Case and Lead entries created by default (1) and click Save

Picture 3: Case and Lead entries created by default

Important – Click the Case entity (1) and make a note of the unique name (2), which is "incident"

Picture 4: Unique name for Case is "incident"

Important – Click the Lead entity (1) and make a note of the unique name (2), which is "lead"

Picture 5: Unique name for Lead is "lead"

All done with the connection

Picture 6: Connection active

x

Test Link2CRM feature as is


Now lets test the new feature Link2CRM

Picture 7: MSE

Navigate to a post and click "Link to CRM" (1)

Picture 8: Post ready to link


Pick which record you want to create in the drop-down (note – this doesnt yield the expected result, but we will make it later)

Picture 9: Pick Case


Type a note and click create

Picture 10: Type note


The post now displays a linked icon

Picture 11: Linked


You can unfold the post to see details about the linked record

Picture 12: Post linked to Contoso instance

What happened behind the curtains at this stage is MSE created a Social Activity in MSE (not a Case as you might expected since you where offered a choice of entity above).

Navigate to CRM -> Activities -> All Social Activities to see your newly created Social Post

Picture 13: Newly created Social Activity in CRM

x

Closer Look at Additional Properties

Open the new Social Activity and Edit the Form to add and display the field "Additional Properties".

In this field you will find the JSON payload from the post (read more in the links in See Also section). One of the properties brought over is the "userPreferredTargetEntity" property which holds information about your choice in the MSE dropdown.

If you picked Case the property value will be "incident", and if you picked Lead the property value will be "lead".

Picture 14: Additional Parameters field shown on form

Before we leverage this information in a rule lets see how we can create a Case from the Social Activity manually.

Click Convert to Case

Picture 15: Manually Convert Social Activity to Case

Set the Regarding

Picture 16: Set Regarding

See the new case in CRM

Picture 17: New Case

And see that the post is now displaying a link to a Case

Picture 18: In MSE post now displays Case link

x

Set Up for Automatic Record Creation

Now using the information from the JSON payload lets set up a Automatic Record Creation rule that creates the records we'd expect from our choice in the entity drop-down in MSE

Navigate to CRM and click Settings -> Business Management -> Automatic Record Creation and Update Rules

Picture 19: Settings, Automatic Record Creation and Update Rules

Create a New Rule

Picture 20: New Rule


Provide required information (name and source type = social activity)

Picture 21: Provide Name and Source Type


Click Save

Picture 22: Save

To leverage the information in the JSON payload as conditional parameter in the rules we are about to build, we must first create a new Channel Property

  1. Create a Channel Property Group and call it eg. "MSE Post Payload"
  2. Pick the type Social Activity
  3. Create a Channel Property with the name "userPreferredTargetEntity" (important you match the JSON property name) and data type Single Line of Text

Picture 23: Pick Channel Property

Picture 24: Channel Property Group with Channel Property


With the Channel Property in place we are now ready to create two rules – one for a Case and one for a Lead

Click the "plus" sign to open the Rules editor

Picture 25: Create Rules


Name the rule eg. CreateCaseFromMSEpost -> Save -> and pick Channel Properties for the Condition

Picture 26: Condition based on Channel Properties


Set the condition to "userPreferredTargetEntity" equals "incident"

Picture 27: Condition is "userPreferredTargetEntity" equals "incident"


For the action pick Create Record -> Case

Picture 28: Action is Create Case


Repeat the above to create a rule for creating a Lead record

Picture 29: Condition is "userPreferredTargetEntity" equals "lead"


When done verify your two rules is created and click Activate (2) to activate rule

Picture 30: Action is Create Lead

x

See Automation at work

Finally we can test to see if the rules will create Leads or Cases from our posts

Open MSE and navigate to a post, click Link to CRM, chose Create Lead and see verify that a Lead record is created

Picture 31: MSE

Picture 32: Navigate to post and click Link to CRM

Picture 33: Pick create Lead

Picture 34: Type a Note and click Create

Picture 35: Post now displays Linked icon

Picture 36: Verified Lead record created

Picture 37: Lead in CRM

Picture 38: Source Social Activity


Then Navigate to another post, click Link to CRM, chose Create Case and see verify that a Case record is created

Picture 39: Navigate to new post and test second part of rule (create case)

Picture 40: Pick create Case, type a note, and click Create

Picture 41: Post now displays Lnked icon

Picture 42: Verified Case record created

Picture 43: Case in CRM

Picture 44: Source Social Activity

I hope you will benefit greatly from this fine new addition to the Microsoft Dynamics CRM and Social Engagement integration story. Start listening for potential leads or cases, and work them the way you know best in CRM.

Note:

  • With pop-up blocker turned on in your browser you must create an exception for https://listening-prod.dynamics.com

See also

  • Set up the connection between Dynamics CRM and Social Engagement – link
  • Create a new CRM record from a social post – link
  • Set up rules to automatically create or update records in CRM – link

Comments (12)

  1. Anonymous says:

    With the latest release of Microsoft Social Engagement we can now connect Dynamics CRM up to it and create

  2. Anonymous says:

    Check out this great new write up on working with Microsoft Social Engagement and Microsoft Dynamics

  3. Emily R says:

    Great detail Jesper! Thanks! Maybe add the modification to security in Internet Options to make sure MSE always allows pop ups even when your pop up blocker is turned off. Thank you!

  4. Tom N says:

    This is great Jesper! Thank you so much for sharing. I will absolutely be putting this into play anywhere I can.

  5. David N says:

    Probably good to mention that this requires the Enterprise license for MSE and will not work with professional.

  6. Correct. To be able to do whats described in this post you must have Microsoft Social Engagement Enterprise.

  7. Darrell Brislane says:

    Hi Jesper,
    Does Link2CRM work with CRM on premise, as well as online?

  8. Anonymous says:

    With Dynamics CRM 2016 comes the brand new Engagement Hub. I just received a preview instance of Dynamics

  9. Currently no – but we will support Link2CRM for CRM 2016 On-Premises as long as it is set up as IFD with oAuth enabled.

  10. pcvg says:

    just to verify, when you say "MS Social Engagement Enterprise" you mean that you need to purchase an additional product for $75 a user per month – correct? the Social Engagement Professional License? in addition to the regular CRM Professional license
    of $65 a user per month

  11. To use Link2CRM you need Microsoft Social Engagement Enterprise. Pricing here:
    http://www.microsoft.com/en-us/dynamics/pricing-list.aspx (Link2CRM is not activated for Microsoft Social Enterprise Professional users)

  12. Trey Kasling says:

    Great post… got mine working!

Skip to main content