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

Feedback and Knowledge Base