Put it right after the joke or fail in your edit, once the setup is complete and the viewer is waiting for a payoff. For a bigger flop, follow it with the SpongeBob Fail sound, and for a sudden reveal, place the Vine Boom sound just before it so the punchline still gets the final word.