It needs to be somewhere in the middle. If it is to dry or to wet it won't compact.

Unless you are in a long drought the clay should have enough moisture in it already to compact properly. Last year I had clay dug out of one pond to build the dam of another. Even though I hadn't had much rain the previous two months the clay still had plenty of moisture.