| Columns: | ||||||
|---|---|---|---|---|---|---|
| Name | Type | Max Length | Default Value | Allow Null | Read Only | Unique |
| id | Int32 | X | ||||
| EarliestPausedID | Int32 | X | ||||
| EarliestSoftFailID | Int32 | X | ||||
| FirstRecipientID | Int32 | X | ||||
| FirstClickID | Int32 | X | ||||
| active | Int32 | |||||
| paused | Int32 | |||||
| mailed | Int32 | |||||
| received | Int32 | |||||
| opens | Int32 | |||||
| opens_firsts | Int32 | |||||
| total_clicks | Int32 | |||||
| clicks_firsts | Int32 | |||||
| unique_clicks | Int32 | |||||
| trans | Int32 | |||||
| trans_firsts | Int32 | |||||
| trans_amt | Decimal | |||||
| soft_fails | Int32 | |||||
| hard_fails | Int32 | |||||
| perm_fails | Int32 | |||||
| dns_temps | Int32 | |||||
| bad_doms | Int32 | |||||
| bounces | Int32 | |||||
| invalids | Int32 | |||||
| mes_missings | Int32 | |||||
| expirations | Int32 | |||||
| skips | Int32 | |||||
| aborts | Int32 | |||||
| unsubs | Int32 | |||||
| forwards | Int32 | |||||
| referrals | Int32 | |||||
| new_members | Int32 | |||||
| start_date | DateTime | X | ||||
| Created | DateTime | X | ||||
| DeliverBefore | DateTime | X | ||||
| InmailBodySize | Int32 | X | ||||
| Priority | Byte | X | ||||
| SplitTestID | Int32 | X | ||||
| SplitPartID | Int32 | X | ||||
| SubsetID | Int32 | X | ||||
| ListID | Int32 | X | ||||
| InmailHdrFrom | String | 238 | X | |||
| OutmailFrom | String | 200 | X | |||
| List | String | 60 | X | |||
| Title | String | 70 | X | |||
| OutmailTo | String | 200 | X | |||
| Subject | String | 1000 | X | |||
| Type | String | 50 | ||||
| unique_opens | Int32 | |||||
| unique_trans | Int32 | |||||
| units | Int32 | X | ||||
| streams | Int32 | X | ||||
| unique_streams | Int32 | X | ||||
| needsEngaCalc | String | 1 | ||||
| engagement | Decimal | |||||
| survey_responses | Int32 | X | ||||
| complaints | Int32 | X | ||||
| attempted | Int32 | |||||
| finish_date | DateTime | X | ||||
| backlight_Impressions | Int32 | X | ||||
| backlight_Unique_Impressions | Int32 | X | ||||
| backlight_Starts | Int32 | X | ||||
| backlight_Unique_Starts | Int32 | X | ||||
| backlight_Completes | Int32 | X | ||||
| backlight_Unique_Completes | Int32 | X | ||||
| social_shares | Int32 | X | ||||
| social_impressions | Int32 | X | ||||
| IsEstimated | String | 1 | X | |||
| completed | DateTime | X | ||||
| MobileOpens | Int32 | X | ||||
| WebOpens | Int32 | X | ||||
| DesktopOpens | Int32 | X | ||||
| UnknownOpens | Int32 | X | ||||
| UniqueMobileOpens | Int32 | X | ||||
| UniqueWebOpens | Int32 | X | ||||
| UniqueDesktopOpens | Int32 | X | ||||
| UniqueUnknownOpens | Int32 | X | ||||
| MessageTypeID | Int32 | X | ||||
| DripCampaignID | Int32 | X | ||||
| IsTriggered | Boolean | X | ||||
| ModerateID | Int32 | X | ||||
| IsTransactional | Boolean | X | ||||