Mass Add/Remove from WITHIN a field

The Mass Change a Field feature historically was a “find and replace” only. For all selected contacts, whatever was in the field was replaced by what you were now adding. That is, you had to replace the entire contents.

TntConnect 3.2 added an enhancement to that feature whereby you can add or remove values in a list. This works for any field with list items, such as the User fields.

So let’s say that I work in an athletic ministry and I track the favourite teams of my partners because I like to reference those teams in my conversation. Here are my partners and their favourite teams:

  • Huck Finn: Canucks
  • George Jetson: Canadiens
  • Fred Flintstone: Maple Leafs, Blue Jays
  • Elmer Fudd: Blue Jays

In this list, “Blue Jays” creates a problem because…

…for Elmer Fudd it is the entire field contents

1154_MassChange1

but for Fred Flintstone it is only part of the field:

1154_MassChange2

The comma between Maple Leafs & Blue Jays is important! The Mass Change can only work if commas separate the entries.


Add a comma-separated value

It’s an Olympic year and my partners are all excited about our team, so let’s say I want to Add “Canadian Olympic Team” to all four of the above contacts:

  1. Group Actions | Mass Change a Field
  2. Select the field to be updated (this is my User 1, renamed to “Favourite Team”)
  3. Select the action I want to take: Add to Comma Separated List
  4. Enter the value I want to add (“Canadian Olympic Team”)
  5. Press OK

1154_MassChange3

This will add (1) a comma and (2) the new text. So the new field values will look like this:

  • Huck Finn: Canucks, Canadian Olympic Team
  • George Jetson: Canadiens, Canadian Olympic Team
  • Fred Flintstone: Maple Leafs, Blue Jays, Canadian Olympic Team
  • Elmer Fudd: Blue Jays, Canadian Olympic Team

Remove comma separated value

Similarly, I can remove items from a list. Let’s say the Blue Jays moved to Toledo so I want to remove that from everyone.

  1. Group Actions | Mass Change a Field
  2. Select the field to be updated (“Favourite Team”)
  3. Select the action I want to take: Remove From Comma Separated List
  4. Enter the value I want to remove (“Blue Jays”)
  5. Press OK

The new field values will look like this:

  • Huck Finn: Canucks, Canadian Olympic Team
  • George Jetson: Canadiens, Canadian Olympic Team
  • Fred Flintstone: Maple Leafs, Canadian Olympic Team
  • Elmer Fudd: Canadian Olympic Team

Finally, remember the easy way to lookup a value inside a field is to use the “contains” option:

1154_MassChange4

 

Advertisements

What if I have nothing to say?

If I am committed to writing a blog post every week—without fail—and yet I find myself with nothing to say, should I write one anyway?

Yes.

Why? Because consistency matters.

If I miss a week or two, should I profusely apologize to my quiet but committed readers for missing, followed by an explanation of why I missed?

No.

Why? Because they are not that committed.

Bob, aren’t you saying the exact opposite with those two questions?

Yes and No.

Boy that’s helpful.


Okay. Here’s my point. When it comes to ministry newsletters (often called a “prayer letter”), consistency DOES matter. Every person—and/or every organization—has a different cycle of consistency. Some ministries encourage their staff members to write a monthly newsletter; others encourage a quarterly newsletter with interim letters or notes to key groups (e.g., quarterly for all people and monthly for donors only).

Regardless of the frequency, I have two axioms about newsletters:

  1. Be somewhat faithful to the schedule… that is, be consistent.
  2. NEVER apologize in a newsletter

The first book I ever read on “major donor development” was called The 7 Deadly Diseases of Ministry Marketing by Doug Brendel. Though written for corporate donor work, it profoundly impacted how I raise my personal support. One of the most significant principles I learned was that my partners are not sitting at their mailbox anxiously awaiting my newsletters, nor secretly condemning me each day it is late.

To think that they are checking me off for sending the newsletter on time actually suggests I am the center of their world. I’m probably not.

The book also jokingly made the comment that one fundraiser could send the exact same letter twelve months in a row and raise more funds than someone who sends twelve radically different letters in a row. Why? Because consistency matters.

