Operator guideEN

Affiliate Settings / PID Performance

PID-level affiliate performance report with period and lifetime modes, backend-calculated deposits, withdrawals, GGR, NGR, and CSV export.

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

PID Performance groups affiliate traffic and value by PID. Use it when an affiliate, media buyer, or BI user asks how a PID performed for registrations, depositors, deposits, withdrawals, gaming activity, GGR, NGR, and deductions.

The report has two modes:

  • Period Data on: values are calculated from banking transactions and gaming summary rows inside the selected date range.
  • Period Data off: values come from the lifetime KPI summary attached to users whose registration belongs to the selected date range.

When to use it

  • compare PIDs by deposits, NGR, attributed GGR, active players, or users
  • inspect period performance for a campaign window
  • check whether a PID has active gaming value before sending the result to an affiliate
  • export PID, sub_id_2, or full analytics rows when detailed reporting is enabled for the brand theme

How to read the main values

  • Total PIDs is the number of PID groups in the current scope.
  • Total Depositors counts users with successful deposit activity in the current mode.
  • Total Deposits and Withdrawals are converted to EUR/base reporting amounts in backend SQL.
  • Attributed GGR is bets - wins for the PID scope. In period mode it is calculated from period gaming rows.
  • NGR is backend-provided net gaming revenue for the PID scope. Do not recalculate it from visible columns unless you are tracing the backend query.

Filters that change the result

  • PID limits the report to one PID.
  • sub_id_2 is available only in period mode when detailed reporting is enabled.
  • Country limits the affiliate PID user cohort by country code.
  • Subcategory 1 and Compare With add active-player percentage columns for selected game subcategories.
  • Start Date and End Date define the period window, or the registration window in lifetime mode.
  • Order By sorts by users/active players, deposits, NGR, or attributed GGR.
  • Active Only keeps period rows with active players when period mode is on.
  • Detailed view expands PID rows into sub_id_2 detail where supported.

Important caveats

  • Test users are excluded from the affiliate PID cohort.
  • Period mode and lifetime mode are not interchangeable. Period mode reads period banking/gaming activity; lifetime mode reads accumulated KPI summary values for users registered in the date range.
  • CSV export uses the same backend endpoint with exportCsv=true; export mode controls whether PID-only, sub_id_2, or full analytics rows are exported.
  • Detailed PID/sub-ID behavior is theme-gated in backend and FE. If the brand theme does not enable it, the page behaves as a PID-level report.
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.

Calculations8 topicsOpen details

Period vs lifetime query selection

Explains why the same PID can show different values when Period Data is toggled.

Formula
usePeriodData selects getAffiliatePidPerformanceByPeriod*.sql; false selects getAffiliatePidPerformance.sql backed by nx.user_kpi_summary.

PID cohort

Defines which users are included before metrics are aggregated.

Formula
Start from analytics.mv_affiliate_pid_users joined to public.users and exclude deleted/test users, then apply PID, affiliate, country, and traffic-quality filters.

Period Attributed GGR

Revenue attributed to the PID inside the selected activity period.

Formula
bet_amount - win_amount

Withdrawal Rate

Shows how much of deposit volume has been withdrawn in the current scope.

Formula
CASE WHEN deposit_amount > 0 THEN (withdrawal_amount / deposit_amount) * 100 ELSE 0 END

Average Deposit

Average deposit amount for depositors in the current scope.

Formula
Period mode uses deposit_amount / depositors; lifetime mode uses total_deposits_eur / depositors with KPI fallback fields.

House Edge

Revenue share of bet volume.

Formula
CASE WHEN bet_amount > 0 THEN ((bet_amount - win_amount) / bet_amount) * 100 ELSE 0 END

Subcategory active-player percentages

Shows the share of unique active players who played selected game subcategories.

Formula
Detailed period SQL marks users with qualifying game-category activity and returns active-player percentage fields for the selected subcategories.

CSV export

Downloads the same filtered report scope with backend-selected CSV columns.

Formula
exportCsv=true removes normal pagination, formats numeric fields, selects period or lifetime CSV column sets, and streams text/csv with filename pid_performance_<mode>_<start>_to_<end>.csv.
Filters11 topicsOpen details

PID

Restricts the report to one affiliate PID.

Data Type
string

sub_id_2

Restricts detailed period mode to one sub-ID. Disabled when period mode is off.

Data Type
string

Country

Restricts the affiliate PID user cohort by country code.

Data Type
country-code

Subcategory 1

Adds a percentage column for active players who played games in the selected subcategory.

Data Type
integer

Compare With

Adds a second subcategory percentage column for side-by-side active-player comparison.

Data Type
integer

Start Date

Start of the selected period. In lifetime mode it filters the user's registration date.

Data Type
date

End Date

