PSP Fee Overview — Report documentation

Purpose

The PSP Fee Overview report gives finance teams a consolidated view of fees and fee rates by PSP, method (deposit vs withdrawal), and brand: successful volumes and values, fee components (success fees, settlement, FX, chargebacks, etc.), and percentage metrics that express total cost and operator fee as a share of volume. It supports comparing PSP economics, spotting outliers, and tracking fee levels over time alongside daily snapshot trends. Use it when you need to answer questions like “Which PSP is cheapest relative to volume?”, “How did total fee or volume change vs yesterday?”, or “What is the split between operator fee and actual payment cost?”

What data this report uses

This report uses two data sources that complement each other:

v_country_buy_rates_2 — Buy-rates style aggregates with measures such as successful transaction amount and fee totals. This source feeds the main detail table and the percentage metrics (Payment Cost %, Operator Fee %, Actual Payment Fee %). For base fields, grain, and semantics, see the v_country_buy_rates_2 — User Guide. Report-specific calculations are in v_country_buy_rates_2 — Calculated fields.
Buy Rates Snapshot (pipeline table daily_snapshot_buy_rates) — Rolling daily snapshot of buy-rates statistics by organisation and PSP account. This source feeds time-series and comparison visuals (successful volume over time, total fee by PSP with day-over-day change, deposit vs withdrawal volume splits). The Method dimension used on the snapshot is derived in Looker from psp_account naming (deposit vs withdrawal buckets). For semantics and columns, see daily_snapshot_buy_rates — User Guide. Report-specific fields and filters are in Buy Rates Snapshot — Calculated fields.

Data source reference (pipeline)

Looker data source	Pipeline resource	Calculated fields doc	User doc
v_country_buy_rates_2	v_country_buy_rates_2	v_country_buy_rates_2_calculated_fields.md	v_country_buy_rates_2_documentation.md
Buy Rates Snapshot	daily_snapshot_buy_rates	daily_snapshot_buy_rates_calculated_fields.md	daily_snapshot_buy_rates_documentation.md

Filters and how to use them

The report has a filter bar. Use these filters to narrow period, entity, brand, PSP, method, and account so you can focus on one corridor or compare PSPs side by side.

Filters tied to v_country_buy_rates_2

Filter (as in Looker)	What it does	How to use it
Buy rates - DP	Keeps only rows where method is DEPOSIT.	Turn this on when you want deposit-only buy rates and fee percentages; the main detail table and its percentage columns will exclude withdrawal rows.
Buy Rates - Other	Keeps only rows where psp is Other.	Use when you need to isolate the “Other” PSP bucket—e.g. to analyse generic or non-named PSPs separately.

For the exact filter definitions and how they tie to the v_country_buy_rates_2 data source, see v_country_buy_rates_2 — Calculated fields (section Filters used in report(s)).

Filters tied to Buy Rates Snapshot

Filter (as in Looker)	What it does	How to use it
Snapshot - DP	Keeps only snapshot rows where the derived Method equals DEPOSIT (accounts whose suffix maps to FTD/TRUSTED in the snapshot naming rules).	Use for deposit-side snapshot trends and totals only—e.g. time series and “yesterday vs 2 days ago” blocks that should show deposit volume or fee.
Snapshot - WD	Keeps only rows where Method equals WD (withdrawal-style accounts by suffix).	Use for withdrawal-side snapshot trends and totals only.

These filters segment the snapshot by account naming convention; the snapshot table has no separate method column. For how Method is derived and how the filters are scoped, see daily_snapshot_buy_rates — Calculated fields (section Filters used in report(s)).

Other filters on the report

From the report layout you will also see filters such as Brand, PSP Account, Method, PSP, Entity, and date range (e.g. month or custom range). They narrow which rows appear in tables and which period the time series cover. Use Entity and Brand when you need one legal entity or brand only; use PSP or PSP Account when focusing on a single provider or account. The date range controls the period for all visuals that use time.

Summary scorecards (Successful Tx, Net Successful Value, Total Fee)

The report includes scorecards that show rolled-up totals for the current filter selection: typically Successful Tx (count of successful transactions), Net Successful Value (sum of successful transaction amounts, in currency—negative for withdrawals), and Total Fee (sum of all fees in scope). These numbers are the main headline totals before you drill into the detail table. Use them to quickly see overall volume and total fee for the selected period and filters; then use the main table or PSP summary to see how that total splits by PSP, method, or brand.

Main detail table (buy rates and fee %)

The primary table lists one row per combination of month, method (e.g. DEPOSIT, WITHDRAWAL), PSP, PSP friendly name, and brand, with volume, value, and fee columns. It is backed by v_country_buy_rates_2.

What the columns mean (in user terms):

Success Tx — Count of successful transactions in that row’s segment.
Success Value — Sum of successful transaction amounts; for withdrawals this is often negative (money going out). Success Value (excl. Operator Fee) and Success Tx Fee / Success Value Fee break out fee-related amounts where the pipeline exposes them.
Failed Tx, Failed Tx Fee, CB Value — Count and value of failed transactions, failed-transaction fees, and chargeback-related value where present.
Settlement Fee, Monthly Fee, FX Fee — Components of cost where the pipeline exposes them; Total Fee is the rolled-up fee total for the row.
Operator Fee — Fee attributed to the operator/product side where available.
Payment Cost %, Operator Fee %, Actual Payment Fee % — Percentage-style rates relative to successful volume (aggregated in Looker). Payment Cost % is total fee as a share of volume; Operator Fee % is the operator-fee share; Actual Payment Fee % is the difference (net “payment” fee after operator fee). So you can compare “how much are we paying in total vs volume?” and “how much of that is operator vs actual payment cost?”

