Skip to main content

How to create, schedule, and export custom reports

Create and share custom reports, filter data with greater precision, and automate scheduled reports.

Written by Alyssa

➕ This feature is only available to Givebutter Plus users.

Givebutter Plus is a paid subscription service that gives you access to buttery advanced features to help you raise more. Read more about Givebutter Plus →

Reports give you a clear view of your fundraising without exporting data to a spreadsheet. Start from a ready-made report on giving, donors, recurring plans, pledges, or engagement, set your date range, and compare against a previous period to see what changed. From a report, you can find the supporters who need attention and email them directly. You can also build and save your own custom reports, export them and schedule them to send automatically. The Reports page is split into two main areas:

  • Reports for you holds ready-made reports that fill in with your account's data automatically, so there's nothing to set up.

  • Your reports (previously called Custom reports) holds the custom reports you build and save.

Reports include transactions from archived contacts and $0 transactions, such as free tickets, so totals may differ slightly from other pages in your dashboard.

Ready-made reports 📌

Each ready-made report brings together the charts and tables fundraisers check most often, organized into sections. Select a report under Reports for you to open it.

To read about each report, view example data, and see a full list of data included in a specific report, click a report name in the toggle list below.

Giving Overview

A snapshot of what you've raised and how. It includes funds raised, number of donors and average gift, giving by gift size, breakdowns by giving type and payment type, and an interactive map of where your donations come from, where you can drill down to the individual records behind each donation.

  • Funds raised – Everything given this period, on the gift amount before fees. (Chart available when this option is selected.)

  • Donors – Distinct people who gave in this period. (Chart available when this option is selected.)

  • Average gift – The average amount per gift, free tickets and registrations included. (Chart available when this option is selected.)

  • Recurring share – How much of this period's funds raised came from recurring gifts rather than one-time ones. (Chart available when this option is selected.)

  • Funds raised by location (map) – Where gifts came from. US gifts are grouped by ZIP code and international gifts by country, with the change versus the previous period.

  • Funds raised by giving type (chart) – Funds raised this period by what was given. A gift that includes more than one kind, like a ticket with a donation added, is divided between them, so the bars add up to funds raised.

  • Funds raised by payment method (chart) – Funds raised this period by how the gift was paid. Digital wallets count as cards. Gifts with no method recorded are shown together.

  • Donors

    • New donors – Donors who gave for the first time in this period, newest first.

    • Donors by gift size – Donors by the total they gave this period, before fees. Every donor lands in a band, so the bands add up to the donor count.

    • Donors by giving frequency – How many donors gave once, twice, or many times in this period.

    • Top donors – Donors who gave the most in this period, by total given.

Recurring Giving

Shows the health of your recurring program. See plan status, payment types, plans at risk, why plans ended (canceled by the donor or ended after a failed payment), and a retention table showing how many plans are still active in the months after they start.

  • Active plans – Recurring plans with an active status at the end of this period. Paused, past-due, and canceled plans are not counted. (Chart available when this option is selected.)

  • Monthly recurring revenue – Committed monthly value of the plans active at the end of this period, on the gift amount. Quarterly and yearly plans count at their monthly share. Paused and past-due plans are left out. (Chart available when this option is selected.)

  • Recurring plan retention – Of the plans billing when this period began, the share still billing at its end. A plan is billing if a successful charge landed within its last cycle plus ten days of grace. (Chart available when this option is selected.)

  • Average plan size – Monthly recurring revenue divided by active plans. A yearly plan counts as a twelfth of its charge. (Chart available when this option is selected.)

  • Recurring vs. one-time funds raised (chart) – Funds raised in each stretch of this period, split by whether the gift came from a recurring plan.

  • Recurring payment methods – Plans active at each point in this period, by how they pay. Digital wallets count as cards.

  • Plan status – Current status of every plan that had started by the end of this period. Statuses are as of today, so Canceled includes plans canceled before this period began.

  • At-risk plans – Recurring plans that had started by the end of this period and are stuck on a failed payment today, most overdue first.

  • Retention

    • Plans no longer billing (chart) – Monthly value of the recurring plans that stopped in each period, by why they stopped. Canceled plans are dated by their cancellation and expand into the reasons given. Payment failed is plans whose card or bank retries all failed, dated by the charge that failed. Plans still being retried are not counted yet.

    • Recent cancellations – Recurring plans that ended or were canceled in this period, newest first.

    • Plan retention by start month (chart) – Of the recurring plans started each month, the share still billing at the end of each later month, counting the start month as month one. A plan counts as billing while a successful charge covers its cycle plus ten days of grace, so quarterly or yearly plans count until their next charge is due. Months still in progress are left out.

