Operator guideEN

Affiliate Settings / Conversion Stats

Affiliate conversion report with daily conversion trends, top referral sources, traffic details, summary cards, 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

Conversion Stats explains how affiliate traffic moves from clicks to registrations and from registrations to first-time depositors. Use it when you need to review traffic quality, daily conversion movement, referral URL performance, or PID-level traffic breakdowns.

The page has two tabs:

  • Daily Statistics shows daily clicks, unique clicks, registrations, first-time depositors, first deposits, deposit amount, and conversion ratios.
  • Traffic Details groups traffic by affiliate key, PID, and referral URL, then shows clicks, unique visitors, registrations, depositors, deposit amount, average value, and first/last click dates.

How to read the summary cards

The four cards at the top switch with the selected tab.

  • Total Clicks shows click volume and the unique visitor/click count for the active tab.
  • Registrations shows users registered from the selected traffic scope. On Daily Statistics, the small CTR chip is registrations divided by total clicks.
  • Depositors shows first-time depositors. On Daily Statistics, the RTD chip is depositors divided by registrations.
  • Total Deposits shows first-deposit amount in the reporting currency.

Filters and actions

Start Date and End Date define the report period. If no dates are selected, the report falls back to the recent default period.

Search by Referral URL filters both tabs by referral URL text.

Search by PID and Sort By are visible only on the Traffic Details tab. Sorting can prioritize clicks, registrations, depositors, or deposit amount.

Reset returns the page to the default recent period, clears text filters, resets sorting to clicks, and returns both tabs to their first page.

Refresh reloads the currently selected tab with the current filter state.

Export downloads the currently selected tab. Export uses the same filters as the visible tab and uses a larger export limit than the table page size.

Important caveats

  • There is currently no visible affiliate selector on this page, so operators cannot narrow this screen to one affiliate from the visible filters.
  • Suspicious or internal traffic is excluded by default. This can make totals lower than raw affiliate-link click counts.
  • Daily rows are generated for each date in the selected range. Days without activity can still appear as zero rows.
  • Deposit amounts are first-deposit reporting amounts. This report is not a full revenue, NGR, or lifetime-value report.
  • The referral URL block ranks only the top visible URLs by click volume.
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.

Calculations7 topicsOpen details

Date window

Explains which period is used when date filters are empty.

Formula
Conversion and traffic queries use affiliate-link created_at >= COALESCE(startDate, CURRENT_DATE - INTERVAL '30 days') and <= COALESCE(endDate, CURRENT_DATE + INTERVAL '1 day'). Daily date buckets are generated from startDate/current default through endDate/current default.
Caveats
Daily statistics can include zero rows for generated date buckets., End date is used as an inclusive upper boundary in the verified SQL condition.

Default traffic-quality filtering

Explains why report totals can be lower than raw affiliate-link click counts.

Formula
Unless includeSuspicious, onlySuspicious, or trafficQuality is provided, the shared affiliate-link traffic filter keeps rows where COALESCE(is_suspicious, false) = false. trafficQuality can explicitly filter COALESCE(traffic_quality, 'human').
Caveats
The current page does not render suspicious/internal traffic controls.

Daily Statistics row formation

Explains how daily rows are built.

Formula
Generate date buckets, left join daily click counts from affiliate links, daily registration counts from users joined by owner UUID, and daily first-deposit banking rows, then COALESCE missing values to 0.

Top Referral Sources

Explains which referral URLs appear in the source block.

Formula
Group non-empty referred_url values, compute click/registration/depositor/deposit metrics, order by total_clicks descending, and return the first 10 rows.

Traffic Details row formation

Explains how the second tab groups traffic.

Formula
Group affiliate-link traffic by affiliate_key, PID payload value, and referred_url. Count distinct click ids and owner UUID visitors, sum registered/deposited flags, sum first-deposit amounts, and calculate first/last click timestamps.

Conversion ratios

Explains the denominator differences behind CTR and RTD labels.

Formula
Daily overall CTR uses registrations / total_clicks. Referral-source CTR uses registrations / unique_clicks. Traffic Details CTR uses registrations / unique_visitors. RTD uses depositors / registrations. Each formula rounds to 2 decimals and returns 0 for zero denominators.

CSV export

Explains what Export downloads.

Formula
Export sends exportCsv=true with limit 10000 to the active tab endpoint. Daily export returns daily rows, a total row, and top referral sources. Traffic export returns traffic-detail rows and prepends a total row when summary data exists. Both controllers stream text/csv directly.
Caveats
Export uses the active tab; switching tabs changes the export endpoint and columns.
Filters7 topicsOpen details

