If the contact cleaner didnt take care of it, you will most likely need to replace the sensor. Especially if it doesnt work at all now, after the cleaning.
Like i mentioned in our last conversation, there is still a possibility the speedometer/odometer itself is at fault, but the sensor is MUCH more common to fail.
The only sure fire way to tell would require a special scan tool that the dealer has. I know you want to repair this yourself, so about all you can do is replace the sensor.
If you have further questions on this, please feel free to reply.
Its a bit pricey at $125 but most likely its the faulty culprit, however there is still a chance of the speedometer itself, but without a scan tool you wont be able to tell. The odometer and speedometer both work off the speed sensor.