What does the Field Mapping look like for Salesforce Service Cloud?

After you configure the Sprout Social app and build your Automatic Rules, Sprout then sends data to Salesforce in raw format. The data is then decoded by a Sprout web service in Salesforce and processed by a Flow template to create two custom Salesforce objects: Sprout Social Post and Sprout Social Persona.

The Sprout Social Post contains information that is post-specific (posts in this context encompass tweets, Twitter direct messages, Facebook posts, comments, comment replies and so on). The Sprout Social Persona stores social profile information that is passed to Salesforce from Sprout.

You can use a modified flow template or a data event trigger to route the data into the standard objects.

 

Custom Object Mapping

Sprout Social Post Object

The following table contains the post values that are passed from Sprout and posted to the Sprout Social Post object in Salesforce.

Sprout Custom Object

Salesforce Field

Salesforce Rest API Payload Attribute

Sample Data

Details

Sprout Social Post

name

postData.name

  • For DIRECT_MESSAGE MessageCategory: "Direct message from handle to: sentToHandle"

  • For all other MessageCategories: "Post from handle"

System generated by Sprout Social.

Sprout Social Post

content

postData.content

“@mysproutcoffee What is up with the warm cold brew these days?”

The actual content of the social post.

Sprout Social Post

externalPostId

postData.externalPostId

“t:1547292117701107712”

Native Social Network Id

Sprout Social Post

messageType

postData.messageType

  • for MessageCategory DIRECT_MESSAGE

    • if Twitter DM: “Direct”

    • else: “Private”

  • for MessageCategory COMMENT: “Comment”

  • POST and default: "Post"

Native message type name

 

Sprout Social Post

sproutMessageType

postData.sproutMessageType

  • Example: “tweet”, “fb_comment”

Sprout message type name

Sprout Social Post

customerProfileId

postData.customerProfileId

  • "5295135"

Sprout customer profile ID

Sprout Social Post

handle

postData.handle

  • Handle if available for given network: “bob_sprout”

  • If network does not provide a handle, use name: “Bob Sprout”

  • If neither are available: “Private”

Handle or name from social network

Sprout Social Post

provider

postData.provider

  • Lowercase provider: “twitter”

Native social network

Sprout Social Post

postTags

postData.postTags

  • "test,label1,label2"

CSV string of Social Post label names sent from Sprout

Sprout Social Post

posted

postData.posted

  • "2022-07-13T18:49:22.000+0000”

Date social post was posted

Sprout Social Post

postURL

postData.postURL

Not available for:

  • Instagram Direct Messages

  • GBM Private Messages

Sprout Social Post

parentGuid

postData.parentGuid

  • “p:293087514692926_975283686473302"

Guid of the parent post of a comment

Sprout Social Post

recipient

postData.recipient

  • "2513140548"

ID of social profile receiving the social post

Sprout Social Persona Object

The following table contains the profile values that are passed from Sprout and posted to the Sprout Social Persona object in Salesforce.

Sprout Custom Object

Salesforce Field

Salesforce Rest API Payload Attribute

Sample Data

Details

Sprout Social Persona

name

personaData.name

  • Handle if available for given network: “bob_sprout”

  • If network does not provide a handle, use name: “Bob Sprout”

  • If neither are available: “Private”

Handle or name from social network

Sprout Social Persona

realName

personaData.realName

  • “Bob Sprout”

Name of profile owner, if available

Sprout Social Persona

provider

personaData.provider

  • Provider: “TWITTER”

Native social network

Sprout Social Persona

externalId

personaData.externalId

  • "621218516"

 

Sprout Social Persona

externalPictureURL

personaData.externalPictureURL

URL for profile image from the native social network

Sprout Social Persona

profileURL

personaData.profileURL

URL for native profile

Sprout Social Persona

followers

personaData.followers

  • Integer followers: 14

Is null for all networks besides Twitter

Sprout Social Persona

authorLabels

personaData.authorLabels

  • "vipList1,vipList2"

CSV string of vip list names

Sprout Social Persona

firstName

personaData.firstName

  • “Bob”

First name of profile owner, if available

Sprout Social Persona

lastName

personaData.lastName

  • “Sprout”

Last name of profile owner, if available

Standard Object Mapping

Social Post Object

The following table contains the post values that are passed from Sprout and posted to the Social Post object in Salesforce.

Standard Object

Salesforce Field

Salesforce Rest API Payload Attribute

Sample Data

Details

Social Post

name

postData.name

  • For DIRECT_MESSAGE MessageCategory: "Direct message from handle to: sentToHandle"

  • For all other MessageCategories: "Post from handle"

System generated by Sprout Social.

Social Post

content

postData.content

“@mysproutcoffee What is up with the warm cold brew these days?”

The actual content of the social post.

Social Post

externalPostId

postData.externalPostId

“t:1547292117701107712”

Native Social Network Id

Social Post

messageType

postData.messageType

  • for MessageCategory DIRECT_MESSAGE

    • if Twitter DM: “Direct”

    • else: “Private”

  • for MessageCategory COMMENT: “Comment”

  • POST and default: "Post"

Native message type name

 

Social Post

TopicProfileName

postData.sproutMessageType

  • Example: “tweet”, “fb_comment”

Sprout message type name

Social Post

R6SourceId

postData.customerProfileId

  • "5295135"

Sprout customer profile ID

Social Post

handle

postData.handle

  • Handle if available for given network: “bob_sprout”

  • If network does not provide a handle, use name: “Bob Sprout”

  • If neither are available: “Private”

Handle or name from social network

Social Post

mediaProvider

personaData.provider

 

 

Social Post

provider

postData.provider

  • Lowercase provider: “twitter”

Native social network

Social Post

postTags

postData.postTags

  • "test,label1,label2"

CSV string of Social Post label names sent from Sprout

Social Post

posted

postData.posted

  • "2022-07-13T18:49:22.000+0000”

Date social post was posted

Social Post

postURL

postData.postURL

Not available for:

  • Instagram Direct Messages

  • GBM Private Messages

Social Post

R6TopicId

postData.parentGuid

  • “p:293087514692926_975283686473302"

Guid of the parent post of a comment

Social Post

recipient

postData.recipient

  • "2513140548"

ID of social profile receiving the social post

Social Persona Object

These following table contains the profile values that are passed from Sprout and posted to the Sprout Social Persona object in Salesforce.

Standard Object

Salesforce Field

Salesforce Rest API Payload Attribute

Sample Data

Notes

Social Persona

name

personaData.name

  • Handle if available for given network: “bob_sprout”

  • If network does not provide a handle, use name: “Bob Sprout”

  • If neither are available: “Private”

Handle or name from social network

Social Persona

realName

personaData.realName

  • “Bob Sprout”

Name of profile owner, if available

Social Persona

provider

personaData.provider

  • Provider: “TWITTER”

Native social network

Social Persona

MediaProvider

personaData.mediaProvider

 

 

Social Persona

externalId

personaData.externalId

  • "621218516"

 

Social Persona

externalPictureURL

personaData.externalPictureURL

URL for profile image from the native social network

Social Persona

profileURL

personaData.profileURL

URL for native profile

Social Persona

followers

personaData.followers

  • Integer followers: 14

Will be null for all networks besides Twitter

Social Persona

authorLabels

personaData.authorLabels

  • "vipList1,vipList2"

CSV string of vip list names

Social Persona

firstName

personaData.firstName

  • “Bob”

First name of profile owner, if available

Social Persona

lastName

personaData.lastName

  • “Sprout”

Last name of profile owner, if available

Was this article helpful?

Still can't find what you're looking for?

Powered by Zendesk