en:dataexchange:export_newsletter_audit

This is an old revision of the document!


Export Types

Newsletter Audition

Every change in newsletter subscriptions (additions and losses) of all newsletters are exported.

Filename:
[SENDER-ID]_newsletter_audit_[full|incremental].csb (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
    3: manual addition (e.g. addition of a target group to the newsletter)
    4: promio.mail cronjob (automatic processes)
    5: promio.mail manual change (e.g. subscription / unsubscribe via newsletter manager)
    7: holiday lock
    8: auto campaign
    9: hardbounce cleaner
    10: blacklist cleaner
    11: removal because of feedbackloop complaint
    13: SOAP
    15: quarantine cleaner
    17: list unsubscribe (unsubscribe via list unsubscribe link in email header)
  • 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
en/dataexchange/export_newsletter_audit.1644831997.txt.gz · Last modified: 2022/02/14 10:46 by fw