Your CRM Is a Haunted Spreadsheet

Open the file. Eleven hundred names. Each name a row, each row eleven tidy columns, each column a small fact that was true on the Wednesday somebody keyed it in.

It is, in any honest reading, a small unmarked cemetery you are paying twenty-eight hundred dollars a month to maintain.

The donor on row 412 — last gift, two hundred and fifty dollars, March 2018; last contact, voicemail re: spring appeal; salutation, Mrs.; spouse field, blank — is a woman whose husband died in February of 2018. The two hundred and fifty dollars she sent in March was a check written at the dining-room table, two weeks after the funeral, because the hospital had been one of three places that handled the last year of his life with anything like grace. The blank spouse field is the whole reason for the gift. The fact the database doesn't know is the only fact about her that matters.

She has not given since. The file records this, neatly, as eight years of unreturned voicemails and unopened newsletters. The world records it differently. The world records a woman at seventy-six who would write you a much larger check tomorrow if you mentioned, by name, the resident who sat with her husband on the second floor of the building in 2017.

She is not lapsed. She is haunting.

What the database forgot

Your CRM was sold to you, in 2016, as a database. It is not a database. It is the graveyard of a small succession of people who used to know things.

The staffer who knew Mrs. Harlow on row 412 was Diane. Diane started in 2013, sat next to the kitchen of the development office for seven years, and could tell you — without opening the file — that Harold had been an internist, that Mrs. Harlow's father had endowed a fellowship in pulmonary medicine in 1986 in the name of a brother who'd died young of polio, that the family kept a small horse farm in Berks County, and that Mrs. Harlow preferred, mildly but firmly, to be called Mrs. Harlow and not by her first name. Diane left in March of 2020 to care for her own mother. None of this is in the file.

The file has capacity rating, 3. It has last gift, $250. It has segment, lapsed. It has, in a free-text notes field that nobody can search across, the seventeen-word fragment Harold passed — sympathy card sent — see Diane re: details.

See Diane re: details.

There is no Diane. There has not been a Diane since 2020. There is a Theo, hired in March of this year, who is reading row 412 for the first time on a Tuesday in June, and who has, by polite institutional consensus, inherited an empty cemetery and a printed list of lapsed donors to reactivate.

The donor isn't lapsed. The institution is amnesiac. Those are very different conditions, and only the second one is curable.

The math nobody wants to do

Here is the small unflattering arithmetic of a thirty-person development office.

The median tenure of a major-gifts officer in this country is something like three years. A portfolio of two hundred names will, in any given decade, pass through three or four pairs of hands. Each handoff loses, by any honest accounting, perhaps eighty percent of the contextual memory the previous officer had carried. The dollar history transfers. The name spelling transfers. The thing Diane could have told you in the kitchen, between the coffee machine and the small fern, does not.

By year ten, your file contains roughly one and a half percent of what your institution actually knew about each donor in 2013. The other ninety-eight and a half percent walked out the side door, kindly, on Diane's last day, with a card and a small grocery-store cake.

We pay six figures a year for a CRM that stores the wrong fact about each donor. We budget nothing — zero dollars, zero hours — to capture what every Diane on the team knows about each donor that the CRM has no field for. Then we are mildly surprised when the file stops resembling the relationship.

The exit interview that should have happened

When Diane left in March 2020, she got a card, a cake, and a Zoom toast. She did not get a microphone, a list of her two hundred names, and three uninterrupted afternoons to talk her successor through every one.

She should have. That conversation — Diane in a folding chair with a cup of bad coffee, going down the column one name at a time, saying Harold was an internist, the brother died of polio, the farm is in Berks County, the granddaughter is at Drexel for architecture, do not lead with the fall appeal — would have cost the institution two days of her billable time. It would have produced the single most valuable internal document the development office had ever owned.

We didn't ask. The CRM was right there, after all. The CRM was on the cloud. The CRM had columns.

The CRM had fields. It did not have what Diane had, which was the shape of the relationship.

Saying the donor's name out loud

The first job of a new development director is not the gala. It is not the case statement. It is not the year-end appeal.

The first job is to walk into the file with a flashlight.

Theo's predecessor left an inbox of unread spreadsheets and a small blue Post-it on the monitor that said the names in column C are the ones who matter. Column C has forty-one names. Theo, in his first ninety days, has had coffee with eleven of them. The other thirty are file rows. He cannot, in any honest sense, see them.

He has to bring each row back to a kind of breathing again. Not by buying another wealth-screen subscription. Not by sending a survey nobody will return. By doing the slow, embarrassing, faintly humbling work of finding out who is on row 412 again, and writing the answer down somewhere the next Theo will be able to find it.

What he needs — and what he does not have on a Tuesday at 9:14 a.m. with eleven other tabs open — is the public-record portrait the file lost when Diane left. Harold's obituary, with the names of the residents who took shifts in 2017 listed at the bottom. The 1986 fellowship at the medical school, with the brother's name on the bronze plaque outside the third-floor library. The board of the small county horse society, where Mrs. Harlow has served, without incident, since 1997. The Drexel architecture school, where the granddaughter's thesis was reviewed last May. Each fact with a source. Each source clickable. Each item something the institution used to know and can know again, in twenty minutes instead of the seven years it took Diane.

(This, more or less, is what we are building Rōmy to do. We will not pretend otherwise. The reason we keep writing about Diane is that the product is, in some real sense, a small kind apology for what we did to her file when she left.)

A note about Mrs. Harlow

Here is what happens if Theo does the work.

In late July, on a Thursday morning, he writes a letter that is three paragraphs long and arrives at a small farm in Berks County in a plain cream envelope. The letter mentions the resident from 2017 by name — Dr. Adekunle, now an attending in Cleveland. It mentions the fellowship at the medical school, and the brother it was named for. It says, in one careful line, that the hospital does not, in any of its records, have Harold's name written down anywhere, and that he would like, if it would be welcome, to do something about that.

Mrs. Harlow reads the letter at the kitchen table on a Saturday. She reads it twice. She folds it and sets it on top of the pile next to the toaster. She does not call. She does not write back. She does not, in any way the CRM would register, engage.

In October, she sends a check for forty-three thousand dollars and a short handwritten note that asks if the development director would mind, sometime in the spring, driving out to the farm for lunch.

Your CRM will record this gift, neatly, as a reactivation. It is not a reactivation. It is the only natural response to having been recognized. It is the gift she has been carrying around in her cardigan pocket since 2018, waiting for the institution on the other end of the file to remember her well enough to deserve it.

The kind of file you can be proud of

You inherited a haunted spreadsheet. That is not your fault. The way the sector built its CRMs in the 2010s assumed institutional memory was a renewable resource. It is not. It is a woman named Diane who left in March of 2020 with a card, a cake, and a small bouquet of grocery-store flowers.

The good news, and there is good news, is that most of what Diane knew is still in the world. It is in the obituary archive of a county paper. It is in the parents' committee roster of a school in Connecticut. It is on the bronze plaque outside the third-floor library at the medical school. It is on a small wooden sign at the entrance to a horse farm in Berks County. None of it is private. None of it requires a wealth screen. All of it is sitting there, in public, waiting to be reassembled.

The development director who walks into the file with a flashlight this week will end the year with the only kind of CRM that has ever mattered: one that knows who the donor is, and not just what she gave.

That is also the gift you leave the next Theo, three years from now, on the Friday afternoon you walk out the side door with your own card and your own small cake.

Don't make him start the file over again from row one.