IBM Watson Campaign Automation | Mailing Standard Dataset
ChannelMix
Below are the fields Alight Analytics considers standard for the Mailing dataset from IBM Watson Campaign Automation. There is a 1-day lag, 30-day lookback window on this dataset and data will be refreshed daily.
| Field Name | Type | Description |
| report_date | Date | |
| sent_date_time | Date Time | The date and time the Acoustic Campaign sent the mailing. |
| mailing_id | Dimension | |
| mailing_name | Dimension | |
| report_id | Date Time | |
| mailing_status | Dimension | |
| privacy_status | Dimension | |
| report_type | Dimension | |
| num_abuse_fwd | Number | The number of abuse complaints by forwarded contacts. |
| num_attach_open_fwd | Number | The number of attachment downloads by forwarded contacts. |
| num_bounce_hard | Number | The number of hard bounces. |
| num_bounce_hard_fwd | Number | The number of hard bounces that occurred for forwarded contacts. |
| num_bounce_soft | Number | The number of soft bounces. |
| num_bounce_soft_fwd | Number | The number of soft bounces that occurred for forwarded contacts. |
| num_change_address_fwd | Number | The number of change address replies by forwarded contacts. |
| num_click_fwd | Number | The number of clicks for forwarded contacts. |
| num_conversion_amount | Number | The total conversion amount. |
| num_conversion_amount_fwd | Number | The total conversion amount that occurred for forwarded contacts. |
| num_conversions | Number | The number of conversions. |
| num_gross_abuse | Number | The number of abuse complaints. |
| num_gross_attach | Number | The number of gross attachment downloads. |
| num_gross_attach_open_fwd | Number | The number of gross attachment downloads by forwarded contacts. |
| num_gross_change_address | Number | The number of change of address replies. |
| num_gross_click | Number | The number of gross clicks. |
| num_gross_click_fwd | Number | The number of gross clicks by forwarded contacts. |
| num_gross_clickstream_fwd | Number | The number of gross clickstream clicks by forwarded contacts. |
| num_gross_clickstreams | Number | The number of gross clickstream clicks. |
| num_gross_conversions_fwd | Number | The number of gross conversions by forwarded contacts. |
| num_gross_forward_fwd | Number | The number of gross forwards by forwarded contacts. |
| num_gross_mail_block | Number | The number of mail block replies. |
| num_gross_mail_restriction | Number | The number of mail restriction replies. |
| num_gross_media | Number | The number of gross media plays. |
| num_gross_media_fwd | Number | The number of gross media plays by forwarded contacts. |
| num_gross_open | Number | The number of gross opens. |
| num_gross_open_fwd | Number | The number of gross opens by forwarded contacts. |
| num_gross_other | Number | The number of other replies. |
| num_inbox_monitored | Number | The number of Inbox Monitoring addresses seeded into this mailing. |
| num_mail_block_fwd | Number | The number of mail block replies by forwarded contacts. |
| num_mail_restriction_fwd | Number | The number of mail restriction replies by forwarded contacts. |
| num_other_fwd | Number | The number of other replies by forwarded contacts. |
| num_seeds | Number | The number of contacts that are seeded into the mailing. |
| num_sent | Number | The number of contacts to whom the Acoustic Campaign sent the mailing. |
| num_suppressed | Number | The number of contacts that are suppressed from the mailing. |
| num_suppressed_fwd | Number | The number of suppressed forwards. |
| num_unique_attach | Number | The number of unique attachment downloads. |
| num_unique_attach_open_fwd | Number | The number of unique attachment downloads by forwarded contacts. |
| num_unique_click | Number | The number of unique clicks. |
| num_unique_click_fwd | Number | The number of unique clicks by forwarded contacts. |
| num_unique_clickstream_fwd | Number | The number of unique clickstream clicks by forwarded contacts. |
| num_unique_clickstreams | Number | The number of unique clickstream clicks. |
| num_unique_conversions_fwd | Number | The number of unique conversions by forwarded contacts. |
| num_unique_forward_fwd | Number | The number of unique forwards by forwarded contacts. |
| num_unique_media | Number | The number of unique media plays. |
| num_unique_media_fwd | Number | The number of unique media plays by forwarded contacts. |
| num_unique_open | Number | The number of unique opens. |
| num_unique_open_fwd | Number | The number of unique opens by forwarded contacts. |
| num_unsubscribes | Number | The number of Opt Outs. |
| insert_date | Date Time | Internal use: when the row was inserted in the table |
| channelmix_profile | Dimension | Contents defined by Alight |