Our marketing team has requested that I create a field on the Account that will show True if the account has had a case logged within the past 30 days. They will be using this for some marketing e-mail automation. I can think of several approaches to this but I'm not sure what would be best. Could you make some recommendations?
For example, create a checkbox that is read-only to most users. Set it to default to N (un-checked). Create a process builder so that when a case is created, it changes the field to Y. Create a time-based workflow rule to un-check the box after 30 days.