I’m looking for a good filter set in a segment to pull in customers that are 5-6 months into a 1 year contract. I seem to have good current contract start date data and renewal date data. I can filter based on 1-year agreements. It’s the > = < and span logic that is challenging me at the moment around the start and renewal dates. I think I’m getting caught up on the ‘span of’ concept.
Solved
Best segment filters for targeting mid contract date of customers
Best answer by dayn.johnson
Curious what others may have done -- have you asked this in the GGA slack community yet?
We have a program that checks executive engagement x number of days prior to renewal (this screenshot is from when it was 180 days, we’ve now extended that time).
The query (or DD) runs daily, and checks for that number of days into the future, like so:
Our program is only internal, so I've been running it in dynamic JO to take advantage of the Action Execution schedule (so we don’t email our account team on the weekend, we can use multiple branches off of one evaluate step, and we can CC more than 3 people).
+6Curious what others may have done -- have you asked this in the GGA slack community yet?
We have a program that checks executive engagement x number of days prior to renewal (this screenshot is from when it was 180 days, we’ve now extended that time).
The query (or DD) runs daily, and checks for that number of days into the future, like so:
Our program is only internal, so I've been running it in dynamic JO to take advantage of the Action Execution schedule (so we don’t email our account team on the weekend, we can use multiple branches off of one evaluate step, and we can CC more than 3 people).
+6Absolutely! If you need it, here’s that invite link: https://join.slack.com/t/globalgainsightadmins/shared_invite/zt-2bm3a4q8h-Spjxc~pI4tpe5wMHTASgpA
Reply
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.