Donor Health

Tracks how your donor base is changing over time. See new, repeat and lapsed donors, your top donors, donors who have given more or less than before, and how many donors you're retaining.

  • Donors – Distinct people who gave in this period. (Chart available when this option is selected.)

  • New donors – Donors whose first gift within the current filters landed in this period. With no filters, their first gift to your account. (Chart available when this option is selected.)

  • Repeat donors – Donors in this period who had given before it: those retained from the comparison period plus those reactivated. New and repeat donors add up to the donor count. (Chart available when this option is selected.)

  • Lapsed donors – Donors who gave in the period before this one and have not given in this one, by lifetime giving. (Chart available when this option is selected.)

  • Donor giving trends (chart) – Donors from the comparison period, grouped by how their giving changed this period: heating up (gave over 20% more), steady (stayed within 20%), cooling off (gave over 20% less), or lapsed (stopped giving).

  • Donor spotlight

    • Top donors – Donors who gave the most in this period, by total given.

    • Donor upgrades – Donors giving meaningfully more this period than last, by the size of the increase.

  • Donors to reengage

    • Donor downgrades – Donors still giving but meaningfully less this period than last, by the size of the drop.

    • Lapsed donors – Donors who gave in the period before this one and have not given in this one, by lifetime giving.

  • Donor retention

    • Donor retention over time (chart) – The retention rate as of each date in the window. The dashed line is the same measure for the comparison period.

    • New, retained, and reactivated donors (chart) – Donors giving in each stretch of the window: new if this period held their first gift, retained if they also gave in the comparison period, reactivated if they gave earlier and came back. A donor keeps one label throughout.

Engage Momentum

Shows how your Engage messages are performing, with a focus on funds raised from your outreach and deliverability across all of your messages. Filter by channel (email, text or mailings), then by individual message.

  • Funds raised – Funds from gifts made after clicking a tracked link or scanning a mailing QR code in a message sent this period. Gifts without a click or scan are not attributed. Each gift is placed on the message's send date. (Chart available when this option is selected.)

  • Donors – Donors whose gift followed a tracked link click or a mailing QR code scan from a message sent this period. Each donor is placed on the message's send date. (Chart available when this option is selected.)

  • Gifts – Gifts attributed to your messages through tracked link clicks and mailing QR scans, placed on the message's send date. (Chart available when this option is selected.)

  • Average gift – Attributed funds raised divided by attributed gifts. (Chart available when this option is selected.)

  • Engagement funnel (chart) – How your outreach narrows from sent to a gift, counted per recipient across email, text, and mail. It stops at the steps every channel shares. For click rates, switch this report to the Email or Text messages view, because a letter has no click step.

  • Funds raised by channel – Attributed funds by channel, placed on the date the message was sent.

  • Top messages by revenue – Messages sent in this period whose tracked links and QR codes drove the most revenue.

  • Deliverability

    • Messages sent – Sends counted per recipient across every channel, so one email to 500 people counts 500 and a mailing of 500 letters counts 500.

    • Recent sends – Messages sent in this period, newest first.

Pledges

