To reach level 5 -- National Support Act -- you must score 2,500,000 rsp (Rocksmith Points).
To reach level 6 -- National Headliner -- you must score 3,500,000 rsp (Rocksmith Points).
You can track your progress by watching the bar at the top-right of the screen (under your gamertag).