You will need the Reporting permission to use the Query Builder. What the columns show follows your campus and organization reach.
In Reporting > Query Builder, the right-hand Columns panel controls which columns appear in the results and the order they appear in.
Reordering columns
In the Columns panel, each column row has a drag handle (the three horizontal lines) on its left side. Click and drag a row's handle up or down to change where that column appears in the results table.
Adding or removing columns
To remove a single column, click the X icon at the right end of the column's row. The row disappears immediately.
To add columns, or to make a larger set of changes in one place, open the menu in the top-right corner of the Columns panel. It has two options.
Choose columns
Opens a side panel with every available column, grouped by category (General, Additional, Contact, and so on) and matching the categories in the Filters panel. Use the checkboxes to add or remove columns. Helpful controls inside this panel:
Search for columns below… - type to narrow the list to matching column names.
show selections only - toggles the view to display just the columns currently checked.
check all / uncheck all - apply to the category they appear under, not the whole list.
Close the panel when done. Selections appear immediately in the Columns panel in the order they were checked. Drag rows to rearrange them.
Reset columns
Restores the default set of columns: First Name, Last Name, Gender, Birthday, Age, Campus, Primary Email, and Primary Phone. Any custom columns will be added.
Tip: Save the column selections to a query so they're ready next time. Click Save as… at the top of the query builder to store the current filters, columns, and sorting as a named saved query.
The Organization column
If your account has more than one organization, an Organization column is available. On a Contributions query it also appears while an archived organization still owns giving, even when only one organization is active.
The column shows only organizations you can reach, so read it this way:
Organization names - the organizations the record belongs to that you can reach.
Blank - the record belongs only to organizations you cannot reach. A blank cell does not mean the record has no organization.
All Organizations - the record is available to All.
Choosing the organization for giving
Once giving is split by organization, a query that reads giving reads one organization:
A Contributions query has an Organization field at the top of Display.
A People query with a giving column or filter asks for the organization the first time it runs, then shows the field.
The organization is saved with the query. Without one, a link or schedule that uses the query is refused, and a list that uses the query as an audience reads every organization. How can I schedule query builder results and built in reports be emailed? explains scheduling.
Warning: Some giving totals add organizations together unless you narrow them. The Batches overview cards, the recurring gifts overview and Query Builder totals can all add giving across organizations, which is how a figure ends up doubled. Choose one organization, or narrow your campus selector, before you compare totals. The Contributions list has an Organization column and shows no total.
Which organization does a gift belong to? explains how a gift gets its organization.