Follows your pledges from commitment to collection. See how much was pledged and collected in a period, what's still outstanding, and which pledges are overdue and need follow-up. Forward-looking charts show when you can expect pledge payments to come in.

  • Pledged – The amount promised by the pledges made this period, on the date they were pledged. A commitment, not money received. (Chart available when this option is selected.)

  • Pledges made – How many pledges were made in this period, counted on the date they were pledged. (Chart available when this option is selected.)

  • Collected this period – Payments recorded against a pledge that arrived this period, whichever period their pledge was made in. Collected to date, further down, is the running total across every period. (Chart available when this option is selected.)

  • Scheduled – Installment payments falling due inside this period, on every pledge that was not canceled. What the schedules said should arrive, beside Collected this period, which is what did. (Chart available when this option is selected.)

  • Payment schedule (chart) – How the pledges made this period are set up to be paid.

  • Pledge size (chart) – Pledges made this period, by the total amount pledged.

  • Pledge types (chart) – The amount pledged this period, by the kind of commitment it was.

  • Portfolio health – Where every pledge stands at the end of the selected period.

    • Outstanding balance – What the pledges still standing had left to pay. Canceled pledges owe nothing and are left out. (Chart available if selected.)

    • Collected to date – Every pledge payment received so far, counting pledges of any age. The line only rises, since it is a running total rather than a per-period figure. (Chart available if selected.)

    • Canceled to date – What canceled pledges had promised, added up over time. Money that was committed and then withdrawn. (Chart available if selected.)

    • Pledge status – Every pledge made by the end of this period, by where it stood then. Off schedule means the installments due by then came to more than the pledge had paid. Every pledge lands in one of the four, cancellations included.

  • Current and upcoming – Where pledges stand as of today, and what is scheduled to arrive.

    • Scheduled receipts and run-off – Columns are what the installment schedules had falling due each year from the start of the period. The dashed line is the outstanding balance at each year end: actual for years already behind us, and from this year on what would remain if every installment were paid on time.

    • Overdue pledges – Every pledge with a missed installment, whenever it was made, longest overdue first.

    • Largest outstanding pledges – Every active pledge, whenever it was made, with the most still to collect first.

Date ranges + filters 📅

Most ready-made reports have the same set of filters at the top: a date range, a comparison period and a campaigns filter to include or exclude specific campaigns. Some reports have extra filters, like giving types on Giving Overview, and channel and message on Engage Momentum. When you choose a comparison period, most line charts show your selected period in blue and the comparison period in orange. Some charts always show the current status, whatever dates you pick, because they reflect where things stand today. For example, plan status in Recurring Giving and overdue pledges in Pledges always show what's true as of today.

  • Open a report, then click the date range at the top and choose a preset range or set custom dates.

  • Choose a comparison period (or None) to see the change against an earlier period.

  • Use the Campaigns filter to include or exclude specific campaigns.

Download data ⬇️

Tables in ready-made reports can be downloaded in CSV format, so you can work with just the data you need, like a list of overdue pledges. Ready-made reports can't be scheduled or shared by email. To send report data automatically, create a custom report under Your reports and schedule it.

  • Open a ready-made report and find the table you'd like to download.

  • Click Download in the upper right corner of the table.

Downloads of up to 50,000 records save directly in your browser. Larger downloads are sent to your email as a link instead.

Emailing supporters ✉️

Some tables in ready-made reports let you email the supporters listed, so you can act on what you see right away. For example, the Donor downgrades table in Donor Health lists donors who are giving less than they have in the past, and you can reach out to re-engage them directly from the report. A pop-up shows how many of the listed supporters are eligible to receive communications before you create your draft. Your email opens in the Engage email editor with those supporters already selected as recipients.

  • Open a ready-made report and find the table you'd like to use.

  • Click Email in the upper right corner of the table.

  • Review how many supporters are eligible to receive communications, then click Create draft.

  • Write your email, then review your recipients in the Recipients tab. Uncheck anyone you'd like to leave out.

  • Send your email, or save it as a draft.

