Apteco
Mission Field Guide
Apteco MissionStop storing your data. Start using it.150+ insights · 25+ audiences
Apteco Mission

Stop storing your data.
Start using it.

Your CRM is a filing cabinet. Mission is your analyst. This guide shows the work behind every answer: the data your charity already collects, and the 150+ insights Mission builds from it on every supporter, surfaced and delivered to you automatically.

150+insights on every supporter
25+audiences ready to activate
20+pathways from data to action

Mission joins gifts, memberships, events, volunteering, grants and campaigns into one record per person, then builds insight and audiences across all of it: look-alikes of your best supporters, lapsed givers who still volunteer, funders due a report. You can start from three columns, supporter ID, gift amount and gift date, but that is the floor, not the ceiling.

We don't know your organization the way you do, and this might not be a fit. We'd rather show you than tell you.

NewBehaviours, built into Orbit

Ask your data a question. Get the answer on the spot.

Pick a kind of record, like gifts or volunteer shifts. Orbit works out a number or a date for every supporter, right when you look. No formula to write. No new field to set up first.

RecencyWhen was it? A first gift. A last shift.
FrequencyHow many? Gifts this year. Shifts last year.
ValueHow much? Dollars given last year.
  • Works on every CRM mapped in this guide. Seven of the 10+ Behaviours need only the three columns you start with: supporter ID, gift amount and gift date.
  • People, not rows. A volunteer with ten shifts counts once.
  • The right year. Donor retention divides by last year’s donors, so the rate means what it says.
  • Calendar years, not rolling days. “New last year” means a first gift last year.
  • One rule, every tile. Save a Behaviour in an audience, and every tile that counts it gives the same answer.
  • In your messages too. A Behaviour can fill a personal line in a campaign message.
Learn it in the courseApteco Help Hub
Pathways

From your data to the right person, and back again.

Questions your CRM can’t answer

Pick one to see the insight, audience or pathway that answers it. The chips show which parts of your data each answer draws on.

0 of 0

The Field Guide in plain words

Everything the guide above shows, written out on one page: 20+ pathways, 25+ audiences, 150+ insights and the CRMs it covers.

What does Apteco Mission do?

Mission joins gifts, memberships, events, volunteering, grants and campaigns into one record per person, then builds insight and audiences across all of it: look-alikes of your best supporters, lapsed givers who still volunteer, funders due a report.

What data do I need to start?

You can start from three columns, supporter ID, gift amount and gift date, but that is the floor, not the ceiling. Mission makes the donation id itself. The Instant Insights module built once on those three columns is free for life; a full Mission deployment is not.

How is Mission different from a CRM, a reporting tool or a data consultant?

Your CRM stores what happened. It shows you the past; it does not work out what the past means. A reporting tool like Power BI is a blank canvas: someone has to build every chart, and a chart is not a prediction. A data consultant project produces a report, not a system, and a few months later the report is stale. An AI prediction add-on predicts from whatever mess the data is in. Mission is a CRM companion: it sits underneath the tools you have, joins their data into one record per supporter, builds the insights once and keeps them current, and hands your team the list to act on. Nothing you use gets replaced.

What are Behaviours?

Behaviours are built into Orbit. Pick a kind of record, like gifts or volunteer shifts, and Orbit works out a number or a date for every supporter, right when you look: when it happened (Recency), how many (Frequency) or how much (Value). There is no formula to write and no new field to set up first. Save a Behaviour in an audience, and every tile that counts the audience gives the same answer. The guide lists 10+ Behaviours and the 20+ audiences built from them. The gift Behaviours need only the three columns above.

Research: what we found in 42 charities' public board reports.

Every pathway on its own page: the pathways. Every audience on its own page: the audiences. Everything built for Mission, searchable, with a request button: Mission Resources. Learn Mission hands on: the course. The questions charities ask us first, answered: questions.

Which CRMs does the guide cover? (11)

Blackbaud Raiser's Edge NXT

What it covers: Deep gift and event coverage. Grants are tracked through Opportunity records.

Gaps: No role-at-event concept, so volunteer insights do not compute.

Salesforce NPSP

What it covers: Broad gift, household and campaign coverage across a very large installed base.

Gaps: No volunteer object. No event fee or duration.

Note: Legacy. Salesforce ended feature development in March 2023 and stopped issuing NPSP to new nonprofits in December 2025. Existing orgs are supported with no end-of-life date, but new Salesforce orgs are on Nonprofit Cloud.

Salesforce Nonprofit Cloud

What it covers: Salesforce's current nonprofit platform and the successor to NPSP. Real volunteer objects, which NPSP never had.

Gaps: Volunteer Management needs Unlimited edition. Campaign start and end are dates rather than datetimes, so event duration cannot be computed.

Note: Grantmaking models grants awarded by a funder, not grants received, so Mission's grants module has no equivalent. Ask which Salesforce edition before promising volunteer analytics.

CiviCRM

What it covers: The only system in this guide where donations, events, participants, volunteering and grants are all first-class tables. Every Mission insight computes.

Gaps: None for the Mission schema.

DonorPerfect

What it covers: Complete donor and gift history, which carries the entire Instant Insights layer.

Gaps: No event, participant, volunteer or grant table in the queryable schema. Campaign is a code on the gift rather than a record. Birth date is a user-defined field.

