The day of week that you check in & how many nights you stay can affect which room you get. If you check in on Sunday or Monday and only stay for 1 or 2 nights, you are competing with the other elites that are staying for the entire week.
The best upgrades I usually get are when I stay for one night on a Thursday -- most of the business travellers are leaving, and the vacation travellers haven't arrived.