Your reports 🗂

Your reports (previously called Custom reports) holds the custom reports you build from scratch or from a template. Custom reports let you choose exactly which contacts or transactions to include, which columns to show, and how to visualize them.

Unlike ready-made reports, custom reports can be exported in full, shared by email and scheduled to send automatically.

To create a new report, click the New report button in the Your reports section of the Reports page. You'll be asked if you want to begin from a template or start from scratch. Both options are entirely customizable.

Report templates 🧩

You can select pre-built reports from a selection of templates for popular use cases. Template reports can be viewed, exported, and shared as-is, but you can also use them as a starting point and customize them to meet your needs.

LYBUNT

LYBUNT (Last year but unfortunately not this year) reports help identify lapsed donors, making it easier to re-engage them and build a stronger support base. This can lead to more predictable revenue and better budgeting.

  • Report type: Contacts

  • Template parameters:

    • Filter – Transactions between 1/1 and 12/31 of last year

    • Filter – No transactions between 1/1 and 12/31 of this year

New Donors

A new donor report helps assess campaign effectiveness, identify growth areas, and turn first-time donors into recurring supporters. Tailored communications can increase future engagement and strengthen your donor pipeline.

  • Report type: Contacts

  • Template parameters:

    • Data table – "First time supported at" column

Recurring Donations

A total recurring transactions report shows repeat donations, helps identify trends, and measures donor commitment. This helps keep donors engaged and build a steady stream of support.

  • Report type: Transactions

Recurring Donors

Recurring donor reports help forecast revenue, strengthen relationships, boost retention, and provide personalized outreach. This helps maximize donor potential, increase contribution amounts, and foster a stable donor base.

  • Report type: Contacts

Retained Donors

A retained donor report tracks loyal supporters, identifies patterns, assesses engagement strategies, and identifies potential candidates for long-term giving.

Shows donors who have donated more than once, within the last two years.

  • Report type: Contacts

  • Parameters:

    • Filter – Has transactions between 1/1 of last year and 12/31 of this year

    • Filter – Has transactions count: greater than 1

Top Donors

Top donor reports help identify and strengthen relationships with your most impactful supporters. Personalized communication, updates, and recognition can deepen engagement and encourage continued support.

  • Report type: Contacts

  • Parameters:

    • Data table – "Total transacted", sorted from most transacted to least transacted

Total Transactions

A total transaction report gives you a clear picture of how much your organization has raised over a set period, tracks donor behavior, and helps time campaigns based on peak giving times for best results. It can also improve revenue forecasting.

  • Report type: Transactions

Creating from scratch ✍

Select a category for the type of report you want to build:

  • Contacts – Create a contact-based report for all of your contacts.

  • Transactions – Create a transaction-based report for all of your transactions, including auction bids, donations, and tickets.

Every report, whether built from a template or from scratch, must be given a unique name to proceed (limit 50 characters). You cannot create multiple reports with the same name, even if they have the same parameters.

To begin building your report, you'll have the option to edit the Report name you set, and add an optional description (no character limit).

report details

Customizing your report ✏️

Date ranges

To customize the date range of the visualization (as applicable) and the data table, you can configure custom date ranges.

  • For contact reports, the selected date range filters the table by the date a contact was created.

  • For transaction reports, the selected date range filters the table by the date a transaction was made.

Date range options include today, last 7 days, 14 days, 4 weeks, 3 months, 12 months, month-to-date, quarter-to-date, year-to-date, all-time, or a custom date range. If working from a template, you can still edit these dates.

Filters

To add filters to your data, click the Filter button. You can select multiple cumulative filters to further narrow down the information included. Available filter options differ based on the type of report category you're creating.

filter button

