I had a leak on the drivers side rear and the water turned out to be leaking from inside the door.

You can test this out by pooring water right at the window sill next to the door. Some water will naturally drip inside the door, but in mine it was then running inside the car. I just sealed up the holes for the clips with the same stuff used on the vapor barrier and it worked perfect!