# Fondea con Pana — Winners Summary

**Date:** 2026-05-05
**Window:** April 23-30, 2026
**Audience:** Pana Global only (US excluded per T&C v2)
**Source:** BigQuery (incomingpayment ∪ payment.Crypto+Blockchain), status=Paid, ≥$100/tx

---

## Headline numbers

| Metric | Value |
|---|---|
| Total winners | **494** |
| Total cashback | **$1952.50** |
| Budget cap | $8,500 |
| Budget utilization | **23.0%** |
| Within budget | ✅ no cuts needed |

---

## Tier distribution

| Tier | Min funding | Cashback/user | Winners | Total cashback |
|---|---|---|---|---|
| Tier 3 | ≥ $750 | $10.00 | 157 | $1570.00 |
| Tier 2 | $250–$749 | $1.50 | 214 | $321.00 |
| Tier 1 | $100–$249 | $0.50 | 123 | $61.50 |
| **TOTAL** | | | **494** | **$1952.50** |

### Tier % distribution (vs forecast)

| Tier | Actual % | Engaged forecast | Churned forecast | A activar forecast |
|---|---|---|---|---|
| Tier 3 | 31.8% | 30% | 15% | 10% |
| Tier 2 | 43.3% | 40% | 35% | 30% |
| Tier 1 | 24.9% | 30% | 50% | 60% |

---

## Audience cross-reference

| Bucket | Count | % |
|---|---|---|
| Winners IN the campaign audience | 450 | 91.1% |
| Winners NOT in the campaign audience | 44 | 8.9% |

The "not in audience" users still qualify per T&C if they meet eligibility — they just weren't directly targeted. Investigate if a high % to ensure no leakage.

---

## Top countries

- **DO**: 334 winners (67.6%)
- **HN**: 49 winners (9.9%)
- **GT**: 38 winners (7.7%)
- **MX**: 16 winners (3.2%)
- **CO**: 15 winners (3.0%)
- **BO**: 7 winners (1.4%)
- **NI**: 5 winners (1.0%)
- **EC**: 4 winners (0.8%)
- **US**: 2 winners (0.4%)
- **BR**: 2 winners (0.4%)
- **PY**: 2 winners (0.4%)
- **AR**: 2 winners (0.4%)
- **IT**: 2 winners (0.4%)
- **CL**: 2 winners (0.4%)
- **CA**: 2 winners (0.4%)

---

## Funding method distribution

- **BankAch**: 363 winners (73.5%)
- **LiquidationAddress**: 55 winners (11.1%)
- **Wire**: 35 winners (7.1%)
- **CryptoBlockchain**: 30 winners (6.1%)
- **TopUp**: 11 winners (2.2%)

---

## Methodology / caveats

- **Source tables**: `incomingpayment` (canonical Add Money: BankAch, Wire, LiquidationAddress, TopUp, BarcodeCashDeposit) UNION `payment` where paymenttype='Crypto' AND providertype='Blockchain' (Privy/Base Chain inflows).
- **User attribution**: `user.usertype = 'GLOBAL'` only. US users explicitly excluded per T&C v2.
- **Status filter**: `status = 'Paid'` only (truly approved, excludes Pending/Rejected/Refunded).
- **Tier rule**: per T&C, cashback determined by user's MAX single-tx eligible funding amount in the window.
- **Excluded methods** (per T&C and exploration): Pana-to-Pana (`paymenttype = 'Pana'`), Uniteller remittance outflows (`RemittanceAccountCredit/CashPickup/HomeDelivery`), PlatformCharge, US-side i2c (`BankAch + I2CProcessor`).

### Open items (post-payout)

1. Confirm with payments ops that user's ID format (ULID vs `sms|<ObjectId>` legacy) is what their payout system expects — there are 7 legacy ObjectId users in this list.
2. Validate empty-name rows (1 users have no firstname/lastname in bankapplication — these may be pending KYC).
3. CTO confirm that Privy/Base Chain crypto and Coinflow card top-ups (TopUp incomingpaymenttype) should both count as eligible "Crypto/Stablecoins" and "Tarjeta débito/crédito" methods respectively per T&C v2.

---

*Generated 2026-05-05 from BigQuery via the product dashboard's Metabase proxy.*