Extremely unpopular on return to power and decision to process down the Nile may have been to remove her from Alexandrian hostility while also promoting herself as queen to rest of Egypt
Even after heavy debts of Ptolemy XII reign and poor harvest Cleo was efficient with rule, extending territory and even if it only gained roman support she would have gained popularity