You go to single player: Custom Campaign (Part of the frozen throne), there you'll find both another campaign made by blizzard and those you have downloaded from Hive (Assuming you placed them in the correct folder, which would be the location of your game.exe file - find the folder named campaigns -> place the downloaded campaign there).