Skip to main content
Contributor II
November 12, 2024
Solved

Review Request Flow Filters

  • November 12, 2024
  • 2 replies
  • 153 views

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?

    This topic has been closed for replies.
    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

    2 replies

    Bobby
    Partner - Silver
    BobbyAnswer
    Champion & Partner
    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

    Freelance Klaviyo Marketer | Klaviyo Partner & Community Champion | check out my services: bobbyleonard.me
    Jen_YEBAuthor
    Contributor II
    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

    Thank you!