en:dataexchange:export_newsletter_audit_specific

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 (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 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_specific.txt · Last modified: 2024/11/18 17:57 by fw