Note: Canadian DonorPerfect systems use the acknowledge preference on each gift for official receipting (receipt, acknowledge only, or neither), and Quebec Law 25 fields exist as user-defined fields on some systems. Mission has no field for either yet; ask which a Canadian prospect uses. Refunds are three linked gift records, not a credit note.

Bloomerang

What it covers: Clean donation and household coverage, with Birthdate and Gender on the constituent record.

Gaps: No events and no volunteers in the CRM schema. No grant object.

Note: Bloomerang is three products. Events sit in Bloomerang Fundraising and volunteers in Bloomerang Volunteer, each with its own API, so that activity never reaches the CRM data model. Campaign detail beyond Id and Name is not published.

Little Green Light

What it covers: The strongest non-CiviCRM fit. volunteer_times is a real object, and campaigns carry financial_goal with start and end dates.

Gaps: No grant object. Events carry no fee, capacity or attendance status.

Note: volunteer_times and events property keys are not published in full; confirm against a live account before build. Events carry no confirmed end datetime, so the three duration insights are off; if volunteer_times exposes hours directly, a schema variant could restore them.

HubSpot

What it covers: Donations map to Deals in a giving pipeline. Marketing Event attendance gives real event insights, and event datetimes allow duration to be computed.

Gaps: No grant object. No volunteer role. No event fee or capacity. hs_goal is deprecated, so campaign goal revenue is unavailable.

Note: Marketing Events are a Marketing Hub feature. Confirm the objects are provisioned before relying on event insights.

Givebutter

What it covers: Real Households object, a repeating emails array, and Contact.dob so donor age computes.

Gaps: No event record carrying dates or attendance status. No volunteer object. No grant object.

Note: Ticketing exists but is not an attendance model, so event insights are switched off rather than approximated.

Keela

Sumac

Gaps: Fields, dropdowns and tabs are renameable by the client, so no two accounts share a schema.

The 20+ pathways

Across your organization

The Board Pack That Builds Itself

The numbers your board asks for, gathered from every system and ready before every meeting.

Problem solved: Board-ready numbers before every meeting. Team: Finance and board.

Why it's hard today: Board numbers are often rebuilt by hand before each meeting, from the CRM, the finance system, a grants spreadsheet and a coordinator’s own counts. Some CRMs only report one month at a time, so a year-on-year comparison becomes a manual job.

Volunteer Appreciation and Drift

Thank volunteers at the moments that matter, and notice when someone starts to drift before they are gone.

Problem solved: Drifting volunteers noticed in time. Team: Volunteers.

Why it's hard today: Volunteer hours often sit in a volunteer platform, a coordinator’s spreadsheet or a paper sign-in sheet. The CRM sees gifts, not shifts, so nobody is told when a regular volunteer stops coming.

Members Who Stopped Showing Up

Notice the members who have stopped coming, long before their renewal is due, and reach them while it still matters.

Problem solved: Quiet members noticed before renewal. Team: Membership.

Why it's hard today: The membership platform handles signup, renewal and payment, and often tells the member their membership has lapsed without telling staff. Visits sit in admissions or on sign-in sheets, so a regular who stops coming isn’t noticed until renewal.

Funder Reporting and Stewardship

Never miss a report deadline, and keep returning funders close between applications.

Problem solved: No more missed funder reports. Team: Grants.

Why it's hard today: Grant deadlines often live in a spreadsheet or a shared calendar that one person watches. When that person is away, a report deadline can slip past.

Clean and Considerate Communications

Every message respects each person’s wishes and reaches a real inbox, across every channel and every team.

Problem solved: No message to anyone who opted out. Team: Communications.

Why it's hard today: Contact preferences end up in several places: the CRM, the email platform, sometimes a membership or events system, and the contact counts often don’t match. An opt-out recorded in one doesn’t reach the others on its own.

Acquisition, ads and channels

Look-alikes: More People Like Your Best

Orbit finds the people already on your file who most resemble your best supporters, then Meta finds more of them beyond it.

Problem solved: More people like your best supporters. Team: Acquisition.

Why it's hard today: What makes your best supporters your best is spread out: gifts in the CRM, events in ticketing, shifts in the volunteer system. A model built on the CRM alone only learns from the gifts.

The Dynamic Ask Appeal

Every supporter sees an ask built from their own giving history, in every channel at once.

Problem solved: The right ask for every person. Team: Fundraising.

Why it's hard today: A personal ask needs the whole giving history. When gifts come in through several giving platforms, or older gifts sit in the finance system from before the current CRM, the ask is set from part of the record.

Always-On Ad Audiences

Google, Meta and LinkedIn always hold the right people: the ones you want to reach, and the ones you should stop paying for.

Problem solved: Ad spend aimed at the right people. Team: Digital.

Why it's hard today: Ad audiences need giving and event history in one place to know who to show and who to leave out. When that history is split across systems, the upload only reflects what one system can see.

Cost to Acquire a Supporter

What each campaign and channel really costs per new supporter, next to what those supporters give in their first year.

Problem solved: The real cost of a new supporter. Team: Leadership.

Why it's hard today: Gifts often don’t record where they came from. Even charities with analytics and ad accounts find that tagging hundreds of donation forms by hand gets abandoned, so cost per supporter becomes a guess.

