Hi Krissy,
I have a few ideas, but perhaps not the full answer.
First, I should probably provide a disclaimer that Workfront Fusion isn't really designed to serve "reporting use cases". Certainly, as you noted, there are lots of possibilities for those types of things; but that wasn't the intended design principle around it and so, please beware of any such impacts (e.g. a single scenario can never execute for more than 40 minutes).
That said, if I were approaching this:
1. I would use the "Watch Proofs" module looking for overall decision changes. As you noted, the default is to look for overall proof decision changes going forward. But Fusion does offer a unique capability to "go back in time". You can right click on the first module and select "Choose Where to Start".
- One caveat here is that, given the available Proof APIs -- this will only return a single proof once based upon when the last overall proof decision was made. If a proof overall decision was set to Approved on 1 July and then changed to Pending on 15 July and then approved again on 30 July....it would only come up on the 30 July date. (whereas, moving forward....you'd see if come up 3 times).
2. I would use this "back in time" approach one time to create a single CSV file that represents a large chunk of the previous data by using a CSV aggregator, then emailing that to myself or downloading manually and then use that as the basis for my Excel file going forward. That helps me address the Excel API limiting for initial load.
3. For stuff moving forward, I would imagine the Excel API limiting could be managed by the natural flow. I'd probably set it up to check every 5 minutes and make sure I never include more than 10 proofs each time (or something like ).
Not sure if that is all of the secret sauce, but hopefully there is something useful in there. Cheers.
