Start your query:
  1. Go to Analysis> Information Library
  2. Click Add an ad-hoc query. 
  3. Select the source view of Revenue and click OK
Add criteria to Include Records Where: 
  1. To set your date range, drag Date from the middle column into Include Records Where. Set this to be the date range you are looking for. 
  2. Next, you will need to add filters to specify what types of revenue you'd like to count in your average gift calculation. To include all donations, highlight Application Details in the left column. Drag Application to Include Records where. Set this to be equal to Donation. To read more about using Application as a query filter, see our related solution What query filters should I use to find contributed revenue?
  3. (Optional) If you'd like to limit your average gift to specific designations, with Application Details still highlighted in the left column, drag Designation System Record ID to Include records where. Set this to be equal to or one of the designations you'd like to include. 
Add fields to Results Fields to Display: 
  1. First, remove the Date field from Results Fields to Display. 
  2. Next to get the average gift amount, highlight Amount in results fields to display. Click the Sigma symbol above Results Fields to Display and check the box for AVG which is the average: User-added image                                                     Note: This will give you the average of the full transaction amount, so if your organization does a lot of split transactions (donations with other items such as memberships or ticket purchases) or if you are filtering on a specific designation, you may want to consider using Application Details\Amount instead for your average. 
Finish Up: 
  1. Click Preview Results and see your average gift amount. 
  2. On the Set Save Options Tab, save your query for later use. You can also copy your query and use this for different date ranges if desired.