Is there something specifically in reports that wouldn't get you what you needed? Do you really need per-user engagement data and have a plan for it? This is not easy to do and definitely not recommended for your first foray into queries. Nevertheless, if it must be done, these are the extensions you'd need in addition to your MasterSubscribers:
You'd need to JOIN these data extensions together on common values.
How many emails did you send with this content? If it's just one you'll need to find the JOB ID - it's the key that will relate to your other tables that you're looking to join. If it's not, you'll need to add another step: you'll have to pull all jobs that correlate to a specific email id. PS: your file name is not the email id. With that you'll have to build a new data extension that contains a list of all the JOB IDs that correlate to your email ID.
Then, you'll need to start writing queries that join this data together where each row matches to a correlating Job ID in your lookup data extension.
If you've never written a JOIN before, think of it like a venn diagram: https://blog.codinghorror.com/a-visual-explanation-of-sql-joins/
I didn't write out the SQL for you because I don't currently have any reports that do exactly what you're looking to do (and it takes time which is what you'll have to invest).