Operator guideENcrmaffiliatesdashboardreporting

Affiliate Deals / Dashboard

Deal-period performance report that combines traffic, deposit, GGR, NGR, payout, and ROI metrics for affiliate deals.

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

This dashboard evaluates each affiliate deal row against delivered traffic and revenue.

Each row represents one deal period and combines:

  • traffic volume
  • registration and deposit outcomes
  • GGR and NGR sent through affiliate events
  • CPA and revshare payouts
  • final ROI after contract costs

When to use it

  • check whether a PID deal is commercially profitable
  • compare traffic volume with actual deposit and revenue outcomes
  • reconcile CPA-sent counts with CPA payout
  • understand how revshare payout was derived
  • explain why a deal with traffic still has weak ROI

How to read it

This page is deal-period based, not global-date based.

The backend first computes the effective period for each deal:

  • start at the deal start_date
  • end at explicit end_date
  • or, if no end date exists, end one day before the next deal for the same PID starts

That effective period is then used to join traffic, registrations, deposit KPIs, and affiliate events.

Filters that change the result

  • PID

The current dashboard does not expose an independent date filter. The deal period itself is the time window.

Why values can differ from other affiliate reports

  • GGR and NGR here are taken from successful Affise events attached to the deal players, not from a generic PID summary.
  • Deposits Amount EUR comes from nx.user_kpi_summary, while GGR and NGR come from affiliate events.
  • ROI is an absolute EUR result, not a percentage ratio.

Metric dictionary

GGR

