Conversions

The conversions file contains a row for each conversion event associated with a subscriber related to an email send job.

Output Types

Columns

Conversions
Name	Description	Possible Values	Data Type	Character Length
ClientID	The system account identifier associated with attribute set	-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)	Numeric	Maximum length - big integer
SendID or JobID	Identifier associated with an email send		Numeric	Maximum length - big integer
SubscriberKey	Customer-specified subscriber unique identifier associated with attribute set. By default, the value is the same as EmailAddress.		String	254
EmailAddress	Subscriber email address identifier associated with attribute set		String	254
SubscriberID	System-generated subscriber unique identifier associated with attribute set. SubscriberID relates to the Subscribers file SubscriberID column.		Number	Maximum length - big integer
ListID	Identifier of the list ID associated with the subscriber in the send		Number	Maximum length - big integer
EventDate	Date the bounce event occurred		Datetime
EventType	Identifies event type	Conversion	String	10
BatchID	Identifies batch associated with a triggered email sent event - defaults to 0 for a marketing list send	Sample values: SendID,EventDate,SubscriberKey,EmailAddress,TriggeredSendExternalKey,BatchId 1234,1/2/2009,"","","Coupon",1 1234,1/2/2009,"","","Coupon",2 1238,1/10/2009,"","","Coupon",1	String	100
TriggeredSendExternalKey	External key associated to a triggered send definition if the bounce resulted from a triggered send request		String	100
ReferringURL	Referring URL used in the Social Forward activity		varchar
LinkAlias	Value in the Alias attribute of the link		String	500
ConversionData			Text	none
URLID	Value used by the applicable database to identify the target URL of the link		Number	Maximum length - big integer