The answers are already in your systems
Most businesses have the data to answer their important questions. It is in four systems, in different shapes, with the customer identified three different ways.
The work is less about clever analysis than about getting it into one place, reconciled, with agreed definitions. Once "active customer" means the same thing to sales and to finance, most of the questions answer themselves.