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 not (
sender.email.domain.root_domain in $high_trust_sender_root_domains
and coalesce(headers.auth_summary.dmarc.pass, false)
)
Playground
Test against your own EMLs or sample data.