Expand my Community achievements bar.

SOLVED

Time Zone

Avatar

Level 1

Hi all,

There is an urgent requirement, but I am unable to find solution. Please help me in solving this issue.

I have recipients from different time zones. I have a custom attribute in recipient schema @recipientTimeZone (String) stores values like IST, EST, CST, MST etc.

 

Our Objective is to send an email delivery at 8AM in their respective time zone. So recipient-A who belongs to India will receive at 8AM IST, recipient-B belongs to CST will be receiving email at 8AM CST and so on.

 

How we can achieve this by using a single delivery in the workflow.

It will be great if I get an idea to achieve this by using a single delivery in the workflow, instead of using split and configuring different delivery for each time zone because we have 15+ time zones.

 

Thanks!

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

hi,

 

You can achieve this by playing with the time conversion.

Basically:

  • scheduler that will run several time (best to coincide with you time zone)
  • js activity where you will calculate (assuming your instance is EST if current hour = 10 then time= 10 and timezone=EST)
  • query using dynamic variables recipient timezone = $(vars/@timezone)
  • continuous delivery

Bonus: you can extend your delivery logs to save timezone for reporting perspective.

Thanks,

David 



David Kangni

View solution in original post

3 Replies

Avatar

Employee Advisor

Hello,

 

As far as I'm aware there isn't any way to proceed with the request as the delivery is configured to send based on a single timezone.  The delivery is then analyzed and prepared to be sent at the contact date defined.  Since we cannot define multiple contact dates/times for a single delivery there isn't any way to enforce specific sending per timezone.

 

Regards,

Craig

Avatar

Correct answer by
Community Advisor

hi,

 

You can achieve this by playing with the time conversion.

Basically:

  • scheduler that will run several time (best to coincide with you time zone)
  • js activity where you will calculate (assuming your instance is EST if current hour = 10 then time= 10 and timezone=EST)
  • query using dynamic variables recipient timezone = $(vars/@timezone)
  • continuous delivery

Bonus: you can extend your delivery logs to save timezone for reporting perspective.

Thanks,

David 



David Kangni

Avatar

Employee Advisor

Hi,


It is possible however the solution is quite complex to implement and engaging Adobe Consulting will be a well placed investment as it has been done for some of our customers and Adobe Consulting has developed a new workflow activity to answer this specific requirement. In a nutshell, the new workflow activity does the following

  1. Create one new subworkflow per timezone and append it to the current campaign. 
  2. Pick up records from the target relevant only to their timezone. 
  3. Set the contact date and Extraction date on the delivery taking into account the timezone of the sub-workflows

As said, it is all done in JS via a new workflow activity.

 

Thanks


Denis