Time-to-Wallet: esasy metrika

1) TTW kesgitlemesi we wariantlary

• TTW₍deposit ₎: 'Töleg' basmak → Pul oýnamak üçin elýeterlidir '.
• Ol UX/3DS, PSP/bankda ygtyýarlylandyrmagy, balansy tassyklamagy we ýazmagy öz içine alýar.

TTW₍payout ₎: 'Çek "basmak → Daşary gapjykdaky/bankdaky pul'.
Ol töwekgelçilik/KYC/SoF barlaglaryny, same-method/ND-geýtleri, koridoryň orkestrleşmegini, PSP/shemasynyň tassyklamasyny we bankyň/gapjygyň postingini öz içine alýar.

2) Näme üçin TTW P & L-metrika?

Konwersiýa we AR: çalt depozit ↑ ilkinji nyrhyň/sessiýanyň ähtimallygy.
Saklamak we ynam: çalt netijeler ↓ churn we sapport biletleri.
Bahasy: instant-rails köplenç has gymmat ⇒ "tizlik bahasy" balansyna mätäç.
Amal töwekgelçiligi: TTW-iň uzyn "guýruklary" hadysalaryň toparlaryny we chargeback-dartgynlygy döredýär.

3) TTW-iň tapgyrlar boýunça dekompozisiýasy

3. 1. Depozitler

1. UI/Checkout (render, tassyklama, 3DS)

2. PSP Auth (authorize)

3. Capture/Booking (deňagramlylygy tassyklamak, täzelemek)

4. Fallback/Retry (при soft-decline)

`TTW₍deposit₎ = t_UI + t_3DS + t_auth + t_capture + t_write_balance`

3. 2. Netijeler

1. Deslapky barlaglar (KYC/SoF, ND/same-method, RG/AML çäkleri)

2. Risk decision (awto/el bilen)

3. Payout orchestration (koridor saýlamak: SEPA Instant/PIX/Faster Payments/RTP/push-to-card/A2A/e-wallet)

4. PSP API (initiate → accepted)

5. Network/Banks (clearing/posting)

6. Reconcile & Notify (ulanyja tassyklama)

`TTW₍payout₎ = t_precheck + t_risk + t_initiation + t_network + t_posting + t_notify`

4) SLA we maksat derejeleri

p95 goýumy: ≤ 10-20 sek (gapjyklar/one-tap), ≤ 30-60 sek (3DS kartoçkalar).

• Instant rails (SEPA Instant/PIX/FPS/RTP, push-to-wallet/card): ≤ 15–30 мин.
• Karz standart A2A/SEPA: T + 0/T + 1 banking (sagat/gün).
• Halkara SWIFT: 1-3 bank güni.
• p99 garaşylýanlary dolandyrmak üçin aragatnaşykda (ETA-diapazonlary) saklamak möhümdir.

5) Ölçeg: birlikler, penjireler, sampling

Ölçeg birligi: geleşik (deposit/payout).
Jemleme: p50/p90/p95/p99, SLA-hit% (ETA paýy), guýruklar (tail> 2 × p95).
Dilimler: usul/koridor/PSP/MID/GEO/BIN-klasterler/gije-gündiziň wagty/kanal.
Aýyrýarys: oýunçynyň haýyşy boýunça ýatyrylan/duplikatlar (idempotentlik), el arakesmeleri.

6) Maglumatlaryň modeli (iň az)

sql payments. timeline (
tx_id PK, kind -- DEPOSIT    PAYOUT,
user_id, method, corridor, provider, mid, iso2, currency, amount_minor BIGINT,
t_ui_start TIMESTAMP, t_3ds_start TIMESTAMP, t_3ds_end TIMESTAMP,
t_auth_req TIMESTAMP, t_auth_ok TIMESTAMP,
t_capture_ok TIMESTAMP,     -- депозиты t_precheck_start TIMESTAMP, t_precheck_ok TIMESTAMP, -- выводы t_risk_start TIMESTAMP, t_risk_ok TIMESTAMP,
t_payout_initiated TIMESTAMP, t_network_posted TIMESTAMP,
t_wallet_available TIMESTAMP, -- final availability status TEXT, decline_code TEXT, meta JSONB
);

sla. catalog (
kind, method, corridor, geo, p95_target_seconds INT, p99_target_seconds INT, eta_text TEXT
);

7) SQL-hasaplaşyk şablonlary

7. 1. Depozitler boýunça TTW (umumy we usullar boýunça)

sql
SELECT method,
PERCENTILE_CONT(0. 95) WITHIN GROUP (ORDER BY EXTRACT(EPOCH FROM (t_wallet_available - t_ui_start))) AS p95_ttw_sec,
PERCENTILE_CONT(0. 99) WITHIN GROUP (ORDER BY EXTRACT(EPOCH FROM (t_wallet_available - t_ui_start))) AS p99_ttw_sec,
COUNT() AS attempts,
100. 0 AVG((EXTRACT(EPOCH FROM (t_wallet_available - t_ui_start)) <= s. p95_target_seconds)::int) AS sla_hit_p95_pct
FROM payments. timeline t
JOIN sla. catalog s ON s. kind='DEPOSIT' AND s. method=t. method
WHERE t. kind='DEPOSIT'
AND t. status='SUCCESS'
AND t. t_ui_start BETWEEN:from AND:to
GROUP BY 1;

