Jeff Bezos said, "If you double the number of experiments you do per year, you're going to double your inventiveness." He's also quoted as saying he doesn't think consistency of thought is a particularly positive trait. It's healthy to have an idea today that contradicts the idea you had yesterday.
The smartest people constant revise their understanding and reconsider problems they thought they’d already solved. They're open to new points of view, new information, new ideas, contradictions, and challenges to their own way of thinking.You have to accept that most buttons you push won't make anything happen. Acknowledge that you're going to feel foolish and discouraged after several duds in a row - but still keep looking for another button to push.
So far, I've paid for a Bookbub ad (successful). I've got out my half-finished screenplay of Replica, finished it, and emailed it to a professional screen writer who was rash enough to volunteer to look at it. I've decided to leave KDP Select (again) and really try to make it work on the other platforms this time. And I'm trying to think up an idea for a series...