CAE please, Lisa Delventhal

I don't see a worksheet, just a link to register for a data calculator...is this correct?

Yes that is correct

Thank you

CAE credit, please and thank you.

How to clean up data - manageable steps

Get an idea of how my organization compares to others regarding data cleanliness.

Get an overview about how we can better clean our data and then maintain it.

how to best advise stakeholders on approaches to data cleanliness

Not even sure - I'm just overwhelmed with data!

Best practices in making it manageable

I'm looking for tips/tricks on how to clean and keep clean our member data. Best practices and such

Maybe think of things we are not already doing

I agree wholeheartedly with Kirk

I would like to hear best practices on data hygiene

Seems daunting

best practices for keeping data clean

Understanding of "dirty data", its sources and solutions.

Understand how easy or difficult data cleansing is. Where to start

Convincing team how important this is!

Data that is organized enough for accurate query pulling

I’m looking for tips on how to clean up data and maintain it

Make an argument to invest in continuous cleansing/quality.

Q1 for CAE/CPE Credit:

5

6

6

-2

6

8

4

5

7

8

7

4

7

4

as much as I trust my ability to keep new year's resolutions

7

5

6

6-7

hahaha

5

5

5

Q2 for CAE/CPE credit

Wasted timeErrors for decisions

Frustration when it comes to invoicing

Staff time

Bad business decisions based upon bad data.

lack of trust in the data

Labor cost for manual clean up

InDirect - not reaching people that could register or purchase

volunteer dissatisfaction and confusion and staff time

Staff time

Frustrated staff.

direct, it's really hard to target marketing; indirect, not knowing our community well enough makes it tough to execute strategically

unable to create programs based on solid data

Missing out on revenue due to bad contact info.

Difficulty in recruiting/fundraising/research

longer to verify reports. tougher to defend numbers.

Getting staff to care and continuity of operations when someone leaves

Time wasted Return Mail

inaccurate assumptions based on data, or doesn't go to the correct market

Wasted staff time. Lost opportunities.

Excess expense of marketing outreach

bad data = crappy marketing affects reputation and staff morale

Lost time of staff, duplicate emails sent out is reputational cost

errors

+1 Jorge

mailing to people who are not there or no longer in the business

+1 AMS, mailers

Not data, but database design that doesn’t fit assoc. Our vendor wanted to do it their way and not how our process works

Today's worksheet - https://www.associationtrends.com/Dirty-Data-Cost-Calculator

thanks

One thing we do, is that whenever a new account/contact record is created a staff member is notified. They then verify if it is good or a duplicate because they forgot their email. Yes, it takes resource time but saves us in the long run

I should say, when it is created via our website

What would you estimate it takes to clean up a bad record, time wise?

:)

🙂

Q3 for CAE/CPE credit

Lower

Lower

I will definitely need to re-do my math!

higher

lower actually.

Math do over!

re-do my math

? may need to redo

Re-do math

i need to redo my math too

it's probably lower

Redo the math

??

higher

about as expected

May need to redo math - not all of our bad records are bad *member* records

redo!

redo

math redo

redo

We are a trade organization, so people might be at a regional office and have a different address from the parent company. How does your company deal with that for mail cleanup?

Wow!! great job!

Have more clean-up questions? Let us know in the chat!

Manual

I dream of that. No bandwidth

Q4 for credit: Are you doing cleanising now?

yes, most,y manual with a few macros employed

Manually

Not doing any cleaning at this point.

I'm literally embarrassed to say that our cleanup is entirely manual

every month, manually, as time permits staff

Manual, fix as we find

mostly manual

manual

Very low level - Manual

Manual :(

We do some manual, but some via Excvel and autoupload processes

No - only one offs.

Excel

Doing cleanup with queries

some manual, some automated

Manual - I'm typically the cleaner upper!

As we find errors. Some are annual for updating. But much manual as needed

Cleanup reports that staff usually don't have time to do.

I love that Lisa!

Create a rule about cleaning out stale data. People that get added in the database but then nothing happens with their record for years.

yes, we need to do that! we have data going back decades.

What about Google drive files???

Please put any questions in the chat... we still have 15 minutes!

@Joann, I can completely relate to the Google drive issue

We definitely need to remember that cleaning data is a continual process. My organization cleaned up data about 4 years ago when combining databases and haven't really done much clean up since. I see duplicate records all the time.

Thank you all for your questions and great discussions!

How do you keep ams providers feet to the fire with delivering the functionality they promised and on budget?

fantastic program, thanks so much! Love being able to calculate the costs of dirty data!

automation is not out of reach compared to the cost of dirty data

calculator and breakdowns

There are tools to visibly understand and estimate the real cost of bad data. A wake up call!

there is always more that we can do

overall a new perspective to look at data quality and costs

I'm afraid to run this calculator by our CFO

Quantifying the costs.

Calculator Worksheet

The calculator was very useful

Financial lens for the importance of data

There is always more that we can do with our data (especially if it's clean)

Reevaluate calendar

Simple but great advice - don't put the dirty data into the new AMS!

woo hoo, enough for a staff raise?

@Barbara great way to get everyone involved!

Thank you

Thank you!