type.inbound
and length(body.current_thread.text) < 1000
and regex.icontains(body.current_thread.text,
'(shared.{0,30}with you|View Document)'
)
and any(body.links, .href_url.domain.domain == "lookerstudio.google.com")
and (
profile.by_sender().prevalence in ("new", "outlier")
and not profile.by_sender().solicited
)
// 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.