Next question: Without checking any history or logs, answer one of these questions:

  • How many newsletters have you sent in the last 365 days?
  • How often do you send your newsletters… monthly? quarterly? six-weeks? bi-monthly?
  • What date do you drop your letter in the mail?

Before reading further: This is NOT a guilt blog post. I am not suggesting you should write your letters with any specific frequency, on any specific day, etc.

But I am suggesting that consistency matters. And this is how and why this is a TNT tip and not just a “support raising principle”.

A common business principle is that you cannot effectively evaluate what you cannot measure. Since March 2006 I have used a Group | Log History to record sending my newsletter each month. This helps me easily review:

  • How many newsletters I send each year
  • How many people are on my newsletter list (the number ebbs and flows over time)
  • That any individual partner received a specific newsletter
  • The content of each newsletter… it’s a great way for me to look back if I have a question such as, “When did I write about Quebec?”

2018-06-06-NewsletterLog.jpg

My newsletters have been surprisingly consistent over the past 12 years. I write 5-7 ministry newsletters per year. I also, typically, write two “Family Updates” separate from our ministry newsletter. And I send 1 or 2 special gift appeals each year. So on average I send 9-11 pieces per year not including at least one handwritten thank you note to every partner.

I almost hate to say this, but when I do coaching of missionaries, more often than not the most common thing I see is too few communications. Ministry is busy and time flies, and I forget to keep my partners in the loop. This is also why I strongly encourage missionaries to use an Annual Plan. I think this helps plan and execute good communications with our partners.

He said, She said

2018-06-25-FamilySideTotal

The portion of the support to our ministry account from my partners (blue) and my wife’s (red). This reflects mostly where I have devoted my partnership development efforts over the past 21 years. The two blips—2005 and 2016—represent significant campaigns we ran at that time.

If you are married, did you marry your spouse before or after you went on the mission field? If after, was she or he also already a supported missionary? And if so, what portion of your current or lifetime support is a result of the contacts each of you brought into the marriage?

It may surprise you to learn that TntConnect can answer that question!

But not natively.

When I started using TntConnect 16 years ago this month, I spent a lot of time getting my data ship-shape. I imported every gift we had received in the 13 years before TNT. I got all of the addresses correct. And more.

I have always loved analyzing data and seeing how things work. Even in Excel (before using TNT) I had separated contacts based on whether they were on my wife’s partnership team or my own. We were married in 1997 and at the time had almost equal amounts of support, so at the time it was about 50/50. Five years later I started using TNT, and to retain this helpful information, I used the Family Side field to differentiate between “his” partners and “her” partners.

The Family Side field is intended to be used in conjunction with the Family Level field to define “his cousin” or “her sibling”. But given that very few of our contacts are relatives, I knew I would never use those two fields as designed.

2018-06-25-FamilySideField

So I repurposed the Family Side to represent “the side of the family this contact came from”. For every contact who has given a gift I marked them as His or Hers. I do have some marked as “Neither” because the relationship has been built with us as a couple, since we got married. But surprisingly, only 1.5% of all giving to our ministry account has come from these kinds of people. The remaining 98.5% has come from partners who joined our team more than 21 years ago OR have been referrals from those two teams as recently as last year.

Because I have every contact marked as “His”, “Hers”, or “Neither”, I can then view reports on the Analysis View:

Average Monthly Gifts by Family Side:

2018-06-25-FamilySideSelection

2018-06-25-FamilySideAverage

Lifetime Gifts by Family Side:

2018-06-25-FamilySideLifetime

The most noticeable aspect of this is that lifetime, partners from my wife’s source are a greater proportion of our lifetime giving than they are of current giving (above).

The above charts are right out of TNT with no additional effort. I did export the Contribution Report to Excel and run more reports for my own delight (that’s how I generated the chart at the top), but that’s beyond the scope of this blog post.

My point, as always: Because I asked a question of my database, I figured out a way to get the answer. In other words, I let my needs drive my use of the software, rather than the software dictate to me what I need.