Skip to main content
10 votes
Accepted

How to convert Mobile Push List into Data Extension

So Mobile lists are DEs (which you can't see in the UI) and you can query them using a query activity. With this you can query the subscriberkey into a target DE which you can leverage elsewhere. ...
EazyE's user avatar
  • 8,547
8 votes
Accepted

Is there any way to shorten URL in SMS in Marketing Cloud?

That's a great question. We've tried using the bit.ly shorten API method in conjunction with an AMPscript HTTPGet function (to make a request to the API) to shorten a URL. This works well, but the ...
Eliot Harper's user avatar
  • 16.6k
7 votes

Accessing _MobileAddress and _MobileSubscription Data Extensions

In case you're wondering about the data types and such: _MobileAddress | Field Name | Data Type (Length) | Required (Y/N) | Data Default | | :- | :- | :-: ...
Adam Spriggs's user avatar
  • 30.8k
7 votes
Accepted

AMPScript SMS InsertDE() function not working in SMS

The InsertDE() function only works with email messages per the documentation: This function applies to email messages at send time only. Instead, you should use UpsertData: i.e. UpsertData('...
Jackson Chen's user avatar
  • 4,725
6 votes

In Journey builder is it possible to subscribe to MobileConnect sender short code/keyword?

Yes, absolutely you can. I've documented the procedural steps below. Regarding setting the short/long code and keyword, refer to #10 and #11 of Step 2. Step 1: Create a MobileConnect List While ...
Eliot Harper's user avatar
  • 16.6k
6 votes

SQL MobileConnect Demographics Table

Currently there is not a data view which would allow access to attribute X in your example. In the MC January 2019 release, two MobileConnect data views were made available. Relating the two ...
Eli Carleton's user avatar
5 votes

Is there a way to update MobileConnect Subscription Data from a Data Extension?

That is correct, opt-in can only be done manually, or opt-in from mobile or via API. Opt-out can be done via Import in Mobile - All contact and populate the Status field with the value Unsubscribe (...
CloseContact's user avatar
5 votes
Accepted

Update MobileConnect Demographics from a Data Extension

Please check you mapping in the import definition. On some occasions, the "Map by Header Row" is failing. Even though the mapping looks correctly in the UI, it fails to map the fields properly. ...
Lukas Lunow's user avatar
  • 21.7k
5 votes
Accepted

CloudPageURL via SMS broken link

Well then, got this issue solved. When using CloudPagesURL ampscript function link creation via MobileConnect, then the Contact this SMS is sent to, needs to exist in Email channel AllSubscribers ...
Rain's user avatar
  • 5,785
5 votes

Can I delete message on Mobile Connect?

Once a message is marked inactive after 180 Days it will be deleted by the system. This is covered in this help doc: Inactivate a Message NOTE After 180 days, MobileConnect archives inactive messages ...
EazyE's user avatar
  • 8,547
5 votes
Accepted

What is'Id' in POST /sms/v1/messageContact/{id}/send

Within MobileConnect you can find/setup Id by creating a message with Outbound type where you have to choose Send Method as API Trigger. If you're setting up a new message then you can find the Id ...
Brad Sapkota - altus.digital's user avatar
5 votes
Accepted

Implications of MobileConnect SMS Long Code

Yes, Long Codes are meant for 1:1 meaningful conversations, not mass messaging. The 1 message per second restriction is correct. What I would talk to SFMC about is looking to get a short code AND a ...
Gortonington's user avatar
  • 30.7k
5 votes

What does the Status column specify in the MobileConnect Demographics and MobilePush Demographics

_MobileAddress._Status 1 = active -1 = unspecified 2 = bounced 3 = held 4 = unsubscribed _MobileSubscription._OptOutStatusID 0 = opted-in 1 = opted-out _MobileSubscription._OptInStatusID ...
Praveen Kumar Bandi's user avatar
5 votes

Marketing Cloud SMS to Service Cloud Case

Maybe this will help someone else, as I had some trouble to find this in the documentation. If you want to save or further process an inbound SMS, you can use MSG(01) variable. Help (https://...
Björn Schubert's user avatar
5 votes
Accepted

Query to get ContactKey and SubscriberKey in results?

You can create filtered lists in Mobile Connect that will be available as a source to standard SQL queries. The method of obtaining those contacts is described here: Permanently remove Contacts or ...
Rafał Wolsztyniak's user avatar
5 votes
Accepted

Salesforce Marketing Cloud Mobile Connect - Explain how Keywords work

The confusion is understandable, because keywords serve a dual purpose: they act as sort of code words that let the system know what should be done with an inbound message (STOP, HELP and custom ...
Rafał Wolsztyniak's user avatar
5 votes
Accepted

Salesforce Marketing Cloud : How to ensure SMS are sent to only those Phone numbers which are present in the sendable Data Extension

The issue is that the mobile number for a subscriber in your sendable DE is different than on the Mobile Connect. You should always have a process to update the mobile number in Mobile Connect and ...
Swati Mishra's user avatar
  • 1,683
4 votes
Accepted

Line breaks in SMS messages not working with messageContact API method

Just guessing, but perhaps you can use the Char() AMPScript function and add some linefeeds: POST https://www.exacttargetapis.com/sms/v1/messageContact/Mzo3OXXX/send Content-Type application/json ...
Adam Spriggs's user avatar
  • 30.8k
4 votes

Mobile Connect STOP keyword

Here is the query we are using to retrieve most recent unsubscribes from our MobileConnect SELECT a._MobileNumber AS MobileNumber, a._MobileSubscriptionID AS MobileSubscriptionID, a._OptOutDate AS ...
Lukas Lunow's user avatar
  • 21.7k
4 votes
Accepted

MobileConnect Send Time Variables?

Refer to this page for a complete list of personalization strings available within MobileConnect. Retrieving Email Subscriber details from MobileConnect The good news is that SubscriberId in Email ...
Eliot Harper's user avatar
  • 16.6k
4 votes
Accepted

Can I use a short code from the parent account in a business unit?

Yes, in short. MobileConnect can be provisioned in one of two ways: A single shared instance where contacts and codes are shared by all BUs. Separate siloed instances for each Business Unit. If ...
Macca's user avatar
  • 8,266
4 votes

Marketing Cloud pushing notifications to external app. How?

The Marketing Cloud SDK would be the right way to accomplish this. The setup is simple, both iOS and Android are supported and there are a number of ways for integrating messaging in a broader system. ...
Brian M. Criscuolo's user avatar
4 votes

Test Mobile Connect SMS Send from SFMC Without Short/ Long Code

You will need a short/long code before you can use MobileConnect. When an account is initially provisioned, it doesn't include a short/long code, even if this is included in your licence. This has to ...
Eliot Harper's user avatar
  • 16.6k
4 votes

SMS Send Logging Data Extension

For send logging to a Data Extension, SFMC added the SMS Send Log Data Extension template last year. There's a knowledge base article that covers what it is an how to use it. One of the challenges ...
Macca's user avatar
  • 8,266
4 votes
Accepted

Update Mobile Connect SMS Opt In/Opt Out status with imports to MobileSubscription

Opt-out can be done via Import in Mobile - All contacts and populate the Status field with the value Unsubscribe (MobileConnect Demographics). So this is a update from opt-in to opt-out. Opt-out to ...
CloseContact's user avatar
4 votes
Accepted

Registered Symbol ® in text message in mobileconnect

I have come across this situation before where MobileConnect Outbound SMS wouldn't respect the spaces and I guess your reg trademark is related to same issue. The workaround this is by using the ...
Brad Sapkota - altus.digital's user avatar
4 votes

MobileConnect - What are some standard guidelines to working with MobileConnect?

Apart from what C Carswell mentioned above, please consider below points. Your Contact Key in Mobileconnect Should be same as Subscriber Key used in Email Studio. If they don't match, it won't be ...
Unais Komath's user avatar
4 votes

How do I track Marketing cloud Mobile Connect(SMS) data in Salesforce?

There is no out of the box solution for this as of yet, so you do need to do something custom in order to achieve it. There are two smart ways to achieve this. 1) Use AMPscript to store messages ...
Rain's user avatar
  • 5,785
4 votes
Accepted

MobileConnect data views

There are details about _MobileAddress and _Mobile Subscription floating around SFSE. I did find some info on _UndeliverableSMS here. MobileNumber, phone Undeliverable, boolean BounceCount, number ...
Adam Spriggs's user avatar
  • 30.8k
4 votes
Accepted

MobileConnect - Opt Out from specific keywords

Keyword level opt-out for SMS is not available yet. I wondered what's the use of having multiple keywords for opt-outs in that case. Figured out that this feature is only available in Australia. ...
sfdcFanBoy's user avatar
  • 4,084

Only top scored, non community-wiki answers of a minimum length are eligible