ReportClickDetails
Returns a list of URLs and unique identifiers included in HTML and plain-text versions of a campaign.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
| CampaignId | = |
SELECT * FROM ReportClickDetails WHERE CampaignId = 'abc' AND Id = '5659'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the link. | |
| 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 | The 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 | The click details for the A variation of an A/B split campaign. | |
| AbSplit_B | String | The click details for the B variation of an A/B split campaign. | |
| CampaignId [KEY] | String |
Campaigns.Id | The Id of the campaign. |