As a follow up and as I promised in a previous post here are both reports which makes it possible to track advertisement status per collection and to link it to the next report, All system resources in a specific collection for a specific advertisement in a specific state. These both reports makes it possible to track advertisement status for a specific advertisment and collection, which is very useful when installing/upgrading applications and reporting needs to be done per site, building or department.
Import both reports which can be found here, and link them like this.
I hope these two reports are useful in your environments out there. Thanks again Ola for you help!