Because Funraise lists are dynamic, they’re great for recurring workflows. By dynamic, we mean that items can fall into or out of the list based on the filters you’ve saved.
Before we jump in, it’s important to note that creating lists is the simplest way to organize your transaction data in Funraise, but it’s not the only way. If you’re looking for more complex filtering functions or want to configure the view of your reports, definitely check into our custom reporting feature called Fundraising Intelligence.
Alright, let’s get this party started!
Start by adding a filter for status = complete. Important side note: Funraise’s transactions section contains transactions of all statuses, including failed transactions. What that means for you is that in most cases, you’ll want to start your list by filtering for status = complete so that your lists reference successful payments.
Next, add a date filter. Rather than an exact date, you can add a relative, or magic date, of this month.
After we apply these filters, we’ll be looking at successful transactions that occurred this month—and we’ll be ready for our monthly reporting meeting!
Now, give this list a name... and save it.
Assuming you created a page on your website and embedded a specific giving form on the page, you just need to add a filter for that giving form, and Boom! List created.
A big part of major gifts management is forecasting and collecting on pledges made by your major donors. As you may already know, you can track donation pledges by creating an offline transaction and marking it as a pledge—and you can mark the pledge as received when you get the money.
With that in mind, it’s a good idea to set the date for your pledges based on when you expect the commitment to be fulfilled.
Let’s assume you’re building a list to forecast pledge fulfillment for Q4 of 2020.
Upon applying these filters you’ll see all the pledges that are expected to be fulfilled in Q4 of 2020. This list shows us potential donations we need to be focused on as well as helps us forecast expected revenue.
There’s a lot more you can do with pledges, but hopefully this example provides a quick guide.
Advanced example warning! There are a lot of ways to measure the ROI of your marketing campaigns. For example, you could pass donation data back to an ad platform using Funraise Giving Form Event Handlers, which is probably what your marketing would prefer.
For now, let’s talk about how you can build transaction lists with UTM data inside Funraise. We’re not going over UTMs in this video, but basically, they’re the five url parameters that enable tracking of online marketing performance across sources and campaigns.
This example assumes your team is using UTMs correctly.
When UTM data is available with a Transaction, the data is visible on the transaction profile and can be used with transaction filters.
Let’s start with Source = Facebook.
When you apply this filter, you’ll see Transactions that occurred after a donor was directed to your site from a link on Facebook.
Say you ran a specific ad campaign with a budget of $500 on Facebook. You can add a filter for UTM Campaign and enter the campaign name.
When you apply these filters you’ll see the amount actually raised from your ad campaign.
It’s worth repeating, so we’ll say it again: there are many ways to monitor marketing influence. Tracking UTMs with a transaction list is the most basic way to see marketing campaign performance.