TransactionalTags
Get Transactional Tags.
Table Specific Information
SELECT and DELETE are supported for TransactionalTags.
Select
The driver 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 driver.
- 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 actual tag as a string. |
| Reputation | Integer | True |
The tag's current reputation on a scale from 0 to 100. |
| Sent | Integer | True |
The total number of messages sent by this sender. |
| HardBounces | Integer | True |
The total number of hard bounces by messages by this sender. |
| SoftBounces | Integer | True |
The total number of soft bounces by messages by this sender. |
| Rejects | Integer | True |
The total number of rejected messages by this sender. |
| Complaints | Integer | True |
The total number of spam complaints received for messages by this sender. |
| Unsubs | Integer | True |
The total number of unsubscribe requests received for messages by this sender. |
| Opens | Integer | True |
The total number of times messages by this sender have been opened. |
| Clicks | Integer | True |
The total number of times tracked URLs in messages by this sender have been clicked. |
| UniqueOpens | Integer | True |
The number of unique opens for emails sent for this sender. |
| UniqueClicks | Integer | True |
The number of unique clicks for emails sent for this sender. |
| StatsTodaySent | Integer | True |
The number of emails sent with this tag so far today. This column will populated when Id is specified in WHERE clause. |
| StatsTodayHardBounces | Integer | True |
The number of emails hard bounced with this tag so far today. This column will populated when Id is specified in WHERE clause. |
| StatsTodaySoftBounces | Integer | True |
The number of emails soft bounced with this tag so far today. This column will populated when Id is specified in WHERE clause. |
| StatsTodayRejects | Integer | True |
The number of emails rejected for sending this sender so far today. This column will populated when Id is specified in WHERE clause. |
| StatsTodayComplaints | Integer | True |
The number of spam complaints with this tag so far today. This column will populated when Id is specified in WHERE clause. |
| StatsTodayUnsubs | Integer | True |
The number of unsubscribes with this tag so far today. This column will populated when Id is specified in WHERE clause. |
| StatsTodayOpens | Integer | True |
The number of times emails have been opened with this tag so far today. This column will populated when Id is specified in WHERE clause. |
| StatsTodayClicks | Integer | True |
The number of URLs that have been clicked with this tag so far today. This column will populated when Id is specified in WHERE clause. |
| StatsTodayUniqueOpens | Integer | True |
The number of unique opens for emails sent with this tag so far today. This column will populated when Id is specified in WHERE clause. |
| StatsTodayUniqueClicks | Integer | True |
The number of unique clicks for emails sent with this tag so far today. This column will populated when Id is specified in WHERE clause. |
| StatsLast7DaysSent | Integer | True |
The number of emails sent with this tag in the last 7 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast7DaysHardBounces | Integer | True |
The number of emails hard bounced with this tag in the last 7 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast7DaysSoftBounces | Integer | True |
The number of emails soft bounced with this tag in the last 7 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast7DaysRejects | Integer | True |
The number of emails rejected for sending this sender in the last 7 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast7DaysComplaints | Integer | True |
The number of spam complaints with this tag in the last 7 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast7DaysUnsubs | Integer | True |
The number of unsubscribes with this tag in the last 7 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast7DaysOpens | Integer | True |
The number of times emails have been opened with this tag in the last 7 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast7DaysClicks | Integer | True |
The number of URLs that have been clicked with this tag in the last 7 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast7DaysUniqueOpens | Integer | True |
The number of unique opens for emails sent with this tag in the last 7 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast7DaysUniqueClicks | Integer | True |
The number of unique clicks for emails sent with this tag in the last 7 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast30DaysSent | Integer | True |
The number of emails sent with this tag in the last 30 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast30DaysHardBounces | Integer | True |
The number of emails hard bounced with this tag in the last 30 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast30DaysSoftBounces | Integer | True |
The number of emails soft bounced with this tag in the last 30 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast30DaysRejects | Integer | True |
The number of emails rejected for sending this sender in the last 30 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast30DaysComplaints | Integer | True |
The number of spam complaints with this tag in the last 30 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast30DaysUnsubs | Integer | True |
The number of unsubscribes with this tag in the last 30 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast30DaysOpens | Integer | True |
The number of times emails have been opened with this tag in the last 30 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast30DaysClicks | Integer | True |
The number of URLs that have been clicked with this tag in the last 30 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast30DaysUniqueOpens | Integer | True |
The number of unique opens for emails sent with this tag in the last 30 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast30DaysUniqueClicks | Integer | True |
The number of unique clicks for emails sent with this tag in the last 30 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast60DaysSent | Integer | True |
The number of emails sent with this tag in the last 60 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast60DaysHardBounces | Integer | True |
The number of emails hard bounced with this tag in the last 60 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast60DaysSoftBounces | Integer | True |
The number of emails soft bounced with this tag in the last 60 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast60DaysRejects | Integer | True |
The number of emails rejected for sending this sender in the last 60 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast60DaysComplaints | Integer | True |
The number of spam complaints with this tag in the last 60 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast60DaysUnsubs | Integer | True |
The number of unsubscribes with this tag in the last 60 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast60DaysOpens | Integer | True |
The number of times emails have been opened with this tag in the last 60 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast60DaysClicks | Integer | True |
The number of URLs that have been clicked with this tag in the last 60 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast60DaysUniqueOpens | Integer | True |
The number of unique opens for emails sent with this tag in the last 60 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast60DaysUniqueClicks | Integer | True |
The number of unique clicks for emails sent with this tag in the last 60 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast90DaysSent | Integer | True |
The number of emails sent with this tag in the last 90 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast90DaysHardBounces | Integer | True |
The number of emails hard bounced with this tag in the last 90 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast90DaysSoftBounces | Integer | True |
The number of emails soft bounced with this tag in the last 90 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast90DaysRejects | Integer | True |
The number of emails rejected for sending this sender in the last 90 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast90DaysComplaints | Integer | True |
The number of spam complaints with this tag in the last 90 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast90DaysUnsubs | Integer | True |
The number of unsubscribes with this tag in the last 90 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast90DaysOpens | Integer | True |
The number of times emails have been opened with this tag in the last 90 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast90DaysClicks | Integer | True |
The number of URLs that have been clicked with this tag in the last 90 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast90DaysUniqueOpens | Integer | True |
The number of unique opens for emails sent with this tag in the last 90 days. This column will populated when Id is specified in WHERE clause. |
| StatsLast90DaysUniqueClicks | Integer | True |
The number of unique clicks for emails sent with this tag in the last 90 days. This column will populated when Id is specified in WHERE clause. |