Publishing & Media
Editorial Research

By · Published · Updated

Rejection tracking A writer's path to resilience and success

An editor's personal spreadsheet habit reveals how documenting every turned-down pitch becomes the most honest pitching classroom a writer can build.

Key Takeaways · Quick Answers
What is a rejection archive and how do I start one?
A rejection archive is a simple log often a spreadsheet of every pitch you send, the outlet it was sent to, the date, and the response received. It tracks rejections alongside acceptances. Start with basic columns: piece title, outlet, date sent, response type, and notes. Review it monthly to spot patterns.
What do editors actually look for in a pitch?
Editors consistently say that pitches fail when writers do not demonstrate knowledge of the publication. Lisa Haney, senior editor at Fitness, told Mediabistro that sending a pitch off-target 'shows that you're not prepared, that you really just don't know the magazine.' Tracking your rejections helps you identify when this is happening.
How common is rejection for professional writers?
According to Denise Cullen's research, pitch success rates range from about 1 percent for beginners to 50 percent for top-tier freelance writers even experienced writers with strong track records are rejected at least half the time. This is normal, not a sign of inadequacy.
Why does rejection hurt so much psychologically?
Psychological research cited by Denise Cullen shows that neurologically, the pain of rejection mimics the pain of physical injury. This response is evolutionary being cast out from a group once meant death. The brain still treats editorial rejection as a social threat, which is why rejection impairs cognitive function in the short term.
How can I use rejection tracking to improve my pitches?
Review your spreadsheet monthly to identify patterns: are certain types of outlets rejecting you more often? Are similar angles producing similar responses? Over time, the archive reveals which ideas fit which venues, helping you target smarter and reduce wasted submissions.

Freelance writers face an average of 17 rejections for every article pitched, a statistic that underscores the relentless challenge of building a writing career. While each “no” can feel deeply personal, data reveals rejection is not a sign of failing talent, but a common and often necessary step toward success. Understanding this pattern can be crucial for developing the resilience needed to navigate the freelance world and ultimately thrive. This article explores how writers can reframe rejection and use it as fuel for continued growth.

Denise Cullen, a writer based in Brisbane, Australia, has a name for that moment: "Rejection's a bitch, isn't it?" She writes on her site about the particular sting of pitching crafting what you believe are "killer story pitches" only to receive, in her words, "some variation of, 'Nup.'" The common alternative is worse: no response at all.

But somewhere in the same moment, something else is happening for writers who have built one particular habit. They are opening a spreadsheet.

The Spreadsheet That Tells the Truth

Jesse Sposato, a writer and editor who writes for Narratively Academy, described a small ritual that many experienced freelancers eventually develop. After receiving a rejection from a goal publication that left her feeling "a bit bummed," she did what she always does: she looked the piece up on what she calls her "story budget" spreadsheet.

"I had been so sure it was a good fit, and yet the form letter stated exactly the opposite," Sposato wrote. "Would it ever find a home, I wondered? Did I need to rework the entire thing? Could I even rework the entire thing? (I looked the piece up on my 'story budget' spreadsheet later and was reminded that this was only the second time I'd sent it out in this form, which actually made me laugh out loud. The drama!)"

That spreadsheet what Sposato calls a "story budget" is the most useful tool most freelance writers never talk about publicly. It is not a portfolio of wins. It is a ledger of attempts. Every query, every pitch, every cold submission, logged with the date sent, the outlet, the response (or lack of one), and the status. When a rejection stings, the spreadsheet does what reassurance often cannot: it provides context. The piece had only been sent twice. The drama, as Sposato noted with self-aware humor, was disproportionate.

Ben Sledge, writing for The Writing Cooperative on Medium, has spoken to editors from national publications including the Evening Standard, Independent, and New York Times about the most common mistakes they see in pitches. The pattern he found is instructive: editors rarely have time to offer extensive feedback, which means the writer who tracks their own rejections has a significant advantage. They are, in effect, building a private classroom where every "no" is a lesson.

The spreadsheet habit does something subtle but powerful. It shifts the writer's relationship with rejection from personal verdict to data point.

What the Numbers Actually Say

Before a writer can build their rejection archive, they need to understand what the baseline actually looks like. Denise Cullen's research into pitch success rates produced a range that surprises many newcomers to freelance journalism.

"When it comes to pitching editors, a straw poll suggests a success rate of anywhere from 1 per cent (beginner writers) to 50 per cent (top-tier freelance writers)," Cullen wrote. "In other words, even top-tier freelance writers those with long-standing relationships with editors and a proven track record of delivering high-quality work are still striking out at least half the time."

This is not a failure rate. It is a volume metric. A writer who sends ten pitches and gets one acceptance is operating within normal parameters. A writer who sends a hundred and gets thirty acceptances is thriving. The difference is not quality it is endurance and systems.

Jane Friedman, whose blog covers the book publishing industry, has documented an even starker attrition rate among authors who finish manuscripts. According to Friedman's findings, more than 80 per cent of published authors quit within three books. About 10 per cent make it to six. Only 5 per cent reach twelve.

