ReportEepUrls
Get EepURL activity reports.
Table Specific Information
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.
- 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. |