<aside> This help article provides an overview of the most common custom queries a gym might need to streamline day-to-day management, track member activity, monitor attendance, analyse performance metrics.

The Reporting Dashboard is available on the Enterprise and Above Tier.

</aside>

<aside> <img src="/icons/arrow-northeast_blue.svg" alt="/icons/arrow-northeast_blue.svg" width="40px" /> Looking to understand the Reporting Dashboard?

Reporting Dashboard Explainer

</aside>

<aside> ⚠️ ATTENTION:

Before creating a query, please save the filters you are going to need in the Advanced SORT page on your BETA dashboard.

</aside>

⤷Saving Commonly Used Filters

If you frequently run the same types of reports, save your filters for easy access. In the Advanced Sort , you can create and save commonly used filters.

For example, “Members” - for saving all Entry Types that constitute a “member”

This helps you quickly apply the same criteria across multiple queries without setting them up each time.

<aside> <img src="/icons/arrow-northeast_blue.svg" alt="/icons/arrow-northeast_blue.svg" width="40px" /> Looking to Saving Advanced SORT Queries as Templates

⤷ Saving Advanced SORT Queries as Templates

</aside>

⤷ Custom Query Examples - Members / Recurring Subscriptions

At BETA, we focus on recurring subscriptions rather than the broad term “member.” Using subscription-based queries gives a more accurate picture of engagement, retention, and growth for your recurring pass holders.

The examples below show you a few of the possibilities.

New “Members” (recurring pass holders) at a given time period

<aside>

This custom query tracks profiles with a specific entry type during a given period who did not have it in the previous period. It helps monitor the growth of recurring subscriptions.

</aside>

Continuing Members (recurring pass holders) at a given time period

<aside>

This custom query tracks profiles with a specific entry type during a given period who did not have it in the previous period, based on subscription transactions only. It helps monitor the growth of recurring subscriptions.

Note: You can also include a Transaction Source Filter For Returning, and Churned metrics, you can filter by subscription transactions only to focus on recurring activity. Using this filter may “miss” some profiles for New or Churned calculations — for example, a recurring pass purchased at the POS won’t be counted. Always consider how transaction source affects your results when interpreting these metrics.

</aside>