Channel Effectiveness

Which channels win the first gift, and which keep supporters giving, side by side, every month.

Problem solved: Budget follows the channels that keep supporters. Team: Leadership.

Why it's hard today: Email results stay in the email platform, ad results in the ad platforms and gifts in the CRM. Without a source on each gift, nobody can say which channel brings supporters who stay.

Fundraising

The Monday Call List

Nine signals become one ranked list, and every person arrives with their whole story and the recommended next step.

Problem solved: This week’s calls, ranked and ready. Team: Fundraising.

Why it's hard today: The signals that say “call this person this week” are split up: gifts in the CRM, attendance in ticketing, hours in a spreadsheet. With no single list, the call list often comes from someone’s memory.

Catch Them Before They Lapse

Each supporter’s own giving rhythm says when they are slipping. Act inside the window, not at year end.

Problem solved: Lapses caught early. Team: Fundraising.

Why it's hard today: Some CRMs only report one month at a time, so a supporter’s rhythm over the years never shows. The usual stand-in is one rule for everyone, such as no gift in 12 months.

The First 90 Days

The weeks after a first gift decide whether there is a second one.

Problem solved: Second gifts asked for on time. Team: Fundraising.

Why it's hard today: First gifts made on giving platforms without a live connection arrive in batches, so the thank-you waits until someone imports them and notices. Where the first gift came from often isn’t recorded at all.

Year-End Recovery

Everyone who gave last year and hasn’t yet this year, ranked by value, timed to their own calendar, and seen in full.

Problem solved: A year-end list that builds itself. Team: Fundraising.

Why it's hard today: LYBUNT reports only count gifts the CRM holds. A gift made on another platform, or a supporter who came to events this year, doesn’t show, so the list can chase people who already gave or never left.

Sleeping Giants to Major Gifts

Find the supporters already behaving like major donors, using gifts, events and volunteering together, then cultivate before anyone asks.

Problem solved: Major donors spotted early. Team: Major gifts.

Why it's hard today: Major gift signals hide in different places: large gifts in the CRM, event visits in ticketing, and a company that gives a grant through one platform and matched employee gifts through another. Split up, it reads as several small relationships.

The Upgrade Ask

Ask for what they have already shown they can give.

Problem solved: Asks matched to what people can give. Team: Fundraising.

Why it's hard today: To ask for more you need someone’s largest gift. When history is split between an old CRM, the finance system and today’s CRM, the peak can sit in a system nobody checks anymore.

Monthly Giving Conversion

Some supporters already give like monthly donors, and some of them used to volunteer. Ask them to make it official.

Problem solved: Monthly donors found in your file. Team: Fundraising.

Why it's hard today: A supporter who gives most months, sometimes by cheque and sometimes through an online platform, looks like an occasional giver in each system on its own.

Volunteers Who Have Never Given

They already give their time. Thank them for it before you ask for anything else.

Problem solved: Volunteers asked to give, the right way. Team: Volunteers.

Why it's hard today: Volunteers are often tracked in their own platform or spreadsheet, apart from donors, so “which volunteers have never given?” is a question no single system can answer.

From Guest to Giver

Turn the night of the event into the start of a relationship.

Problem solved: Event guests followed up while it matters. Team: Events.

Why it's hard today: Attendance often lives in a ticketing tool, a box office or a paper sign-in sheet that gets tallied into totals. The names stay on the sheet, so the CRM never learns which guests came.

Right Month, Right Ask

Ask people in the month they usually give, and leave them alone in months they never do.

Problem solved: Asks timed to each person’s month. Team: Fundraising.

Why it's hard today: Finding each person’s best month means looking across every gift they’ve made, through every platform they’ve used. Gifts split across systems, and reports that run one month at a time, hide the pattern.

Win-Back With a Listening Step

Before you ask a lapsed supporter for money, check whether they really left, then ask what changed.

Problem solved: Lapsed supporters asked what changed. Team: Fundraising.

Why it's hard today: A giver the CRM calls lapsed may still be volunteering or coming to events, logged somewhere else. Without that, the win-back appeal chases someone who never left.

A Year of Stewardship

Your most loyal supporters hear about their impact all year, across every way they are involved, not only when you need something.

Problem solved: Loyal supporters thanked all year. Team: Fundraising.

Why it's hard today: Stewardship often runs from a separate spreadsheet: who got a card, who got a call, who wants to be recognized and how. Kept apart from the gift history, nobody sees the whole year a supporter actually had.

