en:dataexchange:export_campaigns

Automatic export: Type '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 [int]: ID of sendQueue (promio internal, unique)
  • campaignId [int]: ID of campaign (promio internal)
  • campaignCode [string]: campaign code (customer code)
  • newsletterId [int]: ID of newsletter (promio internal)
  • camp_remark [string]: name of campaign
  • clientId [int]: client of campaign (5-digit code, promio internal)
  • statisticsUrl [string]: URL of statistics (link to realtime statistics in browser)
  • previewUrl [string]: URL of preview (link to view of the e-mail in browser)
  • emailId [int]: ID of letter / e-mail (promio internal)
  • emailName [string]: name of e-mail
  • noRecipients [int]: number of recipients
  • send_datetime [datetime]: timestamp of delivery (YYYY-MM-DD HH:MM:SS)

If interested or for questions regarding the automatic export, please contact our support team via ticket.
You find more export types in the article Export: Which specifications has the batch process?.

en/dataexchange/export_campaigns.txt · Last modified: 2022/05/12 17:03 by fw