End of the selected period. In lifetime mode it filters the user's registration date.

Data Type
date

Order By

Sorts rows by users/active players, deposits, NGR, or attributed GGR.

Data Type
enum
Allowed Values
users, deposits, ngr, ggr, players

Active Only

In period mode, keeps only rows with active players.

Data Type
boolean

Period Data

Switches between period banking/gaming calculations and lifetime KPI summary fields.

Data Type
boolean

Detailed view

Expands supported period reports from PID rows into PID plus sub_id_2 rows.

Data Type
boolean
Summary cards5 topicsOpen details

Total PIDs

Number of PID groups in the current scope.

Data Type
integer

Total Depositors

Count of depositors in the current report mode.

Data Type
integer

Total Deposits

Sum of deposits in the current scope, converted in backend SQL.

Data Type
money

Total NGR

Backend NGR total for the current PID scope.

Data Type
money

Total Attributed GGR

Backend attributed GGR total for the current PID scope.

Data Type
money
Metrics8 topicsOpen details

Total PIDs

Number of PID groups in the current scope.

Aliases
pid performance total pids, affiliate pid count
Formula
Period mode counts distinct PID values from the materialized report rows; lifetime mode counts distinct PID values from the KPI-backed PID query.

Total Depositors

Count of users with successful deposit activity in the current mode.

Aliases
pid performance depositors, affiliate pid depositors
Formula
Period mode counts users with SUCCESS deposit events; lifetime mode counts users with first_deposit_date in user KPI summary.

Total Deposits

Deposit amount for the current PID scope.

Aliases
pid performance deposits, affiliate pid deposit amount
Formula
Period mode sums SUCCESS deposit transaction amounts divided by transaction conversion_rate; lifetime mode sums user_kpi_summary.total_deposit_amount divided by KPI exchange_rate.
Currency Basis
Reporting Currency: EUR/base reporting amount | Rate Source: transaction_bankings.conversion_rate in period mode; nx.user_kpi_summary.exchange_rate in lifetime mode | Missing Rate Behavior: COALESCE(conversion_rate, 1)

Total Withdrawals

Withdrawal amount for the current PID scope.

Aliases
pid performance withdrawals
Formula
Period mode sums SUCCESS/APPROVED withdrawal amounts divided by transaction conversion_rate; lifetime mode sums user_kpi_summary.total_withdrawal_amount divided by KPI exchange_rate.
Currency Basis
Reporting Currency: EUR/base reporting amount | Rate Source: transaction_bankings.conversion_rate in period mode; nx.user_kpi_summary.exchange_rate in lifetime mode | Missing Rate Behavior: COALESCE(conversion_rate, 1)

Total Attributed GGR

Gross gaming revenue attributed to the PID scope.

Aliases
pid performance ggr, attributed ggr
Formula
Period mode uses bet_amount - win_amount from player_game_daily_summary or fallback casino transaction rows; lifetime mode sums user_kpi_summary.total_ggr divided by KPI exchange_rate.
Currency Basis
Reporting Currency: EUR/base reporting amount | Rate Source: analytics base columns in period mode; nx.user_kpi_summary.exchange_rate in lifetime mode

Total NGR

Backend net gaming revenue for the PID scope.

Aliases
pid performance ngr, affiliate pid ngr
Formula
Period mode sums ngr_base from analytics player-game daily summary/fallback logic; lifetime mode sums user_kpi_summary.ngr divided by KPI exchange_rate.
Currency Basis
Reporting Currency: EUR/base reporting amount | Rate Source: analytics base columns in period mode; nx.user_kpi_summary.exchange_rate in lifetime mode

Total Active Players

Users with period gaming activity in the selected PID scope.

Aliases
pid performance active players
Formula
Sum active_players from period report rows; active-only mode filters rows with active_players > 0.

House Edge

GGR as a percentage of bets.

Aliases
pid performance house edge
Formula
CASE WHEN bet_amount > 0 THEN ((bet_amount - win_amount) / bet_amount) * 100 ELSE 0 END
More help

Related pages

Affiliate Deals / Dashboard

Affiliate deal cohort report that period-bounds registrations, then combines the selected players with cumulative deposit and linked-event values.

Affiliate Deals / Form

Create and edit form for affiliate deals, including PID, date window, commercial terms, and responsible person.

Affiliate Deals / List

Searchable table of affiliate deal rows with PID filter, create action, dashboard shortcut, and edit/delete row actions.

Affiliate Payment Settings / Detail

Detail/edit shell for one saved affiliate payment-setting record.

Affiliate Payment Settings / Form

Create and edit form for one affiliate payment-setting record, with visible PID targeting, minimum deposit threshold, and active-state control.

Affiliate Payment Settings / List

Affiliate payment settings inventory page for reviewing configured rows and opening saved records.