The 25+ audiences

  • Lapsed Givers Still Showing Up: Supporters whose giving has lapsed but who still come to events or volunteer. Your CRM calls them lapsed. They are still here.
  • Look-alikes of Your Best Supporters: People already on your file who most resemble your best supporters, scored by Orbit’s Find Look-alikes on the variables your administrator chooses. The seed group is excluded, so every name is someone new to target.
  • Volunteers Starting to Drift: Volunteers who gave their time last year but have not logged a shift this year.
  • Funders Due a Report: Grants whose report due date has passed with no report received yet, alongside how often each funder has given before.
  • Sleeping Giants: Who in your database is already acting like a major donor? These supporters score 3 or more out of 5 on signals of untapped potential: long tenure, growing gifts, a strong first gift, giving outside their peak month and a steady giving floor.
  • Lapse Prevention: Who is about to lapse, and how many days do you have? These supporters are close to, or already past, the point where their own giving rhythm says they have gone quiet.
  • Gala Guests Who Never Gave: Supporters who came to one or more events but have never made a gift. They showed up for your mission. They just haven't been asked the right way yet.
  • Critical Action Required: Who should you contact this week? These supporters have the most urgent signals firing at once. They need a personal conversation now, not a mass appeal.
  • Upgrade Window: Who is giving less than they used to, and how much is that worth? These supporters have already shown they can give more: their largest gift is more than double their most recent one.
  • Monthly Giving Candidates: Who already gives like a monthly donor without being asked? Their gifts arrive on a steady rhythm at a steady amount. They just haven't been asked to make it official.
  • Silent Major Donors: Supporters with high lifetime giving who have never come to an event or volunteered. Generous but invisible. You may not even know what they look like.
  • Volunteers Who Have Never Donated: How many of your volunteers have never been asked to give? They already give you their time. They're the warmest supporters you have.
  • New Donor Welcome: Supporters in the first year after their first gift. What happens in their first 90 days shapes whether they give again.
  • Second Gift Push: Which new supporters will give a second time? These supporters have given once and are still in the window for a second gift. A faster second gift is strongly associated with long-term retention.
  • Drifting Donors: Whose giving pattern just changed? These supporters are overdue against their own personal giving rhythm. Not lapsed yet, but the gap is widening.
  • Peak Month Outreach: Supporters whose personal peak giving month is now or next month. Their own history says this is when they are most likely to respond.
  • Multi-Channel Champions: Supporters who give, come to events and volunteer. They show up in every way your organization offers.
  • Household Giving Gaps: Households where one person gives and others at the same address don't. Untapped capacity sitting at the same address.
  • Event Regulars, Gift Irregulars: Supporters who come to events consistently but whose giving is sporadic or declining. The connection is strong. The giving pattern needs attention.
  • Re-engagement: Supporters 1 to 2 years past their last gift. Not deeply lapsed yet, and still recoverable with the right message at the right time.
  • Loyal Stewardship: Supporters who have given across many years and sit in the Loyal or Established stage. Some of your most valuable relationships.
  • Value Upgraders: Supporters who moved into a higher value band than last year. Their giving is growing, and they are responding to your work.
  • First Event, First Gift: Supporters whose first gift came shortly after their first event. Events are how they found their way to giving.
  • Event to Donor Conversion: Supporters who come to your events but have not yet become regular givers. They are already engaged with your mission.
  • Lapsing Volunteers Who Still Give: Supporters who stopped volunteering but still give. Something changed in their availability, not their commitment.
  • Campaign Responders Going Cold: Supporters who responded to past campaigns but are now drifting away. Your campaigns used to reach them. Something stopped working.
  • Cold Month Suppression: Supporters who have never given in the current calendar month, across their whole history. An ask right now is likely to be ignored.
  • Returning Funders at Risk: Funders who have granted more than once but whose most recent application or decision was a long time ago. The relationship may be cooling.

The 150+ insights

