Operator guideEN

Dashboard / KPI Reports

Compare game or provider activity, stakes, wins, GGR, bonus values, adjustments, and house edge for one selected period.

How to use this guide

Start with the main guide

Follow the explanation and examples first. Extra definitions and formulas are available below when you need them.

What this widget shows

KPI Reports compares casino activity by Game or by Provider for one selected period.

Use it to answer questions such as:

  • Which games or providers produced the most rounds or players?
  • Where are real-money stakes and wins concentrated?
  • Why do GGR and Total GGR differ for the same row?
  • Which rows have an unusual house-edge percentage?

This is an entity comparison table. It is not a time-series chart and does not split the selected period into daily or hourly buckets.

Tabs

  • Games groups each row by game and aggregator.
  • Providers groups each row by provider and aggregator.

Changing the tab keeps the active date and streamer filters but runs the corresponding grouped report.

Filters

Date options

Available presets are Today, Yesterday, Month to date, Custom, Last 7 days, Last 30 days, Last 90 days, Week to date, Year to date, Previous month, and Previous year.

Changing the preset auto-applies it after a short delay.

Important current behavior:

  • Last 7 days starts at today minus 7 days and includes today, so it can cover 8 calendar dates.
  • Last 30 days can cover 31 calendar dates.
  • Last 90 days can cover 91 calendar dates.
  • Year to date currently starts on January 1 of the previous year and ends today. The label is misleading; do not treat it as current-year-only data.
  • The report does not expose an explicit business timezone. Date boundaries follow the date handling of the running service.

Date start and Date end

These fields appear for Custom. Changing either accepted date auto-applies the pair after a short delay. Apply Filters repeats the values currently shown.

The final day ends at exactly 23:59:59. Events recorded later within that final second using fractional timestamps are outside the current query.

Streamer data

Switches between streamer and non-streamer players and reloads the active report immediately.

Aggregated Mode

The interface presents this switch as a preference for aggregated versus live data and disables it for Today. The current report service, however, ignores this preference and always uses the same report path.

Treat this switch as non-authoritative: enabling it does not prove that the result came from aggregated data.

Columns

game / provider

The grouped game or provider name for the selected tab, together with its aggregator context. The visible header is lowercase: game on the Games tab and provider on the Providers tab.

Rounds

Count of qualifying bets that are not marked as adjustments or marketing. A positive cash amount is not required, so do not read it as a cash-only round count.

Players

Distinct players represented in the row.

The two tabs differ:

  • Providers counts players found in the period's bet/win source.
  • Games counts players from all casino records in the period before the amount formulas are applied. A player can therefore be counted in Games even when the related record adds nothing to the amount columns.

Real bet and Real win

Rate-adjusted cash stake and cash win from qualifying bets and wins that are neither adjustments nor marketing.

GGR

Rate-adjusted cash bets minus rate-adjusted cash wins. Correction, bonus-payout, and adjustment activity is excluded. Providers also excludes marketing activity; Games currently does not.

Total GGR

Rate-adjusted full-amount bets minus wins. It uses a broader amount source than cash-only GGR and also excludes freespins-payout activity. Providers excludes marketing activity; Games currently does not.

Bonus bet and Bonus win

Rate-adjusted non-cash values on qualifying bets and wins. These formulas do not separately remove adjustment or marketing activity.

Bonus GGR

Bonus bet minus bonus win. Adjustment and marketing activity can contribute when it is also a qualifying bet or win.

Total bets

Rate-adjusted full-amount value on qualifying bets, excluding correction and bonus-payout identifiers. Adjustment and marketing bets are not separately removed.

Adjustment

Rate-adjusted amount on adjustment bets minus rate-adjusted amount on adjustment wins.

HE %

House edge based on Real bet and Real win:

HE % = (1 - Real win / Real bet) * 100

The report rounds Real bet and Real win to two decimals before calculating HE. Zero or missing Real bet returns 0 %.

The visible value can contain a duplicated % because the percentage is formatted twice. This column is a percentage, not a payout amount.

Currency and exchange rates

Money columns are displayed with an EUR label. The report divides each qualifying amount by a saved conversion value before adding it to the grouped total.

The checked source does not establish the conversion pair, direction, upstream rate source, or capture timestamp. It also does not read the original currency while calculating the totals. Treat EUR as the report's display assumption, not as proof that every amount was converted from its original currency into EUR correctly.

