Business Intelligence

(Mandatory for clients who have purchased the Standard Intelligence Module)

While Xtremepush can ingest any raw event data for engagement, our Intelligence engine requires a specific standardisation layer to calculate high-value metrics such as GGR, NGR etc in real-time.

This process does not require you to rename your internal fields. Instead, we use a collaborative process to map your existing data to our Core Event Properties Model.

1. The BI Onboarding Journey

We follow a four-phase process to ensure your data is accurate. This journey relies on the technical documentation and mapping provided by your team in Phase 1.

Phase 1: Benchmarking & Mapping: You provide your Schema Documentation for review to assess and recommend any changes required
Phase 2: Configuration: On populating sufficient data (historical or 2 weeks "real" data) in the client's production project, our date team will configure the Intelligence engine to correctly interpret your event data.
Phase 3: Validation (Reconciliation): We produce a report of our findings and align with you any recommendations or changes needed.
Phase 4: Value Delivery: Your real-time BI dashboards and player computations are activated.

2. Required Technical Inputs

To commence Phase 1, our Data Solutions team requires two specific items from your technical team:

1. Your Schema Documentation: Any available technical docs for your event structures (e.g. JSON schemas, Swagger/OpenAPI docs, or a data dictionary).

2. Data Verification Sample (Benchmarking Set): 2 weeks real data or historical data in production environment to allow us assess data and propose changes where required

3. Core Mapping Logic

When completing your mapping document, you will need to identify three pillars for every transactional event:

Nature: Categorises the vertical (e.g. sports, casino, deposit, withdrawal, bonus).
Value Property: Identifies the field containing the monetary amount (e.g. stake_total or amount).
Natural Key (Critical): The identifier (e.g. bet_id or transaction_id) that links a wager to its eventual settlement. This ID must be identical in both events to calculate accurate margins and NGR.

4. Annotated BI Mapping Examples

The following example uses the standard payload defined to show how your existing fields are mapped for Intelligence purposes within the external Readiness Guide.

{
  "event": "bet_placed",
  "timestamp": "2025-08-17T14:10:00Z",
  "user_id": "user123",
  "value": {
    "bet_id": "B123456789", // Mapped as: Natural Key
...
    "stake_total": 50.00, // Mapped as: Value Property (Type: debit)
    "potential_return": 125.00,
...
    "legs": [
         {
              "leg_id": 1,
              "event_name": "Manchester United v Liverpool",
              "sport": "Football", // Mapped as: Category
              "competition": "Premier League",// Mapped as: Subcategory
              "participants": ["Manchester United", "Liverpool"]
              "market": "Match Result",// Mapped as: Item
              "selection": "Liverpool Win",
         }
...
          ]
    "balance_cash": 1100.00,
    "balance_bonus": 200.00,
    "balance_total": 1300.00
  }
}

Model Field	Your Field Name
event_name	bet_placed
nature	sports
value_property	stake_total
value_type	debit
natural_key	bet_id
category	sport
subcategory	competition
item	market

Player Aggregates/Computed Attributes

The following attributes can be derived from your event data. How they are made available depends on your Xtremepush package:

If you have purchased Intelligence: Depending on the package purchased, these attributes are calculated by the Intelligence engine in real-time as events are received. No additional data is required beyond the events defined in onboarding.

If you have not purchased Intelligence: These attributes will not be computed automatically. To enable segmentation and personalisation based on these fields, we recommend sending them as custom profile attributes via your regular data sync.

The following attributes are available:

Financial and liquidity

Computation	Computed attribute(s)	Windows	Description
XP \| [Window] \| Deposits	`[window]_deposits_amount`, `[window]_deposits_count`	L7D, L14D, L30D, L90D, Lifetime	Total deposit amount and count of deposits within the window
XP \| [Window] \| Withdrawals	`[window]_withdrawals_amount`, `[window]_withdrawals_count`	L7D, L14D, L30D, L90D, Lifetime	Total withdrawal amount and count of withdrawals within the window
XP \| [Window] \| Deposits Average	`[window]_deposits_average_amount`	L7D, L14D, L30D, L90D, Lifetime	Average deposit amount within the window
XP \| [Window] \| Withdrawals Average	`[window]_withdrawals_average_amount`	L7D, L14D, L30D, L90D, Lifetime	Average withdrawal amount within the window
XP \| [Window] \| Days Deposit Made	`[window]_days_deposit_made`	L7D, L14D, L30D, L90D, Lifetime	Number of unique days on which deposits were made
XP \| [Window] \| Days Withdrawal Made	`[window]_days_withdrawal_made`	L7D, L14D, L30D, L90D, Lifetime	Number of unique days on which withdrawals were made
XP \| [Window] \| Net Deposit	`[window]_net_deposit` (windowed), `net_deposit` (lifetime)	L7D, L14D, L30D, L90D, Lifetime	Net deposit - total deposits minus total withdrawals
XP \| Lifetime \| Has Deposited	`has_deposited`	Lifetime	`TRUE` if the player has made at least one deposit
XP \| Lifetime \| Has Withdrawn	`has_withdrawn`	Lifetime	`TRUE` if the player has made at least one withdrawal
XP \| Lifetime \| First Deposit Date	`deposit_first_date`	Lifetime	Date of the player's first deposit
XP \| Lifetime \| Last Deposit Date	`deposit_last_date`	Lifetime	Date of the player's most recent deposit
XP \| Lifetime \| First Withdrawal Date	`withdrawal_first_date`	Lifetime	Date of the player's first withdrawal
XP \| Lifetime \| Last Withdrawal Date	`withdrawal_last_date`	Lifetime	Date of the player's most recent withdrawal

