Answers.Body: <p>That data is stored in tables like "civicrm_mailing_event_opened" and "civicrm_mailing_event_bounce" joined with the civicrm_mailing_event table. I see that subscribe and unsubscribe have been implemented for example, but not the examples you're looking at (bounce or open).</p>
  
  <p>So you could use the existing implementations to figure out how to write some new api functions for the ones that are missing.</p>
  
  <p>Alternatively you might get what you want using CiviReports, and be able to consume that data from another machine.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-23T20:37:59.667Z
Answers.LastActivityDate: 2017-08-23T20:37:59.667Z
Answers.UserDisplayName: Alan Dixon
Body: <p>How do I get mailing behavioural data through the CiviCRM data through the API? Like number of bounce per mailing job or number of opens.</p>
  
Tags: <civimail><api>
Title: Mailing behavioural data throgh API
ThreadText: # Mailing behavioural data throgh API
  
  (Asked by: username_0 on 2017-08-16)
  
  How do I get mailing behavioural data through the CiviCRM data through the API? Like number of bounce per mailing job or number of opens.
  
  **Tags:** civimail, api
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-08-23. Score: 1 | Accepted answer
  
  That data is stored in tables like "civicrm\_mailing\_event\_opened" and "civicrm\_mailing\_event\_bounce" joined with the civicrm\_mailing\_event table. I see that subscribe and unsubscribe have been implemented for example, but not the examples you're looking at (bounce or open).
  
  So you could use the existing implementations to figure out how to write some new api functions for the ones that are missing.
  
  Alternatively you might get what you want using CiviReports, and be able to consume that data from another machine.
  
  
  ---
  
  