I consider a project dead once I feel that's "better" (whatever it means in the specific context) to invest my time in something else. Or if I feel that I'm not able to scale/grow it more than it is.