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

After you configure the Sprout Social app and build your Automated Rules and/or macros, 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

Sample Data

Details

Sprout Social Post

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

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

The actual content of the social post.

Sprout Social Post

externalPostId

“t:1547292117701107712”

Native Social Network Id

Sprout Social Post

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

  • Example: “tweet”, “fb_comment”

Sprout message type name

Sprout Social Post

customerProfileId

  • "5295135"

Sprout customer profile ID

Sprout Social Post

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

  • Lowercase provider: “twitter”

Native social network

Sprout Social Post

postTags

  • "test,label1,label2"

CSV string of Social Post label names sent from Sprout

Sprout Social Post

posted

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

Date social post was posted

Sprout Social Post

postURL

Not available for:

  • Instagram Direct Messages

  • GBM Private Messages

Sprout Social Post

parentGuid

  • “p:293087514692926_975283686473302"

Guid of the parent post of a comment

Sprout Social Post

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

Sample Data

Details

Sprout Social Persona

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

  • “Bob Sprout”

Name of profile owner, if available

Sprout Social Persona

provider

  • Provider: “TWITTER”

Native social network

Sprout Social Persona

externalId

  • "621218516"

 

Sprout Social Persona

externalPictureURL

URL for profile image from the native social network

Sprout Social Persona

profileURL

URL for native profile

Sprout Social Persona

followers

  • Integer followers: 14

Is null for all networks besides Twitter

Sprout Social Persona

authorLabels

  • "vipList1,vipList2"

CSV string of vip list names

Sprout Social Persona

firstName

  • “Bob”

First name of profile owner, if available

Sprout Social Persona

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

Sample Data

Details

Social Post

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

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

The actual content of the social post.

Social Post

externalPostId

“t:1547292117701107712”

Native Social Network Id

Social Post

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

Topic Profile Name

  • Example: “tweet”, “fb_comment”

Sprout message type name

Social Post

R6SourceId

Field Label: Social Studio Source ID

  • "5295135"

Sprout customer profile ID

Social Post

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

provider

  • Lowercase provider: “twitter”

Native social network

Social Post

Post Tags

  • "test,label1,label2"

Post labels defined in an Automated Rule or Macro in Sprout

Social Post

posted

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

Date social post was posted

Social Post

postURL

Not available for:

  • Instagram Direct Messages

  • GBM Private Messages

Social Post

R6TopicId

Field Label: Social Studio Topic ID

  • “p:293087514692926_975283686473302"

Guid of the parent post of a comment

Social Post

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

Sample Data

Notes

Social Persona

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

  • “Bob Sprout”

Name of profile owner, if available

Social Persona

provider

  • Provider: “TWITTER”

Native social network

Social Persona

MediaProvider

 

 

Social Persona

externalId

  • "621218516"

 

Social Persona

externalPictureURL

URL for profile image from the native social network

Social Persona

profileURL

URL for native profile

Social Persona

followers

  • Integer followers: 14

Will be null for all networks besides Twitter

Social Persona

authorLabels

  • "vipList1,vipList2"

CSV string of vip list names

Social Persona

firstName

  • “Bob”

First name of profile owner, if available

Social Persona

lastName

  • “Sprout”

Last name of profile owner, if available

Language field values

A language value will be passed in the language field on the social post object. You can use this field to route to a language-based queue via an omni-routing flow.

Language Field Value
English en
Swedish sv
Danish da
Dutch nl
French fr
German de
Spanish es
Arabic ar
Greek el
Galician gl
Finnish fi
Welsh cy
Czech cs
Catalan ca
Bulgarian bg
Belarusian be
Hindi hi
Esperanto eo
Icelandic is
Indonesian id
Irish ga
Persian fa
Estonian et
Haitian ht
Croatian hr
Hungarian hu
Afrikaans af
Chinese zh
Taiwanese zh-TW
Korean ko
Japanese ja
Italian it
Yiddish yi
Vietnamese vi
Romanian ro
Russian ru
Ukrainian uk
Turkish tr
Tagalog tl
Thai th
Swahili sw
Slovenian sl
Slovak sk
Portuguese pt
Polish pl
Norwegian nw
Maltese mt
Malay ms
Macedonian mk
Albanian sq
Serbian sr
Latvian lv
Lithuanian lt
Unknown un

Was this article helpful?

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

Powered by Zendesk