Bots/Common users and success rate
The focus of this bounty is on the transactions of bots and normal users and it tries to identify the behavior of bots by distinguishing between them.
The method used to identify bots
The main part of this analysis is to find or identify bots from ordinary users. There are several ways to do this, but what can easily separate a bot from a human is the number of transactions of that bot. For this purpose, a condition must be placed on the number of transactions in a short period of time. In the present work, ten transactions per minute is considered as a reasonable condition for this. In this way, first the total transactions of the last two months are counted. Then by placing the condition that each wallet has performed more than ten transactions per minute (success or failed) is a bot. By applying this condition to the transactions, we reach the table below, which gives us a complete list of possible bots.
Common users transactions
A large number of transactions on the Terra network are performed daily by bots and ordinary users, some of which may encounter errors and most of which are successful. The table below details the total number of transactions (swap-related transactions) showing that approximately 98 of them were correct, which is a significant number. As you can see, the number of failed transactions is very small.
The table below shows the successful and unsuccessful transactions (swaps) performed by robots. It should be noted that in this table, the data of the first part have been used to identify the robots. As you can see, robots have many more failed transactions and the percentage of successful transactions is higher than real users.