We had a need to send an email to certain accounts at the end of the quarter but currently Journey Orchestrator only allows for at most a monthly sync for a query.
Within the filter, you can allow participants to be added to the Program once every 90 days but that wouldn't prevent a new contact on the account from getting an email mid-quarter.
To solve this, we could have just run a new Program every end of quarter but instead I build one Program to run continuously using a query and included a couple transformation tasks to find the Last Day of the Quarter based off an Opportunity record's Close Date.
Then another transformation task to filter only if the Last Day of the Quarter equals Rule Date. Thus, the Program syncs on the last day of the month but only on the last day of the quarter are Participants added into the Program.
Page 1 / 1
Super cool. Thanks for sharing!
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.