Operator guideENreportingaffiliatesmkt

Reporting / MKT Performance

Grouped affiliate MKT performance report for depositors, deposits, GGR, NGR, and marketing deductions.

Reader view

Clean portal guidance

This page keeps the operator explanation, field and action descriptions, and screenshots visible without exposing repo paths, raw sidecars, or editorial-only implementation details.

Narrative content

Page body

What this page shows

MKT Performance groups affiliate outcomes by MKT tag. It compares depositors, banking movement, gaming revenue, and marketing-style deductions in either period mode or lifetime mode.

When to use it

  • compare MKT tags against deposit and revenue outcomes
  • inspect revenue after marketing and correction-style fields
  • switch between period-based and lifetime-style views

How to read it

The report has two different shapes:

  • Period Data on: period-based table with active players, deposits, withdrawals, GGR, NGR, and operational ratios
  • Period Data off: lifetime table with total users, cumulative deposit and revenue values, FTD conversion, and average-to-FTD timing

The visible summary cards remain:

  • Total MKTs
  • Total Deposits
  • Total NGR
  • Total GGR

The table is not one fixed schema:

  • period mode adds operational deductions such as Bonus Payouts, Cashback, Rakeback, Correction, Adjustment, and Marketing
  • lifetime mode swaps those for cumulative user and conversion fields such as Affiliate, Reg to FTD, and Avg Days to FTD

Known caveats

  • MKT is a substring tag match, not an exact-key filter
  • Active Only is a backend row filter, not just a visual toggle
  • the visible table columns change materially when Period Data is switched
  • period mode can sort by active players, but lifetime mode does not expose that exact sort semantics in the same way
  • Marketing is its own backend amount column and should not be merged mentally into NGR; NGR is already calculated after its own deduction set

Filters that change the result

  • start date
  • end date
  • MKT
  • country
  • order by
  • show only active
  • use period data

Verification status

  • status: verified_backend
  • FE route, mode toggle, summary cards, mode-specific columns, and export flow are mapped
  • gs-admin-backend owns both period and lifetime aggregations
  • nx-workspace is not required for the current operator meaning
Calculation notes

Calculations

calculation

GGR

Gross gaming revenue for the current MKT row.

Source Fields
bet_amount, win_amount
Transform
Backend calculates GGR as bet amount minus win amount.
calculation

NGR

Net gaming revenue for the current MKT row.

Source Fields
ggr, bonus_payout, cashback, rakeback_calendar, correction, adjustment_amount
Transform
Backend calculates NGR by subtracting revenue deductions from GGR.
calculation

Marketing

Separate marketing spend column shown in period mode. Do not read it as part of `NGR`; it is its own visible amount.

Source Fields
total_marketing
Transform
Backend carries `marketing_amount` into the period-mode row as `total_marketing`.
calculation

Withdrawal Rate

Indicates how much of deposited volume is returned as withdrawals.

Source Fields
withdrawal_amount, deposit_amount
Transform
Withdrawal Rate = (withdrawal amount / deposit amount) * 100 in period mode.
calculation

House Edge

Margin percentage for the current MKT row.

Source Fields
ggr, bet_amount
Transform
House Edge = (GGR / bet amount) * 100 in period mode.
calculation

Reg to FTD Rate

Lifetime conversion from registrations to first deposits for the MKT tag.

Source Fields
reg_to_ftd_rate
Transform
Lifetime mode exposes the backend-computed registration-to-first-deposit rate directly.
calculation

Avg Days to FTD

Useful for comparing time-to-conversion across MKT tags.

Source Fields
avg_days_to_ftd
Transform
Lifetime mode exposes the average days from registration to first deposit as a backend-calculated value.
calculation

Avg Deposit

The visible `Avg Deposit` column changes source field by mode, but keeps the same operator meaning.

Source Fields
avg_deposit_amount, avg_deposit_per_depositor_eur
Transform
Period mode exposes `avg_deposit_amount`; lifetime mode exposes `avg_deposit_per_depositor_eur` (or `avg_deposit_amount_eur` where returned by the row DTO).
Grid columns

Columns

field

MKT

field

Affiliate

Visibility
lifetime_only
field

Depositors

field

Active Players

Visibility
period_only
field

Deposits

Visibility
period_only
field

