get_results("select send_on, id, subject, total, status, type from " . NEWSLETTER_EMAILS_TABLE . " where status='sent' and type='message' order by send_on desc limit 10"); $report = new TNP_Statistics(); $overview_labels = array(); $overview_titles = array(); $overview_open_rate = array(); $overview_click_rate = array(); $total_sent = 0; $open_count_total = 0; $click_count_total = 0; foreach ($emails as $email) { $data = $this->get_statistics($email); $entry = array(); if (empty($data->total)) { continue; } // Used later for the tabled view $email->report = $data; $report->total += $data->total; $report->open_count += $data->open_count; $report->click_count += $data->click_count; $overview_labels[] = strftime('%a, %e %b %y', $email->send_on); $overview_open_rate[] = $data->open_rate; $overview_click_rate[] = $data->click_rate; $overview_titles[] = $email->subject; } $report->update(); $overview_labels = array_reverse($overview_labels); $overview_open_rate = array_reverse($overview_open_rate); $overview_click_rate = array_reverse($overview_click_rate); if (empty($emails)) { $controls->warnings[] = __('No newsletters have been sent till now', 'newsletter'); } ?>

More details, including Automated and Autoresponder newsletter statistics are available with the Reports Addon.

Emails Sent

total, 0) ?>

Overall Opens

open_rate; ?>%
(open_count; ?>)

Overall Clicks

click_rate; ?>%
(click_count; ?>)

Overall Reactivity

-%

Open rate

Click rate