I like to reverse associate things via SAINT. Perhaps this idea could help you.
I assume today you are capturing Campaign IDS or Campaign names as a Dimesion/evar
Using SAINT you could create a sub breakdown where you can associate Each Campaign ID by:
Brand, NonBrand, Other...Now in all reports and even in segments you can then leverage this sub association.
The cool thing is now this can be uploaded once. Then always present. Just add to it as needed for new camapigns and the really cool part in future if an error or a change you could update it to reflect new changes. These would even be retro active.
GLTU