I'll often see people post screenshots of Dune dashboards as if they reflect "current state," but the query has an ! because it failed at some point in the past.
In this specific example (https://twitter.com/0xperp/status/1669480788511817730?s=20), i was able to click in to the query and see that it hadn't run for 2 months, but your average Twitter user can't/won't.
An idea is to "somehow" in a non-intrusive way add some indication of when the query last ran to the visual (maybe give the option to turn it off if it becomes intrusive).