Start your query: 
  1. Go to Analysis > Information Library 
  2. Click Add an ad-hoc query 
  3. Select a Source View of Constituents, and click OK
Add filters to Include Records Where: 
  1. In the left column, expand Appeal Mailing, then select Appeals. From the middle, drag Appeal record into Include records where. Set this Equal to General Membership.
  2. In the left column, select Appeal Mailing. From the middle, drag Date Sent into Include records where. Set this Equal to the date of the membership renewal that you want to review.
  3. 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 On or after 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: 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 Membership.
Add additional fields to Results Fields to Display: 
  1. To see membership cost: Revenue\Application Details\Amount 
  2. To see what Sales Method this revenue came in: Revenue\Sales Order\Sales Method Type
  3. To see the date of the membership renewal: Revenue\Date