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 |
|
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 |
|
Native message type name
|
Sprout Social Post |
sproutMessageType |
|
Sprout message type name |
Sprout Social Post |
customerProfileId |
|
Sprout customer profile ID |
Sprout Social Post |
handle |
|
Handle or name from social network |
Sprout Social Post |
provider |
|
Native social network |
Sprout Social Post |
postTags |
|
CSV string of Social Post label names sent from Sprout |
Sprout Social Post |
posted |
|
Date social post was posted |
Sprout Social Post |
postURL |
|
Not available for:
|
Sprout Social Post |
parentGuid |
|
Guid of the parent post of a comment |
Sprout Social Post |
recipient |
|
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 or name from social network |
Sprout Social Persona |
realName |
|
Name of profile owner, if available |
Sprout Social Persona |
provider |
|
Native social network |
Sprout Social Persona |
externalId |
|
|
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 |
|
Is null for all networks besides Twitter |
Sprout Social Persona |
authorLabels |
|
CSV string of vip list names |
Sprout Social Persona |
firstName |
|
First name of profile owner, if available |
Sprout Social Persona |
lastName |
|
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 |
|
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 |
|
Native message type name
|
Social Post |
TopicProfileName Topic Profile Name |
|
Sprout message type name |
Social Post |
R6SourceId Field Label: Social Studio Source ID |
|
Sprout customer profile ID |
Social Post |
handle |
|
Handle or name from social network |
Social Post |
provider |
|
Native social network |
Social Post |
Post Tags |
|
Post labels defined in an Automated Rule or Macro in Sprout |
Social Post |
posted |
|
Date social post was posted |
Social Post |
postURL |
|
Not available for:
|
Social Post |
R6TopicId Field Label: Social Studio Topic ID |
|
Guid of the parent post of a comment |
Social Post |
recipient |
|
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 or name from social network |
Social Persona |
realName |
|
Name of profile owner, if available |
Social Persona |
provider |
|
Native social network |
Social Persona |
MediaProvider |
|
|
Social Persona |
externalId |
|
|
Social Persona |
externalPictureURL |
URL for profile image from the native social network |
|
Social Persona |
profileURL |
URL for native profile |
|
Social Persona |
followers |
|
Will be null for all networks besides Twitter |
Social Persona |
authorLabels |
|
CSV string of vip list names |
Social Persona |
firstName |
|
First name of profile owner, if available |
Social Persona |
lastName |
|
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 |