ReportEepUrls
Provides detailed activity reports for EepURLs (Mailchimp's link-tracking redirects).
View-Specific Information
Select
The provider uses 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 provider.
| Column | Supported Operators |
| CampaignId | = |
SELECT * FROM ReportEepUrls
SELECT * FROM ReportEepUrls WHERE CampaignId = '1121'
Columns
| Name | Type | References | Description |
| CampaignId | String |
Campaigns.Id | The unique identifier of the campaign associated with this EepURL performance report. |
| Eepurl | String | The shortened Mailchimp tracking URL (EepURL) used to monitor engagement and sharing activity for the campaign. | |
| ClicksClicks | Integer | The total number of times recipients or visitors clicked on this tracked EepURL. | |
| ClicksFirstClick | Datetime | The date and time when the first recorded click on this EepURL occurred. | |
| ClicksLastClick | Datetime | The date and time when the most recent click on this EepURL occurred. | |
| ClicksLocations | String | An array of geographic locations representing where clicks on this EepURL originated. | |
| Referrers | String | An array of referrer sources, such as websites or social networks, that directed traffic to this EepURL. | |
| TwitterTweets | Integer | The total number of tweets that included this EepURL. | |
| TwitterRetweets | Integer | The total number of retweets involving this EepURL. | |
| TwitterStatuses | String | An array of tweet statuses that mention or include this EepURL. | |
| TwitterFirstTweet | String | The text or identifier of the first tweet that contained this EepURL. | |
| TwitterLastTweet | String | The text or identifier of the most recent tweet that contained this EepURL. |