the top programs, if you are an average candidate.
the good programs, if you are an okay candidate.
the average programs, if you are a below average candidate.
It's just part of the picture, and CAN help you to the next level in terms of getting an interview. After that, it probably doesn't contribute too much.