Operator guideEN

Reporting / FTD Cohort Retention

Long-term retention and revenue-quality report that groups players by their first deposit date and measures D7 and D30 activity and deposit retention plus deposits, GGR, and NGR per cohort.

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 page shows

FTD Cohort Retention groups players by the date of their first deposit and then measures, for each cohort, how well those players stayed engaged over the long term and how much revenue they produced.

It is a different report from FTD Cohort. This page answers two questions side by side:

  • did the cohort keep playing and keep depositing after a fixed number of days, and
  • what was the cohort worth in deposits, gross gaming revenue, and net gaming revenue.

When to use it

  • judge the long-term quality of first-time depositors, not just early activity
  • compare retention at fixed day-7 and day-30 thresholds across cohorts
  • separate players who only stayed active from players who actually deposited again
  • compare cohorts by country, by traffic source, or by first-deposit period
  • size the deposit and revenue value behind each cohort in one place

How to read it

Each row is one cohort. The cohort label depends on the selected cohort mode:

  • Daily shows the first-deposit day
  • Weekly shows an ISO week label such as 2026-W12
  • Monthly shows a month label such as March 2026
  • Selected period (single cohort) collapses the whole date range into one cohort row labelled with the start and end dates

The retention columns are read as percentages of the cohort:

  • D7 Activity Ret. % is the share of the cohort with any user activity on or after day 7 from their first deposit
  • D7 Deposit Ret. % is the share of the cohort that made a repeat deposit on or after day 7
  • D30 Activity Ret. % and D30 Deposit Ret. % are the same two measures at the 30-day threshold

The revenue-quality columns show the cohort total of player deposits in the reporting currency, gross gaming revenue, and net gaming revenue.

Important reading rules:

  • a blank cell shown as a dash means the threshold has not been reached yet for that cohort, so the value is not available rather than zero
  • activity retention and deposit retention are independent measures; a cohort can keep activity high while repeat deposits fall
  • retention cells are colour-coded by the page: green at 30 percent or more, amber from 10 up to 30 percent, red below 10 percent
  • the deposit column is labelled in EUR because deposits are normalised to the reporting currency before they are summed

Filters that change the result

  • FTD From and FTD To bound the first-deposit date window; the default window is the last six months
  • Cohort Mode controls how cohort rows are bucketed
  • Traffic Source limits the cohort to Affiliate, Referral, or Direct players, or keeps All
  • PID limits cohorts to specific affiliate PIDs
  • Country limits cohorts to specific player country codes
  • rows per page

Action and filter behaviour

  • Apply Filters copies the currently edited filter controls into the active query and resets the table to the first page.
  • Refresh re-runs the last applied query only; it does not pick up staged edits that were not applied.
  • Pressing Enter in the PID field also applies the staged filters.
  • Typing a PID and leaving the PID field stages it as a chip, but the active query still waits for Apply Filters or Enter.
  • Export CSV uses the active filter snapshot and ignores table pagination by requesting up to 10,000 cohort rows.

Known caveats

  • The cohort is defined only by the first successful deposit. A player belongs to exactly one cohort.
  • Retention thresholds are inclusive: day 7 means on or after the 7th day from the first deposit, and the same applies to day 30.
  • Activity retention counts user-driven activity events, not gaming-summary rows, so it can differ from how the original FTD Cohort report measures later activity.
  • Deposit retention counts repeat successful deposits and does not require the same amount as the first deposit.
  • Traffic Source classifies a player by whether they have an affiliate PID link, otherwise an active referral, otherwise direct; this is mutually exclusive in that priority order.
  • GGR and NGR exclude correction, bonus payout, rakeback calendar, and referral rakeback entries so they reflect gameplay revenue rather than adjustments.
  • Streamer accounts and deleted players are excluded from every cohort.
  • This report has no summary or total row; each row stands on its own.
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.

Calculations10 topicsOpen details

Cohort membership

Each player belongs to exactly one cohort, set by the first deposit.

Transform
A player joins a cohort only through their first successful deposit, identified by a successful deposit marked as the first deposit within the selected FTD date window. Deleted players and streamer accounts are excluded. The first-deposit date is the anchor used by every later threshold.

