How many creative variations do you test before giving up?

I've bled through at least 20 variations of a single ad before deciding to let it die. Each time, i thought it could be the one but sometimes you just hit a wall. It's a brutal reality check when your passion isn't matched by results.

How do you know when to keep pushing or when to move on?