Open redirect: retailrocket.net

type.inbound
and length(filter(body.links,
                  .href_url.domain.root_domain == "retailrocket.net"
           )
) < 10
and any(body.links,
        .href_url.domain.domain == "clickproxy.retailrocket.net"
        and strings.icontains(.href_url.query_params, 'url=')
        and not regex.icontains(.href_url.query_params,
                                'url=(?:https?(?:%3a|:))?(?:%2f|\/){2}[^&]*retailrocket\.net(?:\&|\/|$)'
        )
)
and not sender.email.domain.root_domain == "retailrocket.net"
// negate highly trusted sender domains unless they fail DMARC authentication
and (
  (
    sender.email.domain.root_domain in $high_trust_sender_root_domains
    and not headers.auth_summary.dmarc.pass
  )
  or sender.email.domain.root_domain not in $high_trust_sender_root_domains
)