I'd like to know the percentage of questions that are deleted by Stack Exchange's automated deletion scripts, which later get undeleted, on each site.
Initially, I thought I could query for this in the Data Explorer, but it turns out that questions that have been deleted by the Roomba which get undeleted later, will be immediately re-deleted (once the script runs) if the criteria still apply to them. As the Data Explorer excludes deleted questions, it would be nice if someone on the inside could query the database for this.
Ideally, I'd like the results to be in a row for each site, including meta sites. Each column should include:
- the percentage, out of all questions that were deleted by the Roomba scripts (preferably including those deleted before those deletions were attributed to Community), of questions that were undeleted at least once after being deleted by the Roomba (including ones that were deleted again)
- said percentage broken down by each respective Roomba criterion (e.g. out of all questions deleted by
RemoveAbandonedQuestions
, the percentage of such questions which were undeleted later, and repeat for all criteria) - for each of the above, the percentage of those questions which were later re-deleted again, preferably broken down into two statistics: those deleted by the same script, and those deleted for a different reason (a different Roomba script, humans voting to delete, owner's account being deleted, etc.)
Based on what I've read in many posts on meta, I'm expecting the first percentage above to be rather small. However, I'd like to concretely know how small it is, or whether or not it's bigger than what's expected.