"A lot of people burn out and go to do something that doesn't suck them so dry emotionally, over and over again," Friedman observes. She makes a point that writers who track their rejections instinctively understand: those who succeed are not necessarily the best writers. They are the ones who are left. They are the last men and women standing because, despite all the odds, they refused to throw the pillow across the room and quit.

Why Editors Say No (And What Your Archive Can Teach You)

Kristen Fischer, writing for Mediabistro, has spoken directly to editors at major publications about the real reasons pitches get rejected. The answers are consistent and often preventable.

This is where the rejection spreadsheet becomes a classroom. When a writer logs a rejection and later reviews their history, patterns emerge. Perhaps three rejections in a row came from health publications for pitches with a technology angle. Perhaps the outlets that showed interest shared a common editorial philosophy that the writer had not consciously identified. Perhaps most valuably the rejections were not saying "this idea is bad" but rather "this idea is in the wrong place."

Fischer's reporting on Mediabistro reveals a vocabulary of rejection that becomes legible only when tracked. "We don't cover those types of stories" is editor-speak for a misalignment that has nothing to do with the pitch's quality. "We're going to pass" often means the publication recently ran something similar. These are not verdicts they are market intelligence.

The Neurological Reality of a Form Rejection

To understand why the spreadsheet habit matters psychologically, it helps to understand what rejection actually does to a writer's brain. Cullen draws on psychological research to explain a phenomenon that most writers have felt but few can articulate.

The prehistoric parts of the brain still respond to editorial brush-offs and other forms of rejection as though they are a threat to survival. Research has found that recalling a recent rejection was enough to cause participants to score significantly lower on IQ tests, tests of short-term memory, and tests of decision-making. The very act of dwelling on a rejection impairs the cognitive tools a writer needs to craft a better pitch.

This is the hidden cost of untracked rejection. It does not just sting it actively diminishes the capacity to recover.

Parisa Saranj, a writer, Persian translator, and longtime editor at literary magazine Consequence Forum, offers a reframe that the spreadsheet makes tangible:

The spreadsheet literalizes this reframe. When a writer looks at their log and sees twenty-two rejections spread across six months, the story changes. They are not failing repeatedly. They are sending consistently. The rejection rate is high because the sending rate is high and high sending rates, the data suggests, correlate with eventual acceptance.

Building the Archive: What to Track and Why

A rejection archive need not be complex. At its core, it answers four questions: What did I send? Where did I send it? When? And what came back?

Sposato's "story budget" spreadsheet tracks pieces she has drafted and where they have been submitted. When she checks a piece's history and finds it has only been sent twice, the rejection becomes a prompt for action beyond a verdict on quality. The spreadsheet tells her the story is still in play.

Ben Sledge's reporting on what editors actually want from pitches suggests additional fields worth logging. Editors he spoke with at national publications identified common mistakes: pitches that were too long, ideas that had been covered recently, angles that did not match the outlet's voice. A writer who logs each rejection with a brief note about the response even "no feedback" is building a pattern library that will eventually illuminate which of these mistakes they are making.

The archive works best when it is reviewed regularly, not just consulted after a rejection. A monthly review of the spreadsheet reveals the health of a pitching practice more clearly than any individual rejection ever could. Are pitches being sent consistently? Are certain categories of outlets producing more responses than others? Is the ratio of responses to rejections improving over time?

The Crowdsourced Classroom: Learning From Others' Rejections

Individual tracking is powerful, but the sources suggest a broader pattern: rejection knowledge is increasingly being shared publicly, creating informal classrooms for writers who want to learn faster.

Cullen's writing on coping with rejection draws on community knowledge, aggregating the experiences of writers across the freelance spectrum. Sledge's Medium piece is explicitly crowdsourced, gathering feedback from multiple editors to identify common patterns. Mediabistro's editorial resources, including their premium tools for pitching, represent an institutional version of the same impulse: aggregating editor knowledge so writers can learn from collective experience more than personal failure alone.

The writer who tracks their own rejections while studying publicly shared rejection intelligence is working in two classrooms simultaneously. Their spreadsheet provides personal data; published accounts from editors and experienced writers provide context.

What This Means for SubmitArticle Readers

For readers working in article submission, syndication, and editorial workflows, the rejection archive is not a morale exercise it is a process tool. Editorial calendars fill with assigned work; cold pitches compete for remaining space. A writer who submits consistently and tracks responses systematically will develop an intuition about which ideas fit which venues, which timing matters, and which angles editors at specific publications respond to.

The spreadsheet does not eliminate rejection. It makes rejection productive. Every "no" logged is a data point. Enough data points form a pattern. The pattern is a classroom. And the classroom is always open.

Where to Read Further

The sources behind this article offer deeper dives into specific aspects of rejection and pitching. Writers looking to build their own rejection archives may find these starting points useful:

The rejection archive is not a cure for the sting of "no." That sting, as the research suggests, is neurological and primal and will never fully dissolve. But it is a way to make every "no" worth something a way to turn the inevitable rejections into a curriculum that compounds over time. Writers who build the habit early and stick with it are, by the numbers, building the only edge that actually matters in this business: they are still in the game.

Sources reviewed

Atlas Research Network