7. 2. TTW netijeler boýunça (koridorlar)

sql
SELECT corridor,
PERCENTILE_CONT(0. 50) WITHIN GROUP (ORDER BY EXTRACT(EPOCH FROM (t_wallet_available - t_precheck_start))) AS p50_sec,
PERCENTILE_CONT(0. 95) WITHIN GROUP (ORDER BY EXTRACT(EPOCH FROM (t_wallet_available - t_precheck_start))) AS p95_sec,
PERCENTILE_CONT(0. 99) WITHIN GROUP (ORDER BY EXTRACT(EPOCH FROM (t_wallet_available - t_precheck_start))) AS p99_sec,
100. 0 AVG((EXTRACT(EPOCH FROM (t_wallet_available - t_precheck_start)) <= s. p95_target_seconds)::int) AS sla_hit_p95_pct,
COUNT() AS payouts
FROM payments. timeline t
JOIN sla. catalog s ON s. kind='PAYOUT' AND s. corridor=t. corridor
WHERE t. kind='PAYOUT' AND t. status='SUCCESS'
AND t. t_precheck_start BETWEEN:from AND:to
GROUP BY 1;

7. 3. "Dar ýerleriň" dekompozisiýasy (netijeler)

sql
SELECT corridor,
AVG(EXTRACT(EPOCH FROM (t_precheck_ok - t_precheck_start))) AS precheck_sec,
AVG(EXTRACT(EPOCH FROM (t_risk_ok - t_risk_start)))     AS risk_sec,
AVG(EXTRACT(EPOCH FROM (t_network_posted - t_payout_initiated))) AS network_sec,
AVG(EXTRACT(EPOCH FROM (t_wallet_available - t_network_posted))) AS posting_sec
FROM payments. timeline
WHERE kind='PAYOUT' AND status='SUCCESS'
AND t_precheck_start BETWEEN:from AND:to
GROUP BY 1
ORDER BY network_sec DESC;

7. 4. SLA briçler we "uzyn guýruklar"

sql
SELECT method, corridor,
COUNT() FILTER (WHERE EXTRACT(EPOCH FROM (t_wallet_available - COALESCE(t_ui_start, t_precheck_start))) > s. p95_target_seconds) AS breaches,
COUNT() AS total,
100. 0 COUNT() FILTER (WHERE EXTRACT(EPOCH FROM (t_wallet_available - COALESCE(t_ui_start, t_precheck_start))) > s. p95_target_seconds)
/ NULLIF(COUNT(),0) AS breach_pct
FROM payments. timeline t
JOIN sla. catalog s ON s. kind=t. kind AND COALESCE(s. method, t. method)=t. method AND COALESCE(s. corridor, t. corridor)=t. corridor
WHERE t. status='SUCCESS' AND (t. t_ui_start BETWEEN:from AND:to OR t. t_precheck_start BETWEEN:from AND:to)
GROUP BY 1,2
ORDER BY breach_pct DESC;

8) Daşbordlar we KPI

TTW p50/p95/p99 usullar/koridorlar/PSP/GEO/BIN-klaster boýunça.
SLA-hit%, tail share (> 2 × p95), hadysalar (düşündirişler).
Netije hunisi: Requested → Pre-check OK → Risk OK → Initiated → Posted → Available.
Baglanyşyklar: TTW vs AR/depozit konwersiýasy, TTW vs sapport biletleri/CSAT, TTW vs churn.
Bahasy: koridor boýunça 'cost _ per _ payout' we 'take-rate' vs TTW boýunça ýeňiş.

9) Alertler

p95 breach: p95 TTW/PSP> SLA X minut.
Tail spike: Z sagatda paý> 2 × p95 ýokarlandy> Y%.
Pre-check stall: t_precheck_start bar, t_precheck_ok ýok> 15 min (awto-eskalasiýa).
Risk backlog: t_risk_start bar, t_risk_ok ýok> bosagasy (el bilen nobat).
Network/posting anomaly: GEO/bank boýunça 'network _ sec' -iň ýiti ösüşi.
Policy drift: zerur wagt bellikleri bolmadyk wakalar.

10) TTW-ni nädip çaltlaşdyrmaly (amallar)

Depozitler

One-tap gapjyklary/Apple Pay/Google Pay, network tokens.
Töwekgelçilik boýunça Frictionless 3DS, 3DS-ni modala salmak.
BIN/GEO/saglygy boýunça PSP kaskady, diňe soft-decline-de retralar.
Prefetch 3DS/ACS kanallar, pese gaçmakda agressiw wagt-autlar.

Netijeler

