Help CenterMathematical operations allow users to derive new metrics, KPIs, and other data points based on formulas. Queries can incorporate basic arithmetic operations to compute new values directly from available data.
Example 1: Applying a Tax Rate
This query calculates Net Gaming Revenue (NGR) from Gross Gaming Revenue (GGR) by applying a 9% tax rate:
show the total casino ggr * 0.09 this month from country UK
Example 2: Comparing Monthly First-Time Depositors
This query compares first-time depositors (FTDs) from the current month versus last month (MTD) and calculates the percentage change:
show all acquisition sources with total FTDs this month lower than last month mtd. Include total FTDs this month as "Curr Mnth", total FTDs last month mtd as "Last Mnth". Include "Delta" as [Curr Mnth/Last Mnth -1] as a percentage to 0 decimal places.
In this case:
-
"Curr Mnth" represents the current month's FTD count
-
"Last Mnth" represents the previous month's FTD count
-
"Delta" calculates the percentage change between the two values
- mtd is a financial keyword representing "Month to today" - the start of a month until the current day minus 1 day.
These calculations help track performance trends over time and make data-driven decisions.
Text enclosed within [ ] is not interpreted as a keyword, ensuring it does not affect query processing.
Example 3: Calculation of Net Gaming Revenue (NGR)
The query below utilises three distinct attributes to calculate the Net Gaming Revenue on the fly.
Select total wagers - payouts - bonuses for my UK market last year
Example 4: Calculating a Ratio for a Specific Player
This calculates the payout to wager ratio for a specific customer.
Show total payouts / total wagers as [PayoutWagerRatio] for playerid [12345]
Text enclosed within [ ] is not interpreted as a keyword, ensuring it does not affect query processing.
Example 5: Calculating a Ratio for a Specific Player
This query lists all players and their respective bonus to deposit ratio (as a percentage) and only includes customers from the Italian market with a lifetime value higher than 1,000 currency units (depending on the default currency configured in your account). The query only returns ratios higher than 1.
list all players and bonus_dep_ratio * 100.00 from country Italy with an LTV greater than 1000 and had total bonus value / total deposit value as bonus_dep_ratio more than 1 last year
Example 6: Calculting player Lifetime Value (LTV) Dynamically
This query assigns the top 10 players with the highest LTV to a variable, namely TOP. It also includes the system generated LTV value, and includes the calculation for LTV by deducting payouts and bonuses to the players lifetime wagers.
TOP = top 10 players with the highest LTV. Include, LTV, total lifetime deposits as [deposits], total lifetime bonuses as [bonuses], total lifetime wagers as [wagers], total lifetime wagers as [payouts] and [wagers] - [payouts] - [bonuses] as [CalclulatedNGR]
⚠️ Text enclosed within [ ] is not interpreted as a keyword, ensuring it does not affect query processing.