Quick start
- On a matrix, click a cell, a segment's View records, a profile, a composite score or a movement number. On True segments or a History comparison, choose View records.
- A side panel opens with one row per ID, the largest value first.
- Type part of an ID in the search box, or pick a value from the filter. Choose Columns to show details kept from your file, such as fund, appeal or channel.
- Choose the arrow at the start of a row to see that person's transactions.
- Choose Export CSV to download every matching row, not just the page you're on, and look the IDs up in your CRM or mailing tool.
Where you'll find View records
View records is the list of people behind a number. It opens as a side panel, so you never leave the page.
| Page | What opens it | Who's listed |
|---|---|---|
| Grids (R × FM, RF, FM, RM, RFE, and the segments grid) | Click a cell with anyone in it | Everyone with that cell's two scores |
| Named segments | View records on a segment; a number in the movement table | Everyone in the segment; or everyone who moved from one segment to another (or is new) since a year before |
| Full RFM | A cell of a recency grid; a composite score; a profile's View records | Everyone with that exact profile, or that R + F + M |
| True segments | View records on a segment or in Likely to move up | Everyone in the segment, or everyone flagged |
| Matrix history Plus | View records beside a movement group in Compare | Everyone who moved up, stayed, moved down, is new, came back or dropped out between two snapshots |
Links appear once a build has finished and the group has anyone in it.
The columns
The panel's title names the group and how many people are in it, such as “Champions · 1,240 donors”, with a line underneath saying who's included.
Matrices
- ID
- The ID from your file or CRM.
- Giving or spend in window
- Their net amount in the window: counted transactions minus refunds. See which transactions count.
- # gifts or purchases
- Counted transactions in the window, not counting refunds.
- First
- Their first counted transaction anywhere in the file.
- Last
- Their latest counted transaction on or before the as-of date.
- Scores
- Their scores:
5-4-3(R-F-M),5-4-E2for RFE, orR5 · F4on the two-score grids.
True segments
- ID
- The ID from your file or CRM.
- Total given
- Their net amount over the whole file.
- Last 12 months
- Their amount in the 12 months ending on the latest transaction in the file — what the segments are measured on.
- # transactions, First, Last
- Counted transactions over the whole file, and the first and latest.
- Segment
- Their segment, by the name you've given it.
- Looks like, Signal and Why
- On likely-to-move-up lists only. See Likely to move up.
Matrix history
- constituentid
- The ID from your file or CRM.
- Group · earlier snapshot and Group · later snapshot
- Their segment, score band or row in each snapshot; “—” if they weren't in it.
- Value · earlier and later
- Their net amount in each snapshot's window (the last 12 months for True segments).
Snapshots keep IDs, groups and totals only, so history records can't be opened to see transactions and don't have detail columns.
A person's transactions
On matrices and True segments, choose the arrow at the start of a row to open that person's transactions underneath; choose it again to close them. Each shows its Date, Amount (with cents), Type in your organization's words, and the detail columns you've chosen. Matrices show transactions in the window, refunds included; True segments show every counted transaction. Newest first, up to the 500 most recent.
Detail columns from your data
When you upload a file, any extra column that isn't personal information — fund, appeal, campaign, channel, product category — can be kept with each transaction (“Keep as detail” on the upload's review step). When you pull from a CRM, the extra fields you pick are kept the same way.
Choose Columns to tick which kept details to show. The first two are shown to start with, and we remember your choice in this browser for that matrix. On a person's row, a column shows the value from their most recent transaction that has one (in the window, for matrices); on each transaction row, that transaction's own value. “—” means there's no value.
Search, filter, sort and pages
Search by ID
Type in the search box. The list narrows as you type, matching any part of the ID and ignoring capital letters. Search works on IDs only; there are no names to search.
Filter by a detail
With kept details, the filter menu (it starts as Any detail) lists values as “Fund: Annual Fund”, the 100 most common values of each column. Pick one to keep only people with at least one transaction that has it — in the window, for matrices.
Sorting
Choose a column heading to sort by it; choose it again to reverse. Lists start sorted by value, largest first (likely-to-move-up lists by signal). Detail columns don't sort.
Pages of 50
The panel shows 50 people at a time, with Previous and Next. Searching, filtering or sorting goes back to page 1. To work with everyone at once, export.
Export CSV
Export CSV in the panel downloads every person in the group as you've narrowed it — your search, filter and sort — across all pages, with the detail columns you've chosen.
What's in the file
| From | Columns |
|---|---|
| Matrix | id,value_in_window,transactions_in_window (RFE adds activities_in_window), first_transaction,last_transaction,lifetime_value,r,f,m (or e for RFE), score, segment on named segments, then one column per chosen detail. File: rfm-records-…csv |
| True segments | constituentid,total_given,last_12_months,gifts,first_gift,last_gift,tier, plus looks_like,signal,why on likely-to-move-up lists, then details |
| History | constituentid,tier_from,tier_to,given_from,given_to |
Amounts are plain numbers with two decimals, dates are YYYY-MM-DD. Any value starting with =, +, - or @ gets an apostrophe in front so a spreadsheet won't treat it as a formula. Each matrix also has Export CSV at the top for its segments, profiles or cells — see exporting a matrix.
Why you see IDs, not names
View records never shows names, because we never have them. Columns that look like names, emails, phone numbers or addresses are removed when a file is read and never stored. See how personal information is removed.
Everyone in your organization can open View records and export these lists. The AI assistant never sees them.
Looking people up
- For one or two people, copy the ID and search for it in your CRM or store system.
- For a list, choose Export CSV and use your system's import or list tools to match the ID column — to build a query, tag a segment or create a mailing or email list.
Worked example: a win-back list
A segments matrix shows At risk: 840 and Can't lose them: 210. The team wants to call the most valuable first.
- Choose View records on Can't lose them. The list is sorted by value in the window, largest first.
- Pick Channel: In-store (or Appeal: Year-end) in the filter to focus on one group.
- Choose Export CSV, then import the IDs into your CRM as a call list.
Questions
Does Export CSV include every page?
Yes: everyone who matches your search and filter, in your sort order.
Does the export include names or contact details?
No. We don't have them. Match the IDs in your own system.
Why do C-5 and c-5 show as one person?
IDs are compared ignoring capital letters, so transactions under either spelling belong to the same person.
Why does a detail column show a dash?
None of that person's transactions in the window have a value in that column.
Why is there no Columns button or filter?
The file has no kept detail columns. Keep extra columns when you upload, or pick extra fields when you pull from your CRM.
Will my column choices be remembered?
Yes, in this browser for each matrix.