Insights

  • Action Clock Score: Your daily priority queue. Sort donors by Action Clock Score to see who needs attention right now. The highest scores have the most urgent and overlapping signals.
  • Primary Action Flag Score: Feeds into the Primary Action Flag.
  • Rhythm Drift Score: Identify donors who are overdue relative to their own pattern. A score above 1.5 means they're late. Prioritize outreach to drifting donors before they fully lapse.
  • Predicted Days To Lapse: See exactly how many days each donor has before they cross their personal lapse point. Prioritize outreach to donors with the fewest days remaining.
  • Metronome Score: Your monthly giving conversion list. Donors scoring 3-4 already behave like monthly givers with their cash gifts. Ask them to formalize what they're already doing.
  • Cold Month Flag: Avoid wasting outreach on months when a donor has never given. Use to suppress contacts during cold months and concentrate effort during warm ones.
  • Predicted Next Donation Date: Know when each donor is next expected to give. Time your outreach to arrive just before their predicted date for maximum relevance.
  • Missed Expected Donation Flag: Pull a list of donors who should have given by now but haven't. These are your most time-sensitive outreach targets.
  • Capacity Suppression Ratio: Find donors giving well below their demonstrated peak. If the number is 0.3, they are giving only 30% of what they have given before. Build an upgrade ask around the gap.
  • Revenue Gap Per Donor: Quantify the dollar value you could recover if each donor returned to their peak. Sum this across your file to show leadership the total recoverable revenue.
  • Weighted Forecast Contribution: Estimate next-gift revenue weighted by reliability. Sum across your active donor file for a confidence-adjusted revenue forecast.
  • Donor Median Interval Days: Understand each donor's personal giving rhythm. A donor with a 90-day median gives roughly quarterly. Use to time asks to land when the donor naturally gives.
  • Peak Giving Month: Time your asks to land in each donor's peak month. An appeal sent in someone's peak month converts at higher rates than one sent off-season.
  • Sleeping Giant Score: Your upgrade prospect list. Donors scoring 3+ out of 5 have multiple signals of untapped capacity. Build a personal outreach plan for your Sleeping Giants.
  • Floor Score: Find donors who give at a consistent level regardless of ask amount. These supporters have a stable giving floor and are reliable revenue you can forecast.
  • Tenure Score: Identify long-tenure supporters (3+ giving years). These donors have demonstrated sustained commitment and are strong candidates for legacy giving conversations.
  • Momentum Score: Spot donors whose giving is accelerating. A latest gift 25%+ above their average signals growing commitment and readiness for an upgrade conversation.
  • Consecutive Giving Streak: See how many donations in a row a donor has made within their expected rhythm. Longer streaks indicate deeply embedded giving habits.
  • Donor Unique Id: Lets the supporter ID appear in tables in Orbit.
  • Off Peak Giving Flag: Identify donors who give outside their peak month. These supporters respond to asks year-round, making them good candidates for additional mid-year appeals.
  • Number Of Giving Years: Count of distinct calendar years with at least one donation. Use to identify long-tenure supporters for legacy giving conversations and milestone recognition.
  • Acquisition Year: Compare groups of donors by the year they first gave. Essential for measuring long-term retention by source.
  • Second Donation Within 90 Days: Spot donors who converted quickly after their first gift. These supporters have high retention potential and deserve immediate stewardship investment.
  • First Donation Month: See which month of year each donor first gave. Useful for understanding seasonal acquisition patterns.
  • Contact Window Status Score: Feeds into the Contact Window Status label.
  • Months Since Acquisition: Track donor tenure in months. Useful for building time-based retention curves and identifying critical churn windows.
  • Next Donation In 90 Days: Build a 90-day outlook of expected donations. Use to forecast near-term revenue and plan outreach.
  • Interval Standard Deviation: Feeds into the Giving Regularity classification.
  • Interval Cv: Feeds into the Giving Regularity classification.
  • Donation Amount Standard Deviation: Feeds into the Donation Amount Consistency Score.
  • Donation Amount Consistency Score: Feeds into the Metronome Score.
  • Donor Value Movement Score: Feeds into the Donor Value Movement label.
  • Donation Value Same Period Last Year: The fairest year-over-year comparison. Use in any module to show "same period" revenue tracking without seasonal distortion.

Giving History

  • Donor Development Stage: Build lifecycle-specific journeys. New donors get a welcome series, Developing donors get deepening asks, Loyal donors get recognition and legacy giving conversations.
  • Donor Movement: Build a donor movement waterfall for your board: how many supporters are new, re-engaged, increased, unchanged, decreased, or lost. Read New and Re-engaged together: between them they hold everyone who gave last year after a year off, including last year's first-time donors.
  • Giving Trend: Spot donors trending up for upgrade conversations. Spot donors trending down for stewardship calls before they lapse.
  • Capacity Signal: Find donors giving below their demonstrated capacity. A High Capacity signal means they've proven they can give more. Build a targeted upgrade appeal around these supporters.
  • Donor Status: Sort any report by Active, Lapsing, Lapsed, or Deeply Lapsed. The starting point for year-end appeals or re-engagement campaigns.
  • Giving Consistency: Identify your most reliable givers for sustainer conversion asks. Highly Consistent donors are your best candidates for monthly giving programs.
  • Days Since Last Donation: The core recency metric. Use to trigger automated re-engagement sequences at 365, 545, and 730 days, or to prioritize phone outreach to recent lapsers.
  • Donor Retention: Split one-time donors from repeat donors in any chart, like New vs Returning Donors on Campaign Performance. For the share of last year's donors who gave again this year, use the Retained donors audience divided by Gave last year.
  • Returning Donor Flag: Split reports between first-time and returning donors to measure retention separately from acquisition. Use in board reporting to show the health of your donor base.
  • Lifetime Value: Group your donors by total giving to prioritize stewardship. Identify your top 10% of lifetime givers for personal thank-you calls or major gift cultivation.
  • Average Lifetime Donation Value: Set personalized ask strings in appeals. A donor averaging $250 should see different suggested amounts than a donor averaging $50.
  • Largest Donation Value: See the peak gift a donor has ever made. When their latest gift is much lower than this, it signals recoverable capacity for a targeted upgrade ask.
  • Number Of Lifetime Donations: Group by engagement depth. Donors with 1 gift need a different retention strategy than donors with 10+. Build different stewardship journeys for each group.
  • First Donation Date: Compare retention rates between donors who started giving in different years. See which campaigns brought in the most loyal supporters over time.
  • Latest Donation Date: Quickly see who has given recently and who has gone quiet. Separate active donors from lapsed donors in any campaign list.
  • First Donation Value: Understand entry-level giving. Compare first gift amounts across acquisition channels to see which sources bring in higher-capacity donors from day one.
  • Latest Donation Value: Compare a donor's most recent gift to their history. Use alongside Giving Trend to spot donors whose giving is climbing or declining.
  • Smallest Donation Value: Identify the floor of a donor's giving range. Useful for setting minimum ask amounts in targeted appeals.
  • Number Of Campaigns: See how many campaigns each donor has responded to. Multi-campaign responders are more engaged and may be ready for deeper cultivation.
  • Donor & Participant Flag: Identify supporters who both give and attend events. Multi-channel supporters have higher retention and lifetime value.
  • Donations Last Year: Year-over-year comparison building block. Use with Donations Year Before Last to calculate retention rates and movement analysis.
  • Donations Year Before Last: The comparison baseline for Donor Movement. Pair with Donations Last Year to build year-over-year donor movement waterfall charts.
  • Donation Value Last Year: Year-over-year revenue comparison by donor. Use to calculate same-donor revenue growth or decline between periods.
  • Donation Value Year Before Last: Revenue baseline for year-over-year comparison. Pair with Donation Value Last Year to build revenue movement analysis.
  • Donations This Year: Live year-to-date giving count per donor. Use in any module to track current year engagement as it happens.
  • Gave Last Year But Not This Year (LYBUNT): Your year-end recovery list: supporters who gave last year and have not given yet this year. Pull them into fall and year-end appeals before the calendar year closes.
  • Gave Some Year But Not This Year (SYBUNT): Your wider win-back pool. Exclude LYBUNT donors to isolate supporters who lapsed longer ago, then give them a softer re-introduction rather than the same ask you send last year's donors.
  • Second Donation Date: Track the critical second gift. The gap between first and second donation is the strongest predictor of long-term retention.
  • Days To Second Donation: Measure conversion speed. Donors who give a second time within 90 days retain at dramatically higher rates. Use to evaluate welcome series effectiveness.
  • Donation Value First 3 Months: Evaluate early giving intensity. High first-3-month value predicts long-term major gift potential.
  • Donation Value First 12 Months: First-year giving total per donor. Compare groups of donors by start year to see which channels produce the highest early-value supporters.
  • Donation Value This Year: Live year-to-date revenue per donor. Use to build current-year value tiers and track progress against annual fundraising targets.