Cohort date bucketing

Defines which cohort row each first-time depositor falls into.

Transform
Daily uses the first-deposit date. Weekly and monthly group first deposits into calendar buckets. Custom mode collapses the selected window into one cohort row with a label built from the start and end dates of the window.

D7 and D30 retention thresholds

Activity and deposit retention are independent. The threshold is inclusive of the Nth day, and uses repeat deposits for deposit retention rather than gaming activity.

Transform
Activity retention counts distinct cohort users with a user-driven activity event on or after the first-deposit date plus the threshold days. Deposit retention counts distinct cohort users with a repeat successful deposit on or after the same threshold. Each count is divided by FTD Players and multiplied by 100.

Future-threshold blanking

A dash means the threshold has not been reached yet, not that retention was zero.

Transform
The report checks whether the first-deposit date plus the threshold days is still after today. When the threshold is in the future the retention value is unavailable. The page renders it as a dash so it is not confused with a real 0 percent.

Zero-denominator guard

Cohorts with no players show 0 percent rather than an error.

Transform
Each retention percentage divides the retained player count by FTD Players. If that count is zero, the report returns 0 percent instead of a divide-by-zero error.

Deposit currency normalisation

Deposits are summed in the reporting currency using the rate captured at the time of each deposit; a missing rate leaves the original amount unconverted.

Transform
Total Deposits divides each successful deposit amount by the stored conversion rate and sums the result over all successful deposits of cohort players. The conversion rate is the transaction-time rate stored on each banking row, so deposits are converted to the reporting currency at posting time. A null or zero rate falls back to 1.

GGR and NGR aggregation

Revenue reflects gameplay only and is already in the reporting currency before it is summed.

Transform
GGR sums base gross gaming revenue and NGR sums base net gaming revenue for cohort players, excluding correction, bonus payout, rakeback calendar, and referral rakeback adjustment categories. Both base columns are already in the reporting currency, so the report applies no further currency conversion.

Traffic source classification

A player is classified into a single channel in the priority order affiliate, then referral, then direct.

Transform
Affiliate matches players who own an affiliate link with a non-empty pid payload. Referral matches players with no affiliate link but an active referral link. Direct matches players with neither. All applies no channel condition.

Active filter snapshot

Unapplied changes in the filter card do not affect the table or export until Apply Filters is used.

Transform
The page keeps editable filter state separate from the active query state. Apply Filters copies the staged controls into the active state and resets pagination to page 1. Refresh only re-fetches the active state.

CSV export formatting

The export covers the full active result set, not just the visible page, and blanks future thresholds.

Transform
Export requests limit 10000 and pageNo 1 with exportCsv true, and the report returns a CSV whose retention and money columns are written with 2-decimal formatting. Future-threshold retention values are written as empty cells.
Columns9 topicsOpen details

Cohort

Cohort bucket built from the first-deposit date. The label format changes by mode: a day, an ISO week, a month name, or a start-to-end range for custom mode.

FTD Players

Count of distinct first-time depositors in the cohort. This is the denominator for all four retention percentages.

D7 Activity Ret. %

Share of the cohort with any user-driven activity on or after day 7 from first deposit. Blank when the 7-day threshold has not been reached yet.

D7 Deposit Ret. %

Share of the cohort that made a repeat successful deposit on or after day 7 from first deposit. Blank when the threshold is in the future.

D30 Activity Ret. %

Share of the cohort with any user-driven activity on or after day 30 from first deposit. Blank when the 30-day threshold has not been reached yet.

D30 Deposit Ret. %

Share of the cohort that made a repeat successful deposit on or after day 30 from first deposit. Blank when the threshold is in the future.

Total Deposits (EUR)

Sum of all successful deposits made by cohort players, normalised to the reporting currency. Includes deposits after the first one, not just the FTD.

GGR

Gross gaming revenue for the cohort from the analytics daily summary base column, excluding correction, bonus payout, rakeback calendar, and referral rakeback entries.

NGR

Net gaming revenue for the cohort from the analytics daily summary base column, with the same game-identifier exclusions as GGR.

Filters6 topicsOpen details

FTD From

Staged lower bound for the first-deposit date. Active only after Apply Filters or Enter. The report compares this against the first successful deposit timestamp.

Type
date
Default Value
today - 6 months
Behavior Notes
Sent as `yyyy-MM-dd` when applied.

FTD To

Staged upper bound for the first-deposit date. The report uses an exclusive upper bound of endDate + 1 day.

Type
date
Default Value
today
Behavior Notes
Sent as `yyyy-MM-dd` when applied.

Cohort Mode

Controls cohort bucketing. Daily, weekly, and monthly group by first-deposit calendar buckets; custom collapses the whole window into one cohort row with a start-to-end label.

Type
select
Default Value
monthly
Options
Daily, Weekly, Monthly, Selected period (single cohort)
Behavior Notes
Staged until Apply Filters or Enter is used from the PID field.

Traffic Source

Limits the cohort by acquisition channel. Affiliate requires an affiliate PID link; Referral requires no affiliate link but an active referral; Direct requires neither. All applies no channel filter.

Type
select
Default Value
All
Options
All, Affiliate, Referral, Direct
Behavior Notes
Staged until Apply Filters or Enter is used from the PID field.

PID

Free-solo staged PID chips matched against affiliate tracking IDs recorded for the cohort players.

Type
multi-select
Behavior Notes
Typed PID text is committed as a staged chip on blur or during Apply Filters., The active query changes only after Apply Filters or Enter.

Country

Staged country-code chips matched against the players' account countries.

Type
multi-select
Options Source
CRM country list
Behavior Notes
Staged until Apply Filters or Enter is used from the PID field.
Page sections8 topicsOpen details

FTD Cohort Retention Report

Header card explaining the cohort definition and the D7 and D30 retention chips, including that a dash cell means the threshold is not yet reached.

Filters

Filter card with staged inputs. Changes become active only after Apply Filters or Enter in the PID field.

Failed to load report. Try narrowing the date range or filters, then refresh.

Error banner shown when the report query fails.

Cohort table

Main grid with one row per cohort and fixed retention and revenue-quality columns.

Retention cell colour bands

Each retention cell is coloured green at 30 percent or more, amber from 10 up to 30 percent, and red below 10 percent. An unavailable value renders as a dash.

No data found for the selected filters.

Empty table row shown when the backend returns no cohort rows.

Export CSV

Exports the active cohort result set as CSV.

Table pagination

Backend pagination with row-size options 10, 20, 50, and 100.

Metrics8 topicsOpen details

FTD Players

Distinct first-time depositors in the cohort. Denominator for all retention percentages.

Aliases
cohort ftd players, first time depositors in cohort
Formula
Count distinct players whose first successful deposit falls inside the selected FTD window, grouped by the selected cohort bucket.

D7 Activity Retention %

Share of the cohort with any user-driven activity on or after day 7 from first deposit.

Aliases
day 7 activity retention, d7 activity ret, early activity retention
Numerator
Distinct cohort users with a user-driven activity event on or after day 7 from first deposit.
Denominator
FTD Players (distinct cohort users)
Zero Denominator Behavior
When FTD Players is 0 the report returns 0, not null and not a divide error.
Future Threshold Behavior
When ftd_date + 7 days is still in the future the value is null and the page renders a dash, distinct from a real 0 percent.
Rounding
Ratio multiplied by 100 and rounded to 2 decimals.

D7 Deposit Retention %

Share of the cohort that made a repeat successful deposit on or after day 7 from first deposit.

Aliases
day 7 deposit retention, repeat deposit retention d7, d7 deposit ret
Numerator
Distinct cohort users with a repeat successful deposit on or after day 7 from first deposit.
Denominator
FTD Players (distinct cohort users)
Zero Denominator Behavior
Returns 0 when FTD Players is 0.
Future Threshold Behavior
Returns null (rendered as a dash) when the 7-day threshold is in the future.
Rounding
Ratio multiplied by 100 and rounded to 2 decimals.

D30 Activity Retention %

Share of the cohort with any user-driven activity on or after day 30 from first deposit.

