This might be a bit tricky if you want to go full scientific on how to measure this. What has been said in this thread already, you would need some kind of coil to produce a magnetic field filed which would excite the pickup being tested.
For the measurement to be accurate, the generator coil must not interfere with the measurement. That being said it would need to produce a magnetic filed with a constant amplitude at all (relevant) frequencies. For a coil to be able to do that, it would need to be connected to a constant current source that produces a sweep signal. Which means that connecting directly to the output of a normal signal source will make the measurement inaccurate (since it's not a constant current source).
Technically a circuit between the signal generator and test coil is needed. I've done some tests at uni about 10 years ago (simple amplifier with a resistor in series to make a "current source"), and the results were meh - not good, not terrible. Sometime later I played around with some simulations, and it would seem that playing around with the placement of the test coil inside a high current opamp might make the current constant at all frequencies. But I forgot the details and never managed to test the circuit in reality
One other important thing to note here - in this kind of measurement you only measure the characteristic of the pickup coil,
not the magnets. So while it is definitely useful to for measuring the frequency response of the pickup coil, it doesn't take into account the influence of the magnet (pole pieces, their position, other metal parts, etc.)
Anyways, I hope this info might be helpful.