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 driver 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 driver.
- 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. |