SingleSendClickTrackingStats

Get Single Send Click Tracking Stats by ID

View-Specific Information

Get Single Send Click Tracking Stats. To access the view, you’ll need to provide the Single Send ID.

 
SELECT * FROM SingleSendClickTrackingStats where SingleSendId = '74550809-66a2-11ef-ad7f-460f539623db'


Name	Type	References	Description
SingleSendId	String	NMCSingleSends.Id	The ID of Single Send for which you want to retrieve Click Tracking stats.
Url	String		This is the URL of the link clicked. If {{custom_fields}} are part of the URL, they will be included.
UrlLocation	Integer		This is the location of the link clicked in each Single Send A/B variation, or in the Single Send itself if there are no variations. Links are numbered from the top down; the topmost link is index 0.
ABvariation	String		This is the A/B variation of the Single Send stat returned. It is set to 'all' if the ab_variation query parameter was not set in the request and group_by doesn't contain ab_variation.
ABphase	String		This is the A/B phase of the Single Send stat returned. If the ab_phase query parameter was not provided, it will return 'all'.
Clicks	Integer		The number of clicks on this particular link.