Knowledge base › Using StudioHub › Finding Contacts

How To Find Everyone Who Booked A Trial But Didn't Sign Up

Updated October 1, 2026

Want to send an offer to everyone who booked a trial class recently but never signed up? StudioHub can pull that list for you. You filter your opportunities for trials that are still open, pick a date range, and export the list. It takes about two minutes.

Before you start

Each lead in StudioHub has an opportunity: a card in your pipeline that moves from stage to stage (New Lead, Appointment Booked, Showed and so on). While someone hasn't registered, their opportunity stays Open. Once they register, it's marked Won. So "booked a trial but didn't sign up" means an opportunity that is still Open and sits in one of the appointment stages.

Pull the list

  1. In the menu on the left, click Opportunities.
  2. At the top left, make sure Pipeline 1 is picked. That's the pipeline your trial bookings go through. If you see an older pipeline such as Regular Classes, don't use it.

The pipeline picker at the top left of the Opportunities page, showing Pipeline 1

  1. Click the blue Advanced filters button. A panel opens on the right.
  2. The first filter should read Status, Is any of, Open. It's usually there already. If it isn't, click Add filter, choose Status, and pick Open.
  3. Under that filter, click + Add nested filter. Use this one, not the blue Add filter button, so both rules have to be true at once.

The Advanced filters panel with Status is any of Open, and Add nested filter outlined

  1. Click Please Select and choose Stage. Leave it on Is any of.
  2. Click the box under it and tick the four appointment stages: Appointment Booked, Appointment Canceled, No Showed and Showed. Each stage has its pipeline's name in brackets after it, so pick the ones that end in (Pipeline 1).

The Stage list with Appointment Booked, Appointment Canceled, No Showed and Showed ticked

Only want people who actually came to their trial? Tick just Showed instead of all four.

  1. Click somewhere empty in the panel to close the list. Then click + Add nested filter again.
  2. Click Please Select and choose Last stage change date. Leave it on Is.
  3. In the box under it, choose Between. Click the date box next to it, click the first day of your range, then the last day, then click Confirm. For "the last two months", that might be August 1 to September 26.

Last stage change date set to Between, with August 1 to September 26 picked and Confirm outlined

Tip: end your range a few days before today. If it runs right up to today, the list includes people who only just booked and haven't had their trial yet.

  1. Click Apply at the bottom of the panel.

The finished filters, Status, Stage and Last stage change date, with Apply outlined

Your pipeline now shows only the people who booked a trial in that date range and haven't registered.

Export the list

  1. Click the three dots at the top right, next to Add opportunity, and click Export.

The three-dots menu open on the Opportunities page, with Export outlined

StudioHub creates a CSV file of the list, which you can open in Excel or Google Sheets. That's your list, ready for your offer.

Questions? Email us at support@getmorestudents.com.