This tutorial will cover the duration in days filter for Contacts. This filter means an action will fire once every X number of days (you can customize any number of days for X.) For this tutorial, we will use 7. The actions in the Duration in Days Trigger will only be applied every 7 days for any contact that hits that day mark, or an exact multiple of it 7, 14, 21, 28 days ago, etc.)
You can do many things with the duration-in-days filter, customizing it for your business however you wish. Commonly itâs used to remove stale/old opportunities. For this use-case example, weâll show you how to remove stale opportunities older than 7 days. In this example, you have two leads, John and Sally. John's last activity was 9 days ago, and Sally's was 7 days ago. This trigger will not fire for John because his last action was 9 days ago (Even though it's more than 7, it's not exactly 7). It will fire for Sally because her last activity was exactly 7 days ago. The trigger will continue to fire every 7 days, so John will eventually be caught in one of the multiples of 7 (since heâs currently at 9 days, heâll get caught at the next multiple of 7 â 14 days.)
NOTE: The Stale Opportunities trigger will not fire retroactively but will fire on the multiple of the duration days. Part 2 below provides a solution for this.
Part 1: Create a Trigger for Filtering Opportunities based on Duration in Days
Step 1: Create a Trigger
- Navigate to Triggers > + Add Trigger
- For Part 1, the automation should be triggered by Stale Opportunities.
- Define the filters as shown in the screenshot below:
- In Pipeline - (Choose the Pipeline)
- Pipeline Stage - (Choose the Stage)
- Duration in Days - (Choose a duration; weâre using 7 for the example.)
- For Part 2, the action performed would be Remove Opportunity, and youâd select the specific Pipeline.
- You can add any additional actions you wish under + Add Action (such as adding/removing a tag, sending yourself a notification, etc.)
- Save and Activate the Trigger.
Part 2: A Workaround For Retroactive Application Since the system wonât retroactively apply the trigger, this will allow you to âclean upâ any old Contacts that are in the system and considered an old opportunity before the trigger in Part 1 was created.
Step 1: Create a Tag
- Navigate to Settings > Tags.
- Name this anything youâd like, such as âstale oppâ or âstale opportunityâ.
Step 2: Create a Trigger Using the Tag
- Navigate to Triggers > + Add Trigger
- For Part 1, the automation should be triggered by a Contact Tag.
- Define the filter as âTag Addedâ and choose the tag you created in Step 1.
- For Part 2, the action performed would be Remove Opportunity, and youâd select the specific Opportunity.
- Save and Activate the trigger for it to run.
Step 3: Create a Contact Filter
- Navigate to Contacts/Smart Lists
- Click âMore Filtersâ to add a filter.
- The first filter should be to filter the pipeline and pipeline stage, selecting from the dropdown.
- The second will be âlast activity more than 7 days agoâ.
- Once you have your contacts filtered out, you can select them and then click âadd tagâ from the bulk actions buttons at the top of the page. Assign the tag you created in Step 1. This will fire the trigger to remove all of these contacts from your pipeline stage.