ReportEepUrls

Get EepURL activity reports.

Table Specific Information

Select

The driver 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 driver.

CampaignId supports the '=' operator.

For example:

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.

ODBC Driver for Mailchimp

ReportEepUrls

Table Specific Information

Select

Columns