Skip to main content
SachinDhir
Level 2
Jun 27, 2021 11:11 AM UTC
Solved

Link SMS reply to respective delivery

Is there any way to link SMS reply to respective delivery if we are sending multiple deliveries to same customer within short period of time like transaction message?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
kapilKochar
kapilKocharAccepted solution
Level 6
Jul 5, 2021 12:47 AM UTC

Hi Sachin, 

 

There is a field in inSMS schema call linkedSmsId.  you can use this field to set broadlogId. Since it's not auto populated so for this you can create one tech Workflow which links incoming SMS with originating broadlogs. 

 

This workflow runs as delta and picks all data from inSMS as first query and then you can add enrichment with rcpbroadlogs join conditions based on extAccountid and messagetype. This will be 1:N, to restrict the output to 1 use data collected as Limit the count in properties and filter based on address=(origin) and sort by eventDate desc. 

 

After enrichment you will have latets records for that origin from rcpbroadlog and pass broadlogsID to next activity which will update inSMS table and column linkedSmsId. 

 

Thanks,

Kapil

7 replies

LaurentLam
Level 5
Jun 27, 2021 5:53 PM UTC

You can check here:
Send, monitor and track SMS | Adobe Campaign

-> linkedSmsId


But carefull, there is no "easy" way to be 100% sure for a response to be linked to the outgoing SMS as this depends from the SMS provider arbitrary rules. That's not coming from Adobe Campaign it self but about the amount of phone number to reply to a SMS in order to identify the answer.

=> usually it is based on a time frame + the phone number used for the delivery by the SMS provider

Translate
Darren_Bowers
Level 9
Jun 28, 2021 9:06 AM UTC

Hey @laurentlam - I have never seen linkedSmsId populated, even when using 2-way SMS with responses from Campaigns.

Is there any documentation on how to get this working? Is there a workflow that does the broadLogId matching?

Genuinely curious.

Cheers Darren

Translate
kapilKochar
kapilKocharAccepted solution
Level 6
Jul 5, 2021 12:47 AM UTC

Hi Sachin, 

 

There is a field in inSMS schema call linkedSmsId.  you can use this field to set broadlogId. Since it's not auto populated so for this you can create one tech Workflow which links incoming SMS with originating broadlogs. 

 

This workflow runs as delta and picks all data from inSMS as first query and then you can add enrichment with rcpbroadlogs join conditions based on extAccountid and messagetype. This will be 1:N, to restrict the output to 1 use data collected as Limit the count in properties and filter based on address=(origin) and sort by eventDate desc. 

 

After enrichment you will have latets records for that origin from rcpbroadlog and pass broadlogsID to next activity which will update inSMS table and column linkedSmsId. 

 

Thanks,

Kapil

Translate
SachinDhir
Level 2
Jul 5, 2021 1:02 AM UTC
Hi @545806, I totally understood the approach but the point it what if customer recieve multiple SMS? The approach relies on assumption customer should not get another SMS until he replies or previous question is expires/no more validate.
Translate