en:dataexchange:export_newsletter_audit_specific

This is an old revision of the document!


Automatic export: Type 'Newsletter Audition specific'

Every change in newsletter subscriptions (additions and losses) of a defined newsletter are exported.

Filename:
[SENDER-ID]_newsletter_audit_specific_[newsletterID]_[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
    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 block
    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)
    18: GDPR Deletion Process (Deletion of personal data according to GDPR requirements)
  • 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 service center!
You find more export types in the article Export: Which specifications has the batch process?.

en/dataexchange/export_newsletter_audit_specific.1651159927.txt.gz · Last modified: 2022/04/28 17:32 by fw