A grand total row at the bottom sums the main numeric columns across all rows in the table. Use this table to compare fee levels and fee rates across PSPs and brands, and to separate deposits from withdrawals via Method. For the exact formulas of the three percentage metrics, see v_country_buy_rates_2 — Calculated fields (Metrics). For base measure definitions (total_fee, piq_user_fee, successful_trx_amount), use the data source user doc sections referenced there.

PSP summary table (Success Tx, Gross Deposit, Player Deposit Fee, Net Deposit)

A summary table by PSP shows Success Tx, Gross Deposit, Player Deposit Fee, and Net Deposit (labels as on screen). Each row is one PSP; the numbers are rolled up so you can compare providers without scrolling the full detail table. Gross Deposit is the total deposit value before deducting fees; Player Deposit Fee is the fee component; Net Deposit is the result after that fee. Use this when you want a compact PSP-level view of volume and fee for the selected period and filters. For column semantics and which data source backs this table, refer to the calculated-fields and user docs for the source that powers this visual in your Looker instance.

Successful Deposit Value (time series chart)

A time series chart shows how successful deposit value (in currency) evolves day by day over the selected date range. The horizontal axis is the snapshot date (e.g. Feb 12–Mar 12); the vertical axis is the summed successful deposit value. The data comes from Buy Rates Snapshot (record_date and summed successful amounts). Where the Snapshot - DP filter is applied, the series reflects deposit-style accounts only. Use this chart to spot trends, seasonality, or sudden shifts in deposit volume after configuration or route changes. For how Method is derived for filtering, see daily_snapshot_buy_rates — Calculated fields (Method calculated field).

Successful Volume by PSP over time (stacked or grouped chart)

Another time series shows successful volume (deposit and/or withdrawal, depending on filters) over the same snapshot dates, often broken out by PSP (e.g. stacked area or grouped bars). Deposit-focused series align with Snapshot - DP where that filter is on; withdrawal volume (often negative in value) aligns with Snapshot - WD or withdrawal slices. Use it to see which PSPs drive volume over time and how the mix changes day to day. Data source and Method logic are the same as in the Successful Deposit Value chart; see the snapshot calculated-fields doc for details.

Successful Withdrawal Volume (time series)

A separate time series shows successful withdrawal volume over snapshot dates—typically negative values (money out). It is driven by Buy Rates Snapshot with Snapshot - WD (or equivalent) so that only withdrawal-style accounts are included. Use it to monitor withdrawal volume trends and to compare with deposit trends on the same report. For how withdrawal vs deposit is determined from psp_account, see daily_snapshot_buy_rates — Calculated fields.

PSP — Total Fee Yesterday vs 2 Days Ago

A table titled along the lines of PSP - Total Fee Yesterday vs 2 Days Ago lists each PSP with Total Fee (for the “yesterday” snapshot) and a % Δ (percent change) column comparing that to the “2 days ago” value. So you can quickly see “did total fee go up or down vs the recent baseline?” without exporting raw data. Use it for daily fee monitoring and to flag PSPs with large percentage moves. The underlying data is from Buy Rates Snapshot; the comparison logic is fixed in the report (yesterday vs two days ago).

PSP — Deposit Successful Volume Y.day vs 2 Days Ago

A table titled PSP - Deposit Successful Volume Y.day vs 2 Days Ago shows each PSP with Volume (deposit successful volume for “yesterday”) and % Δ vs “2 days ago”. It answers “how did deposit volume change vs the recent baseline?” and helps spot big moves by PSP. Data comes from Buy Rates Snapshot with deposit-oriented logic (e.g. Snapshot - DP). Use it alongside the Total Fee comparison to relate volume changes to fee changes.

PSP — WD Successful Volume Y.day vs 2 Days Ago

A table titled PSP - WD Successful Volume Y.day vs 2 Days Ago does the same for withdrawal volume: each PSP with Volume (withdrawal successful volume for “yesterday”) and % Δ vs “2 days ago”. Withdrawal volumes are typically negative. Use it to see which PSPs had the largest withdrawal volume and how that changed day over day. Data is from Buy Rates Snapshot with Snapshot - WD (or equivalent) so only withdrawal-style accounts are included.

Method / PSP / PSP Account breakdown table

A compact table by method, PSP, and psp_account (with Success Tx, Gross Deposit, Player Deposit Fee, Net Deposit) gives a lower-level split—useful when many rows share a generic PSP label such as Other or ThreeDS2DataCollect. You can see exactly which psp_account values contribute to those buckets and reconcile with internal naming. This table is backed by Buy Rates Snapshot grain and the Method dimension derived from psp_account in Looker. When you need deposit-only or withdrawal-only rows in this table, the same Snapshot - DP and Snapshot - WD filters apply; see daily_snapshot_buy_rates — Calculated fields for filter definitions.

Where to read more

Percentage metrics and formulas (v_country_buy_rates_2): v_country_buy_rates_2 — Calculated fields
Snapshot Method and snapshot filters: daily_snapshot_buy_rates — Calculated fields
Field-level semantics: v_country_buy_rates_2 — User Guide, daily_snapshot_buy_rates — User Guide
Process and template: Report documentation guide

Structure and labels aligned with PDF export General_Structure_-_Finance_Overview (PSP Fee Overview section) and calculated-fields docs for v_country_buy_rates_2 and Buy Rates Snapshot.