en:dataexchange:export_campaigns

This is an old revision of the document!


Export Types

Campaigns

Campaign data is exported that were delivered.

The data includes:

  • ID of sendQueue (promio internal, unique)
  • ID of campaign (promio internal)
  • campaign code (customer code)
  • ID of newsletter (promio internal)
  • name of campaign
  • client of campaign (5-numbered code, promio internal)
  • URL of statistics (link to realtime statistics in browser)
  • URL of preview (link to view of the e-mail in browser)
  • ID of letter / e-mail (promio internal)
  • name of e-mail
  • number of recipients
  • timestamp of delivery (YYYY-MM-DD HH:MM:SS)

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"
en/dataexchange/export_campaigns.1438184392.txt.gz · Last modified: 2015/07/29 17:39 by fw