en:dataexchange:export_campaign_statistics

Automatic export: Type 'Campaign Statistics'

The statistics of all campaigns will be exported up to 30 days after the start of delivery.

The number of exported last delivery days can be configured (default: 7 days).
The following campaign types are NOT included:

  • Tracking
  • Network Campaign Manager (there is a separate export type available)

It is possible to send the report by e-mail as an attachment.

Dateiname:
[SENDER_ID]_campaignStatistics_full.csv (respectively with individual date suffix)

Beispiel:

"campaignDate";"campaignId";"campaignName";"campaignCode";"campaignType";"clientId";"clientName";"newsletterId";"newsletterCode";"newsletterName";"messageId";"messageName";"messageType";"subject";"sendFrom";"previewUrl";"sendDatetime";"noRecipients";"noDelivered";"noOpens";"noOpensUnique";"noClicks";"noClicksUnique";"noConversions";"noSoftbounces";"noHardbounces";"noUnsubscribes"
"2019-08-20";"10312345";"Campaign A";"CampaignCode A";"default";"12345";"client ABC";"70000","NL_ABC";"Daily Newsletter";"1234567";"MessageName A";"E-mail";"a great subject line";"name@domain.com";"http://system.promio-mail.com/view/?xxx";"2019-08-20 11:09:59";"117566";"115837";"69807";"52694";"5712";"3609";"0";"1260";"469";"1188"
"2019-08-20";"10312345";"Campaign B";"CampaignCode B";"default";"12345";"client XYZ";"70001","NL_XYZ";"Weekly Newsletter";"1234567";"MessageName B";"E-mail";"a even greater subject line";"name@domain.com";"http://system.promio-mail.com/view/?xxx";"2019-08-20 11:09:59";"117566";"115837";"69807";"52694";"5712";"3609";"0";"1260";"469";"1188"
  • campaignDate [date]: Campaign delivery date (last delivery)
  • campaignId [int]: ID of the campaign
  • campaignName [string]: Name of the campaign
  • campaignCode [string]: Campaign code (optional)
  • campaignType [string]: Campaign type (e.g., A / B test, auto, transaction)
  • clientId [int]: ID of the client
  • clientName [string]: Name of the client
  • newsletterId [int]: ID of the newsletter (optional)
  • newsletterCode [string]: Customer code of the newsletter (optional)
  • newsletterName [string]: Name of the newsletter (optional)
  • messageId [int]: ID of the message
  • messageName [string]: Name of the message
  • messageType [string]: Message Type (e.g., Email, SMS, Whatsapp, App Push, Web Push, Print)
  • subject [string]: Subject of the message (optional)
  • sendFrom [string]: Sender of the message (optional)
  • previeUrl [string]: URL for message preview
  • sendDatetime [datetime]: Date and time of (last) delivery
  • noRecipients [int]: number of recipients
  • noDelivered [int]: Number of delivered messages
  • noOpens [int]: Number of openings
  • noOpensUnique [int]: number of openings unique
  • noClicks [int]: number of clicks
  • noClicksUnique [int]: Number of clicks unique
  • noConversions [int]: number of conversions
  • noSoftbounces [int]: Number of soft bounces
  • noHardbounces [int]: number of hard bounces
  • noUnsubscribes [int]: Number unsubscribes

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_campaign_statistics.txt · Last modified: 2024/05/06 16:41 by fw