TransactionalTags
Lists available tags used to categorize transactional emails.
Table Specific Information
SELECT and DELETE are supported for TransactionalTags.
Select
The connector will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.
- Tag supports the '=' operator.
SELECT * FROM TransactionalTags WHERE Tag = 'welcome'
Delete
Tag is required for the DELETE operation.
DELETE FROM TransactionalTags WHERE Tag = 'welcome'
Columns
| Name | Type | ReadOnly | Description |
| Tag [KEY] | String | True |
The name of the tag used to categorize or track transactional messages. |
| Reputation | Integer | True |
The tag's current reputation score on a scale from 0 to 100, which reflects its overall deliverability and engagement performance. |
| Sent | Integer | True |
The total number of messages sent with this tag across all campaigns or send operations. |
| HardBounces | Integer | True |
The total number of messages with this tag that resulted in hard bounces, indicating permanent delivery failures. |
| SoftBounces | Integer | True |
The total number of messages with this tag that resulted in soft bounces, indicating temporary delivery issues. |
| Rejects | Integer | True |
The total number of messages with this tag that were rejected before delivery. |
| Complaints | Integer | True |
The total number of spam complaints received for messages sent with this tag. |
| Unsubs | Integer | True |
The total number of unsubscribe requests received for messages sent with this tag. |
| Opens | Integer | True |
The total number of times messages tagged with this label were opened. |
| Clicks | Integer | True |
The total number of times tracked URLs within messages tagged with this label were clicked. |
| UniqueOpens | Integer | True |
The total number of unique recipients who opened at least one message sent with this tag. |
| UniqueClicks | Integer | True |
The total number of unique recipients who clicked at least one tracked URL in messages sent with this tag. |
| StatsTodaySent | Integer | True |
The number of emails sent with this tag so far today. This value is populated when an Id is specified in the WHERE clause. |
| StatsTodayHardBounces | Integer | True |
The number of hard-bounced emails with this tag so far today. This value is populated when an Id is specified in the WHERE clause. |
| StatsTodaySoftBounces | Integer | True |
The number of soft-bounced emails with this tag so far today. This value is populated when an Id is specified in the WHERE clause. |
| StatsTodayRejects | Integer | True |
The number of rejected emails sent with this tag so far today. This value is populated when an Id is specified in the WHERE clause. |
| StatsTodayComplaints | Integer | True |
The number of spam complaints received for messages with this tag so far today. This value is populated when an Id is specified in the WHERE clause. |
| StatsTodayUnsubs | Integer | True |
The number of unsubscribe requests for messages sent with this tag so far today. This value is populated when an Id is specified in the WHERE clause. |
| StatsTodayOpens | Integer | True |
The number of times messages with this tag were opened so far today. This value is populated when an Id is specified in the WHERE clause. |
| StatsTodayClicks | Integer | True |
The number of times tracked URLs in messages with this tag were clicked so far today. This value is populated when an Id is specified in the WHERE clause. |
| StatsTodayUniqueOpens | Integer | True |
The number of unique recipients who opened messages sent with this tag so far today. This value is populated when an Id is specified in the WHERE clause. |
| StatsTodayUniqueClicks | Integer | True |
The number of unique recipients who clicked URLs in messages with this tag so far today. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast7DaysSent | Integer | True |
The number of emails sent with this tag in the last 7 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast7DaysHardBounces | Integer | True |
The number of hard-bounced emails with this tag in the last 7 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast7DaysSoftBounces | Integer | True |
The number of soft-bounced emails with this tag in the last 7 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast7DaysRejects | Integer | True |
The number of rejected emails sent with this tag in the last 7 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast7DaysComplaints | Integer | True |
The number of spam complaints received for messages with this tag in the last 7 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast7DaysUnsubs | Integer | True |
The number of unsubscribe requests for messages with this tag in the last 7 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast7DaysOpens | Integer | True |
The number of times messages with this tag were opened in the last 7 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast7DaysClicks | Integer | True |
The number of times tracked URLs in messages with this tag were clicked in the last 7 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast7DaysUniqueOpens | Integer | True |
The number of unique recipients who opened messages sent with this tag in the last 7 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast7DaysUniqueClicks | Integer | True |
The number of unique recipients who clicked URLs in messages with this tag in the last 7 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast30DaysSent | Integer | True |
The number of emails sent with this tag in the last 30 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast30DaysHardBounces | Integer | True |
The number of hard-bounced emails with this tag in the last 30 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast30DaysSoftBounces | Integer | True |
The number of soft-bounced emails with this tag in the last 30 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast30DaysRejects | Integer | True |
The number of rejected emails sent with this tag in the last 30 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast30DaysComplaints | Integer | True |
The number of spam complaints received for messages with this tag in the last 30 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast30DaysUnsubs | Integer | True |
The number of unsubscribe requests for messages with this tag in the last 30 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast30DaysOpens | Integer | True |
The number of times messages with this tag were opened in the last 30 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast30DaysClicks | Integer | True |
The number of times tracked URLs in messages with this tag were clicked in the last 30 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast30DaysUniqueOpens | Integer | True |
The number of unique recipients who opened messages sent with this tag in the last 30 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast30DaysUniqueClicks | Integer | True |
The number of unique recipients who clicked URLs in messages with this tag in the last 30 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast60DaysSent | Integer | True |
The number of emails sent with this tag in the last 60 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast60DaysHardBounces | Integer | True |
The number of hard-bounced emails with this tag in the last 60 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast60DaysSoftBounces | Integer | True |
The number of soft-bounced emails with this tag in the last 60 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast60DaysRejects | Integer | True |
The number of rejected emails sent with this tag in the last 60 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast60DaysComplaints | Integer | True |
The number of spam complaints received for messages with this tag in the last 60 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast60DaysUnsubs | Integer | True |
The number of unsubscribe requests for messages with this tag in the last 60 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast60DaysOpens | Integer | True |
The number of times messages with this tag were opened in the last 60 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast60DaysClicks | Integer | True |
The number of times tracked URLs in messages with this tag were clicked in the last 60 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast60DaysUniqueOpens | Integer | True |
The number of unique recipients who opened messages sent with this tag in the last 60 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast60DaysUniqueClicks | Integer | True |
The number of unique recipients who clicked URLs in messages with this tag in the last 60 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast90DaysSent | Integer | True |
The number of emails sent with this tag in the last 90 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast90DaysHardBounces | Integer | True |
The number of hard-bounced emails with this tag in the last 90 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast90DaysSoftBounces | Integer | True |
The number of soft-bounced emails with this tag in the last 90 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast90DaysRejects | Integer | True |
The number of rejected emails sent with this tag in the last 90 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast90DaysComplaints | Integer | True |
The number of spam complaints received for messages with this tag in the last 90 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast90DaysUnsubs | Integer | True |
The number of unsubscribe requests for messages with this tag in the last 90 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast90DaysOpens | Integer | True |
The number of times messages with this tag were opened in the last 90 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast90DaysClicks | Integer | True |
The number of times tracked URLs in messages with this tag were clicked in the last 90 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast90DaysUniqueOpens | Integer | True |
The number of unique recipients who opened messages sent with this tag in the last 90 days. This value is populated when an Id is specified in the WHERE clause. |
| StatsLast90DaysUniqueClicks | Integer | True |
The number of unique recipients who clicked URLs in messages with this tag in the last 90 days. This value is populated when an Id is specified in the WHERE clause. |