Can’t help on the Dogs attribute, but for the late queries, there is a trick you can do.
Understand that at Midnight Pacific Time, all the queries due for the specific day get queued up in order of when the they were last generated (the ones generated most recently are at the back of the line). If someone requests a new or existing query during the day, it will “jump the line” as if the place where it would have gone had it been requested at Midnight. This means that a NEW query will be processed immediately. So the trick is to always be requesting a new query or at least one that hasn’t been run in a while if you want it right away. So, when you want the information, rather than waiting for your scheduled query to run, just create a new query for “today”, then delete it as soon as it runs. You can still keep the scheduled queries for regular updates, but if you want something right away, you have to create it right before you need it.
My technique is slightly different. I usually don’t care when I get my PQs, but for those times when I do, I keep a second backup copy that is rarely run. When I need one quickly, I just activate the backup and it comes right away.
.
