2

Trying to make Syncronised Data Extension attributes to be available for MobileConnect group in Contact Builder / Data Designer.

Despite linking the Account_Salesforce syncronised data extension to the MobileConnect Demographics table, the list of available attributes is not showing up in MobileConnect contact Attribute list.

Is there a step I'm missing here? There wasn't anything extra in documentation.

The only thing I can think of is the fact that on MobileConnect Demographics we have 18-digit contact ID field and on Account_Salesforce we have 15-digit contact ID, which are used to link these.

18digit-vs-15digitenter image description here

Any ideas?

Improve this question
5
  • Thats strange. I thought that when SF exports it's ID it adds an extra 3 digits to it to make it 18?
    – 0xsegfault
    Commented Jun 15, 2017 at 8:28
  • Could you expand a bit more where you want to use this data? Is it for creating segments or? If you are pulling SFIDs in via Marketing Cloud Connect (which should be the way), the ID should ALWAYS be 18 digits.
    – Kenneth Wagner
    Commented Jun 15, 2017 at 8:29
  • Hi @Data_Kid - I apologize, you were right. Checked the Account_Salesforece syncronised data extensiona and the PersonContactID is indeed 18 digits. This then rules out the possibility of the ID's not matching.
    – Rain
    Commented Jun 15, 2017 at 8:47
  • Hi @Kenneth Wagner - Idea is to use Salesforce attributes in MobileConnect, so we could use SF fields in SMS sendings, for personalization. I'm adding a second picture where these attributes are missing. The attribute tab list, basically. There is no Account_Salesforce tab with SF attributes. I wonder if it could be because the Contact Key for this contact is a custom ID? Even though the "Salesforce ID" is also shown under MobileConnect Data
    – Rain
    Commented Jun 15, 2017 at 8:47
  • Hi Atheri - you don't have access to that information at send time, I'll try and elaborate a bit an post relevant answers.
    – Kenneth Wagner
    Commented Jun 15, 2017 at 8:51

1 Answer 1

Reset to default
4

Overall, the challenge is that you only have access to data that is stored in the mobile demographics table, and not linked data sets to my knowledge.

If you want to include personalization, this is done using ampscript, which numerous examples can be found in the links below. Conceptually, you use the mobile number at send time, to reference an attribute value (e.g. SFID) which you've created on the demograhics table, and then you use that value to reference your personalization strings.

There are numerous resources that deal with personalization in Mobile Connect:
Personalization in Mobile Connect SMS called within Journey Builder
MobileConnect Send Time Variables?
Outbound SMS referencing event source data?

%%[
VAR @ContactRows, @ContactRow, @RowCount, @ContactKey

SET @ContactKey = AttributeValue("Salesforce_ID")
SET @ContactRows = LookupRows("Contact_Salesforce","PersonContactId", @contactKey)
SET @RowCount = RowCount(@ContactRows)

IF @RowCount > 0 then

    /* Write out your values here */

ENDIF
]%%
Reference values here using %%=v(@YourValue)=%%
Improve this answer
3
  • Comments are not for extended discussion; this conversation has been moved to chat.
    – Adrian Larson ♦
    Commented Jun 15, 2017 at 18:10
  • 1
    Atheri - did it solve everything? Or are more things needed? (and thanks for moving it to chat Adrian)
    – Kenneth Wagner
    Commented Jun 16, 2017 at 12:30
  • Hi KennethWagner, I tried doing SET @ContactKey = AttributeValue("Salesforce_ID") however It doesnt return any value. I've already added this attribute in my MobileConnect Demographics
    – sforce
    Commented Jul 6, 2017 at 3:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .