When to give up?

I'm curious to know your take on this. When do you stop pushing a product idea? How do you decide that it's time to pivot or kill this product? What metrics or rule-of-thumbs do you use?