emails_sent only shows the number of emails that went out for a campaign. It does not incorporate bounced emails. The current click_rate metric does not account for unique clicks or bounces.
To follow email marketing reporting best practices, I recommend new fields of bounces, delivered, and a revision to click_rate
For example,emails_sent = 3,000bounces^ = 100delivered^ = emails_sent- bounces=2,900unique_subscriber_clicks = 200total_clicks = 400click_rate^ = unique_subscriber_clicks / [emails_sent-bounces] =
6.9%
proposed change^
