ReportClickDetailsMembers
A collection of members who clicked on a specific link 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 ID for the given email address. |
| EmailAddress | String | Email address for a subscriber |
| Clicks | Integer | The total number of times the subscriber clicked on the link. |
| CampaignId [KEY] | String | The id for the campaign. |
| UrlId [KEY] | String | The id for the tracked URL in the campaign. |
| ListId [KEY] | String | The id for the list. |
| ListIsActive | Boolean | The status of the list used, namely if it's deleted or disabled. |
| ContactStatus | String | The status of the member, namely if they are subscribed, unsubscribed, deleted, non-subscribed, transactional, pending, or need reconfirmation. |
| MergeFields | String | A dictionary of merge fields where the keys are the merge tags. See the Merge Fields documentation for more about the structure. |
| VIP | Boolean | VIP status for subscriber. |