#Early fraud warnings
shrewd trellis
Hi David, thanks for responding :). I thought it was TC40s + SAFE, but I was surprised to see rapid dispute resolution on the object in sigma.
zinc lake
If you’re already set up with RDR, these will basically get surfaced to you as “unwinnable” disputes with the RDR property you noticed
The EFW has the RDR property? Or the dispute does?
shrewd trellis
At present, we're not setup with Verifi's RDR / CDRN, am going to sign a contract with Kount to get these services early next week to help us reduce our friendly fraud.
zinc lake
If you’re seeing it on the EFW, that surprises me
zinc lake
Apologies I’m not on our VPN (I thought this one would be a slam dunk!) but I can look into the data schema later on today
shrewd trellis
No worries, where I spotted it was actually in the Stripe 'Fraudulent Dispute Activity' graph which can be opened in Sigma (It generates the following query).
Select
date(date_trunc('day', charges.created)) as day,
count_if(disputes.charge_id is not null and disputes.reason = 'fraudulent') * 100.0 / count(*) as fraud_dispute_rate_percentage
from
charges
left join disputes on charges.id = disputes.charge_id
where
charges.created >= timestamp '2022-01-01 00:00:00'
and charges.created < timestamp '2022-03-12 00:00:00'
and charges.paid
and charges.captured
and not coalesce(disputes.network_details_visa_rapid_dispute_resolution, false)
group by
1
order by
1 asc
It's passed into the not coalesce function there and it seems to live on the dispute object.
zinc lake
This query looks to me like it’s just reckoning actual disputes, not Early Fraud Warnings
It is my belief EFWs are not in the disputes table, but in another table
shrewd trellis
Yep, they are, with their own object. No worries.
On a side note, support gave me a merchant id this morning, but I'm not sure if it's an aggregate one or a dedicated one for just our account? Are you aware of any Stripe customers with their own dedicated merchant id as opposed to using an aggregate?
zinc lake
Every stripe merchant should have a unique merchant ID starting with acct_
Without seeing the exchange it’s unclear to me what they gave you
shrewd trellis
Oh that's interesting, I thought we were all aggregated under Stripe's umbrella. In terms of the message:
Taking a look at your account [0] I am glad to let you know that your unique MID is CTP2***************D
Is this something I can provide to Visa directly and they'll be able to utilise?