Standard Queries: Set Up & Examples

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.

ATTENTION:

The Reporting Dashboard is fully available to gyms on BETA Enterprise & Custom.

You can generate queries, charts and views with owner permissions only.

⤷ Reporting Queries, Overview

To understand what is a Query in BETA, as well as gain insights into the Query Types & Categories you can use, please read the full Reporting Dashboard Explainer.

⤷ Standard Queries

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.

› Create a Standard Query

You can generate a query with owner permissions.

To access the reporting page, please go to Insights page on your BETA dashboard and find the Go to reporting page button on the right top corner of the filters` function.

› Available Standard Queries

Members as defined by BETA’s standard queries - namely everyone with a pass with an expiry greater than one day and excludes infinite duration entry types.

ATTENTION, your definition of "member" may not meet the BETA standard definition, in which case a custom query is better suited for your membership tracking.

» Members Count

This query retrieves membership statistics for a specified time period. When you provide a start and an end date, the query checks all climbers with active passes for the gym during the selected period.

If you are using a multi-gym setup, the results are broken down by facility — for example: Gym A: 50 members, Gym B: 60 members.

You can see an example in BETA demo by filtering with:

• Period: Monthly

• Type: Standard

» New Members Per Facility

A query that generates a report on new members

Helpful to define membership growth trends and seasonal patterns (if you split by time periods).

• When isChurn = false:

  • Calculates new member signups

  • Tracks membership growth

» Churn Per Facility

A query that generates a report on the members who left. Helpful to define membership decline trends and seasonal patterns (if you choose to split by time periods).

• When isChurn = true:

  • Calculates members who left during the period

  • Identifies membership cancellations

» Average Membership Duration

This calculates the total duration of active memberships within a specified start and end date, grouped by entry type. It helps assess how long members are active under each entry type during a given period, providing insights into usage patterns and retention.

» Member Lifetime Value (LTV)

This query calculates the lifetime value of members i.e., total revenue generated per member.

We can calculate Member LTV over various time periods—daily, weekly, monthly, or quarterly. For each period, we identify all users who had an active membership (excluding day passes and unlimited-duration passes, which are typically used for punch cards or staff access) and retrieve their all-time transaction value total. Then we calculate the average value across the group to estimate the average lifetime value of members active during the selected period.

Note: This calculation does not include historical (imported) data, so it reflects only transactions recorded within the BETA system.

» Sales by Category

This query provides a breakdown of sales after discounts by product category and tax bracket. It calculates the total amount sold in each category and includes an overall sales total across all categories. The report accurately handles both tax-inclusive and tax-exclusive pricing, making it a reliable tool for comprehensive sales reporting.

Please note:

• Some regions require inclusive tax (common in Europe)

• Some require exclusive tax (common in US/Canada) - i.e. gyms whose currency is USD or CAD their amounts are tax exclusive in the report

» Refunds by Category

This query provides information on total refunds after discounts per category and per tax bracket.

This data is useful for:

• Monitoring refund rates by category

• Financial reporting

• Identifying potential issues (i.e., high refund rates in specific categories)

• Tax accounting for refunded transactions

These 2 use the same function to calculate the output using a start and end period.

Gets total which is category specific and totalVal which is grand total across the categories.

Please note:

• Some regions require inclusive tax (common in Europe)

• Some require exclusive tax (common in US/Canada) - i.e. gyms whose currency is USD or CAD their amounts are tax exclusive in the report

» Inventory Costs

This query calculates the Cost of Goods Sold (COGS) per gym, broken down by product category. It’s useful for detailed tracking of inventory costs, whether you're analysing a single location or comparing multiple gyms.

» Inventory Counts

This query is similar to the above, but instead returns the quantity per product, rather than monetary values.

» Inventory Value

This query calculates the current value of inventory held at each gym. It does this by retrieving the current stock levels, multiplying the cost price by the quantity on hand, and aggregating the total by gym. This helps with tracking inventory value for accounting, audits, and stock management.

» Get Hours By Tag

The getHoursByTag query supports the four use cases below by checking actual vs planned and monetary (money) vs hours. It checks hours worked or cost of hours worked according to employees timesheet at the gym.

» 01. Schedules Hours per Shift Tag

Tracks planned employee working hours by tags and per gym.

» 02. Schedules Cost per Shift Tag

Tracks planned monetary costs per tag and per gym.

planned hours worked * shift rate e.g. 8h * £10 = £80

» 03. Worked Hours per Shift Tag

Tracks actual hours worked per tag and per gym.

» 04. Actual Cost per Shift Tag

Tracks actual monetary cost per tag and per gym.

worked hours worked * shift rate e.g. 8h * £10 = £80

FAQs

….Please forward any questions to the BETA team….

Still Lost? We’ve got you covered!

Use the search box on the main Help to search the entire list of available help guides, or drop your question in the Support Chat!