SOLVED

In Future / In Future After Filters on Multiple Custom Objects

Go to solution
manjuladevipal
Level 1

In Future / In Future After Filters on Multiple Custom Objects

Hello all,

 

we have a problem and I wonder if anyone had a creative solution for it.

We have a Custom Object created for sending our Expiration Emails based on the Product End date purchased.

One custom object created as a Service agreement -  linked to Lead ID in the Marketo database and has a relationship like below

1 product vs. 1 lead

multiple product vs. 1 lead

 

We need to build a Smart List that finds all customers whose contracts expire in exactly 90 days. 

In Future after X-1-> so we add 89 days 

In Future X days -> so we add as 90 days

 

manjuladevipal_1-1694508828670.png

 

But the results are not expected, because of the multiple Contract on the same person. It qualifies the contact even with the Empty END date. Not exactly ending in 90 days is not qualified here. 

 

 

If someone can suggest any solutions for this, it would be a great help.

 

Manjuladevi P
2 ACCEPTED SOLUTIONS

Accepted Solutions
Darshil_Shah1
Level 10 - Community Advisor

Re: In Future / In Future After Filters on Multiple Custom Objects

Yeah, this is the expected behavior as each filter you have in the smart list is filtering the custom objects associated to the person’s record individually. An obvious solution to remedy/walk around this and people getting qualified even if they have expiration date field empty is to have a duplicate field with exact same date on each of the CO record and use both the fields as constraints with different operators (in future and in future after) in the same Has Custom Object filter.

View solution in original post

Jo_Pitts1
Level 10 - Community Advisor

Re: In Future / In Future After Filters on Multiple Custom Objects

@manjuladevipal@Darshil_Shah1 is correct.  

To explain in a bit more depth; If a person has two service contracts (let's call them A and B), A could meet one constraint, and B could meet the other constraint.  If that occurred, then the person has qualified.

 

You've bumped into one of the frustrations of Marketo; namely that you can't use the same constraint twice in a single filter.

 

The solution (to @Darshil_Shah1's point) is to have the same field twice in your CO, and ensure it always has the same value in both fields.  That way you can add both constraints to a single flow step, meaning they will be evaluated for the same CO.  

 

Don't forget, when you are building your emails, you'll need to loop through the COs to find which one(s) qualified for the email.

 

Regards

Jo

 

View solution in original post

5 REPLIES 5
Darshil_Shah1
Level 10 - Community Advisor

Re: In Future / In Future After Filters on Multiple Custom Objects

Yeah, this is the expected behavior as each filter you have in the smart list is filtering the custom objects associated to the person’s record individually. An obvious solution to remedy/walk around this and people getting qualified even if they have expiration date field empty is to have a duplicate field with exact same date on each of the CO record and use both the fields as constraints with different operators (in future and in future after) in the same Has Custom Object filter.

Jo_Pitts1
Level 10 - Community Advisor

Re: In Future / In Future After Filters on Multiple Custom Objects

@manjuladevipal@Darshil_Shah1 is correct.  

To explain in a bit more depth; If a person has two service contracts (let's call them A and B), A could meet one constraint, and B could meet the other constraint.  If that occurred, then the person has qualified.

 

You've bumped into one of the frustrations of Marketo; namely that you can't use the same constraint twice in a single filter.

 

The solution (to @Darshil_Shah1's point) is to have the same field twice in your CO, and ensure it always has the same value in both fields.  That way you can add both constraints to a single flow step, meaning they will be evaluated for the same CO.  

 

Don't forget, when you are building your emails, you'll need to loop through the COs to find which one(s) qualified for the email.

 

Regards

Jo

 

manjuladevipal
Level 1

Re: In Future / In Future After Filters on Multiple Custom Objects

Hai  

 

Thanks for the in-depth explanation. We understood the logic here.

 

Now the function works fine.

 

 

Manjuladevi P
manjuladevipal
Level 1

Re: In Future / In Future After Filters on Multiple Custom Objects

Hai  

 

Thanks for the timely help!!!

we tried duplicating the same Service End date field, results are pretty much the expected ones. 

 

filters as follows 

manjuladevipal_0-1694586766168.png

 

 

thanks a lot !

 

Manjuladevi P
Darshil_Shah1
Level 10 - Community Advisor

Re: In Future / In Future After Filters on Multiple Custom Objects

Perfect! You're very welcome, @manjuladevipal!  Glad to be of help. 🙂