Basically from just having done quite a lot of research into it, and having TeslaMate working on the car since I got it. The car will recharge the 12v battery in hour blocks. In my case it tends to be 2 hours, but I’ve seen three and very occasionally 1.
When it was waking up every 24 hours for 2 hours each time I opened a service request because I was concerned. It used to do it every few days, and then every 48 hours, which then became every 24 hours, which suggested to me that the 12v battery was degrading. Tesla confirmed to me on the phone (with timestamps) that the periods that it was spontaneously waking up and staying awake for 2 hours was “supporting the 12v system”. They told me not to worry about it, that it takes care of itself, and that the car would tell me when the battery needed to be replaced.
I should add that I barely drive my car, maybe once every 2 weeks, sometimes once a month, depending on what’s going on, so I see this behaviour more acutely and predictably than someone who drives the car often (if I do that it throws the pattern out for a day or so, because the 12v is always being maintained when the car is awake, and I have Sentry on everywhere except home)