ChimpChatterActivity
Returns recent Chimp Chatter activity for the account, including Mailchimp system updates and campaign notifications.
View-Specific Information
Select
To retrieve all records from this view:SELECT * FROM ChimpChatterActivity
Columns
| Name | Type | References | Description |
| Title | String | The short title or subject line summarizing the Chimp Chatter activity. | |
| Message | String | The message text describing the activity, such as campaign updates, account notifications, or system alerts. | |
| Type | String | The category or type of Chimp Chatter event, such as campaign_send, subscriber_activity, or account_notice.
The allowed values are lists:new-subscriber, lists:unsubscribes, lists:profile-updates, campaigns:facebook-likes, campaigns:forward-to-friend, lists:imports. | |
| ModifiedAt | Datetime | The date and time when the activity record was last updated. | |
| Url | String | A link to view more details about the specific activity within the Mailchimp web interface. | |
| ListId | String |
Lists.Id | The unique identifier of the list associated with the activity, if applicable. |
| CamapignId | String |
Campaigns.Id | The unique identifier of the campaign related to the activity, if applicable. |