Withdrawals

Visibility
period_only
field

Withdrawals

Visibility
lifetime_only
field

Bets

Visibility
period_only
field

Bets

Visibility
lifetime_only
field

Wins

Visibility
period_only
field

Wins

Visibility
lifetime_only
field

Bonus Payouts

Visibility
period_only
field

Cashback

Visibility
period_only
field

Rakeback

Visibility
period_only
field

Correction

Visibility
period_only
field

Adjustment

Visibility
period_only
field

Marketing

Visibility
period_only
field

GGR

Visibility
period_only
field

NGR

Visibility
period_only
field

House Edge

Visibility
period_only
field

Total Users

Visibility
lifetime_only
field

Total Deposits

Visibility
lifetime_only
field

Total GGR

Visibility
lifetime_only
field

Total NGR

Visibility
lifetime_only
field

Reg to FTD Rate

Visibility
lifetime_only
field

Avg Days to FTD

Visibility
lifetime_only
Filter dictionary

Filters

field

Start date

Type
date
field

End date

Type
date
field

MKT

Type
text
field

Country

Type
select
field

Order by

Type
select
field

Show only active

Type
boolean
field

Use period data

Type
boolean
Summary cards

Summary cards

field

Total MKTs

field

Total deposits

field

Total NGR

field

Total GGR

Widget map

Widgets

item

Performance table

item

CSV export

Metric dictionary

Metrics

metric

Total MKTs

Number of MKT tags represented by the current report.

Aliases
mkt performance total mkts, distinct mkt tags
Backend Formula
count(distinct mkt)
Verification Status
verified_backend
Last Verified At
2026-04-18
metric

Total Deposits

Total deposit amount for the current query and mode.

Aliases
mkt performance total deposits
Backend Formula
sum(deposit amount field for selected mode)
Verification Status
verified_backend
Last Verified At
2026-04-18
metric

Total NGR

Net gaming revenue for the current MKT query.

Aliases
mkt performance ngr
Backend Formula
sum(ngr or total_ngr_eur depending on mode)
Verification Status
verified_backend
Last Verified At
2026-04-18
metric

Total GGR

Gross gaming revenue for the current MKT query.

Aliases
mkt performance ggr
Backend Formula
sum(ggr or total_ggr_eur depending on mode)
Verification Status
verified_backend
Last Verified At
2026-04-18
metric

Active Players

Period-mode count of distinct active players for the MKT tag.

Aliases
mkt performance active players
Backend Formula
active_players
Verification Status
verified_backend
Last Verified At
2026-04-18
metric

Total Users

Lifetime-mode count of users attributed to the MKT tag.

Aliases
mkt performance total users
Backend Formula
total_users
Verification Status
verified_backend
Last Verified At
2026-04-18
metric

Marketing

Period-mode backend marketing amount separate from GGR and NGR.

Aliases
mkt performance marketing, mkt performance marketing amount
Backend Formula
total_marketing
Verification Status
verified_backend
Last Verified At
2026-04-18
metric

Avg Deposit

Period-mode average deposit amount per depositor, or lifetime average deposit amount per depositor in EUR.

Aliases
mkt performance avg deposit
Backend Formula
avg_deposit_amount or avg_deposit_per_depositor_eur depending on mode
Verification Status
verified_backend
Last Verified At
2026-04-18
metric

Withdrawal Rate

Withdrawals expressed as a percentage of deposits for the current row.

Aliases
mkt performance withdrawal rate
Backend Formula
withdrawal_amount / deposit_amount * 100
Verification Status
verified_backend
Last Verified At
2026-04-18
Operational notes

Notes

item

The service switches between period and lifetime SQL depending on `usePeriodData`.

item

The visible table columns change materially with the mode toggle and should not be documented as one fixed grid.

item

Period mode exposes backend deduction columns such as `bonus_payout`, `cashback`, `rakeback_calendar`, `correction`, `adjustment_amount`, and `total_marketing`.

Related references

Related pages

pageReporting

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

pageReporting / Affiliate Events Report

Audit log of the events and saved amounts the platform sent to the affiliate system, with per-currency successful totals and a CSV export.

pageReporting / Bonus Performance

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

pageReporting / 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.

pageReporting / Change Notification Detail

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

pageReporting / Change Notifications

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