Missing and zero rates are handled differently by tab:

  • Providers treats a missing or zero conversion value as 1, leaving the original number unchanged.
  • Games also treats a missing value as 1 for Real bet, Real win, Bonus bet, Bonus win, and Total bets, but a saved zero can make those calculations fail.
  • Games can fail GGR, Total GGR, Bonus GGR, and Adjustment when the conversion value is missing or zero.

Most money values are rounded to two decimals before they reach the table. Adjustment is different: its unrounded total can reach the page, and the table applies the visible two-decimal money formatting. HE is calculated from the already rounded Real bet and Real win values.

There is no separate refund, reversal, or chargeback formula in this report. Amounts enter through the documented bet/win and exclusion rules. Non-bet/non-win records do not enter amount metrics, although they can affect the Games player count.

Sorting

Sorting rearranges only the rows already loaded; it does not reload the report. The current sort is reliable for the numeric Rounds and Players columns, but not for every displayed value:

  • the game/provider name does not sort because that name is the group key rather than a numeric value inside the row
  • money values containing grouping commas can fail numeric sorting
  • HE values containing % can fail numeric sorting

Refresh data

Refresh data reloads the already active tab and filters. It does not apply different custom-date values that have not become active.

A refresh can still show the same recent result during a short cooldown. Simultaneous refreshes can share one calculation or temporarily leave the refresh unsuccessful without showing the backend retry interval. If that happens, wait briefly and retry.

Download CSV

Download CSV creates a fresh export with the active tab and filters. Because it reads the data separately, it is not guaranteed to represent the exact same moment as the table already on screen.

The CSV exposes the configured product prefix under a productPrefix header. Its Adjustment mapping currently reads a missing value and writes the reporting-currency symbol followed by undefined (for example, € undefined). HE is not included in the export.

Known limitations

  • The optional Aggregated Data / Live Data badge is normally absent because the current service does not return a source label.
  • Games and Providers differ in player counting, marketing exclusion, and conversion-rate fallback.
  • Year to date currently starts on January 1 of the previous year rather than the current year.
  • EUR is a display assumption because the conversion pair, direction, source, and capture time are not proven by this report path.
  • The final custom-date second can omit fractional timestamps after 23:59:59.000.
  • Name, formatted money, and HE sorting are unreliable; Rounds and Players remain numeric sort inputs.
  • HE can display a duplicated percent sign.
  • CSV is a separate read, uses a productPrefix header, writes Adjustment as a symbol plus undefined, and omits HE.
More details

Definitions and formulas

Open only the section you need. The relevant section opens automatically when you request help for a specific item on screen.

Source calculations4 topicsOpen details

Total GGR

Total GGR can differ from GGR because it uses a broader amount source and a different exclusion set.

Transform
GGR uses cash amounts, while Total GGR uses the broader full-amount basis and also excludes freespin-payout activity. Providers excludes marketing activity from both values; Games does not apply that exclusion.

HE %

HE is based on the already rounded Real bet and Real win values, not the unrounded grouped totals.

Transform
The report first rounds Real bet and Real win to two decimals, then calculates (1 - Real win / Real bet) * 100 and formats the result to two decimals. Zero or missing Real bet returns 0 %.

Reporting-currency normalization

EUR is a reporting-display assumption; this report path does not prove that every amount was converted from its original currency into EUR.

Transform
SQL divides each qualifying amount path by the saved conversion value before the report displays an EUR label. The checked calculation does not establish the divisor's currency pair, direction, upstream source, or capture timestamp. Providers silently uses divisor 1 for missing or zero values. Games has mixed fallback behavior and can fail on zero or missing values.

CSV export

Export applies the active filters but is a separate read; it exposes productPrefix, writes an invalid Adjustment value, and omits HE.

Transform
A fresh export reads the selected report, exposes the configured product prefix under the productPrefix header, and prefixes amount columns with the reporting-currency symbol. Its Adjustment mapping is missing and produces a symbol followed by undefined. HE is not selected for export.
Columns13 topicsOpen details

game / provider

Group name being compared in the current tab. The visible header is `game` on the Games tab and `provider` on the Providers tab.

Formula
Provider tab uses provider name plus aggregator; Games uses game name plus aggregator.
Caveat
Sorting this column currently has no reliable effect because the group name is not stored as a sortable numeric cell value.

Rounds

Number of qualifying bets that are not marked as adjustments or marketing.

