UserInfos
Returns account details and email sending statistics for the current user.
View-Specific Information
This view provides the details of the current user.Select
To retrieve all records from this view:SELECT * FROM UserInfos
Columns
| Name | Type | Description |
| UserName | String | The username of the user (used for SMTP authentication). |
| CreatedAt | Datetime | The date and time that the user's Mandrill account was created as a UTC string in YYYY-MM-DD HH:MM:SS format. |
| PublicId | String | A unique, permanent identifier for this user. |
| Reputation | Integer | The reputation of the user on a scale from 0 to 100. |
| HourlyQuota | Integer | The maximum number of emails Mandrill will deliver for this user each hour. |
| Backlog | Integer | The number of emails that are queued for delivery due to exceeding your monthly or hourly quotas. |
| StatsTodaySent | Integer | The number of emails sent so far today. |
| StatsTodayHardBounces | Integer | The number of emails that hard bounced so far today. |
| StatsTodaySoftBounces | Integer | The number of emails that soft bounced so far today. |
| StatsTodayRejects | Integer | The number of emails rejected for sending so far today. |
| StatsTodayComplaints | Integer | The number of spam complaints received so far today. |
| StatsTodayUnsubs | Integer | The number of unsubscribes received so far today. |
| StatsTodayOpens | Integer | The number of times emails have been opened so far today. |
| StatsTodayClicks | Integer | The number of URLs that have been clicked so far today. |
| StatsTodayUniqueOpens | Integer | The number of unique opens so far today. |
| StatsTodayUniqueClicks | Integer | The number of unique clicks so far today. |
| StatsLast7DaysSent | Integer | The number of emails sent in the last 7 days. |
| StatsLast7DaysHardBounces | Integer | The number of hard bounces in the last 7 days. |
| StatsLast7DaysSoftBounces | Integer | The number of soft bounces in the last 7 days. |
| StatsLast7DaysRejects | Integer | The number of rejected emails in the last 7 days. |
| StatsLast7DaysComplaints | Integer | The number of spam complaints in the last 7 days. |
| StatsLast7DaysUnsubs | Integer | The number of unsubscribes in the last 7 days. |
| StatsLast7DaysOpens | Integer | The number of opens in the last 7 days. |
| StatsLast7DaysClicks | Integer | The number of clicks in the last 7 days. |
| StatsLast7DaysUniqueOpens | Integer | The number of unique opens in the last 7 days. |
| StatsLast7DaysUniqueClicks | Integer | The number of unique clicks in the last 7 days. |
| StatsLast30DaysSent | Integer | The number of emails sent in the last 30 days. |
| StatsLast30DaysHardBounces | Integer | The number of hard bounces in the last 30 days. |
| StatsLast30DaysSoftBounces | Integer | The number of soft bounces in the last 30 days. |
| StatsLast30DaysRejects | Integer | The number of rejected emails in the last 30 days. |
| StatsLast30DaysComplaints | Integer | The number of spam complaints in the last 30 days. |
| StatsLast30DaysUnsubs | Integer | The number of unsubscribes 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 URLs that have been clicked in the last 30 days. |
| StatsLast30DaysUniqueOpens | Integer | The number of unique opens in the last 30 days. |
| StatsLast30DaysUniqueClicks | Integer | The number of unique clicks in the last 30 days. |
| StatsLast60DaysSent | Integer | The number of emails sent in the last 60 days. |
| StatsLast60DaysHardBounces | Integer | The number of hard bounces in the last 60 days. |
| StatsLast60DaysSoftBounces | Integer | The number of soft bounces in the last 60 days. |
| StatsLast60DaysRejects | Integer | The number of rejected emails in the last 60 days. |
| StatsLast60DaysComplaints | Integer | The number of spam complaints in the last 60 days. |
| StatsLast60DaysUnsubs | Integer | The number of unsubscribes 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 URLs that have been clicked in the last 60 days. |
| StatsLast60DaysUniqueOpens | Integer | The number of unique opens in the last 60 days. |
| StatsLast60DaysUniqueClicks | Integer | The number of unique clicks in the last 60 days. |
| StatsLast90DaysSent | Integer | The number of emails sent in the last 90 days. |
| StatsLast90DaysHardBounces | Integer | The number of hard bounces in the last 90 days. |
| StatsLast90DaysSoftBounces | Integer | The number of soft bounces in the last 90 days. |
| StatsLast90DaysRejects | Integer | The number of rejected emails in the last 90 days. |
| StatsLast90DaysComplaints | Integer | The number of spam complaints in the last 90 days. |
| StatsLast90DaysUnsubs | Integer | The number of unsubscribes 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 URLs that have been clicked in the last 90 days. |
| StatsLast90DaysUniqueOpens | Integer | The number of unique opens in the last 90 days. |
| StatsLast90DaysUniqueClicks | Integer | The number of unique clicks in the last 90 days. |
| StatsLastAllTimeDaysSent | Integer | The total number of emails sent through the account. |
| StatsLastAllTimeDaysHardBounces | Integer | The total number of hard bounces for the account. |
| StatsLastAllTimeDaysSoftBounces | Integer | The total number of soft bounces for the account. |
| StatsLastAllTimeDaysRejects | Integer | The total number of rejected emails for the account. |
| StatsLastAllTimeDaysComplaints | Integer | The total number of spam complaints for the account. |
| StatsLastAllTimeDaysUnsubs | Integer | The total number of unsubscribes for the account. |
| StatsLastAllTimeDaysOpens | Integer | The total number of times emails have been opened for the account. |
| StatsLastAllTimeDaysClicks | Integer | The total number of URLs that have been clicked for the account. |
| StatsLastAllTimeDaysUniqueOpens | Integer | The total number of unique opens for the account. |
| StatsLastAllTimeDaysUniqueClicks | Integer | The total number of unique clicks for the account. |