How to build a data retention schedule (without inventing the periods yourself)

A retention schedule only works if the periods are correct for your data. How to structure one, and what a tool can and can't decide for you.