I'm glad it worked out Tony.
I suppose an alternative, if there is room for it, might have been to countersink, and glass in, a small skin fitting flush with the bottom of the trough. Then to put another similar skin fitting slightly lower down in the transom with some reinforced hose connecting between the two fittings in much the same way that cockpit drains were fitted years ago.