Full list of reporting filters (Transactions)

  • Date

  • Amount

  • Contact

  • Campaign

  • Fund

  • Team

  • Team member

  • Payment status

  • Payment method

  • Check deposited

  • Creation type

  • Acknowledgment

  • External label

  • Auction item

  • Campaign matches

  • Number

  • Plan ID

  • First name

  • Last name

  • Company

  • Email

  • Phone

  • Amount

  • Status

  • Acknowledged at

  • Created at

  • Transacted at

  • Contact ID

  • Street 1

  • Street 2

  • City

  • State

  • ZIP

  • Country

  • Donor name

  • Recurring status

  • Campaign title

  • Creation source

  • Payment method

  • Check number

  • Team name

  • Team raised

  • Team member first name

  • Team member last name

  • Team member email

  • Team member phone

  • Team member raised

  • Donor first name

  • Donor last name

  • Donor email

  • Donor phone

Full list of reporting filters (Contacts)

  • Contact

    • First Name

    • Last Name

    • Primary Email

    • Primary Phone

    • Website URL

    • LinkedIn URL

    • Facebook URL

    • Total Contributions

    • Recurring Contributions

    • First Donation Date

    • Last Donation Date

    • Last Donation Amount

    • First Time Supporter At

    • Date

    • Birthday

    • Bidder Status

    • Widget Sign-ups

    • Trackable Messages

    • Received Mailing

    • Tag

    • Custom Fields

    • Address

    • Activity

    • Last Communication Date

    • Created At

    • Total Transacted

    • Gender

    • Date of Birth

    • Company

    • Title

    • Note

    • X URL

  • Donorsearch

    • Donorsearch Rating

    • Major Gift Likelihood

    • Lowest External Gift Amount

    • Total Likely External Gift Amount

    • Annual Gift Likelihood

  • Transactions

    • Transactions Count

    • Date Added

    • Amount

    • Contact

    • Campaign

    • Fund

    • Team

    • Team Member

    • Status

    • Payment Method

    • Check Deposited

    • Creation Type

    • Acknowledgement

    • External Label

    • Auction Item

    • Campaign Matches

  • Team member

    • Campaign Members Count

    • Amount Raised

    • Fundraising Goal

    • Supporter Count

    • Date Registered

  • Tickets

    • Tickets Count

    • Date

    • Status

    • Ticket Type

    • Campaign

    • Custom Fields

    • Event

    • Promo Code

  • Transaction Plan

    • Transaction Plans Count

    • Amount

    • Created On

    • Next Bill Date

    • Status

    • Payment Method

    • Fund

    • Frequency

  • Pledge

    • Pledges Count

    • Amount

    • Amount Fulfilled

    • Remaining Balance

    • First Installment Date

    • Next Installment Date

    • Fulfillment Date

    • Status

    • Type

    • Fund

    • Installment frequency

Data table

Once you're happy with the filters applied to specify the contacts or transactions included in your report, you can customize the information shown in the report data table. Click the table icon to check or uncheck information to appear in your report.

data table options

Some column items include a graph/visualization icon. If your data table includes one or more of these, your report will include a graph. If your report doesn't include any of these columns, your report will not include a visualization.

visualization icon

Full list of data table options (Transactions)

  • First name

  • Last name

  • Email

  • Amount

  • Transacted at

  • Number

  • Plan ID

  • Company

  • Phone

  • Status

  • Acknowledged at

  • Created at

  • Contact ID

  • Street 1

  • Street 2

  • City

  • State

  • ZIP

  • Country

  • Donor name

  • Recurring status

  • Campaign title

  • Creation source

  • Payment method

  • Check number

  • Team name

  • Team raised

  • Team member first name

  • Team member last name

  • Team member email

  • Team member phone

  • Team member raised

  • Donor first name

  • Donor last name

  • Donor email

  • Donor phone

Full list of data table options (Contacts)

  • First name

  • Last name

  • Primary email

  • Contact since

  • Total transacted

  • Total donated

  • First donation date

  • Last donation date

  • Last donation amount

  • Gender

  • Date of birth

  • Company

  • Title

  • Note

  • Website URL

