Salesforce Social Insights Data and Reports

When you install the Social Insights package in Salesforce, it will create a Social Activity object in your account containing the fields below.

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

Available Reports

With the package installation, we've also created several reports for your convenience as well as a dashboard called: Oktopost Social Insights.


  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