ReportEepUrls
Get EepURL activity reports.
Table Specific Information
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.
- CampaignId supports the '=' operator.
SELECT * FROM ReportEepUrls; SELECT * FROM ReportEepUrls where CampaignId='1121';
Columns
| Name | Type | Description |
| CampaignId | String | The unique id for the campaign. |
| Eepurl | String | The EepURL being tracked. |
| ClicksClicks | Integer | The number of clicks for this EepURL. |
| ClicksFirstClick | Datetime | The date and time of the first click. |
| ClicksLastClick | Datetime | The date and time of the last click. |
| ClicksLocations | String | The locations of the clicks (array). |
| Referrers | String | The referrers for this EepURL (array). |
| TwitterTweets | Integer | The number of tweets for this EepURL. |
| TwitterRetweets | Integer | The number of retweets for this EepURL. |
| TwitterStatuses | String | The statuses for this EepURL (array). |
| TwitterFirstTweet | String | The first tweet for this EepURL. |
| TwitterLastTweet | String | The last tweet for this EepURL. |