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 target group if added by target group, ID of message if unsubscribe by list unsubscribe link.
• remark [string]: optional, additional information