Datasets

In addition to the computed attributes written to each player profile, Xtremepush provides a set of pre-aggregated datasets available in the Databases section of your BI suite.

Use these tables to build custom questions, dashboards, and computations that go beyond what's already on the player profile.

Data integration requirements
Below, lists the standard dataset available in your Intelligence suite, along with what it covers. This assumes a full input of supporting data from you, as described in Data Integration Requirements. You can discuss the data required with your Account Manager and the Onboarding Team.

Table	Granularity	Description
`model:daily_user_events_aggregations`	Daily · Player	Daily player-level metrics including GGR and NGR
`model:weekly_user_events_aggregations`	Weekly · Player	Weekly player-level metrics
`model:monthly_user_events_aggregations`	Monthly · Player	Monthly player-level metrics
`model:lifetime_user_events_aggregations`	Lifetime · Player	Cumulative player-level metrics with first/last activity dates
`model:lifetime_user_sports_events_aggregations`	Lifetime · Player · Sport	Lifetime sports metrics broken down by sport name
`model:lifetime_user_casino_events_aggregations`	Lifetime · Player · Game	Lifetime casino metrics broken down by game name
`model:daily_user_bingo_events_aggregations`	Daily · Player · Game	Daily bingo stakes and payouts per player per game
`model:weekly_user_bingo_events_aggregations`	Weekly · Player · Game	Weekly bingo metrics per player per game
`model:monthly_user_bingo_events_aggregations`	Monthly · Player · Game	Monthly bingo metrics per player per game
`model:lifetime_user_bingo_events_aggregations`	Lifetime · Player · Game	Lifetime bingo metrics including GGR and margin per game
`model:daily_events_aggregations`	Daily · Platform	Daily platform-wide metrics for trend analysis
`model:weekly_events_aggregations`	Weekly · Platform	Weekly platform-wide metrics
`model:monthly_events_aggregations`	Monthly · Platform	Monthly platform-wide metrics

When to use each table
Use case
Table
Track an individual player's activity over time
Daily / weekly / monthly player tables
Understand a player's lifetime value
model:lifetime_user_events_aggregations
Identify top casino games by revenue
model:lifetime_user_casino_events_aggregations
Identify top sports by wagering volume
model:lifetime_user_sports_events_aggregations
Identify top bingo rooms by revenue
model:lifetime_user_bingo_events_aggregations
Platform-level revenue trend
Daily / weekly / monthly platform tables

Use case	Table
Track an individual player's activity over time	Daily / weekly / monthly player tables
Understand a player's lifetime value	`model:lifetime_user_events_aggregations`
Identify top casino games by revenue	`model:lifetime_user_casino_events_aggregations`
Identify top sports by wagering volume	`model:lifetime_user_sports_events_aggregations`
Identify top bingo rooms by revenue	`model:lifetime_user_bingo_events_aggregations`
Platform-level revenue trend	Daily / weekly / monthly platform tables

Key Columns (Player level tables)

The following are the key columns across the player-level tables:

model:daily_user_events_aggregations
model:weekly_user_events_aggregations
model:monthly_user_events_aggregations
model:lifetime_user_events_aggregations

Column	Description
`profile_uid`	Xtremepush player identifier
`user_id`	Your external player identifier
`deposit_count` / `deposit_value`	Number and total value of deposits
`withdrawal_count` / `withdrawal_value`	Number and total value of withdrawals
`sports_debit_count` / `sports_debit_value`	Sports bets placed
`sports_credit_count` / `sports_credit_value`	Sports payouts received
`sports_ggr`	Sports GGR (wagers − payouts)
`casino_debit_count` / `casino_debit_value`	Casino bets placed
`casino_credit_count` / `casino_credit_value`	Casino payouts received
`casino_ggr`	Casino GGR (wagers − payouts)
`bingo_debit_count` / `bingo_debit_value`	Bingo stakes placed
`bingo_credit_count` / `bingo_credit_value`	Bingo payouts received
`bingo_ggr`	Bingo GGR — lifetime table only
`bonus_debit_value` / `bonus_credit_value`	Bonus wager and payout amounts
`ggr`	Total GGR (sports + casino)
`ngr`	Net Gaming Revenue (GGR − bonus credit)

The lifetime player table includes all of the above, plus first and last activity dates for each vertical:

deposit_first_date
deposit_last_date
casino_debit_first_date
casino_debit_last_date
sports_debit_first_date
sports_debit_last_date
bingo_debit_first_date
bingo_debit_last_date
bingo_margin where bingo is configured.

Key Columns (Sport and game dimension tables)

The following are the key columns across the sport and game dimension tables:

model:lifetime_user_sports_events_aggregations adds primary_property (sport name) to the standard sports columns.
model:lifetime_user_casino_events_aggregations adds primary_property (game name) to the standard casino columns.

Key Columns (Platform-level tables)

The following are the key columns across the platform-level tables:

model:daily_events_aggregations
model:weekly_events_aggregations
model:monthly_events_aggregations

Column	Description
`event_date`	Date
`deposit_users`	Unique players who made a deposit
`sports_debit_users` / `casino_debit_users`	Unique active bettors by vertical
All count, value, GGR, and margin columns	As above, summed at platform level

Documentation Index

Datasets

Key Columns (Player level tables)

Key Columns (Sport and game dimension tables)

Key Columns (Platform-level tables)