It would be great if there was an "easy" way to perform an audit on props, evars & events to see if there are any which haven't had data rolled into them in recent history so they can be repurposed. For clients where they're only using a limited # of props/evars/events - this can somewhat easily be done via DataWarehouse. But for clients where they're using (for example) 50 or 60+ props/evars/events, this would be arduous (to put it mildly) using DW.
It would be great if there were a tool with a use case as such:
- Enter the Props section of the Admin Panel for a given report suite where you'd like/need to repurpose Props
- Click a button which says "Audit" or something of the sort
- A text box appears that says "Audit all props for the past:" (or something of the sort) with a drop down list offering a few options, such as "6 months" or "1 year"
- Have a DB in place on the back end so the time necessary to scrub for the "empty" props doesn't take as long as it would if you simply ran a DW report for all props for the past 6 months or 1 year
- Have report emailed out
I'd love to hear your thoughts around this...as functionality like this would be GREATLY appreciated!
Cheers