Formula
Count bets whose adjustment and marketing markers are both off. A positive cash amount is not required.

Players

Distinct players represented in the group.

Formula
Providers counts players represented by qualifying bets or wins. Games counts players from all casino activity in the period before amount rules are applied, so other activity can affect this count.

Real bet

Rate-adjusted cash stake from qualifying non-adjustment, non-marketing bets.

Data Type
amount
Formula
Add qualifying cash bet amounts after applying the saved rate divisor; round the grouped total to two decimals.
Currency Warning
Provider missing/zero rate uses divisor 1. Games missing rate uses 1 here, but zero rate can fail the query.

Real win

Rate-adjusted cash win from qualifying non-adjustment, non-marketing wins.

Data Type
amount
Formula
Add qualifying cash win amounts after applying the saved rate divisor; round the grouped total to two decimals.
Currency Warning
Provider missing/zero rate uses divisor 1. Games missing rate uses 1 here, but zero rate can fail the query.

GGR

Rate-adjusted cash bets minus rate-adjusted cash wins for the group.

Data Type
amount
Formula
Exclude correction, bonus-payout, and adjustment activity. Providers also excludes marketing activity; Games does not.
Currency Warning
Providers substitutes divisor 1 for missing/zero rates. Games uses divisor 0 for missing/zero rates in this expression and can fail.

Total GGR

Rate-adjusted bets minus wins from the broader full-amount basis rather than the cash-only GGR basis.

Data Type
amount
Formula
Exclude correction, bonus-payout, adjustment, and freespin-payout activity. Providers also excludes marketing activity; Games does not.
Currency Warning
Providers substitutes divisor 1 for missing/zero rates. Games uses divisor 0 for missing/zero rates in this expression and can fail.

Bonus bet

Rate-adjusted non-cash amount on qualifying bets.

Data Type
amount
Formula
Add non-cash bet amounts after applying the saved rate divisor; adjustment and marketing activity is not separately excluded.
Currency Warning
Provider missing/zero rate uses divisor 1. Games missing rate uses 1 here, but zero rate can fail the query.

Bonus win

Rate-adjusted non-cash amount on qualifying wins.

Data Type
amount
Formula
Add non-cash win amounts after applying the saved rate divisor; adjustment and marketing activity is not separately excluded.
Currency Warning
Provider missing/zero rate uses divisor 1. Games missing rate uses 1 here, but zero rate can fail the query.

Bonus GGR

Bonus bet amount minus bonus win amount.

Data Type
amount
Formula
Non-cash bet aggregate minus non-cash win aggregate.
Currency Warning
Providers substitutes divisor 1 for missing/zero rates. Games uses divisor 0 for missing/zero rates in this expression and can fail.

Total bets

Rate-adjusted full-amount value on qualifying bets.

Data Type
amount
Formula
Add qualifying full bet amounts after applying the saved rate divisor, excluding correction and bonus-payout identifiers. Adjustment and marketing activity is not separately excluded.
Currency Warning
Provider missing/zero rate uses divisor 1. Games missing rate uses 1 here, but zero rate can fail the query.

Adjustment

Net rate-adjusted value of activity marked as adjustments.

Data Type
amount
Formula
Adjustment bet amount minus adjustment win amount; correction and marketing identifiers are not separately excluded.
Currency Warning
Providers substitutes divisor 1 for missing/zero rates. Games uses divisor 0 for missing/zero rates in this expression and can fail.
Rounding Boundary
The grouped Adjustment value can arrive unrounded; the table applies the visible two-decimal money formatting.
Caveat
CSV uses a different Adjustment mapping than the table and currently writes the reporting-currency symbol followed by `undefined` for this value.

HE %

House-edge percentage calculated from the displayed real-bet and real-win inputs.

Data Type
percentage
Formula
After Real bet and Real win are rounded to two decimals, calculate (1 - Real win / Real bet) * 100 and round the result to two decimals; zero or missing Real bet returns 0 %.
Caveat
The value is formatted with `%` twice and can show a duplicate suffix. HE is not included in the CSV export.
Filters5 topicsOpen details

Date options

Type
preset-range
Default
last7days
Options
today, yesterday, monthtodate, custom, last7days, last30days, last90days, weektodate, yeartodate, previousmonth, previousyear
Behavior
Changing the preset auto-applies it after the shared 250 ms form delay. Last 7/30/90 Days can span 8/31/91 calendar dates because they include both the calculated start and today. Year to date currently starts on January 1 of the previous year, so its label is misleading.

