The easiest way to pull this list is to create a selection of members who have visited. You can then merge this list with a list of your active memberships to see all of your memberships that are active, but the members have not visited. 

Step 1: Create a selection of members who have visited
First, we will want to create a selection of any memberships where members have visited recently. Note: You don't need to limit this query to active members since we will do this in the second query. 
  1. Go to Analysis > Information Library 
  2. Click Add an ad-hoc query 
  3. Select the source view of Memberships and click OK. Note: We recommend using a Membership source view for this query to easily include visits from any member on the membership. 
  4. (Optional) If you'd like to limit this list to a specific membership program, from the middle column drag Membership Program to Include records where. Set this to be equal to your membership program. 
  5. From the left column, expand Members, then expand Constituent, then highlight Sales Orders. From the Sales Order node, you will specify what activities you'd like to count as a visit. Here are some options: ​
    1. If you'd like to limit your analysis to members with recent visits, from the middle column, drag Transaction Date to Include records where. Set this to be equal to the date of the transactions you'd like to include. 
    2. If you'd like to only count transactions that occurred in a specific sales method (for example: only Daily Sales), drag Sales Method Type to Include records where. Set this to be equal to or one of the sales methods you'd like to include. 
    3. To count only program purchases as a visit, expand Sales Orders from the left and then highlight Sales Order Item. From the middle column drag Type to Include records where. Set this to be equal to Ticket. 
    4. If you'd like to only count specific programs as a visit, expand Sales Order Item from the left, expand Sales Order Item Ticket, then highlight Program. From the middle column, drag Program record to Include records where. Set this to be equal to or one of the programs you'd like to include in your analysis. Here is an example of how the query might look when you're finished applying these criteria: User-added image
  6. On the Set save options tab, name your query and check the boxes to Create a Selection and to Show this selection in the Query DesignerUser-added image
Step 2: Create a query of Active Members without Recent Visits
  1. ​Go to Analysis > Information Library 
  2. Click Add an ad-hoc query 
  3. Select the source view of Memberships and click OK.
  4. To find Active members, from the middle column, drag Status from the middle column to Include Records Where. Set this to be equal to Active. 
  5. (Optional) If you'd like to limit this list to a specific membership program, from the middle column drag Membership Program to Include records where. Set this to be equal to your membership program. 
  6. From the left column, highlight the Selections folder. In the middle column, click the name of the selection you saved in Step 1. An Apply Criteria window will pop. Set this to be equal to No. This will filter your query to find only memberships that are not present in your recent visit query (and therefore have not visited). Here is an image of what the query will look like: User-added image
  7. Next, you can add anything additional you'd like to view about these members to Results Fields to Display: 
    1. From the Membership node at the top of the left column drag any of these details to Results fields to display: Expiration Date, Membership Level, Last Renewed, Member Since, etc. 
    2. To see the primary member name: From the left column, highlight Members. From the middle column, drag Is Primary to Include Records Where and set this to be equal to Yes. Next, expand Members, then highlight Constituent. From the middle column, drag Name to Results fields to display to output the name of the primary member.