Data Metrics of Maintenance

Hi Judith-


You seem to have two question there. One is about tracking contactable constituents and another about data maintenance. I've posted a screenshot of my data maintenance dashboards below. I'm not sure which past information you mean (you can get some historical data with start and end dates of certain values), but in general once you've fixed something there's no record it was previously broken so I think you'd want to track your own changes somewhere else. I have an Excel spreadsheet called Change Log on my desktop that I update every time I make global changes, delete records, fix records, etc...Six months from now I may run up against something weird in the database that I can't recall anything about and I use my change log to see if, when and why I might have changed something.


Below are my maintenance dashboards:




 

Judith, we track/measure many of the things mentioned by Aaron including a number of others such as 'Complete Record' (what we define as a good quality record). we also use a rolling 2 year rolling window (based on date the record was last updated).  All of these statics/counts are generated once/evening via a custom SQL script which updates a separate database which feeds our PowerBI reporting.  We found this method easier than trying to develop and review (daily) numerous RE dashboards.

Margaret, it's an SQL database - also use it as a mini data warehouse and other misc uses.