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 (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. subscription / unsubscribe via newsletter manager)
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