Thank you for all this great information. I have been having the same problem with my 04 mustang convertible, with about 3 inches of water in the back passenger floor.
I removed my back seat and lifted up the carpet as instructed. The water is coming in from the 2nd yellow arrow to the right...