Thanks, Diane! I'm going to try and set up a similar solution
Data Set Up
- I set up a smart campaign based on the trigger of the existing datetime field value changing (happens at the time of application)
- I created a separate custom field called Application Time that will stamp the system time into the field the moment the datetime field for the application updates
- I created a smart campaign that will append time zone information at the time of application into a custom field based on the State value
- Example: If State= Oregon, Washington, California, Nevada | Then: Change Data Value for Time Zone field to "Pacific"
Campaign Set Up
- I created a smart campaign that will take the eligible population for our sms/voicemail test, and split them into six separate timezone lists (three time zones split into business hours vs non-business hours) similar to how you defined your campaign above
The ultimate goal (when we have resources and budget) is to execute on something closer to what Sanford/Justin/Mark suggested to reduce the fragile/complex setup of these campaigns.
THANK YOU, EVERYONE, FOR THE HELP AND SUGGESTIONS! The Marketo Community is AWESOME!