Start your query: 
  1. Go to Analysis > Information Library 
  2. Click Add an ad-hoc query 
  3. Select a Source View of Constituents
  4. Click OK
Add filters to Include Records Where: 
  1. First, to find constituents that received your mailing, highlight Appeal Mailing in the left column. From the middle column, drag Mailing system record ID to Include Records where. Set this filter to be equal to your mailing. Your filter will look similar to this: Appeal Mailing\Mailing System Record ID is equal to Annual Appeal
  2. Next, output the Date Sent. Drag Date Sent from the middle column to Results Fields to display. It will display as Appeal Mailing\Date Sent 
  3. You will need to find constituents that made gifts after the mailing was sent. In the left column, highlight Revenue. From the middle column, drag Date to Include Records Where. Set the date filter to be Greater than or equal to. Next, instead of Value, choose Output field. Choose Appeal Mailing\Date Sent from the drop down. Your field will appeal like this: Revenue\Date is on or after Appeal Mailing\Date Sent.
  4. To filter only on the type of revenue that you are soliciting, use this field. From the left column, expand Revenue. Next, highlight Application Details. Drag Application to Include Records Where. Set this to be equal to the type of revenue you are reporting on (most commonly membership or donation). Your field will appear simi liar to this: Revenue\Application Details\Application is equal to Donation.
Add additional fields to Results Fields to Display: 
  1. If you'd like to see gift amount, use Revenue\Application Details\Amount 
  2. If you'd like to see what Sales Method this revenue came in, use: Revenue\Sales Order\Sales Method Type
  3. If you'd like to see the date of the gift, use: Revenue\Date