User Tools

Site Tools


en:dataexchange:export_newsletter_audit

This is an old revision of the document!


Automatic export: Type '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

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_newsletter_audit.1652451737.txt.gz · Last modified: 2022/05/13 16:22 by fw