If you set up Microsoft 365 usage analytics in Power BI, you can access a pre-built dashboard that provides a cross-product view of the last 12 months. If you want to overcome the 12-month limit then the best way is to periodically export the usage data to your data store or use any existing third party tool.
There are a number of third party auditing tools out there, though I can't speak to any of them specifically.
https://www.manageengine.com/microsoft-365-management-reporting/microsoft-365-auditing-tool.html