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

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	The link to the native post: “https://twitter.com/O_colleen_G/status/1547292117701107712”	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

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	"https://pbs.twimg.com/profile_images/2350005836/profile_normal.jpg"	URL for profile image from the native social network
Sprout Social Persona	profileURL	"https://twitter.com/O_colleen_G/status/1547292117701107712"	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

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	The link to the native post: “https://twitter.com/O_colleen_G/status/1547292117701107712”	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

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	"https://pbs.twimg.com/profile_images/2350005836/profile_normal.jpg"	URL for profile image from the native social network
Social Persona	profileURL	"https://twitter.com/O_colleen_G/status/1547292117701107712"	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?

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

Custom Object Mapping

Sprout Social Post Object

Sprout Social Persona Object

Standard Object Mapping

Social Post Object

Social Persona Object

Language field values

Was this article helpful?

Related articles