@Zoe371 The CS reps are basically useless. They repeat things like robots and seem incapable of giving simple explanations. I know I can find much better advice and explanations from other hosts here than from any CS rep.
Yes, it is automatically calculated, but Airbnb is full of tech glitches, and I know there have been hosts who met all the criteria before and still lost Superhost status. And Airbnb can take a look at possible glitches and correct them, but the lowly telephone answerers can't, and so just repeat the same unhelpful thing over and over.
Try not to get too invested in the idea of Superhost- it really doesn't have much to do with how hard you work to be a good host, because while you have control over the other criteria like response rate, not cancelling, and trying to get at least 10 bookings a year, (or 100 ddays over at least 3 bookings), hosts have little control over whatever star ratings a guest decides to leave and unless you get hundreds of bookings a year, one 4* overall rating can tank your rating. And plenty of guests leave 4* ratings, when there was nothing wrong with their stay at all.