Queries provide a powerful way to access and filter data within BETA to generate reports and gain insights about your members, sales, staff and much more.
You can either use this BETA tool to generate custom or compound queries tailored to your gym's needs, or select from a range of our standard, ready-to-use queries available.
<aside>
⚠️ ATTENTION:
The Reporting Dashboard is fully available to gyms on BETA Enterprise & Custom.
You can generate queries, charts and views with ***owner permissions*** only.
</aside>
<aside> <img src="/icons/arrow-northeast_blue.svg" alt="/icons/arrow-northeast_blue.svg" width="40px" /> Looking to take a deep dive into the Reporting page?
</aside>
<aside> <img src="/icons/arrow-northeast_blue.svg" alt="/icons/arrow-northeast_blue.svg" width="40px" /> Understanding the differences between Queries, Charts and Views
⤷ Differences between Queries, Charts and View in BETA
</aside>
<aside> <img src="/icons/arrow-northeast_blue.svg" alt="/icons/arrow-northeast_blue.svg" width="40px" /> Looking to learn about BETA Insights Page
</aside>
<aside>
is a set of filters and rules that pulls raw data points from your BETA database (e.g., “forms signed in June”).
In BETA, there are three main query types:
These can further be divided into query categories, depending on what we want to see:
Each query category is designed to match the level of insight you’re looking for in your gym’s performance. Simply choose the type of query based on the specific metrics or areas you want to measure.
<aside>
No need to build queries from scratch as BETA provides a collection of pre-built standard queries. These ready-to-use queries help your team quickly access detailed insights into key performance areas.
</aside>
<aside>
Create and edit fully customizable queries at any time to suit your specific needs. These flexible tools empower you to explore your data in depth - whether you're tracking performance trends, analysing member behaviour, or evaluating operational changes. Dive as deep as you need to, whenever you need to.
</aside>
<aside>
Combine two or more queries, and perform mathematical calculations such as addition, subtraction, multiplication, or division.
</aside>
<aside>
Climber queries count unique profiles. Use this when you're interested in how many individuals meet certain conditions.
Example, How many climbers have a “10 punch pass”? How many climbers signed a document?
</aside>
<aside>
Sessions queries count visits. Use this when you're interested in how many visits meet certain conditions.
Example, How many sessions on a “10 punch pass”
</aside>
<aside>
Product queries for ****when you want to track product activity (what was sold). Chose this type when you are interested in how many of a specific product.
Example, How many 10 punch passes were refunded? How many cakes were sold?
</aside>
<aside>
Totals queries sums financial data. Use this type when you want to understand total revenue.
Example, How much revenue was generated on sales “10 punch pass”? How much in refunds was processed for the category? How much money did I make in cake sales?
</aside>
Screen Recording 2025-11-12 at 13.36.29.mov
<aside>
</aside>