Date start

Type
date
Default
today minus 7 days
Behavior
Shown for Custom. Selecting a valid date auto-applies after the shared 250 ms form delay; Apply Filters can explicitly reapply the current pair.

Date end

Type
date
Default
today
Behavior
Shown for Custom and auto-applied like Date start. The service ends the range at exactly 23:59:59, so events with fractional seconds later in that final second are outside the current query.

Streamer data

Type
boolean
Visibility
all_tabs
Behavior
Immediately switches between streamer and non-streamer players; the source compares the player streamer flag with the selected boolean.

Aggregated Mode

Type
boolean
Visibility
all_tabs
Behavior
Immediately changes the requested preference and is disabled for Today, but the current KPI report service drops this unrecognized parameter and always selects the same SQL path.
Status badges1 topicOpen details

Aggregated Data / Live Data

Optional label indicating whether the displayed data is aggregated or live.

Type
display-chip
Visibility
all_tabs
Caveat
The current report does not supply this label, so the badge is normally absent and Aggregated Mode does not prove the source used.
Metrics12 topicsOpen details

Rounds

Number of qualifying bets for the grouped provider or game.

Formula
Count bets whose adjustment and marketing markers are both off. A positive cash amount is not required, so this is not a cash-only round count.
Filter Dependencies
Games / Providers tab, Date option or custom dates, Streamer data

Players

Distinct players represented in the grouped game or provider.

Formula
Providers counts players represented by qualifying bets or wins. Games counts players from all casino activity in the period before amount rules are applied.
Filter Dependencies
Games / Providers tab, Date option or custom dates, Streamer data
Caveats
A Games player can be counted because of non-bet/non-win activity even when that activity contributes nothing to the displayed amount columns.

Real bet

Rate-adjusted cash stake from qualifying non-adjustment, non-marketing bets.

Formula
Add qualifying cash bet amounts after applying the saved rate divisor; round the grouped total to two decimals.
Currency Basis
Displayed with an EUR label, but the divisor's currency pair, direction, upstream source, and capture time are not proven by this report path.
Filter Dependencies
Games / Providers tab, Date option or custom dates, Streamer data
Caveats
Provider missing or zero rate silently uses divisor 1., Games missing rate uses divisor 1, while zero rate can fail the expression.

Real win

Rate-adjusted cash win from qualifying non-adjustment, non-marketing wins.

Formula
Add qualifying cash win amounts after applying the saved rate divisor; round the grouped total to two decimals.
Currency Basis
Displayed with an EUR label, but the divisor's currency pair, direction, upstream source, and capture time are not proven by this report path.
Filter Dependencies
Games / Providers tab, Date option or custom dates, Streamer data
Caveats
Provider missing or zero rate silently uses divisor 1., Games missing rate uses divisor 1, while zero rate can fail the expression.

GGR

Rate-adjusted cash bets minus rate-adjusted cash wins for the group.

Formula
Cash bet total minus cash win total, excluding correction, bonus-payout, and adjustment activity. Providers also excludes marketing activity; Games does not.
Currency Basis
Displayed with an EUR label, but the divisor's currency pair, direction, upstream source, and capture time are not proven by this report path.
Filter Dependencies
Games / Providers tab, Date option or custom dates, Streamer data
Caveats
Provider missing or zero rate silently uses divisor 1., Games uses divisor 0 for a missing or zero rate in this expression and can fail., Marketing-activity handling differs between tabs.

Total GGR

Rate-adjusted bets minus wins for the group, using a broader amount basis than cash-only GGR.

Formula
Full-amount bet total minus full-amount win total, excluding correction, bonus-payout, adjustment, and freespin-payout activity. Providers also excludes marketing activity; Games does not.
Currency Basis
Displayed with an EUR label, but the divisor's currency pair, direction, upstream source, and capture time are not proven by this report path.
Filter Dependencies
Games / Providers tab, Date option or custom dates, Streamer data
Caveats
This can differ from GGR because it uses the broader amount basis and excludes freespin-payout activity., Provider missing or zero rate silently uses divisor 1., Games uses divisor 0 for a missing or zero rate in this expression and can fail., Marketing-activity handling differs between tabs.

Bonus bet

Rate-adjusted non-cash amount on qualifying bets.

