Translate Mobile Connect Keyword GUID To Its Clear Text Name

Photo by Maliha Mannan on Unsplash

Today’s post is a quick hack to find the GUID and Clear Text Name for your Mobile Connect keywords. This is particularly important and useful because the _SMSSubscriptionLog DataView only has the GUID version of the keyword, the field being SubscriptionDefinitionID.

So first things first, you should log in to your account and BU, then use the internal api I have linked below.

https://mc.s10.marketingcloudapps.com/contactsmeta/fuelapi/legacy/v1/beta/mobile/keyword/

It will work if you past the URL directly in to your browser, and as long as you are logged in. Just update the stack version in the URL to be congruent with your SMFC stack.

When the page has loaded, in the API response look for Keyword and decodedId values.

The decodedId value from this API response is equivalent to the SubscriptionDefinitionID field within the_SMSSubscriptionLog Data View.

To make use of this information, jump into Automation Studio and write a SQL Query Activity.

Use a CASE WHEN statement to translate the Keyword GUID into an easy to read KeywordName.

SELECT 
    s._MobileNumber                AS MobileNumber,
    s._SubscriptionDefinitionID    AS KeywordGUID,
    CASE 
        WHEN s._SubscriptionDefinitionID = '90AC04CE-D410-403b-3462-a24ed49a299f' THEN 'JOIN' 
        WHEN s._SubscriptionDefinitionID = 'b7ecbb23-e183-4828-5948-4815a46aa10d' THEN 'TEST' 
    END AS KeywordName
FROM 
    [_SMSSubscriptionLog] AS s

An alternative approach is to subscribe a Test contact to all your keywords, then open Contact Builder, click the Attributes tab and find the section called MobileConnect Data. Click on the Carrier ID value. It will open the MobileConnect Subscriptions view. Check the Keyword column which will have your Keyword in a Clear Text format. Make a note of this and write it down; then click Edit. The edit interface will display the same data, but the Keyword will be in its GUID form. Copy this value down. Now go ahead and repeat this process for the other Keywords.

I prefer the internal API route I have just shared as it will provide all the information you need plus more! You also don’t have to worry about subscribing a test contact to all the keywords.