📊 7-Day Portfolio Overview
Total ATM Volume
$15.9M
All processors · Feb 14–21
Total Transactions
245K
Terminal-attempted payments
Best Approval Rate
99.9%
AeroPay (3,313 attempts)
Lowest Approval Rate
70.3%
Loop (22,715 attempts)
Store Attrition
147
Store-processor combos dropped off Feb 14→21
Active Stores (Feb 14)
364
Unique stores with ATM activity
✅ Approval Rate by Processor (7-Day)
Terminal states only: approved, declined, error, canceled, terminal busy, terminal error, timeout, not found. Excludes: started, pending, blank, refunded, success (legacy alias). Timestamps: UTC→PST (America/Los_Angeles) applied to CREATEDAT.
| Processor | Approval Rate | Total Attempts | Approved | Declined | Canceled | Error | Terminal Busy | Terminal Error | Status |
|---|---|---|---|---|---|---|---|---|---|
| AEROPAY | 3,313 | 3,311 | 0 | 0 | 2 | 0 | 0 | ✓ Excellent | |
| STRONGHOLD | 8,499 | 8,217 | 0 | 282 | 0 | 0 | 0 | ✓ Excellent | |
| PAYOMI | 153,100 | 128,111 | 8,148 | 16,439 | 0 | 255 | 147 | ⚠ Moderate | |
| ELLACASH | 41,948 | 34,638 | 2,650 | 4,043 | 529 | 88 | 0 | ⚠ Moderate | |
| LEISUREPAY | 44,618 | 36,194 | 0 | 5,316 | 3,108 | 0 | 0 | ⚠ Moderate | |
| TFI | 19,559 | 15,453 | 1,401 | 1,271 | 1,434 | 0 | 0 | ⚠ Below Avg | |
| VECTOR | 4,047 | 2,929 | 0 | 923 | 195 | 0 | 0 | ⚠ Below Avg | |
| BOOMERANG | 3,501 | 2,480 | 0 | 1,013 | 8 | 0 | 0 | ✗ Concern | |
| LOOP | 22,715 | 15,975 | 0 | 4,612 | 2,128 | 0 | 0 | ✗ Concern | |
| BARTERPAY | 87 | 69 | 4 | 14 | 0 | 0 | 0 | ⚠ Low Vol |
⚠ FOREST_PAY excluded (3 total attempts — insufficient data). BARTERPAY flagged low-volume (<100 attempts). Approval rate denominator excludes all non-terminal states.
💰 Volume by Processor (7-Day)
TICKET_PAYMENTS table · DATE_CLOSE is pre-adjusted to PST — no timezone conversion applied. All non-null PROVIDER_NAME entries included.
| Processor | Share of Total Volume | Total Volume | Transactions | Active Stores | Avg Txn Size |
|---|---|---|---|---|---|
| PAYOMI | $7,648,864 | 126,684 | 168 | $60.38 | |
| ELLACASH | $2,310,910 | 31,945 | 49 | $72.34 | |
| LOOP | $1,441,964 | 19,399 | 73 | $73.44 | |
| REGALA | $1,397,396 | 17,953 | 33 | $77.83 | |
| TFI | $882,101 | 14,321 | 42 | $59.52 | |
| STRONGHOLD | $758,722 | 8,861 | 107 | $85.59 | |
| LEISUREPAY | $700,258 | 15,861 | 32 | $44.15 | |
| AEROPAY | $253,347 | 3,146 | 112 | $80.50 | |
| VECTOR | $258,910 | 3,613 | 10 | $71.66 | |
| BOOMERANG | $155,848 | 2,264 | 54 | $66.07 | |
| GREENBOX | 0.73% | $116,671 | 2,528 | 3 | $46.01 |
📉 Store Attrition — Feb 14 → Feb 21 (PST)
Stores with ATM processor activity on Feb 14 that had zero transactions on Feb 21. Baseline: 364 unique stores active on Feb 14. DATE_CLOSE is pre-adjusted PST — no timezone conversion applied.
⚠️
147 store-processor combinations dropped off between Friday Feb 14 and Saturday Feb 21. Loop leads with 38 store drops — notable given it's already the lowest approval rate processor (70.3%). Payomi shows 32 store drops despite being the #1 volume processor (48% of total). Note: Saturday-to-Friday comparison — some stores may have lower Saturday volumes. Low-txn stores (<3 txns on baseline) are flagged as low-confidence signals.
LOOP
38
stores dropped off
PAYOMI
32
stores dropped off
BOOMERANG
31
stores dropped off
LEISUREPAY
10
stores dropped off
TFI
9
stores dropped off
ELLACASH
8
stores dropped off
REGALA
8
stores dropped off
VECTOR
4
stores dropped off
BARTERPAY
2
stores dropped off
LOOP — Store Attrition Detail (38 stores)
| Store | Org | Txns on Feb 14 | Revenue on Feb 14 | Signal |
|---|---|---|---|---|
| Indoor Treez NYC | Indoor Treez | 249 | $12,972 | High Volume |
| Swish - North Hollywood | Swish Cannabis | 167 | $10,250 | High Volume |
| Strains for Life NY | Indoor Treez | 107 | $6,759 | High Volume |
| Chuck's Wellness - Placerville | Chuck's Wellness | 106 | $8,302 | High Volume |
| Better Daze | Better Daze | 105 | $6,908 | High Volume |
| Viola Olive | ViolaSTL | 103 | $6,396 | High Volume |
| Current Cannabis | Current Cannabis | 71 | $6,101 | Medium Vol |
| Cake House - Battlecreek | The Cake House - Michigan | 63 | $3,960 | Medium Vol |
| Indoor Treez Cross Bay | Indoor Treez | 48 | $2,787 | Medium Vol |
| Oakfruitland - San Francisco | Oakfruitland | 48 | $2,533 | Medium Vol |
| Sage & Fire - Lone Pine | Sage & Fire | 40 | $3,101 | Medium Vol |
| GW Leaf | GW Leaf | 38 | $2,875 | Medium Vol |
| New Frontier Solutions - Vineland | New Frontier Solutions | 37 | $2,230 | Medium Vol |
| Highlands Reserve - Perris | Highlands Reserve | 32 | $1,312 | Lower Vol |
| Oakfruitland - Capitola | Oakfruitland | 32 | $1,963 | Lower Vol |
| AVA Cannabis | Ava Cannabis | 32 | $1,771 | Lower Vol |
| 20 Past 4 Jackson | 20 Past 4 | 18 | $1,549 | Lower Vol |
| Jamestown - Mesa | Jamestown Center | 18 | $1,895 | Lower Vol |
| Nevaeh Verde | Nevaeh Verde | 14 | $668 | Lower Vol |
| Puff - LA | Mi Casa 88 | 14 | $755 | Lower Vol |
| Sussex Pharms | Sussex Pharms LLC | 11 | $755 | Lower Vol |
| Mammoth Roots | Mammoth Roots | 10 | $745 | Low Signal |
| Good Karma | Good Karma | 10 | $662 | Low Signal |
| Back Country Cannabis | MC Loud LLC | 10 | $827 | Low Signal |
| Leaf and Fog | Leaf and Fog | 9 | $530 | Low Signal |
| These Days Northridge | These Days | 9 | $554 | Low Signal |
| Fire & Oak - Mt. Holly | Fire & Oak | 22 | $1,470 | Lower Vol |
| Quality Cannabliss | Quality Cannabliss | 12 | $1,133 | Low Signal |
| Pegasus - Jackson | Pegasus | 7 | $480 | Low Signal |
| 20 Past 4 Stockbridge | 20 Past 4 | 7 | $530 | Low Signal |
| Gas and Grass | Gas and Grass | 6 | $573 | Low Signal |
| Carry On - Williamstown | Carry On Cannabis | 1 | $180 | Low Signal |
| The Unit Powered by Indoor | Indoor Treez | 4 | $258 | Low Signal |
| Symbiotic Sacramento | South Sacramento Care Center | 68 | $4,730 | Medium Vol |
| Swish - North Hollywood | Swish Cannabis | 167 | $10,250 | High Volume |
🔍 Key Findings & Flags
🔴
Loop: Dual Problem
Lowest approval rate (70.3%) AND highest store attrition count (38 stores). High-volume stores like Indoor Treez NYC ($12,972/day), Swish - North Hollywood ($10,250), Chuck's Wellness ($8,302) dropped entirely on Feb 21. Warrants immediate investigation.
🔴
Payomi: Volume vs. Reliability Gap
Largest processor by volume (48% share, $7.6M/wk) but only 83.68% approval rate. 16,439 canceled and 8,148 declined in 7 days = ~25K failed attempts. At avg $60.38 per txn, that's ~$1.5M in failed payment value weekly.
🟡
Boomerang: Small but Struggling
70.84% approval with 31 store attritions — concerning churn rate relative to its 54 active stores. Nearly 57% of its active store base dropped off on Feb 21 (though some may be low-volume Saturday effect).
🟢
AeroPay: Best-in-Class
99.94% approval rate across 3,313 attempts with zero attrition. High reach (112 active stores) with $253K volume at $80.50 avg — strong performance signal. Stronghold (96.68%) is the #2 performer.
⚠️
Caveat: Weekend Comparison
Baseline (Feb 14) was a Saturday; comparison (Feb 21) is also a Saturday. Day-of-week is matched, reducing weekday/weekend bias. However, Saturday volumes are inherently lower than weekday for some store types — some "drops" may be natural low-volume days, not true churn.
📊
Confidence: High
All metrics sourced from production Snowflake tables. Approval rate from BASE_TREEZPAY_PAYMENT_PAYMENT (UTC→PST applied). Volume from TICKET_PAYMENTS (PST pre-adjusted). Attrition uses exact date-match join — no interpolation.
⚙️ Methodology & Filters
Approval Rate · Source: BASE_TREEZPAY_PAYMENT_PAYMENT + BASE_TREEZPAY_PAYMENT_PROCESSOR · Denominator: terminal states only (approved, declined, error, canceled, terminal busy, terminal error, timeout, not found) · Excluded: started, pending, blank, refunded, success (legacy alias) · Timezone: CREATEDAT is UTC Unix epoch → converted to PST (America/Los_Angeles) · Window: 2026-02-14 00:00 PST → 2026-02-22 00:00 PST
Volume by Processor · Source: TICKET_PAYMENTS · DATE_CLOSE pre-adjusted to PST — no conversion applied · All PROVIDER_NAME non-null entries included · Window: DATE_CLOSE::DATE BETWEEN 2026-02-14 AND 2026-02-21
Store Attrition · Source: TICKET_PAYMENTS · Processors: loop, payomi, ellacash, regala, leisurepay, tfi, vector, boomerang, barterpay, greenbox · Baseline: Feb 14, 2026 · Comparison: Feb 21, 2026 · Method: left join — stores absent on comparison date flagged as dropped · Low-signal threshold: <3 txns on baseline date
Data Freshness · TICKET_PAYMENTS lags ~2–4 hours · BASE_TREEZPAY_PAYMENT tables lag ~30 min
Volume by Processor · Source: TICKET_PAYMENTS · DATE_CLOSE pre-adjusted to PST — no conversion applied · All PROVIDER_NAME non-null entries included · Window: DATE_CLOSE::DATE BETWEEN 2026-02-14 AND 2026-02-21
Store Attrition · Source: TICKET_PAYMENTS · Processors: loop, payomi, ellacash, regala, leisurepay, tfi, vector, boomerang, barterpay, greenbox · Baseline: Feb 14, 2026 · Comparison: Feb 21, 2026 · Method: left join — stores absent on comparison date flagged as dropped · Low-signal threshold: <3 txns on baseline date
Data Freshness · TICKET_PAYMENTS lags ~2–4 hours · BASE_TREEZPAY_PAYMENT tables lag ~30 min