Casino performance

Computation	Computed attribute(s)	Windows	Description
XP \| [Window] \| Casino	`[window]_casino_wager_amount`, `[window]_casino_payout_amount`, `[window]_casino_wager_count`, `[window]_casino_payout_count`, `[window]_casino_ggr`	L7D, L14D, L30D, L90D, Lifetime	Casino wager amount, payout amount, wager count, payout count, and GGR within the window
XP \| [Window] \| Casino Average	`[window]_casino_average_amount`	L7D, L14D, L30D, L90D, Lifetime	Average casino bet stake within the window
XP \| [Window] \| Days Casino Bet Placed	`[window]_days_casino_bet_placed`	L7D, L14D, L30D, L90D, Lifetime	Number of unique days on which casino bets were placed
XP \| Lifetime \| Has Placed Casino Bet	`has_placed_casino_bet`	Lifetime	`TRUE` if the player has placed at least one casino bet
XP \| Lifetime \| First Casino Bet Date	`casino_debit_first_date`	Lifetime	Date of the player's first casino bet
XP \| Lifetime \| Last Casino Bet Date	`casino_debit_last_date`	Lifetime	Date of the player's most recent casino bet
XP \| Lifetime \| Casino Margin	`casino_margin`	Lifetime	Percentage of total real-money casino wagers retained by the operator

Sportsbook performance

Computation	Computed attribute(s)	Windows	Description
XP \| [Window] \| Sports	`[window]_sports_wager_amount`, `[window]_sports_payout_amount`, `[window]_sports_wager_count`, `[window]_sports_payout_count`, `[window]_sports_ggr`	L7D, L14D, L30D, L90D, Lifetime	Sports wager amount, payout amount, wager count, payout count, and GGR within the window
XP \| [Window] \| Sports Average	`[window]_sports_average_amount`	L7D, L14D, L30D, L90D, Lifetime	Average sports bet stake within the window
XP \| [Window] \| Days Sports Bet Placed	`[window]_days_sports_bet_placed`	L7D, L14D, L30D, L90D, Lifetime	Number of unique days on which sports bets were placed
XP \| Lifetime \| Has Placed Sports Bet	`has_placed_sports_bet`	Lifetime	`TRUE` if the player has placed at least one sports bet
XP \| Lifetime \| First Sports Bet Date	`sports_debit_first_date`	Lifetime	Date of the player's first sports bet
XP \| Lifetime \| Last Sports Bet Date	`sports_debit_last_date`	Lifetime	Date of the player's most recent sports bet
XP \| Lifetime \| Sports Margin	`sports_margin`	Lifetime	Percentage of total real-money sportsbook wagers retained by the operator

Revenue (GGR and NGR)

Computation	Computed attribute(s)	Windows	Description
XP \| [Window] \| Total NGR	`[window]_total_ngr` (windowed), `total_ngr` (lifetime)	L7D, L14D, L30D, L90D, Lifetime	Total Net Gaming Revenue - GGR minus total bonus cost
XP \| [Window] \| Total GGR	`[window]_total_ggr` (windowed), `total_ggr` (lifetime)	L7D, L14D, L30D, L90D, Lifetime	Total GGR across Casino and Sports - combined stakes minus combined winnings
XP \| Lifetime \| Overall Margin	`overall_margin`	Lifetime	Overall margin across Casino and Sports - percentage of all wagers retained by the operator

Incentives and bonuses

Computation	Computed attribute(s)	Windows	Description
XP \| [Window] \| Bonus	`[window]_bonus_wager_amount`, `[window]_bonus_payout_amount`, `[window]_bonus_wager_count`, `[window]_bonus_payout_count`, `[window]_bonus_ggr`	L7D, L14D, L30D, L90D, Lifetime	Bonus wager amount, payout amount, wager count, payout count, and GGR within the window
XP \| [Window] \| Bonus Average	`[window]_bonus_average_amount`	L7D, L14D, L30D, L90D, Lifetime	Average bonus amount within the window
XP \| [Window] \| Days Bonuses Awarded	`[window]_days_bonuses_awarded`	L7D, L14D, L30D, L90D, Lifetime	Number of unique days on which bonuses were awarded
XP \| Lifetime \| Has Received Bonus	`has_received_bonus`	Lifetime	`TRUE` if the player has received at least one bonus
XP \| Lifetime \| First Bonus Date	`bonus_credit_first_date`	Lifetime	Date of the player's first bonus received
XP \| Lifetime \| Last Bonus Date	`bonus_credit_last_date`	Lifetime	Date of the player's most recent bonus received
XP \| Lifetime \| Bonus Margin	`bonus_margin`	Lifetime	Percentage of bonus funds retained by the operator after payouts

Dashboards

Standard OOTB dashboard will be configured based on the consumed data, where applicable. These include a range of dashboards covering:

Overall Performance
Email Performance
Push Performance
Campaign Performance by Bet
Sports Performance
Casino Performance
Campaign Performance by Bet
Deposit & Bet Commercial Performance