It only seems to work for the mission itself sadly. It doesn't carry over with the campaign progression. As a result, don't bother with it while doing Campaign. However, in Skirmishes it does level up your units which attributes to more health, more DPS, etc. and is useful. Plus your army gives you little 'Hurrays!' when a commander or certain unit levels up.