GGR on this dashboard is derived from affiliate events that were actually sent successfully:

  • sum of bets/* events
  • minus sum of wins/* events

NGR

NGR is the sum of successful ngr/* affiliate events for players tied to the deal period.

CPA Payout

CPA Payout equals:

  • CPA Sent Count
  • multiplied by the contractual CPA amount on the deal row

RevShare Base

RevShare Base is the same backend value as NGR on this dashboard.

RevShare Payout

RevShare Payout equals:

  • NGR
  • multiplied by RevShare / 100

ROI

ROI is calculated as:

  • NGR
  • minus Fixed Fee
  • minus CPA Payout
  • minus RevShare Payout

Known caveats

  • End Date may display as open-ended in the UI, but the backend still computes effective_end_date for reporting joins.
  • CPA Rate is the contract rate, not the amount already paid out. Use CPA Payout for the actual computed payout.
  • RevShare Base and NGR are the same source measure in the current SQL.
Calculation notes

Backend calculations

calculation

effective-end-date

Caps open-ended deals at the day before the next deal for the same PID starts.

Formula
COALESCE(end_date, LEAD(start_date by pid) - interval '1 day')
calculation

deposits-amount-eur

Converts deposit amount to EUR from `nx.user_kpi_summary`.

Formula
SUM(user_kpi_summary.total_deposit_amount / NULLIF(exchange_rate, 0))
calculation

ggr-eur

Uses successful affiliate events attached to the deal-period player set.

Formula
SUM(affiliate bets events) - SUM(affiliate wins events)
calculation

ngr-eur

Uses successful `ngr/*` affiliate events attached to the deal-period player set.

Formula
SUM(successful affiliate ngr events)
calculation

cpa-payout

Multiplies successful CPA event count by the contract CPA amount.

Formula
cpa_sent_count * cpa
calculation

revshare-payout

Calculates revshare payout from the NGR base.

Formula
ROUND(ngr_eur * rev_share / 100.0, 2)
calculation

roi

Returns the final absolute result after subtracting deal costs from NGR.

Formula
ROUND(ngr_eur - fixed_fee - cpa_payout - revshare_payout, 2)
Field dictionary

Fields

field

PID

Affiliate PID for the reported deal row.

Data Type
string
field

Start Date

Deal start date used for the reporting window.

Data Type
date
field

End Date

Explicit contract end date. Open-ended rows can still have a backend effective end date.

Data Type
date
field

Fixed Fee

Contractual fixed fee for the deal row.

Data Type
amount
field

CPA Rate

Contractual CPA amount used to calculate payout.

Data Type
amount
field

RevShare

Contractual revshare percentage.

Data Type
percentage
field

Responsible

Owner of the deal row.

Data Type
string
field

Clicks

Traffic clicks attributed to the PID during the deal period.

Data Type
integer
field

Registrations

Registrations attributed to the PID during the deal period.

Data Type
integer
field

FTDs

Distinct first-time depositors tied to the deal-period player set.

Data Type
integer
field

Depositors

Distinct players with at least one deposit.

Data Type
integer
field

Deposits Count

Total number of deposits from the deal-period player set.

Data Type
integer
field

Deposits Amount

Deposit amount converted to EUR from user KPI summary.

Data Type
amount
field

GGR

Gross gaming revenue derived from successful affiliate events.

Data Type
amount
field

NGR

Net gaming revenue derived from successful affiliate events.

Data Type
amount
field

CPA Sent

Count of successful `ftd/*` affiliate events sent for the deal-period player set.

Data Type
integer
field

CPA Payout

Actual CPA payout derived from sent CPA events and the contractual CPA rate.

Data Type
amount
field

RevShare Base

NGR value used as the base for revshare payout.

Data Type
amount
field

RevShare Payout

Actual revshare payout derived from NGR and the contractual revshare percentage.

Data Type
amount
field

ROI

Absolute EUR result after subtracting contract costs from NGR.

Data Type
amount
Filter dictionary

Filters

field

PID

Limits the dashboard to one PID.

Type
text
Metric dictionary

Metrics

metric

GGR

Gross gaming revenue from successful affiliate events for the deal-period player set.

Aliases
affiliate deals ggr, affiliate dashboard ggr, deal ggr
Backend Method
GetAffiliateDealPerformanceService
Backend Formula
SUM(bets/*) - SUM(wins/*)
Last Verified At
2026-04-14
metric

NGR

Net gaming revenue from successful `ngr/*` affiliate events for the deal-period player set.

Aliases
affiliate deals ngr, affiliate dashboard ngr, deal ngr
Backend Method
GetAffiliateDealPerformanceService
Backend Formula
SUM(ngr/* successful affise events)
Last Verified At
2026-04-14
metric

CPA Payout

Actual CPA payout for the row, derived from qualified CPA events and the contract CPA rate.

Aliases
affiliate cpa payout, cpa payout
Backend Method
GetAffiliateDealPerformanceService
Backend Formula
cpa_sent_count * cpa
Last Verified At
2026-04-14
metric

RevShare Payout

Actual revshare payout for the row, derived from NGR and the revshare percentage.

Aliases
affiliate revshare payout, revshare payout
Backend Method
GetAffiliateDealPerformanceService
Backend Formula
ROUND(ngr_eur * rev_share / 100.0, 2)
Last Verified At
2026-04-14
metric

ROI

Absolute EUR result after subtracting fixed fee, CPA payout, and revshare payout from NGR.

Aliases
affiliate roi, affiliate deals roi, deal roi
Backend Method
GetAffiliateDealPerformanceService
Backend Formula
ngr_eur - fixed_fee - cpa_payout - revshare_payout
Comparison Notes
ROI is displayed as an absolute currency amount, not as a percentage.
Last Verified At
2026-04-14
Operational notes

Notes

item

The dashboard joins affiliate-links traffic, user KPI summary, and successful affiliate events by the computed deal period.

item

`GGR` and `NGR` here come from successful affiliate events, not from a generic affiliate summary endpoint.

item

`ROI` is an absolute EUR result, not a ratio.

Related references

Related pages

pageAffiliate Deals / Form

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

pageAffiliate Deals / List

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

pageAffiliate Deals Overview

Operator guide for affiliate-deal records, their create/edit flow, and the performance dashboard that reconciles contract settings with delivered traffic and revenue metrics.

pageAffiliate Payment Settings

Operator documentation for the affiliate payment configuration workspace, including payment settings and sending-window tabs.

pageAffiliate Payment Settings / Detail

Saved affiliate payment-setting detail page for reviewing one configured record.

pageAffiliate Payment Settings / Form

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