ReportClickDetails
A list of URLs and unique IDs included in HTML and plain-text versions of a campaign.
Table Specific Information
SELECT is supported for ReportClickDetails.
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.
- Id supports the '=' operator.
- CampaignId supports the '=' operator.
SELECT * FROM ReportClickDetails WHERE CampaignId = 'abc' and Id = '5659'
Columns
| Name | Type | Description |
| Id [KEY] | String | |
| Url | String | The URL for the link in the campaign. |
| TotalClicks | Integer | The number of total clicks for a given link. |
| ClickPercentage | Double | The percentage of total clicks a given link generated for a campaign. |
| UniqueClicks | Integer | Number of unique clicks for a given link. |
| UniqueClickPercentage | Double | The percentage of unique clicks a given link generated for a campaign. |
| LastClick | Datetime | The date and time for the last recorded click for a given link. |
| AbSplit_A | String | |
| AbSplit_B | String | |
| CampaignId [KEY] | String | The id for the campaign. |