What's the difference between adding filters and customizing the data table?

  • Filters narrow down the contacts or transactions included in your report.

  • Data table customizations add or remove information (columns) pertaining to the contacts or transactions that meet your report parameters.

Visualizations

To generate a visualization for your report, click on the column you'd like to use to create the chart/visualization. In the dropdown menu, click Visualize.

visualize

By default, any reports containing visualizations will include both the current period (as defined by the selected date range) and the previous period. You can specify the current period date range, and the previous period will automatically reflect the same date range from the previous year. The previous period cannot be customized at this time. To remove a data set, click on the legend/title of the data you'd like to remove – clicking will strike it out and remove it from the chart.

To change the date range in the visualization, edit the date parameters for the report itself. The chart will then update to the new dates.

Saving a report 💾

To save your report, click the Save button at the top of the page. If you've edited an existing report, these edits will apply to any scheduled reports that you've already set up. A saved report will be stored under Your reports.

save

You do not need to immediately download or send a report – you can save the report in your dashboard and come back to it later.

Exporting a CSV 📨

To export a custom report as a CSV (spreadsheet) file, click the blue Share button in the upper right, and select Export CSV. A copy of your report will be sent to the email address you're logged in with.

export as csv

Please note that CSV files do not support graphs/visualizations, if applicable to your report.

Sharing via email 📬

To send a custom report by email, click the blue Share button, then select Share via email.

share via email

On this page, you'll see a summary of this report, including:

  • The name of the report

  • Number of rows in the data table (records)

  • The report date range

summary

Next, you'll be prompted to fill out the Subject and recipients (Send to) of this email – both of these are required fields. You can optionally add a message to include as well.

To email this report to admins on your Givebutter account, select them from the pre-loaded options, or click in the Send to box to see a list of all admins on your account.

To email this report to someone else, whether it's someone at your organization who isn't a Givebutter admin (or someone outside your organization entirely), you can click in the Send to field and type email addresses manually, separated by a comma.

By default, the frequency for this report will be set to send One time, and the send date will be set to Immediately. Clicking Send in the upper right corner will send this report right away.

Scheduling reports ⏰

To send a One time report at a later date and time, click On date. Here, you can select a date and time to automatically send the report in the future.

To send a report automatically on a pre-determined recurring schedule, select Recurring. This is an ideal choice for automating your reporting to organizational staff, admins, or board members.

Recurring reports use the original filters you set, including fixed date ranges. Reports do not automatically update/change these date ranges.

If you schedule a report with a Between date filter, it will continue to pull data from that same date range, even after the date range has passed. To ensure your report includes new data over time, we recommend using an After filter instead.

Schedule options include:

  • Daily – Select the time to send the report

  • Weekly – Select the day of the week (ie. Monday) and time to send the report

  • Monthly – Select the day of the month (ie. 15th) and time to send the report

Scheduled reports will appear in a recipient's inbox with the customized Subject/Message and a download link. The link for a scheduled report is good for 72 hours, after which it expires and must be resent.

sample scheduled report link

FAQ 🤔

Is the default report date range a fiscal year or a calendar year?

The default report date range for most report templates is year-to-date (calendar year). Fiscal years can vary from organization to organization – you can customize your date range to suit your fiscal year as needed.

Why don't my report totals match other pages in my dashboard?
Reports include transactions from archived contacts and $0 transactions, such as free tickets. Other pages in your dashboard may leave these out.

Can I use reports without Givebutter Plus?
Reports are a Givebutter Plus feature. Every account can still export transactions, end-of-year giving summaries and payout details for free.

Why doesn't my report include a graph or visualization?

  • Your report doesn't include any data columns that support visualization. Data columns that support visualization are indicated by a small graph icon in the data table menu.

  • Reports created from scratch may not display a visualization by default. Click on the supported column heading for the data column you'd like to create a visualization for and click Visualize.

  • You exported as a CSV – unfortunately, CSV files do not support images.

Did this answer your question?