MailCampaign (v1)
One mail sendout (Serienmail) with its delivery and engagement statistics
| # | Field | Type | Description |
|---|---|---|---|
| 0 | id | int | internal mailstats id |
| 1 | serieref | int | PCG serial reference of the sendout; also the key for the per-serie open/click charts and /readonline |
| 2 | campaignid | int | campaign id, 0 = info mail (no campaign) |
| 3 | sent | datetime | start of the sendout |
| 4 | duration | int | sendout duration in seconds, 0 = still running |
| 5 | subject | string | mail subject |
| 6 | total | int | number of mails sent |
| 7 | senderrors | int | errors during the sendout itself |
| 8 | uniquebounces | int | unique bounces after the sendout |
| 9 | uniqueopens | int | mails opened, counted once per reader |
| 10 | opens | int | mails opened, every open counted |
| 11 | unsubscribes | int | unsubscribes attributed to this sendout |
| 12 | clicks | int | link clicks, every click counted |
| 13 | unique_clicks | int | link clicks, counted once per reader |
| 14 | openrate | double | unique opens in percent of total |
| 15 | clickrate | double | unique clicks in percent of total |
| 16 | bouncerate | double | unique bounces in percent of total |
| 17 | last_updated | datetime | last (automatic) refresh of these numbers |
| 18 | archived | bool | true if the sendout was archived in the admin UI |
Used in endpoints
Referenced in skills
Other versions
- MailCampaign v2 (newer)