Run a automated query everyday that will send reminders (infinitely) to prospects every 14 days who have not signed up | Community
Skip to main content
V
Vijay2021
September 1, 2021
Solved

Run a automated query everyday that will send reminders (infinitely) to prospects every 14 days who have not signed up

  • September 1, 2021
  • 1 reply
  • 1365 views

Hi
I am new to Adobe Campaign Standard. Could anyone help me to write a query for an
automated workflow that will run everyday and will send reminders to prospects every 14 days who have not signed up. They will be sent the reminders till the time they sign up.

Thanks,
Vijay

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 tommy_8

hi @vijay2021 ,

my approach would be a scheduled workflow (daily). The sign up would be a subscription to a service.

  1. I would add a custom field to the profiles table, which gives us the next date of reminding that profile (i.e. "Next Reminder" -> format as date)
  2. In the workflow you have to select all profiles (not subscribed AND Next Reminder = TODAY())
    1. Node = Query
  3. Send the reminder and set the Next Reminder column to TODAY+14days
    1. Node = Delivery
    2. Node = Update data

A second branch of the workflow would set the reminder date (Next Reminder) for profiles where that value hasn't been set to TODAY+14days.

 

Hope, that helps

 

Greetz!

Tommy

1 reply

T
tommy_8Accepted solution
Level 2
September 1, 2021

hi @vijay2021 ,

my approach would be a scheduled workflow (daily). The sign up would be a subscription to a service.

  1. I would add a custom field to the profiles table, which gives us the next date of reminding that profile (i.e. "Next Reminder" -> format as date)
  2. In the workflow you have to select all profiles (not subscribed AND Next Reminder = TODAY())
    1. Node = Query
  3. Send the reminder and set the Next Reminder column to TODAY+14days
    1. Node = Delivery
    2. Node = Update data

A second branch of the workflow would set the reminder date (Next Reminder) for profiles where that value hasn't been set to TODAY+14days.

 

Hope, that helps

 

Greetz!

Tommy

    V
    Vijay2021Author
    September 6, 2021

    Thank a ton, Tommy! That worked perfectly. Though I didn't have permission to add a field, got the field added by admin and created the query as you advised. 

     

    Best Regards,

    Vijay

      Terms & ConditionsAccessibility statement

      Loading footer...