Pre-KYC/pre-SoF ýygy-ýygydan oýunçylar üçin; ≤ çäginiň mukdaryna pre-approval.
Instant-koridorlar: SEPA Instant/Faster Payments/RTP/PIX/push-to-card/wallet.
Koridorlaryň kaskady: instant → fast A2A → standart SEPA/SWIFT (ETA bilen).
Same-method & ND-logika el bilen barlamazdan awtomatlaşdyryldy.
Wagtlaýyn penjireler: cut-off we bank "dar" sagatlaryndan gaça durmak.
"Provider health-feed" we "auto-failover" ulalanda 'network _ sec'.

Aragatnaşyklar

Başda ETA + progress-statuslar ("Barlag", "Başlangyç", "Hasaba alyndy").
Proactive gijikdirilen duýduryşlar> SLA, dogruçyl sebäpler we garaşylýan wagt.

11) Ykdysadyýet we ylalaşyklar

Instant has gymmat: CSAT/churn/retention vs bps/fixed upliftini deňeşdiriň.
Guýruklar p50-den has gymmat: p95 optimizasiýalary has köp P&L täsirini berýär.
Ýerli tapawutlar: käbir GEO-larda "çalt, ýöne gymmat" kanal has gowy töleýär.

12) Playbook hadysasy

1. Belli bir PSP/koridor boýunça p95

Awto-reroute ätiýaçlyk koridoryna, pese gaçmak boýunça çäkleri azaltmak.
Täzelenen ETA bilen oýunçylara aragatnaşyk, üpjün edijä bilet.

2. Risk backlog (el bilen barlamak)

X ≤ mukdaryna pre-approval goşmak, nobaty gaýtadan paýlamak, awto-pass çäklerini wagtlaýyn ýokarlandyrmak.

3. Bank posting GEO boýunça gijikdirmeler

Beýleki habarçy bank/gapjyk bilen aýlanyp geçmek, täze arzalar üçin "haýal" koridory wagtlaýyn öçürmek.

4. 3DS/ACS pese gaçmagy (goýumlar)

Frictionless/alternate DS-ni töwekgelçilik syýasaty ýa-da başga bir PSP-de kaskad rugsat berýän ýerinde mejbur etmek.

13) TTW töweregindäki A/B synaglary

Instant vs Standard traffigiň bir bölegi üçin koridor (guardrails: CBR bps, cost/payout, CSAT).
Pre-KYC copyright/flow, ETA formulalary, usullaryň tertibi.
Metrikler: TTW p95, SLA-hit%, biletler/1000 trx, AR/öwrülişik, çurn 7/30.

14) Iň oňat amallar (gysgaça)

1. Tapgyrlar boýunça ölçäň we wagt belliklerini bir shemada saklaň.
2. Diňe medianany däl, p95/p99 optimizirläň.
3. Ykdysadyýetiň birleşýän ýerinde instant-rails guruň.
4. Gaýtalanýan ssenariler üçin pre-KYC/SoF/approval ediň.
5. Koridorlary we PSP awto-kaskad ediň, saglyga jogap beriň.
6. Dogruçyl ETA we statuslary aýdyň, gijikdirmeler barada habar beriň.
7. SLA-lary katalogda saklaň we her bölek üçin SLA-hit% -ni barlaň.
8. TTW-ny dashbordlarda CSAT/ticket/churn bilen baglanyşdyryň.
9. Post-wakalar: sebäpleri belläň, düzgünleri/çäkli wagtlary üýtgediň.
10. Wakalaryň shemasyny wersiýa ediň, wagt bellikleriniň dolulygyny tassyklaň.

15) Girizmegiň çek-sanawy

• Önüm/maliýe bilen ylalaşylan goýumlar/netijeler üçin TTW kesgitlemeleri.
• Wagt bellikleri 'payments. timeline`; SLA katalogy.
• Daşbordlar p50/p95/p99, SLA-hit%, guýruklar; p95/tails/backlogs alertleri.
• PSP/koridor kaskadlary, health-feed we awto-failover.
• Pre-KYC/SoF we pre-approval syýasatlar; ND/same-method awtomatlaşdyryldy.
• Ulanyjy üçin ETA-aragatnaşyk we status-tracker.
• Koridorlarda "tizlik bahasy" ykdysady modeli.
• Wakalaryň oýun kitaplary we post-mortem prosesi.
• Guardrails bilen TTW gowulaşmalarynyň A/B synaglary.
• Maglumatlaryň dolulygynyň we hasaplaşyklaryň dogrulygynyň yzygiderli barlagy.

Gysgaça maglumat

"Time-to-Wallet" diňe "çykarmak tizligi" däl. Bu, konwersiýa, saklamak we P&L täsir edýän töleg tejribesiniň ahyrky metrikasydyr. TTW-ni tapgyrlar boýunça ölçäň, p95/p99 optimizirläň, instant-rails we kaskadlary birikdiriň, öňünden-KYC/approval arkaly sürtülmegi aýyryň we ND/same-method barlagyny awtomatlaşdyryň. Güýçli telemetriýa, dogruçyl ETA we taýýar pleýbuklar tölegleri çalt, öňünden aýdyp boljak we ykdysady taýdan esaslandyrar.