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 ch
ange:
1: address generation (addition) or system unsubscribe page (loss)
3: m
anual addition (e.g. addition of a target group to the newsletter)
4: promio.connect cronjob (automatic processes, e.g. import, renewal)
5: promio.connect m
anual ch
ange (e.g.
API, newsletter m
anager, address research)
7: holiday lock
9: hardbounce cle
aner
10: blacklist cle
aner
11: feedbackloop complaint
12: unsubscription via blocklist
13: SOAP
15: quar
antine cle
aner
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: ch
annel optin cle
aner
sourceID [int]: optional, corresponding to sourceType, e.g. ID of target group if added by target group, ID of e-mail if unsubscribe by list unsubscribe link.
remark [string]: optional, additional information
en/dataexchange/export_newsletter_audit_specific.txt · Last modified: 2025/06/20 11:43 by fw