We're doing some research to see what others are doing in this area.
Any additional context is welcome as well. Thank you.
We see a lot of our customers use Content Filters and regular expressions (Regex) to automate handling of sensitive information while it's being posted. You can set the content filter to decline the post if it's being posted, which includes a line of feedback to the user on what they would need to remove from their post (our version of the automated prompt).
Here are some examples you can use on your community: https://community.khoros.com/t5/Community-Moderation/Examples-of-regular-expressions-for-content-fil...
I can't comment on any external tools our customers may be using to scan existing content, but would love to get feedback from everyone that we can share with our Khoros Community product team!