Hoping we can start pulling in non campaign emails (RML as example) to these tables:

• civicrm.civicrm_mailing_provider_data
• civicrm.civicrm_mailing
• civicrm.civicrm_mailing_stats

Email team documentation: https://docs.google.com/document/d/1ziO3voCdqTbzEmhXjEfOyTB7rFcnatt6eDYl7eYOZvc/edit#heading=h.75id8n9j2j69

Instructions and links from @bsisolak :

Use GetSentMailingsForOrg with CAMPAIGN_ACTIVE, CAMPAIGN_COMPLETED and CAMPAIGN_CANCELLED. Then cycle the IDs through GetAggregateTrackingForMailing. The trick is you get a new ReportId for each day, so you might want to store these somewhere else so you can pivot the data by day

https://developer.goacoustic.com/acoustic-campaign/reference/getaggregatetrackingformailing

https://developer.goacoustic.com/acoustic-campaign/reference/getsentmailingsfororg