SSIS Components for Mailchimp

Build 25.0.9434

TransactionalUserInfos

Get Transactional user info.

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 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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434