The 8-5227079-1: This plug is designed for RG-59, 59A, 59B, 62, 62A, and 62B cable groups — the common 75 Ohm video coax types that also work well in 50 Ohm systems at these frequencies.
The 0.2 dB insertion loss at the connector interface is typical for a BNC at these frequencies; the loss budget in your cable run should account for it.