Start Date

Start of the affiliate traffic reporting period.

Data Type
date
Default Behavior
Defaults to the recent period when left unset.

End Date

End of the affiliate traffic reporting period.

Data Type
date
Default Behavior
Defaults to the current reporting boundary when left unset.

Search by Referral URL

Filters both tabs by text contained in the referral URL.

Data Type
string

Search by PID

Filters traffic-detail rows by PID text.

Data Type
string
Visibility
Traffic Details tab only

Sort By

Sorts traffic-detail rows by the selected performance measure.

Data Type
enum
Visibility
Traffic Details tab only
Allowed Values
clicks, registrations, depositors, amount
Default Value
clicks

Affiliate key

The report contract supports affiliate-key scoping, but the current page does not render a visible affiliate selector.

Data Type
string
Visibility
request-state-not-currently-rendered

Show only with data

Backend-supported option for excluding empty rows. The current page initializes it to false and does not render a visible toggle.

Data Type
boolean
Visibility
request-state-not-currently-rendered
Summary cards7 topicsOpen details

Total Clicks

Count of affiliate-link click rows in the active tab scope.

Data Type
integer

Unique

Daily tab shows deduplicated click fingerprints; Traffic Details shows distinct owner UUID visitors.

Data Type
integer

Registrations

Count of registered users attributed to the active traffic scope.

Data Type
integer

Depositors

Count of first-time depositors in the active traffic scope.

Data Type
integer

Total Deposits

Sum of first-deposit reporting amounts in the active traffic scope.

Data Type
money

CTR

Overall registrations divided by total clicks.

Data Type
percentage
Visibility
Daily Statistics tab only

RTD

Overall first-time depositors divided by registrations.

Data Type
percentage
Visibility
Daily Statistics tab only
Metrics9 topicsOpen details

Total Clicks

Count of affiliate-link click rows in the active report scope.

Aliases
affiliate conversion total clicks, conversion stats clicks
Formula
Summary and daily statistics count distinct nx.affiliate_links.affiliate_link_id after date, affiliate-key, referral URL, and traffic-quality filters.

Unique Clicks

Deduplicated click fingerprint count used by Daily Statistics and Top Referral Sources.

Aliases
affiliate conversion unique clicks, conversion stats unique
Formula
Count distinct concatenation of PID, IP address, browser agent, and country code for rows whose browser agent is null or not bot-like.
Caveats
Traffic Details uses distinct owner UUID visitors instead of this fingerprint.

Registrations

Registered users attributed to affiliate-link traffic in the active scope.

Aliases
affiliate conversion registrations, conversion stats registrations
Formula
Count distinct public.users.user_id joined by users.unique_id = affiliate_links.owner_uuid.

Depositors

Users with successful first-deposit activity in the active scope.

Aliases
affiliate conversion depositors, conversion stats ftd users
Formula
Count distinct transaction_bankings.actionee_id where status=1, transaction_type='deposit', and is_first_deposit=true.

Total Deposits

First-deposit amount for the active traffic scope.

Aliases
affiliate conversion deposit amount, conversion stats deposit amount
Formula
Sum transaction_bankings.primary_currency_amount for successful first-deposit rows.
Currency Basis
Reporting Currency: primary currency amount stored on the banking transaction | Rate Source: no additional conversion in this report path | Rounding Boundary: displayed by the frontend currency formatter

Click to Registration Ratio

Percentage of clicks or unique visitors that became registrations, depending on the tab.

Aliases
affiliate conversion ctr, click to reg, CTR
Formula
Daily summary uses registrations / total_clicks * 100. Top Referral Sources uses registrations / unique_clicks * 100. Traffic Details uses registrations / unique_visitors * 100. All formulas round to 2 decimals and return 0 when denominator is 0.

Registration to Depositor Ratio

Percentage of registrations that became first-time depositors.

Aliases
affiliate conversion rtd, reg to dep, RTD
Formula
depositors / registrations * 100, rounded to 2 decimals, or 0 when registrations is 0.

Avg/Visitor

Deposit amount per unique visitor in the Traffic Details tab.

Aliases
average value per visitor, affiliate traffic average visitor value
Formula
total_deposit_amount / unique_visitors, rounded to 2 decimals, or 0 when unique_visitors is 0.

Avg Deposit

Deposit amount per depositor in the Traffic Details response.

Aliases
affiliate traffic average deposit
Formula
total_deposit_amount / depositors, rounded to 2 decimals, or 0 when depositors is 0.
Caveats
The current table does not render Avg Deposit, but CSV export includes it.
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.