Volunteering

  • Volunteer Donor Status: See which volunteers also give and vice versa. Use to build cross-engagement campaigns that convert volunteers into donors.
  • Volunteer Engagement Tier: Group volunteers by activity level for recognition programs. Your most active volunteers should receive personal outreach.
  • No. Of Times Volunteered: Rank volunteers by frequency. Your most active volunteers are often your best candidates for giving conversations.
  • Total Volunteer Hours: Quantify volunteer contribution in hours for impact reporting and grant applications that require volunteer hour totals.
  • Years As Volunteer: Recognize tenure milestones. A 5-year volunteer anniversary is an opportunity for a thank-you and a conversation about legacy giving.
  • Volunteer This Year: Pull a list of current-year active volunteers. Use for volunteer appreciation campaigns and year-end giving asks.
  • Volunteer Last Year: Track volunteer retention year over year. Compare with Volunteer This Year to measure volunteer churn.
  • Volunteer This Year And Last Year: Identify your most committed volunteers who show up consistently. These supporters are prime candidates for board recruitment or donor conversion.
  • First Date As Volunteer: Track volunteer tenure. Long-serving volunteers deserve recognition milestones and legacy giving conversations.
  • Last Date As Volunteer: Spot volunteers who have stopped showing up. Pair with Years Since Last Volunteered for re-engagement outreach.
  • First Volunteered This Year: Identify new volunteers for a welcome and onboarding sequence. First-year volunteers need different communication than veterans.
  • Volunteer Year Before Last Year: Build a three-year volunteer movement analysis alongside Volunteer Last Year and Volunteer This Year.
  • Volunteer Last Year And Year Before: Identify consistently active volunteers over a two-year window. These are your most reliable volunteer corps.
  • First Volunteered Last Year: Track second-year volunteer retention. Did last year's new volunteers come back this year?
  • Years Since Last Volunteered: Identify lapsed volunteers for re-engagement. A supporter who volunteered for years and then stopped may need a personal check-in.
  • Volunteer Flag: Identify supporters who have volunteered at least once. Build volunteer-specific communications and appeals.

Behaviours

  • Gifts this year: The building block for "gave this year". Pair it with Gifts last year to see who came back and who hasn't yet.
  • Gifts last year: The starting line for retention: everyone with 1 or more here is one of last year's donors. Retention asks how many of them gave again.
  • Gifts year before last: Compare two full years side by side, the way Donor Movement does.
  • Gifts before this year: The wider win-back pool: anyone with 1 or more here who hasn't given yet this year is in the SYBNT audience.
  • Giving last year: See where last year's money came from. Take away Giving year before last to see who gave more and who gave less, the way the Donor Movement chart does.
  • Giving year before last: The baseline for Giving last year. The gap between the two is each supporter's change in giving.
  • First gift date: Find new donors by the year of their first gift. Chart new donors by the month of that first gift, so each one counts once.
  • Shifts this year: The building block for "volunteered this year". Count the people with 1 or more, and each volunteer counts once.
  • Shifts last year: The starting line for volunteer retention: everyone with 1 or more here volunteered last year.
  • Shifts year before last: Check who has volunteered two or three years running.
  • First shift date: Find new volunteers by the year of their first shift, and chart recruitment year by year.
  • Last shift date: Spot volunteers who have stopped coming: a last shift more than a year ago makes someone a lapsed volunteer.

