Microsoft Dynamics Social Activity Entity

When you set up the Microsoft Dynamics integration, Oktopost will create an Oktopost Social Activity entity in your Common Data Service. The entity will have the following fields:

Field Type Description
Account Lookup(Account) Reference to Dynamics Account (Contacts only)
Activity Datetime Date and Time -
Activity Id Text Reference to the activity ID in Oktopost
Activity Text Text Area Post, mention, direct message, or comment text
Activity Type Text Link Click, Comment, Share, Mention, or Direct Message
Campaign Name Text Oktopost campaign name
Campaign Tags Text Area A comma-separated list of tags from Oktopost campaign
Comment Keywords Text Area A comma-separated list of keywords extracted from the comment text
Contact Lookup(Contact) Reference to Dynamics Contact
Lead Lookup(Lead) Reference to Dynamics Lead
Message Keywords Text Area A comma-separated list of keywords extracted from the post, mention, or message content
Network Text LinkedIn, Twitter, Facebook, Google or Instagram
Post Datetime Date and Time The post date and time
Poster Name Text Area Name of the Oktopost user who scheduled the post
Post Id Text Reference to Oktopost post ID
Post Source Text UI, API, Board, Curation or Direct
Profile Name Text Name of the social profile who shared the link
Remote Url URL A link to the post on social media
Sentiment Text Positive, Negative, Neutral or Mixed
Sentiment Score Whole Number Positive = 100, Negative = 0, Neutral = 50, Mixed = 50
Who Type Text Who this activity is associated with: Lead or Contact

Every time a social interaction will be captured by Oktopost and associated with a known Contact or Lead in Dynamics, Oktopost will append a record to this object.

Each record will represent a different social activity and contain information about it. Fields that are not available or irrelevant to the activity type will remain empty.

Here's the full reference of available fields per activity type:

Field Link Click Mention Comment Share Like Reaction Direct Message
Activity Datetime
Activity Id
Activity Text - - -
Activity Type
Campaign Name - -
Campaign Tags - -
Comment Keywords - - - - - -
Message Keywords - - - - -
Post Datetime -
Poster Name - -
Post Id - -
Post Source - -
Profile Name -
Remote Url
Sentiment - - - -
Sentiment Score - - - -
Who Type

Note that not all interactions can be associated with known Leads or Contacts immediately, therefore, when such a connection will be detected, the associated activities will be synced soon after.


  1. How to Set Up The Marketo Integration
  2. How to Install Social Insights for Salesforce
  3. Salesforce Social Insights Data and Reports
  4. How to Install Social Analytics for Salesforce
  5. How to Install Social Advocacy For Salesforce
  6. How to Set Up The Eloqua Integration
  7. How to Set Up the HubSpot Integration
  8. How to Set Up The Salesforce Integration
  9. How to Set up The Microsoft Dynamics Integration
  10. Microsoft Dynamics Social Activity Entity
  11. Oktopost Solution Package for Microsoft Dynamics
  12. How to Set Up The Mautic Integration
  13. How to Set Up the Bitly Integration
  14. How to Set Up the Feedly Integration
  15. How to Set Up the Act-On Integration
  16. Feedly Custom Sharing with Oktopost
  17. Act-On Integration: Segmenting Lists Using Social Data
  18. Act-On Integration: Social Lead Scoring
  19. Conversion Tracking With Marketo Forms 2.0
  20. Marketo Integration: Lead Segmentation
  21. Marketo Integration: Interesting Social Moments
  22. How to Set Up the Salesfusion Integration
  23. How to Set Up the Pardot Integration
  24. Setting up the Google Analytics integration
  25. How to Set Up the Facebook Retargeting Integration
  26. How to Create a Facebook Audience Based on Social Behavior
  27. Attributing Social to Leads in Marketo
  28. Webhooks
  29. How to Connect Oktopost to Zapier
  30. How to Create Salesforce Cases From Assignments
  31. Setting up Integration Assets
  32. Social Click URLs
  33. Salesforce Campaign Naming Parameters
  34. How to Track Conversion on HubSpot Embedded Forms
  35. How to Track Conversion on Pardot Forms
  36. How to Track Conversions on Act-On Labs Forms
  37. How to Set Up Single Sign-on With AD FS
  38. How to Set Up Single Sign-on With Okta
  39. How to Set Up Single Sign-on With OneLogin
  40. How to Set Up Single Sign-on With Google Apps
  41. How to Set Up The Facebook Lead Ads Integration
  42. Zapier Use Cases
  43. How to Set up Oktopost for Bizible
  44. How to Format Dates in Salesforce Template Fields
  45. Social Attribution Parameters
  46. Lead Parameters
  47. How to Update an Existing Social Insights Installation

Feedback and Knowledge Base