en:dataexchange:export_blocklist_audit

Automatic export: Type 'Blocklist Audition'

Every change (additions and losses) of blocklists are exported.

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

Example:

"blocklistId";"ts";"userId";"custID";"mail";"status";"sourceType";"sourceId";"remark"
"80347";"2011-01-26 00:10:04";"522503";"CUSTOMERCODE";"mail@mail.com";"1";"1";"13011";""
  • blocklistId [int]: ID of blocklist (promio internal, unique)
  • ts [datetime]: timestamp of change (YYYY-MM-DD HH:MM:SS)
  • userId [int]: ID of user (promio internal, unique per user)
  • custID [string]: ID of customer (external)
  • mail [string]: e-mail address (external)
  • status [int, -1|1]:
    -1: removed from blocklist
    1: added to blocklist
  • sourceType [int]: source of change
    1: system unsubscribe page
    2: not used
    3: not used
    4: promio.connect cronjob (autom. processes)
    5: promio.connect manual change (e.g. API, address research)
    6: not used
    7: holiday block
    8: auto-campaign
    9: hardbounce cleaning
    10: blacklist cleaning
    11: feedbackloop complaint
    12: SOAP addUserToBlocklist, removeUserFromBlocklist
    13: SOAP general
    17: list-unsubscribe
  • sourceId [int]: optional, corresponding to sourceType
  • remark [string]: optional, additional information

If interested or for questions regarding the automatic export, please contact our support team via ticket.
You find more export types in the article Export: Which specifications has the batch process?.

en/dataexchange/export_blocklist_audit.txt · Last modified: 2024/11/18 17:54 by fw