Automated Holiday Campaigns

Question

We need to implement automated email communications to customers, notifying them of branch closures due to holidays. We have a list of 11 holidays that are not stored in ACC. The email template will also consist of dynamic info: Holiday name and respective closure date.
Can a script be set up for the scheduler to send emails on those dates only?
Can we create a separate table in ACC to store that info(holiday dates, etc.)?

Or can you advise on any other better approach?

vt0509 · Accepted Answer

@mhasan There's a simpler approach for this!
Create a list which contains all 11 Public holidays date and their respective name. (Or upload a csv file via Data loading)

Add a scheduler to run daily.

If GetDate() = Public holiday date, Test activity will proceed the workflow and send email communications to customers populating holiday name as dynamic field.

Add External signal if you want to trigger multiple workflows on holiday dates.

Marcel_Szimonisz · Answer

Hello @mhasan ,you can!I will not give you exactly how but.I would divide it into two workflows. However, considering time pressure, feel free to split it into as many workflows as needed. Trigger one workflow at a time, each containing information about a single shop, with the target already set.Technical workflow:you save your dynamic info as JSON  to Advanced JS activityset to run daily at a time you would send an emailin next run script tab you can do something similar  var shops = [{shop:a,...},{shop:b,..}],    shopsThatAreClosed = shops.filter({// find your shop data});if (shopsThatAreClosed.length){//send signal to your marketing workflow to trigger it and save the variables as start parametersvar strLabel = "Adobe Campaign, Marketing that delivers"NLWS.xtkWorkflow.PostEvent(    "wkfExampleReceiver",    "signal",    "",    <variables strLine={JSON.stringify(shopsThatAreClosed )}/>,    false)}}reutrn 0;  Campaign workflow:add signal activityadd query -> this i suppose can be dynamically changed as well based on the shop location and recipient locationadd email -> save variables into the email and use them in personalization look here on how to do it https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/store-an-array-in-variable-pass-it-and-display-in-delivery/td-p/567881If you will have more shops sent to the campaign worklfow and you want to sent it a separate recipients in separate email you would need to run worklflow in loops until there is no more shop to iterate over.  Marcel SzimoniszMarTech Consultantfor more tips visit my bloghttps://www.martechnotes.com/

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded