Operator guideEN

Reporting / FTD Cohort

Cohort report for post-FTD activity, depositors, and deposit-amount retention after the first successful deposit.

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 groups players by the date of their first successful deposit and then measures later behavior across follow-up periods.

When to use it

  • evaluate post-FTD retention
  • compare how many first-time depositors stay active later
  • compare follow-up deposit behavior by PID or country
  • analyze deposit momentum after the first deposit event

How to read it

Each base row is one cohort. The first deposit event defines the cohort date. The later columns are follow-up periods whose meaning depends on the selected cohort mode:

  • daily
  • weekly
  • monthly
  • custom-period buckets

Important reading rules:

  • visible period cells currently represent distinct cohort users seen after FTD in either gaming daily summaries or later successful deposit rows
  • period 0 is always set to 100.00% for each cohort and for the total row
  • future periods are unavailable and are displayed as blank cells

Filters that change the result

  • PID
  • Country
  • Cohort Mode
  • Custom Period (days)
  • FTD Start Date
  • FTD End Date
  • rows per page

Action and filter behavior

  • Apply Filters copies the currently edited filter controls into the active query state and resets pagination to page 1.
  • Refresh re-runs the last active query only. It does not apply staged changes that have not been committed with Apply Filters.
  • Export CSV uses the active filter snapshot and ignores the visible table pagination by requesting up to 10,000 cohort rows.
  • pressing Enter in the PID field also applies the staged filters.
  • typing a PID and leaving the PID field adds it to the staged PID chips, but the active query still waits for Apply Filters or Enter.
  • Custom Period (days) is only visible when cohort mode is Selected period (custom) and is clamped to at least 1.

Known caveats

  • The cohort is defined by the first successful deposit only.
  • later-period values come from a union of gaming-summary activity and later successful deposits after FTD; the original FTD day is excluded from later periods by > ftd_date.
  • Visible metric cells render as percentages.
  • Exported CSV rows keep raw decimal ratios rounded to 4 decimal places, not the % formatting shown in the table.
  • The PID filter depends on stored player KPI summary data and does not use a separate affiliate-settings lookup.
  • When the result set contains more than 50,000 cohort rows, the page shows a warning banner that recommends narrowing the date range or filters before exporting.
  • totalCount counts cohort buckets, not users.
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.

Calculations9 topicsOpen details

Cohort date bucketing

Defines which cohort row a first-time depositor belongs to.

Formula
The report groups successful first deposits by day, week, month, or custom-period bucket using the selected cohort mode. Weekly/monthly use date truncation; custom buckets use the configured custom day width.

Current period metric

Current verified period cells mean later activity/deposit presence, not a metric-type-specific formula.

Formula
The report builds each later-period value from a union of later gameplay activity dates and later successful deposit dates after FTD, counts distinct users per period, then divides by cohort users.

Depositors

Not a visible current selector; treat any direct depositors-specific mode request as unsupported for separate formula meaning.

Formula
The current page does not expose a Depositors metric selector and does not switch to a depositors-only calculation.

Deposit Amounts

Do not use this selector as a verified deposit-amount index in the current build.

Formula
The current page does not expose a Deposit Amounts metric selector and does not calculate a deposit-amount index.

Period 0 and future periods

Period 0 is a baseline; future periods render blank because they are unavailable, not zero.

Formula
Period `0` is set to ratio `1` for every cohort and summary. Future periods are set to `null`.

Summary row

Overall ratio across returned cohorts, not a simple arithmetic average of displayed percentages.

Formula
Summary period ratios divide total period metric users by eligible users across the returned cohort rows.

Active filter snapshot

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

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

PID chip staging

A visible PID chip may still be staged until Apply Filters or Enter promotes it.

Presentation Transform
Typing a PID and blurring the PID field adds it to staged chips. Pressing Enter also applies filters and promotes the staged PID list into the active query.

CSV export formatting

Exported files contain raw decimal ratios, so values may look smaller than the percentages shown on screen.

Formula
CSV export writes each ratio with `toFixed(4)`-style decimal precision and does not apply the visible percentage formatting used in the table cells.
Columns3 topicsOpen details

Cohort header

Cohort bucket created from the first successful deposit date. The visible header changes by mode, for example `FTD Date`, `FTD Week`, `FTD Month`, or `FTD Period Start`.

Users

Number of first-time depositors in the cohort.

Period metric cells

Ratio of distinct cohort users with later gameplay activity or later successful deposit presence in that period; period `0` is always `1`, and future periods render blank.

Filters6 topicsOpen details

FTD Start Date

Staged lower bound for first successful deposit `created_at`; active only after `Apply Filters` or Enter.

Type
date
Default Value
today - 30 days
Submitted As
startDate
Apply Model
draft-until-applied

FTD End Date

Staged upper bound for first successful deposit; service uses `< endDate + 1 day`.

Type
date
Default Value
today
Submitted As
endDate
Apply Model
draft-until-applied

PID

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

Type
multi-select
Submitted As
pid
Apply Model
draft-until-applied

Country

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

Type
multi-select
Options Source
CRM country list
Submitted As
country
Apply Model
draft-until-applied

Cohort Mode

Controls cohort date bucketing and period label width.

Type
select
Submitted As
cohortMode
Apply Model
draft-until-applied
Options
Daily, Weekly, Monthly, Selected period (custom)

Custom Period (days)

Bucket width in days for `Selected period (custom)` mode. The control is hidden for daily, weekly, and monthly cohorts and clamped to at least `1`.

Type
number
Default Value
7
Submitted As
customPeriodDays
Apply Model
draft-until-applied
Page sections8 topicsOpen details

Filter FTD Cohort

Filter card with staged inputs. Changes become active only after `Apply Filters`.

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

Error banner shown when the report query fails.

Large dataset detected. Narrow the date range or filters for faster loading and exports.

Warning banner shown when `totalCount` exceeds 50000 cohort buckets.

Cohort table

Main grid that expands cohort periods and metric ratios.

Cohort summary

Weighted summary row over the currently visible cohorts.

CSV export

Exports the current cohort result set.

No cohort data found for the selected filters.

Empty table row when the backend returns no cohort rows.

Table pagination

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

Metrics5 topicsOpen details

Users

Number of first-time depositors in the cohort row.

Aliases
ftd cohort users, cohort users
Formula
Count distinct players grouped by the selected cohort bucket from successful first-deposit rows.

Period metric ratio

Share of cohort users seen in the later-period activity calculation, using gameplay activity and later successful deposits after FTD.

Aliases
ftd cohort activity, cohort activity ratio, ftd cohort period ratio
Formula
Distinct users with later-period activity or deposit presence divided by cohort users for each period after FTD.

Depositors

Historical caveat. This is not a visible current selector and does not switch the table to a depositors-only formula.

Aliases
ftd cohort depositors, later depositors ratio
Formula
Not separately implemented in the current report calculation.
Comparison Notes
Direct requests with this parameter still return the same period ratios as the default activity/deposit-presence calculation.

Deposit Amounts

Historical caveat. This is not a visible current selector and does not switch the table to a deposit-amount formula.

Aliases
ftd cohort deposit amounts, deposit amount ratio
Formula
Not separately implemented in the current report calculation.
Comparison Notes
Direct requests with this parameter still return the same period ratios as the default activity/deposit-presence calculation.

Total Users

Total users across the cohort rows returned for the current applied filters.

Aliases
ftd cohort total users, cohort summary users
Formula
SUM(cohort.users) over returned cohort rows.
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.