SingleSendClickTrackingStats

Retrieves Single Send click tracking statistics by Id.

View-Specific Information

Get Single Send Click Tracking statistics. To access the view, you 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 statistics.
Url	String		The URL of the link clicked. If {{custom_fields}} are part of the URL, they are included.
UrlLocation	Integer		The location of the link clicked in each Single Send A/B variation, or if there are no variations, the Single Send itself. Links are numbered from the top down; the topmost link is index 0.
ABvariation	String		The A/B variation of the Single Send statistic returned. It is set to 'all' if the ab_variation query parameter was not set in the request and group_by does not contain ab_variation.
ABphase	String		The A/B phase of the Single Send statistic returned. If the ab_phase query parameter was not provided, it returns 'all'.
Clicks	Integer		The number of clicks on this particular link.