Place it early in a scene as the cue that someone has arrived, before any dialogue or reaction shot. Follow it with a louder door knocking sound for a second, more urgent knock, then let a Dun Dun Dun sting answer the reveal of who is standing there.