you can put the "current best rated battery" into your car, but that will also likely die, after a week or more.
You either have some sort of parasitic drain going on which needs to be addressed first or the battery itself is bad.
start by testing the battery.