Event History

  • No. Of Events Attended: Measure breadth of event engagement. It counts registrations, so pair it with Attendance Status when you need the events someone actually came to.
  • Days Since Last Event Attended: Trigger re-engagement outreach when event engagement lapses. Set automated touchpoints at 90, 180, and 365 days.
  • Participated In Events: Identify donors who also attend events. Multi-channel engagement correlates with higher retention and lifetime value.
  • Total Event Fees: Track fee revenue per supporter. Useful for event ROI analysis and identifying supporters who engage financially beyond donations.
  • First Event: Find when a supporter first engaged through events. Use to compare event-acquired supporters vs donation-acquired supporters.
  • Last Event: Identify supporters whose event engagement has gone cold. Pair with Days Since Last Event Attended for re-engagement targeting.
  • Total Hours At Events: Quantify volunteer and participant time investment. High-hours supporters are deeply engaged even if their giving is modest.
  • Last Event Attended: Quick reference for the most recent event a supporter attended. Useful in conversation prep before a phone call or meeting.
  • Event Participant Flag: Identify supporters who have attended at least one event. Separate event-engaged from event-inactive donors.
  • Total Events Attended: Count of events per supporter. Use to measure breadth of event engagement alongside Total Hours At Events.

Participants

  • Event Capacity Percentage: See what percentage of capacity each event has filled. Use to trigger promotional pushes for under-filled events.
  • Attended: See confirmed attendees. Measure actual vs registered attendance and spot no-shows.
  • Event No Show: A personal note after a no-show can recover the relationship and improve future attendance.
  • Days Registered Before Event: Measure how far in advance people register. Early registrants may respond to early-bird pricing or VIP offers.
  • Days Until Event: Countdown to each upcoming event. Use to trigger pre-event communications at 30, 14, and 7 days out.
  • Event Counter: Used for event-level calculations in your modules.
  • Max Revenue For Event Fee: Calculate maximum potential fee revenue per event if every spot fills. Use for event budgeting and ROI projections.
  • Event Hours: Duration of each event in hours. Feeds into total volunteer and participant hours.
  • Attendance: Compare engagement and giving patterns between attendees and no-shows.
  • Total Events Count: Used for percentages in your modules.

Donations

  • Days Between Donations: Feeds into the Donor Median Interval Days calculation.
  • Donation Month: Feeds into the Peak Giving Month calculation.
  • Off Peak Donation Flag: Feeds into the Off Peak Giving Flag.
  • Donation Year: Feeds into the Number of Giving Years calculation.
  • Current Month Of Year Flag: Feeds into the Cold Month Flag.
  • Is Within 3 Months Of Acquisition: Feeds into the Donation Value First 3 Months calculation.
  • Is Within 12 Months Of Acquisition: Feeds into the Donation Value First 12 Months calculation.
  • Is Within Expected Interval: Feeds into the Consecutive Giving Streak calculation.

Grant History

  • Returning Funder Flag: Identify funders who have given more than once. Returning funders are your most reliable grant revenue source.
  • Funder Retention: Separate new from returning funders in any module. The grant equivalent of donor retention.
  • Total Amount Granted: Total grant revenue per funder organization. Rank your funders by total giving to prioritize stewardship.
  • Total Grants: Count of grants per funder organization. Identify your most active grant relationships.
  • First Grant Application Date: Track when you first applied to each funder. Useful for measuring funder relationship tenure.
  • Latest Grant Application Date: See the most recent application date per funder. Identify funders you haven't applied to recently.
  • First Grant Decision Date: Track your earliest decision from each funder. Useful for understanding funder decision timelines.
  • Latest Grant Decision Date: See the most recent decision per funder. Pair with Latest Grant Application Date to measure decision lag.

Donor Scoring

  • LAI Score: Combined major gift prospect rating using Linkage, Ability, and Interest. Sort by LAI Score to build your major gift prospect list. Higher scores mean stronger candidates for personal cultivation.
  • Linkage Score: Part of the LAI major gift rating. Measures how connected a supporter is to your organization through giving frequency, volunteering, and event attendance. Use alongside Ability and Interest to build a major gift prospect list.
  • Ability Score: Part of the LAI major gift rating. Estimates financial capacity based on largest gift ever made. Identify supporters who have demonstrated the ability to give at major gift levels.
  • Interest Score: Part of the LAI major gift rating. Reflects demonstrated engagement through recency of giving, volunteering, event attendance, and geographic proximity. Use to identify supporters who are actively interested in your mission.
  • Strong Entry Score: Identify donors who entered at or above their own average. Strong entry predicts higher retention and lifetime value.

Grants

  • Grant Report Received Count: Track which grants have submitted reports. Spot outstanding report deadlines.
  • Grant Due Date - Past Flag: Spot overdue grant reports. Pull a list of past-due grants for immediate follow-up.
  • Full Amount Granted: Identify grants where you received the full requested amount. Compare against partial grants to understand funder patterns.
  • Grant Received: Identify grants where at least one payment has been received. Separate committed from pending grants.

Supporters

  • Donor Age: Group communications by life stage. Younger donors may respond to digital channels, older donors to mail and phone.
  • Donor Age (Banded): Use in any module to compare giving patterns, event attendance, and retention across age groups.

Volunteers

  • Volunteer Hours: The building block behind Total Volunteer Hours. Use it at timesheet level to see where volunteer time is going, shift by shift.

Others

  • All Supporters: The default starting point for any chart in a module. Shows everyone with no conditions applied.

