Place it at the end of your build-up, right before the reveal or entrance it is announcing. Follow it with the And His Name Is John Cena sound for a bigger entrance, or end the sequence there when you want a single short tease before the main clip.