Place it as the climax of a goal edit, right after the shot goes in and before the replay. Follow it with a big cheer to keep the celebration going, and save a contrasting miss sound for the opponent's failed chance earlier in the clip.