Start your query:
  1. Navigate to Analysis, then click on Information Library
  2. Click on Add an ad-hoc query
  3. Select source view of Memberships, then click OK.

Add fields to Include records where:
  1. For back office transactions: In the left column, expand Membership Transaction, then select Membership Promotion. From the middle column, bring Name into Include records where. Manually type the name of your membership promo and click OK.
  2. For front office transactions: In the left column, expand Membership Transaction, expand Revenue Application, expand Revenue Details, expand Sales Order, expand Sales Order Item, expand Sales Order Item Membership, expand Sales Order Item Membership Item Promotion, and select Membership Promotion. From the middle, bring Name into Include records where. Manually type the name of your membership promotion and click OK.
  3. Click first line for back office transactions in Include records where and click to Add left parenthesis. Click second line item for Front office transactions in Include records where and click the OR button. With second line still selected, click Add right parenthesis.
  4. To see only the primary member in your results, in the left column select Members. From the middle, bring Primary member into Include records where. Set this equal to Yes and click OK. 

Add fields to Results fields to display:
  1. To add Constituent name: From the left column, expand Member, then select Constituent. From the middle column, drag Name into Results fields to display. 
  2. To add how much the member paid for the membership for front office transactions: In the left column, expand Membership Transaction, expand Revenue Application, expand Revenue Details and select Sales Order. From the middle column, drag Amount into Results fields to display.
  3. To add how much the member paid for the membership for back office transactions: In the left column, expand Membership Transaction and select Revenue Application. From the middle column, drag Amount into Results fields to display.

Here is an example of what your final query will look like: 
User-added image