I added to my post.
I would disconnect speedo cable, at transmission end, clean fluid out of the mechanical drive, then drive it a bit to see how much fluid is leaking and when.
You could also put a reversible drill on the speedo cable and run it at low speed(same as driving in Reverse) to draw out any trans fluid still in the cable.
As for the check, stop after a few minutes of driving and check it, if it isn't leaking cold then drive it for 1/2 to 1 hour to heat up trans fluid and check it again, if that's when it leaks then trans is over filled or vent is plugged.
If it leaks cold then seal in Drive gear / VSS is bad.
New no longer means "it works"
New now means "never been tested", although I would tend to trust Ford parts, as far as I know they still have Quality Control on parts, but that doesn't mean they check every part.