Discrepancy on number of event in event table

[nazzatul21]

Hello,

we find that there are event data that missing and not the same with what being shown in the SMFC itself.
for example, the number of click is not the same as what SMFC show. there are link that missing in the table after we already integrate.
and the bounce category that being show also not tally for soft bounce and other bounce. maybe could we add more bounce category and bounce number. and click link name.

it would be good also if in this table we could get something like this -
id 🔑
subscriber_key ➤ SUBSCRIBER
opt_in_subscriber_id ➤ SUBSCRIBER
triggered_send_id ➤ TRIGGERED_SEND
send_id ➤ SEND
unsubscribed_list ➤ LIST
batch_id
bounce_category
bounce_type
created_date
event_date
event_type
modified_date
url
smtp_code
smtp_reason
question