Filename:
[SENDER-ID]_newsletter_audit_[full|incremental].csv (respectively with individual date suffix)

Example:

"newsletterId";"ts";"userId";"status";"sourceType";"sourceId";"remark"
"80347";"2011-01-26 00:10:04";"522503";"1";"1";"13011";""

• newsletterId [int]: ID of newsletter
• ts [datetime]: timestamp of addition/loss (YYYY-MM-DD HH:MM:SS)
• userId [int]: ID of user (promio internal, unique)
• status [int, -1|1]:
  1: addition
  -1: loss
• sourceType [int]: source of change:
  1: address generation (addition) or system unsubscribe page (loss)
  3: manual addition (e.g. addition of a target group to the newsletter)
  4: promio.connect cronjob (automatic processes, e.g. import, renewal)
  5: promio.connect manual change (e.g. API, newsletter manager, address research)
  7: holiday lock
  9: hardbounce cleaner
  10: blacklist cleaner
  11: feedbackloop complaint
  12: unsubscription via blocklist
  13: SOAP
  15: quarantine cleaner
  16: conversion tracking
  17: list unsubscribe (unsubscribe via list unsubscribe link in email header)
  18: auto campaign
  19: GDPR deletion process (deletion of personal data according to GDPR requirements)
  20: channel optin cleaner
• sourceID [int]: optional, corresponding to sourceType, e.g. ID of address generation if added by adress generation, ID of target group if added by target group, ID of email if unsubcribe by list unsubcribe link.
• remark [string]: optional, additional information