What is your FAVORITE clean up task, project, or product?

Carlene Johnson

I just found out a client has Address Accelerator and I became disproportionally excited about the idea of standardizing all their addresses, doing some cleanup, and having valuable data about the deliverability of their addresses so that they can improve their direct mail program.

I want to drop everything else I'm supposed to be working on so that I can do that project and I'm forcing myself to only start that project as a reward if I get all the other things done.

I recognize that my level of enthusiasm for discovering they have Address Accelerator is a little bizarre. ? So now I want to know about the project, task, or BB product that generates that type of response in YOU!

Austen Brown

@Carlene Johnson - One of my most rewarding clean-up projects involved comparing credit cardholder names against donor records - at my last org, I mined 20 years of gift data over a couple of years. It ultimately helped standardize legal names vs. preferred names and served as a valuable double-check to ensure gifts were recorded on the correct records. There’s something deeply satisfying about bringing order to chaos and uncovering insights hidden in plain sight.

Bobby Steurer

@Carlene Johnson Merging records is big for me. A corporate partner will send us contributions from any number of business addresses, and in the past, those often got recorded under that address as a brand new record. Always nice to consolidate.

Rachel Cavalier

@Carlene Johnson Like Bobby, I LOVE being able to match up records and merging them. It's so satisfying to make the database just a little tidier each time.

Spring Velazquez

@Carlene Johnson cleaning up and organizing Addressee & Salutation formulas. To go from 200+ formulas to (currently) 50 plus with headers so users know which one to use. I feel like I need a cigarette and a drink when I'm done ?

Carrie Powell

@Carlene Johnson, I hope it goes well! We have had some issues with Address Accelerator incorrectly updating our donors' addresses or marking them as undeliverable. ?

Carlene Johnson

@Carrie Powell - are you referring to Address Finder or Address Accelerator?

Carlene Johnson

@Spring Velazquez you deserve both after a project like that!!!

Carlene Johnson

@Austen Brown that is FANTASTIC data mining! Love it!

Carlene Johnson

@Bobby Steurer don't you love seeing the number of duplicates # go down?!?

Carlene Johnson

@Rachel Cavalier
I agree. It is such a tangible measure of cleanliness. Sometimes when I'm having trouble getting started with my day I will merge a handful of duplicates to get me in the flow of work.

Carrie Powell

@Carlene Johnson Oh, that's right – Address Finder.

Miki Martin

@Carlene Johnson at my last org I had almost completed cleaning up the addressees and salutations before they removed my position. It was such a rewarding experience knowing I had reduced the number of options.

Carlene Johnson

@Miki Martin
That's a great project to complete! So satisfying.

Sunshine Reinken Watson

@Carlene Johnson
Any coding reconfiguration/clean-up that makes it easier for people to pull reports and see what they need to see on standard dashboards is very satisfying.