Time-to-Wallet: asosiy metrika

1) TTW ta’rifi va variantlari

• TTW₍deposit ₎:’To’lash’tugmasi → Pul o’yin uchun mavjud. ’
• UX/3DS, PSP/bankda avtorizatsiya, tasdiqlash va balans yozuvlarini o’z ichiga oladi.

TTW₍payout ₎: "Olib qo’yish" tugmasi → tashqi hamyon/bankdagi pul ".
Risk/KYC/SoF tekshiruvlari, same-method/ND-geytlar, koridor orkestri, PSP/sxemalarni tasdiqlash va bank/hamyondagi posting kiradi.

2) Nima uchun TTW - bu P & L-metrika

Konvertatsiya va AR: tezkor depozit ↑ birinchi stavka/sessiya ehtimoli.
Ushlab turish va ishonch: tezkor xulosalar ↓ churn va sapport biletlari.
Narxi: instant-rails ko’pincha qimmatroq ⇒ «tezlik narxi» balansi kerak.
Operatsion xavf: TTW ning uzun «dumlari» hodisalar klasterlari va chargeback-kuchlanishni keltirib chiqaradi.

3) TTWning bosqichlar bo’yicha dekompozitsiyasi

3. 1. Depozitlar

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

2. PSP Auth (authorize)

3. Capture/Booking (tasdiqlash, balansni yangilash)

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

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

3. 2. Xulosalar

1. Pre-checks (KYC/SoF, ND/same-method, RG/AML limitlari)

2. Risk decision (avto/qo’lda)

3. Payout orchestration (yoʻlakni tanlash: 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 (foydalanuvchiga tasdiqlash)

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

4) SLA va maqsadli darajalar

Depozit p95: ≤ 10-20 sek (hamyonlar/one-tap), ≤ 30-60 sek (3DS kartalar).

• Instant rails (SEPA Instant/PIX/FPS/RTP, push-to-wallet/card): ≤ 15–30 мин.
• Standart A2A/SEPA Credit: T + 0/T + 1 banking (soat/sutka).
• Xalqaro SWIFT: 1-3 bank kuni.
• p99 umidlarni boshqarish uchun kommunikatsiyalarda (ETA-diapazonlar) saqlash muhimdir.

5) O’lchov: birliklar, derazalar, sampling

O’lchov birligi: tranzaksiya (deposit/payout).
Agregatsiya: p50/p90/p95/p99, SLA-hit% (ETAdagi ulush), dumlar (tail> 2 × p95).
Kesmalar: usul/koridor/PSP/MID/GEO/BIN-klasterlar/sutka vaqti/kanal.
Istisno qilamiz: bekor qilingan/duplikatlar (idempotentlik), o’yinchining so’roviga ko’ra qo’l pauzalari.

6) Ma’lumotlar modeli (minimal)

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) Hisob-kitoblarning SQL-shablonlari

7. 1. TTW depozitlar bo’yicha (umumiy va usullar bo’yicha)

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 xulosalar boʻyicha (yoʻlaklar)

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. «Tor joylar» dekompozitsiyasi (xulosalar)

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-brichi va «uzun dumlar»

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) Dashbordlar va KPI

TTW p50/p95/p99 usullar/koridorlar/PSP/GEO/BIN-klaster bo’yicha.
SLA-hit%, tail share (> 2 × p95), hodisalar (izohlar).
Xulosa shakli: Requested → Pre-check OK → Risk OK → Initiated → Posted → Available.
Korrelyatsiyalar: TTW vs AR/konvertatsiya depozit, TTW vs chiptalar sapport/CSAT, TTW vs churn.
Qiymati: yo’lak bo’yicha’cost _ per _ payout’va’take-rate’vs TTW bo’yicha yutuq.

9) Alertlar

p95 breach: p95 TTW yoʻlak boʻylab/PSP> SLA X daqiqa.
Tail spike:> 2 × p95 ulushi ortdi> Y% Z soat davomida.
Pre-check stall: t_precheck_start bor, t_precheck_ok yo’q> 15 min (avto-eskalatsiya).
Risk backlog: t_risk_start bor, t_risk_ok yoʻq> chegara (qoʻl navbati).
Network/posting anomaly: GEO/bank bo’yicha’network _ sec’ning keskin o’sishi.
Policy drift: kerakli vaqt belgilarisiz voqealar.

10) TTW (amaliyot) ni qanday tezlashtirish kerak

Depozitlar

One-tap hamyonlari/Apple Pay/Google Pay, network tokens.
Frictionless 3DS xavf bo’yicha, 3DSni modalga kiritish.
BIN/GEO/salomatlik bo’yicha PSP kaskadi, faqat soft-decline retrasi.
Prefetch 3DS/ACS kanallar, tanazzulga uchragan tajovuzkor taym-autlar.

Xulosalar

