Skip to main content
Solved

Review Request Flow Filters

  • November 12, 2024
  • 2 replies
  • 14 views

Forum|alt.badge.img+4

Hello, i’m trying to create a Review Request Flow and used Klaviyo’s suggested setup.

However, i’m confused about the filters?

  • Submitted reviewzero timesin the last90dayswherereview_ratingequals1
  • and
  • Submitted reviewzero timesin the last90dayswherereview_ratingequals2
  • and
  • Submitted reviewzero timessince starting this flow

This means they should not have submitted any review since starting the flow AND they have not submitted reviews where rating is 1 AND 2 in the last 90 days. Should it not be an OR instead of AND for the rating?

Best answer by Bobby

Hi @Jen_YEB,

The flow filters as you listed them are correct.

If the filters instead were:

 

“Submitted review zero times in the last 90 days where review_rating equals 1
OR Submitted review zero times in the last 90 days where review_ratingequals 2”

 

Then that means the profile would only need to meet one of those conditions to pass this block of criteria, which would not be desirable here. If someone submitted a review rating of “1”, but not of “2”, they would pass the above criteria since they “Submitted review zero times in the last 90 days where review_rating equals 2”.

The AND/OR statements can be tricky! I typically find saying them out loud can be helpful. And generally, “OR” is to be inclusive and “AND” is to be exclusive.


Cheers,
Bobby

View original
Did this topic or the replies in the thread help you find an answer to your question?

2 replies

Bobby
Partner - Silver
Forum|alt.badge.img+22
  • Champion & Partner
  • 58 replies
  • Answer
  • November 12, 2024

Hi @Jen_YEB,

The flow filters as you listed them are correct.

If the filters instead were:

 

“Submitted review zero times in the last 90 days where review_rating equals 1
OR Submitted review zero times in the last 90 days where review_ratingequals 2”

 

Then that means the profile would only need to meet one of those conditions to pass this block of criteria, which would not be desirable here. If someone submitted a review rating of “1”, but not of “2”, they would pass the above criteria since they “Submitted review zero times in the last 90 days where review_rating equals 2”.

The AND/OR statements can be tricky! I typically find saying them out loud can be helpful. And generally, “OR” is to be inclusive and “AND” is to be exclusive.


Cheers,
Bobby


Forum|alt.badge.img+4
  • Author
  • Contributor I
  • 2 replies
  • November 12, 2024
Bobby wrote:

Hi @Jen_YEB,

The flow filters as you listed them are correct.

If the filters instead were:

 

“Submitted review zero times in the last 90 days where review_rating equals 1
OR Submitted review zero times in the last 90 days where review_ratingequals 2”

 

Then that means the profile would only need to meet one of those conditions to pass this block of criteria, which would not be desirable here. If someone submitted a review rating of “1”, but not of “2”, they would pass the above criteria since they “Submitted review zero times in the last 90 days where review_rating equals 2”.

The AND/OR statements can be tricky! I typically find saying them out loud can be helpful. And generally, “OR” is to be inclusive and “AND” is to be exclusive.


Cheers,
Bobby

Thank you!