ReportEepUrls

Provides detailed activity reports for EepURLs (Mailchimp's link-tracking redirects).

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.

For example:

SELECT * FROM ReportEepUrls;
SELECT * FROM ReportEepUrls where CampaignId='1121';

Columns


Name	Type	Description
CampaignId	String	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.

Excel Add-In for Mailchimp

ReportEepUrls

Table Specific Information

Select

Columns