ReportClickDetailsMembers
Displays the subscribers who clicked on specific links within a campaign.
Table Specific Information
SELECT is supported for ReportClickDetailsMembers.
Select
The connector 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 connector.
- 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. |