I think it comes down to query time and size in terms of cost. So, it’s worth testing different fact tables that are optimised for the way you run experiments.
But yeah multiple tables should save you some money as you are only querying what you need instead of just the entire dataset.