ReportClickDetailsMembers
Displays the subscribers who clicked on specific links within a campaign.
Table Specific Information
SELECT is supported for ReportClickDetailsMembers.
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.
- EmailId supports the '=' operator.
- CampaignId supports the '=' operator.
- UrlId supports the '=' operator.
SELECT * FROM ReportClickDetailsMembers WHERE EmailId = '12a32' and CampaignId = '123d' and URLId = '3241s'
Columns
| Name | Type | 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 | 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 | 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. |