Aliases
day 30 activity retention, d30 activity ret, long term activity retention
Numerator
Distinct cohort users with a user-driven activity event on or after day 30 from first deposit.
Denominator
FTD Players (distinct cohort users)
Zero Denominator Behavior
Returns 0 when FTD Players is 0.
Future Threshold Behavior
Returns null (rendered as a dash) when the 30-day threshold is in the future.
Rounding
Ratio multiplied by 100 and rounded to 2 decimals.

D30 Deposit Retention %

Share of the cohort that made a repeat successful deposit on or after day 30 from first deposit.

Aliases
day 30 deposit retention, repeat deposit retention d30, long term deposit retention
Numerator
Distinct cohort users with a repeat successful deposit on or after day 30 from first deposit.
Denominator
FTD Players (distinct cohort users)
Zero Denominator Behavior
Returns 0 when FTD Players is 0.
Future Threshold Behavior
Returns null (rendered as a dash) when the 30-day threshold is in the future.
Rounding
Ratio multiplied by 100 and rounded to 2 decimals.

Total Deposits (EUR)

Sum of all successful deposits made by cohort players, in the reporting currency. Includes repeat deposits, not only the first deposit.

Aliases
cohort total deposits, cohort deposit volume, revenue quality deposits
Formula
Sum each successful deposit amount after applying the stored transaction conversion rate, grouped by the selected cohort bucket.
Currency Basis
Reporting Currency: EUR (base / reporting currency; the visible column is labelled Total Deposits (EUR)). | Original Amount Source: Deposit amount in the original transaction currency. | Exchange Rate Source: Stored conversion rate on the deposit transaction. | Basis: Transaction-time (posting-time) rate stored on each deposit row; no period-average or closing rate is applied. | Missing Rate Behavior: A missing or zero stored rate falls back to 1, so the original amount is summed as if already in the reporting currency. This can distort the total when a real rate was missing. | Rounding: Cohort sum rounded to 2 decimals.

GGR

Gross gaming revenue produced by the cohort, in the reporting currency.

Aliases
cohort gross gaming revenue, cohort ggr, revenue quality ggr
Formula
Sum base-currency gross gaming revenue for cohort players, excluding correction, bonus payout, rakeback calendar, and referral rakeback adjustment categories.
Currency Basis
Reporting Currency: EUR (base currency); the report reads already-converted base-currency gross gaming revenue. | Basis: The report sums already-converted base values and applies no further FX. The base amounts are materialised upstream by the analytics pipeline (nx-analytics-engine) using per-transaction conversion rates; the exact upstream rate basis is owned by that pipeline and is not re-derived in this report. | Rounding: Cohort sum rounded to 2 decimals.
Comparison Notes
GGR here excludes adjustment-style game identifiers, so it can differ from a raw GGR total that includes corrections or bonus payouts.

NGR

Net gaming revenue produced by the cohort, in the reporting currency.

Aliases
cohort net gaming revenue, cohort ngr, revenue quality ngr
Formula
Sum base-currency net gaming revenue for cohort players, with the same adjustment-category exclusions as GGR.
Currency Basis
Reporting Currency: EUR (base currency); the report reads already-converted base-currency net gaming revenue. | Basis: The report sums already-converted base values and applies no further FX. Base amounts are materialised upstream by the analytics pipeline; the upstream rate basis is owned by that pipeline. | Rounding: Cohort sum rounded to 2 decimals.
More help

Related pages

Reporting

Canonical entrypoint for standalone reporting pages outside the main Dashboard widgets.

Reporting / Affiliate Events Report

Audit log of the events and saved amounts the platform sent to the affiliate system, with per-currency successful totals, CSV export, suspicious-traffic visibility, and a guarded force-send override.

Reporting / Bonus Performance

Grouped bonus performance report for activations, amounts, deposits, withdrawals, GGR, and NGR by bonus item.

Reporting / Card Approval Rates

Snapshot report of card deposit approval rates for NetworxPay, Paydex, and Carouseller, split by Trusted and NonTrusted players, with today versus the previous 30 days and today top decline reasons.

Reporting / Change Notification Detail

Detail page for one audit entry, including actor metadata, description, and before/after comparison views.

Reporting / Change Notifications

Audit list for recorded configuration, administrator, and system change entries with filters for actor, entity, and change type.