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