TransactionalTags
Get Transactional Tags.
Table Specific Information
SELECT and DELETE are supported for TransactionalTags.
Select
The add-in 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 add-in.
- 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. |