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?

  • Thats strange. I thought that when SF exports it's ID it adds an extra 3 digits to it to make it 18? – Samuel Dare Jun 15 '17 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 Jun 15 '17 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 Jun 15 '17 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 Jun 15 '17 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 Jun 15 '17 at 8:51
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)=%%
  • Comments are not for extended discussion; this conversation has been moved to chat. – Adrian Larson Jun 15 '17 at 18:10
  • 1
    Atheri - did it solve everything? Or are more things needed? (and thanks for moving it to chat Adrian) – Kenneth Wagner Jun 16 '17 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 Jul 6 '17 at 3:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.