en:dataexchange:export_campaigns
This is an old revision of the document!
Campaigns
Campaign data is exported that were delivered.
As auto campaigns exist that use one e-mail ID several times for a longer period of time or several times a day (e.g. birthday mailings), the only unique ID is sendQueue-ID.
Filename: [SENDER-ID]_campaigns_[full|incremental].csv (repectively with individual date suffix)
Example:
"sendQueueId";"campaignId";"campaignCode";"newsletterId";"camp_remark";"clientId";"statisticsUrl";"previewUrl";"emailId";"emailName";"noRecipients";"send_datetime" "799786";"73127";"customerCode";"80493";"customerName";"11xxx";"http://man.mailer-service.de/public/stats.php?ID=xyz&c=38ae3f1ac04edf9de6e922e50c610157";"http://mailer-service.com/userpages/view.php?letterId=xyz&cs=4123b5d5f930febe335303ad2a2 fcd04";"105190";"customerEmailname";"2653";"2011-01-26 10:00:00"
- sendQueueId: ID of sendQueue (promio internal, unique)
- campaignId: ID of campaign (promio internal)
- campaignCode: campaign code (customer code)
- newsletterId: ID of newsletter (promio internal)
- camp_remark: name of campaign
- clientId: client of campaign (5-numbered code, promio internal)
- statisticsUrl: URL of statistics (link to realtime statistics in browser)
- previewUrl: URL of preview (link to view of the e-mail in browser)
- emailId: ID of letter / e-mail (promio internal)
- emailName: name of e-mail
- noRecipients: number of recipients
- send_datetime: timestamp of delivery (YYYY-MM-DD HH:MM:SS)
en/dataexchange/export_campaigns.1438184609.txt.gz · Last modified: 2015/07/29 17:43 by fw
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
