Link SMS reply to respective delivery | Community
Skip to main content
SachinDhir
SachinDhir
Level 2
June 27, 2021
Solved

Link SMS reply to respective delivery

  • June 27, 2021
  • 2 replies
  • 2296 views

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.
Best answer by kapilKochar

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

2 replies

LaurentLam
LaurentLam
Level 5
June 27, 2021

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

Darren_Bowers
Darren_Bowers
Level 9
June 28, 2021

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

kapilKochar
kapilKocharAccepted solution
Level 6
July 5, 2021

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

SachinDhir
SachinDhirAuthor
Level 2
July 5, 2021
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.
Terms & ConditionsAccessibility statement

Loading footer...