tez-tez o’yinchilar uchun pre-KYC/pre-SoF; ≤ chegara summasiga pre-approval.
Instant-koridorlar: SEPA Instant/Faster Payments/RTP/PIX/push-to-card/wallet.
Koridorlar kaskadi: instant → fast A2A → standart SEPA/SWIFT (ETA bilan).
Same-method & ND-mantiq qoʻlda tekshirilmagan holda avtomatlashtirilgan.
Vaqtinchalik derazalar: yopiq va bank «tor» soatlaridan qochish.
Provider health-feed va avto-failover’network _ sec’.

Kommunikatsiyalar

Startdagi ETA + progress-maqomlar («Tekshirish», «Tashabbuskor», «Qabul qilingan»).
Kechikishlarda proaktiv ogohlantirishlar> SLA, halol sabablar va kutilayotgan vaqt.

11) Iqtisodiyot va murosalar

Instant qimmatroq: uplift CSAT/churn/retention vs bps/fixed ni solishtiring.
Quyruqlar p50 dan qimmatroq: p95 optimallashtirish P&L ta’sirini oshiradi.
Mahalliy farqlar: ba’zi GEOlarda «tez, ammo qimmat» kanal yaxshi to’laydi.

12) Hodisa-pleybuklar

1. Aniq PSP/koridor bo’yicha p95 o’sishi

Avto-reroute zaxira koridoriga, degradatsiya bo’yicha limitni pasaytirish.
Yangilangan ETA bilan o’yinchilar uchun aloqa, provayderga chipta.

2. Risk backlog (qoʻlda tekshirish)

X ≤ summasiga pre-approval kiritish, navbatni qayta taqsimlash, vaqtincha auto-pass ostonalarini ko’tarish.

3. Bank posting GEO bo’yicha kechikishlar

Boshqa bank-muxbir/hamyon bilan aylanib chiqish, yangi buyurtmalar uchun «sekin» yo’lakni vaqtincha o’chirish.

4. 3DS/ACS degradatsiya (depozitlar)

Frictionless/alternate DSni tavakkalchilik siyosati yoki boshqa PSP kaskadi mumkin boʻlgan joyda majburlash.

13) TTW atrofida A/B testlari

Instant vs Standard yo’lagi (guardrails: CBR bps, cost/payout, CSAT).
Pre-KYC kopirayt/flou, ETA formulalari, usullar tartibi.
Metrikasi: TTW p95, SLA-hit%, ticets/1000 trx, AR/konversiya, churn 7/30.

14) Best practices (qisqacha)

1. Bosqichlar bo’yicha o’lchang va taym-belgilarni yagona sxemada saqlang.
2. Faqat medianani emas, balki p95/p99 ni optimallashtiring.
3. Iqtisodiyot birlashtirilgan joyga instant-rails joylashtiring.
4. Takrorlanadigan skriptlar uchun pre-KYC/SoF/approval qiling.
5. Yo’laklar va PSPlarni avto-kaskad qiling, sog’liqqa javob bering.
6. To’g’ri ETA va maqomlarni ayting, kechikishlar haqida xabar bering.
7. SLAni katalogda saqlang va har bir kesim uchun SLA-hit% ni tekshiring.
8. TTWni dashbordlardagi CSAT/tiketlarga/churnga bogʻlang.
9. Post-hodisalar: sabablarini aniqlang, qoidalarni/chegaraviy taymerlarni o’zgartiring.
10. Voqealar sxemasini versiya qiling, taym-belgilarning to’liqligini tasdiqlang.

15) Joriy etish chek-varaqasi

• Mahsulot/moliya bilan kelishilgan depozitlar/xulosalar uchun TTW ta’riflari.
• ’payments’dagi bosqichlar bo’yicha taym-belgilar. timeline`; SLA katalogi.
• Dashbordlar p50/p95/p99, SLA-hit%, dumlari; p95/tails/backlogs alertlari.
• PSP/koridorlar kaskadlari, health-feed va avto-failover.
• Pre-KYC/SoF va pre-approval siyosati; ND/same-method avtomatlashtirilgan.
• ETA kommunikatsiyalari va foydalanuvchi uchun status-treker.
• Yo’laklar bo’yicha «tezlik narx» iqtisodiy modeli.
• Hodisalar pleybuklari va post-mortem jarayoni.
• Guardrails bilan TTW yaxshilanishlarining A/B testlari.
• Ma’lumotlarning to’liqligi va hisob-kitoblarning to’g "riligi bo’yicha muntazam audit.

Xulosa

Time-to-Wallet shunchaki «chiqish tezligi» emas. Bu konversiya, ushlab qolish va P & Lga ta’sir qiluvchi to’lov tajribasining to’liq metrikasi. TTWni bosqichma-bosqich o’lchang, p95/p99 ni optimallashtiring, instant-rails va kaskadlarni ulang, pre-KYC/approval orqali ishqalanishni olib tashlang va ND/same-method tekshiruvini avtomatlashtiring. Kuchli telemetriya, halol ETA va tayyor pleybuklar to’lovlarni tezkor, oldindan aytib bo’ladigan va iqtisodiy jihatdan oqlaydi.