Since your data are in various format, you need a script or programming language to do that. Somewhat slow, Excel VBA is a good choice. If you do heavy lifting, then python is the best. These two options need some programming/scripting knowledge. Stackoverflow is a good source of programming knowledge.
I’m a fan of PKMs, Logseq is in beta with their db version Knowing how to ask one of the chatbots for pro’s and con’s, with your goals in mind and your starting point would yield good results
Obsidian Similar to Logseq but personally found it more polished and useful for my workflow. No experience with coding necessary. You can categorize and tag your day types with screenshots, stats, etc. and callback tag combinations depending how you setup the db.