Campaigns

  • Campaigns Count: See how many campaigns each supporter is linked to. Multi-campaign supporters are more deeply embedded in your program.

More insights

  • Lifetime Value Banded: Use in any module to compare retention, engagement, and giving patterns across value groups.
  • First Gift Banded: Use in any module to compare long-term performance of donors who entered at different giving levels.
  • Rhythm Band: Separate on-rhythm donors from those who are drifting or overdue in any module.
  • Sleeping Giant Flag: Pull a list of High or Very High potential Sleeping Giants for your major gift officer or stewardship team.
  • Cliff Edge Band: Separate donors by lapse urgency. Critical donors need immediate personal contact. Urgent donors need a priority email sequence.
  • Upgrade Window Band: Identify your highest-priority upgrade targets: supporters with the biggest gap between what they gave last and what they have given before.
  • First Donation Month Band: See which months of the year bring in the most new donors. Use for planning acquisition campaigns.
  • Peak Giving Quarter: Plan your campaign calendar around when your donors actually give. Align major appeals with peak quarters.
  • Contact Window Status: See whether right now is a good time to reach out to each donor, based on when they tend to give.
  • Peak Giving Month Band: Plan your campaign calendar around each donor's peak giving month.
  • Giving Regularity: Identify your most predictable givers. Highly Consistent donors are your most forecastable revenue source and strongest monthly giving conversion candidates.
  • Metronome Band: Identify which donors are most ready for a monthly giving ask. Priority donors should be first on your sustainer conversion list.
  • This Year Value Band: Use in any module to split donors into five current-year value groups. Updates automatically from your data.
  • Last Year Value Band: Use in any module to compare with This Year Value Band and see who has moved up, down, or stayed the same.
  • Donor Value Movement: See which donors upgraded, downgraded, lapsed, or stayed stable between last year and this year. Build targeted outreach for each group.
  • Donor Median Interval Band: Group donors by giving cadence: monthly, quarterly, twice a year, or annual.
  • Second Donation Speed Band: Group donors by how quickly they gave a second time. Fast converters retain better.
  • Primary Action Flag: Tells your team exactly what to do for each donor this week. Phone call, thank-you, upgrade appeal, monthly giving ask, or re-engagement outreach. Pull this list every Monday.
  • Action Clock Score Band: Group donors into urgency levels: Critical, High, Moderate, Low. Allocate your team's time across the levels.

The 20+ Behaviour audiences

  • Gave this year: People who gave at least once this year, from 1 January to today. This year's donors so far. Leave them out of a "we miss you" appeal.
  • Gave last year: People who gave at least once last year. The bottom of the retention sum: donor retention divides by this audience.
  • Gave year before last: People who gave at least once in the year before last. Two years back, for comparing full years.
  • Retained donors: People who gave last year and have given again this year. These are your kept donors. Donor retention is this audience divided by Gave last year. Divide by last year's donors, not this year's.
  • Gave last year, not yet this year (LYBNT): People who gave last year but have not given yet this year. The same people as Gave Last Year But Not This Year (LYBUNT). Your year-end recovery list. It and Retained donors add up to everyone who gave last year.
  • Gave before, not yet this year (SYBNT): People who gave in any year before this one but have not given yet this year. The same people as Gave Some Year But Not This Year (SYBUNT). Your wider win-back pool. Leave out the LYBNT audience to find people who stopped longer ago. People who have never given can't get in.
  • New donors this year: People whose first-ever gift was this year. Welcome them. Chart them by the month of their first gift, so each new donor counts once.
  • New donors last year: People whose first-ever gift was last year. Last year's new donors: the bottom of the new donor retention sum.
  • New donors last year, retained: People whose first-ever gift was last year and who have given again this year. New donor retention is this audience divided by New donors last year. It uses calendar years, first gift last year and a gift this year, so each donor is counted in the right year.
  • Volunteered this year: People with at least one timesheet this year. Your volunteers this year, counted as people. Someone with ten shifts counts once.
  • Volunteered last year: People with at least one timesheet last year. The bottom of the volunteer retention sum.
  • Volunteered year before last: People with at least one timesheet in the year before last. The bottom of the "kept from the year before" sum.
  • Volunteered this year and last year: People with timesheets this year and last year. Volunteer retention is this audience divided by Volunteered last year.
  • Volunteered last year and year before: People with timesheets last year and the year before. Divide by Volunteered year before last to see how many of that year's volunteers stayed on.
  • Volunteered 3 years running: People with timesheets in all three years. Your steadiest volunteers. Thank them by name.
  • Volunteers lapsing: People with a timesheet last year but none yet this year. Call them before the next event. It and Volunteered this year and last year add up to everyone who volunteered last year.
  • New volunteers this year: People whose first-ever timesheet was this year. Welcome them. Recruitment rate is this audience divided by Volunteered this year.
  • New volunteers last year: People whose first-ever timesheet was last year. Divide by Volunteered last year for last year's recruitment rate.
  • Lapsed volunteers: People whose last timesheet was more than a year ago. A welcome-back list: what has changed since they last came, and an easy way to return.
  • Volunteered before this year: People whose first timesheet was before this year. Everyone who started before this year. With New volunteers this year, it adds up to everyone who has ever volunteered.