Игрушка QIWI
QIWI офис
QIWI лого

Model explaining anomalies in QIWI transactions

Data analysis

About client

QIWI is a popular electronic payment system.
With the QIWI wallet, you can make transfers between people, pay bills and online-store purchases.
QIWI provides acquiring services to businesses.
Acquiring is a technology that allows companies to accept non-cash payments.
Payment passed or not
The main quality indicator in acquiring is conversion.
Payment failed - the client is dissatisfied
We must try to prevent such cases.
On the side of the acquiring system

A payment error can be:

On the provider side
On the side of banking systems
There was a story that one mobile operator enrolled the account did not work from 1 to 3 am - it turned out that his time zones were incorrectly set.

Our task

Identify signs of anomalies due to which payments are not going through.

Scheme of work

What we did:
We looked at transaction data, looked for patterns.
September - November 2018
Hypothesis:
With a fictitious wooden toy store, transactions will be more successful than with a fictitious online casino
The customer could offer different acquiring prices depending on the likelihood of the success of the transaction
We could not verify, because the customer did not give access to information about the provider companies - this is prohibited by security protocols.

Technologies

Classic Data Science

Project team

Sergey Verentsov
Developer
Ramil Gizatullin
Developer

Technical solution

Received dumps of QIWI databases in PostgreSQL system
Collected preliminary markup from databases
Processed data using Python
Built a decision tree
You can go through it and see what set of features leads to unsuccessful transactions.
Clustered by provider group
Each node is a condition for a sign of a transaction
Orange nodes are where many transactions have failed.

Development difficulties

Limited access to data
Complexity of the subject area
No guarantees of meaningful results
Communication problems
For example, feature importance is familiar to datasets, while analysts are more familiar with correlations and funnels.

Results of the project

Confirmed the client's hypotheses:
One user tried to put 3.5 billion rubles on the phone.
Of course, nothing came of it.
Transactions with large amounts with a high probability will not pass
There are problematic providers and provider groups
Unfortunately, there was no «magic pill» to fix one problem and transactions will grow. But extra confirmation is always good.

Quote

What the project gave us

Learned to plan better
Understood the importance of working closely with the client
For a week we worked in Innopolis together with a QIWI analyst, exchanged competencies.

In 2019 we took part in Product Hub QIWI Universe 3.0

Georgy Konnov,
Head of QIWI Cashier, one of the business customers of the program
«... As a result, with the EORA team, we made a data analytics case, during which we analyzed the work of our providers and were able to identify new factors that reduce the conversion of payments. Working with them will lead to an increase in the turnover of our partners.»

Emotions from the project

«It was a unique experience for our data scientists: we got financial data on transactions that are not available in other ways. The volume of data was very large, and a whole infrastructure had to be deployed for them.

We worked side by side with specialists from QIWI, learned how the processes inside the corporation are arranged, learned how to interact with the security service.»
CEO EORA
Roman Doronin

Mass media wrote about us

RUSBASE лого
COSSA лого
Contact us