en:dataexchange:export_newsletter_monthly_report

This is an old revision of the document!


Export Types

Newsletter - Monthly Report

A report of response data (opens, clicks) of all newsletters that were delivered is exported.

The following options of this export are obligatory: period = monthly, format = csv.

Filename:
[SENDER-ID]_newsletter_monthly_report_[full|incremental].csv (respectively with individual date suffix)

Example:

"newsletterId";"newsletterName";"newsletterCode";"clientId";"clientName";"noDeliveries";"noRecipients";"avgRecipients";"noDelivered";"noOpens";"openRate";"noClicks";"clickRate"
"70387";"Newsletter am Mittag";"";"11146";"promio.net Newsletter";"16";"238502";"14906";"235267";"78373";"32.86";"13251";"5.56"
  • newsletterId [int]: ID of newsletter (promio internal)
  • newsletterName: name of newsletter
  • newsletterCode: customer code of newsletter
  • clientId: ID of client (5-digit code, promio-internal)
  • clientName: name of client
  • noDeliveries: number of deliveries of newsletter
  • noRecipients: number of recipients of newsletter
  • avgRecipients: average of sent emails per delivery
  • noDelivered: number of delivered emails
  • noOpens: opens (brutto)
  • openRate: open rate
  • noClicks: clicks (brutto)
  • clickRate: click rate
en/dataexchange/export_newsletter_monthly_report.1459781760.txt.gz · Last modified: 2016/04/04 16:56 by fw