The easiest way to pull this list is to create a selection of members who have recently visited. You can then merge this list with a list of expired memberships to see all of your expired members who have still visited recently. 

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 expired 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 expired memberships with 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 expired members, from the middle column, drag Status from the middle column to Include records where. Set this to be one of Lapsed or Expired. 
  5. To find members that have expired recently, drag Expiration date from the middle column to Include records where. Set this to be on or after the expiration dates you'd like to include. For example: Expiration date is on or after 5/1/2016 would include only those members who have expired since May 1, 2016.
  6. (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. 
  7. 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 Yes. This will filter your query to find only memberships that are present in your recent visit query (and therefore have visited). Here is an image of what the query will look like: User-added image
  8. 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, Status, 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.