---
title: "Datasets"
slug: "datasets"
updated: 2026-08-10T14:12:57Z
published: 2026-08-10T18:25:37Z
canonical: "docs.xtremepush.com/datasets"
stale: true
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.xtremepush.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.

> [!WARNING]
> 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](/documentation/docs/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 |

> [!TIP]
> 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 |

### 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 |