Formula
Add non-cash bet amounts after applying the saved rate divisor; adjustment and marketing activity is not separately excluded.
Currency Basis
Displayed with an EUR label, but the divisor's currency pair, direction, upstream source, and capture time are not proven by this report path.
Filter Dependencies
Games / Providers tab, Date option or custom dates, Streamer data
Caveats
Provider missing or zero rate silently uses divisor 1., Games missing rate uses divisor 1, while zero rate can fail the expression., Adjustment and marketing activity can contribute when it is also a qualifying bet.

Bonus win

Rate-adjusted non-cash amount on qualifying wins.

Formula
Add non-cash win amounts after applying the saved rate divisor; adjustment and marketing activity is not separately excluded.
Currency Basis
Displayed with an EUR label, but the divisor's currency pair, direction, upstream source, and capture time are not proven by this report path.
Filter Dependencies
Games / Providers tab, Date option or custom dates, Streamer data
Caveats
Provider missing or zero rate silently uses divisor 1., Games missing rate uses divisor 1, while zero rate can fail the expression., Adjustment and marketing activity can contribute when it is also a qualifying win.

Bonus GGR

Rate-adjusted bonus bet amount minus rate-adjusted bonus win amount.

Formula
Non-cash bet aggregate minus non-cash win aggregate, without separate adjustment or marketing exclusions.
Currency Basis
Displayed with an EUR label, but the divisor's currency pair, direction, upstream source, and capture time are not proven by this report path.
Filter Dependencies
Games / Providers tab, Date option or custom dates, Streamer data
Caveats
Provider missing or zero rate silently uses divisor 1., Games uses divisor 0 for a missing or zero rate in this expression and can fail., Adjustment and marketing activity can contribute when it is also a qualifying bet or win.

Total bets

Rate-adjusted full-amount value on qualifying bets.

Formula
Add full bet amounts after applying the saved rate divisor, excluding correction and bonus-payout identifiers. Adjustment and marketing activity is not separately excluded.
Currency Basis
Displayed with an EUR label, but the divisor's currency pair, direction, upstream source, and capture time are not proven by this report path.
Filter Dependencies
Games / Providers tab, Date option or custom dates, Streamer data
Caveats
Provider missing or zero rate silently uses divisor 1., Games missing rate uses divisor 1, while zero rate can fail the expression., Adjustment and marketing bets can contribute.

Adjustment

Rate-adjusted adjustment bet amount minus rate-adjusted adjustment win amount.

Formula
Adjustment bet total minus adjustment win total; correction and marketing identifiers are not separately excluded.
Currency Basis
Displayed with an EUR label, but the divisor's currency pair, direction, upstream source, and capture time are not proven by this report path.
Rounding Boundary
The grouped value can arrive unrounded; the table applies the visible two-decimal money formatting.
Filter Dependencies
Games / Providers tab, Date option or custom dates, Streamer data
Caveats
Provider missing or zero rate silently uses divisor 1., Games uses divisor 0 for a missing or zero rate in this expression and can fail., CSV uses a different Adjustment mapping than the table and currently writes the reporting-currency symbol followed by `undefined`.

HE %

House-edge percentage calculated from the displayed Real bet and Real win inputs.

Formula
First format Real bet and Real win to two decimals; then return 0 % when Real bet is zero or missing, otherwise calculate (1 - Real win / Real bet) * 100 and format to two decimals.
Display Rule
The percentage is formatted with a percent sign twice, so the visible value can contain a duplicate suffix.
Filter Dependencies
every filter that changes Real bet or Real win
Caveats
HE uses rounded Real bet and Real win values rather than the unrounded grouped totals., The visible value can contain a duplicated percent suffix., HE is a percentage rather than a money amount, and it is omitted from the CSV export.
More help

Related pages

Dashboard / Bonus Payouts

Compare six payout measures for tournament, challenge, and no-deposit bonus families across four date buckets.

Dashboard / Game Reports

Compare Games and Providers across separate report paths, filters, source modes, summary cards, and row-level performance measures.

Dashboard / GGR Chart

Revenue trend chart with summary cards derived from the loaded time series.

Dashboard / KPI Summary

Compare the dashboard KPI row inventory across current, previous, month-to-date, and selected periods.

Dashboard / Live Player Report

Read the six live commercial cards, their trend badges, exact time windows, and current limitations.

Dashboard / Performance Overview

Container widget for Casino, Banking, and Registrations charts with shared date-range and streamer-data controls.