type.inbound
and (
strings.ilike(sender.display_name, '*dotloop*')
or strings.ilike(sender.email.domain.domain, '*dotloop*')
)
and sender.email.domain.root_domain not in~ ('dotloop.com', 'showingtime.com')
and (
(
profile.by_sender().prevalence in ("new", "outlier")
and not profile.by_sender().solicited
)
or profile.by_sender().any_messages_malicious_or_spam
)
and not profile.by_sender().any_messages_benign
// 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
)
Playground
Test against your own EMLs or sample data.