A drained battery is not usually the fault of the battery. It is from either A) bad alternator not putting out enough amperage or B) too much use (accidental or intentional) of electrical items with the engine off.
I will tell you this. Whether you get another red top or a yellow top (I have yellow top now, but had red tops in my previous car) make sure the alternator is ok too.