TransactionalUserInfos
Provides account-level information about Mailchimp Transactional users, including usage and limits.
Table Specific Information
Only SELECT is supported for TransactionalUserInfos.
Select
There are filters supported server side for this view. This view will provide the details of current user.
SELECT * FROM TransactionalUserInfos
Columns
| Name | Type | Description |
| UserName | String | The username associated with the Mandrill account, used for Simple Mail Transfer Protocol (SMTP) authentication. |
| CreatedAt | Datetime | The Coordinated Universal Time (UTC) timestamp indicating when the user's Mandrill account was created, formatted as YYYY-MM-DD HH:MM:SS. |
| PublicId | String | A permanent and unique identifier for the user's Mandrill account. |
| Reputation | Integer | The user's current reputation score on a scale from 0 to 100, reflecting deliverability and engagement performance. |
| HourlyQuota | Integer | The maximum number of emails Mandrill will deliver for this user within one hour. |
| Backlog | Integer | The number of emails currently queued for delivery because the user's hourly or monthly quotas have been exceeded. |
| StatsTodaySent | Integer | The total number of emails sent by the user so far today. |
| StatsTodayHardBounces | Integer | The number of emails sent today that resulted in hard bounces, indicating permanent delivery failures. |
| StatsTodaySoftBounces | Integer | The number of emails sent today that resulted in soft bounces, indicating temporary delivery issues. |
| StatsTodayRejects | Integer | The number of emails rejected for sending so far today. |
| StatsTodayComplaints | Integer | The number of spam complaints received for emails sent so far today. |
| StatsTodayUnsubs | Integer | The number of unsubscribe requests received for emails sent so far today. |
| StatsTodayOpens | Integer | The total number of times emails sent today have been opened. |
| StatsTodayClicks | Integer | The total number of times tracked URLs in emails sent today have been clicked. |
| StatsTodayUniqueOpens | Integer | The number of unique recipients who opened emails sent today. |
| StatsTodayUniqueClicks | Integer | The number of unique recipients who clicked links in emails sent today. |
| StatsLast7DaysSent | Integer | The total number of emails sent by the user in the last 7 days. |
| StatsLast7DaysHardBounces | Integer | The number of hard-bounced emails in the last 7 days. |
| StatsLast7DaysSoftBounces | Integer | The number of soft-bounced emails in the last 7 days. |
| StatsLast7DaysRejects | Integer | The number of rejected emails in the last 7 days. |
| StatsLast7DaysComplaints | Integer | The number of spam complaints received in the last 7 days. |
| StatsLast7DaysUnsubs | Integer | The number of unsubscribe requests received in the last 7 days. |
| StatsLast7DaysOpens | Integer | The number of times emails have been opened in the last 7 days. |
| StatsLast7DaysClicks | Integer | The number of times tracked URLs have been clicked in the last 7 days. |
| StatsLast7DaysUniqueOpens | Integer | The number of unique recipients who opened emails in the last 7 days. |
| StatsLast7DaysUniqueClicks | Integer | The number of unique recipients who clicked tracked URLs in the last 7 days. |
| StatsLast30DaysSent | Integer | The total number of emails sent by the user in the last 30 days. |
| StatsLast30DaysHardBounces | Integer | The number of hard-bounced emails in the last 30 days. |
| StatsLast30DaysSoftBounces | Integer | The number of soft-bounced emails in the last 30 days. |
| StatsLast30DaysRejects | Integer | The number of rejected emails in the last 30 days. |
| StatsLast30DaysComplaints | Integer | The number of spam complaints received in the last 30 days. |
| StatsLast30DaysUnsubs | Integer | The number of unsubscribe requests received in the last 30 days. |
| StatsLast30DaysOpens | Integer | The number of times emails have been opened in the last 30 days. |
| StatsLast30DaysClicks | Integer | The number of times tracked URLs have been clicked in the last 30 days. |
| StatsLast30DaysUniqueOpens | Integer | The number of unique recipients who opened emails in the last 30 days. |
| StatsLast30DaysUniqueClicks | Integer | The number of unique recipients who clicked tracked URLs in the last 30 days. |
| StatsLast60DaysSent | Integer | The total number of emails sent by the user in the last 60 days. |
| StatsLast60DaysHardBounces | Integer | The number of hard-bounced emails in the last 60 days. |
| StatsLast60DaysSoftBounces | Integer | The number of soft-bounced emails in the last 60 days. |
| StatsLast60DaysRejects | Integer | The number of rejected emails in the last 60 days. |
| StatsLast60DaysComplaints | Integer | The number of spam complaints received in the last 60 days. |
| StatsLast60DaysUnsubs | Integer | The number of unsubscribe requests received in the last 60 days. |
| StatsLast60DaysOpens | Integer | The number of times emails have been opened in the last 60 days. |
| StatsLast60DaysClicks | Integer | The number of times tracked URLs have been clicked in the last 60 days. |
| StatsLast60DaysUniqueOpens | Integer | The number of unique recipients who opened emails in the last 60 days. |
| StatsLast60DaysUniqueClicks | Integer | The number of unique recipients who clicked tracked URLs in the last 60 days. |
| StatsLast90DaysSent | Integer | The total number of emails sent by the user in the last 90 days. |
| StatsLast90DaysHardBounces | Integer | The number of hard-bounced emails in the last 90 days. |
| StatsLast90DaysSoftBounces | Integer | The number of soft-bounced emails in the last 90 days. |
| StatsLast90DaysRejects | Integer | The number of rejected emails in the last 90 days. |
| StatsLast90DaysComplaints | Integer | The number of spam complaints received in the last 90 days. |
| StatsLast90DaysUnsubs | Integer | The number of unsubscribe requests received in the last 90 days. |
| StatsLast90DaysOpens | Integer | The number of times emails have been opened in the last 90 days. |
| StatsLast90DaysClicks | Integer | The number of times tracked URLs have been clicked in the last 90 days. |
| StatsLast90DaysUniqueOpens | Integer | The number of unique recipients who opened emails in the last 90 days. |
| StatsLast90DaysUniqueClicks | Integer | The number of unique recipients who clicked tracked URLs in the last 90 days. |
| StatsLastAllTimeDaysSent | Integer | The total number of emails ever sent through the user's Mandrill account. |
| StatsLastAllTimeDaysHardBounces | Integer | The total number of hard-bounced emails recorded for the account since its creation. |
| StatsLastAllTimeDaysSoftBounces | Integer | The total number of soft-bounced emails recorded for the account since its creation. |
| StatsLastAllTimeDaysRejects | Integer | The total number of rejected emails for the account since its creation. |
| StatsLastAllTimeDaysComplaints | Integer | The total number of spam complaints received across all campaigns and periods. |
| StatsLastAllTimeDaysUnsubs | Integer | The total number of unsubscribe requests received across all campaigns and periods. |
| StatsLastAllTimeDaysOpens | Integer | The total number of times emails have been opened for the entire account history. |
| StatsLastAllTimeDaysClicks | Integer | The total number of times tracked URLs have been clicked for the entire account history. |
| StatsLastAllTimeDaysUniqueOpens | Integer | The total number of unique recipients who have opened emails across the entire account history. |
| StatsLastAllTimeDaysUniqueClicks | Integer | The total number of unique recipients who have clicked tracked URLs across the entire account history. |