Filtering is a really powerful tool in Beacon, which helps you to customise the way you see your data. Below are 8 step-by-step examples of filters that you can create and save in Beacon.

You can find more general information on searching and filtering here, and then get stuck into these examples:

Easily differentiate between your one-off and recurring donations within Beacon

Overtime you may accumulate different kinds of donation payments in your account that you might want to filter by and report on. An example of this is One-Off vs Recurring donations.

Both of these payments are going to be type is - donation in Beacon. So what additional filter can we use to distinguish a one-off donation from a recurring donation?

Well …. In Beacon payments that are recurring will always be linked to a subscription record, and we can use this to help us refine our search.

Scroll to the bottom of you filter box and click Add filter.

And there you have it! Nice and easy! You have a list of either your one-off or your recurring donations.

From the people record type, select the filtering icon from the top right of the page and click on + Add Filter and then scroll down to select related payments.

Set the related field to Payer (default) and the metric to Sum of amount and set the filter to greater than £1000.

As above, from the people record type, select the filtering icon from the top right of the page and click on + Add Filter and then scroll down to select related payments.

Set the related field to Payer (default) and the metric to Number of Payments where it is greater than 0.

In order for it to find payments between £50-£100, 2 filters will need to be added, one to limit it to payments over £49 and another to limit the search to payments under £101.

To do this, click on FILTER PAYMENTS, ADD FILTER, select Amount and then set each amount in the provided fields.

Whenever we're considering a concept (in the case a 'new donor') it's always best to define the specifics to make filtering much easier! In this case, a new donor is a Person who:

From the People list page, add the first filter for 'Related payments'. We want to look for anyone with at least one donation Payment this year, so they would be the 'Payer' of the payment, and we filter the payments for their 'Payment date is this year' and also 'Type is donation'.

This gives us all the donors from this year, but will also include existing donors that have donated in the past. Let's exclude them so that we're left with only the new donors!

We'll add our second filter for 'Related payments' again. We're looking for people who have NOT made donations, so we'll use the 'Number of payments is 0' and then define what the Payments we don't want them to have would look like: 'Payment date before this year' and 'Type is donation'.

As with filtering for new donors, it's always best to define what we consider a lapsed donor. We're going to use two common definitions:

Both types of lapsed donor share a filter: No donations this year. Let's add that first!

From the People list page, add a filter for 'Related payments' with the following settings:

For LYBUNT lapsed donors, we'll also include a filter for having at least one donation last year.

Add another filter for 'Related payments' with the following settings:

We've now got our two filters:

For SYBUNT lapsed donors, we'll instead include a filter for having at least one donation any time before this year.

Add another filter for 'Related payments' with the following settings:

We've now got our two filters:

In this example, we're going to be setting filters to look for 4 different criteria. We want the results to show a list of people who:

To begin with, from the people record type, select the filtering icon from the top right of the page and click on + Add Filter and then scroll down to select related event attendees.

Now, to filter for people who attended events in the last year, click on filter event attendees.

Now we want to add two filters, one to limit it to events that happened no earlier than a year ago and a second to limit the filters to events that have not yet happened.

For both, begin by clicking + Add Filter and select event. Select meets criteria and change the field to start date.

This will now show all people who have attended an event in the past year. In order to only show those who have also made a payment of over £100 in the past year we need to click + Add Filter and select related payments from the dropdown menu.

Set the related field to payer (default) and the metric to sum of amount where the amount is greater than £100.

Now you filter will be showing all individuals who attended an event in the past year AND who have ever donated £100. In order to limit the results to people who have donated over £100 this year, we need to add the same date constraints as we did for the events.

Click on Filter Payments then + Add Filter. Select Payment Date from the dropdown menu where the payment was less than 365 days ago.

Select + Add Filter and again choose Payment Date where the payment was before today (default).

From the People record type, click on the filtering icon in the top right. Click + Add Filter and choose Related Event Attendees and click on Filter Event Attendees. Select Event and begin typing the name of the event you'd like to filter by. A dropdown list will populate any events that match what you've typed so far (think search bar). Select the even you'd like and voila! Your search filter is complete.

From the Payment record type, click on the filtering icon in the top right, click on + Add Filter, select Payer from the dropdown menu, and select Meets Criteria, and set the record type to Person.

Set the field to Related Gift Aid declaration where it is 0.