ReportClickDetailsMembers
Displays the subscribers who clicked on specific links within a campaign.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| EmailId | = |
| CampaignId | = |
| UrlId | = |
SELECT * FROM ReportClickDetailsMembers WHERE EmailId = '12a32' AND CampaignId = '123d' AND URLId = '3241s'
Columns
| Name | Type | References | Description |
| EmailId [KEY] | String | The list-specific identifier for the subscriber's email address within the campaign report. | |
| EmailAddress | String | The subscriber's email address associated with the recorded clicks. | |
| Clicks | Integer | The total number of times this subscriber clicked on the specific tracked link in the campaign. | |
| CampaignId [KEY] | String |
Campaigns.Id | The unique identifier of the campaign in which the clicks were recorded. |
| UrlId [KEY] | String | The unique identifier of the tracked URL that the subscriber clicked on. | |
| ListId [KEY] | String |
Lists.Id | The unique identifier of the audience (list) associated with the campaign. |
| ListIsActive | Boolean | If the value is 'true', the list is currently active; if 'false', it has been deleted or disabled. | |
| ContactStatus | String | The current status of the subscriber in the list, such as subscribed, unsubscribed, deleted, non-subscribed, transactional, pending, or awaiting reconfirmation. | |
| MergeFields | String | A collection of merge fields for the subscriber, where keys represent merge tags and values contain associated data (for example, first name or company). | |
| VIP | Boolean | If the value is 'true', indicates that the subscriber holds VIP status in the list. |