I am getting summary report of email by using CiviCRM API but not able to get the field Unique Opens I can see on the report page. Currently I am using this query:

$result = civicrm_api3('Mailing', 'stats', [
  'mailing_id' => 10,

And this gives me these columns:

{'Delivered': '1', 'Bounces': '0', 'Unsubscribers': 0, 'Unique Clicks': '0', 'Opened': '1', 'clickthrough_rate': '0%', 'opened_rate': '100%', 'delivered_rate': '100%'}

But not the Unique Opens which I need too.

Example email report page: enter image description here

Any help will be appreciated.

1 Answer 1


Have you tried passing is_distinct=1 as a parameter in api? It would show unique clicks and opens

$result = civicrm_api3('Mailing', 'stats', [
  'mailing_id' => 12,
  'is_distinct' => 1,
  • Thank you Pradeep May 30, 2022 at 13:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.