Follow

Daily CSVs fields details

Here are the fields details of the daily CSVs files, but first a few remarks:

  • Fields with length = "max" have no size limit.
  • A field "char(x)" is always of its maximum length (x).  If the character string is shorter than maximum length, it will be completed with spaces.  Example : if you store "ABC" in a field with char(6), teh value of this field will be ABC followed by three spaces ("ABC   ").
  • A field varchar can contain strings of any length
  • A fiel nvarchar can contain UNICODE characters contrary to a varchar field
  • Tinyint contains values ranging from 0 to 255 (1 byte)
  • Smallint contains values from -215 to 215-1 (2 bytes)
  • Int contains values from -231 to 231-1 (4 bytes)
  • Bigint contains values from  -263 to 263 (8 bytes - is called int64 in sertain programming languages).
  • Datetime are YYYY.MM.DD HH:MM:SS

 

Contacts

 

 

 

clKey

char(6)

dtActivated

datetime

dtCreated

datetime

dtDeactivated

datetime

dtInvalidMailbox

datetime

dtInvalidMailboxReset

datetime

dtModified

datetime

idContact

int

idSource_Activation

int

idSource_Creation

int

idSource_Deactivation

int

idSource_Modification

int

ignoreInvalidMailbox

bit

isActive

bit

isInvalidMailbox

bit

prefersText

bit

SourceData_Activation

varchar(100)

SourceData_Creation

varchar(100)

SourceData_Deactivation

varchar(100)

SourceData_Modification

varchar(100)

SourceIndex_Activation

int

SourceIndex_Creation

int

SourceIndex_Deactivation

int

SourceIndex_Modification

int

 

 

SendLog

 

 

 

BounceCode

varchar(5)

BytesDelivered

int

ClickCount

tinyint

dsnDiag

varchar(max)

dsnMTA

varchar(100)

dtBounce

datetime

dtDelivered

datetime

dtFBL

datetime

dtFirstClick

datetime

dtFirstView

datetime

dtLastClick

datetime

dtLastView

datetime

dtOptout

datetime

dtProcessed

datetime

FBL_Report

nvarchar(max)

FBL_type

tinyint

gotBounce

bit

gotClick

bit

gotFBL

bit

gotOptout

bit

gotProcessingError

bit

gotView

bit

idBatch

int

idContact

int

idMessage

int

idSendLog

int

idVersion

bit

isDelivered

bit

isHardBounce

bit

isInvalid

bit

isInvalidMailbox

bit

isMultiPart

bit

isProcessed

bit

isRedirected

bit

isSoftBounce

bit

isTellAFriend

bit

isTest

bit

processingErrorCode

tinyint

slKey

char(8)

ViewCount

tinyint

 

 

Batches

 

 

 

BatchDevicesStats

nvarchar(max)

BatchStats

varbinary(max)

Bounces_Hard

int

Bounces_Invalid

int

Bounces_Soft

int

dtApproved

datetime

dtCancelled

datetime

dtCreated

datetime

dtDeliveryCancellationRequested

datetime

dtDeliveryCancelled

datetime

dtExpire

datetime

dtFirstDelivery

datetime

dtFirstMessage

datetime

dtLastDelivery

datetime

dtLastMessage

datetime

dtLaunch

datetime

dtPaused

datetime

dtRejected

datetime

dtResumed

datetime

dtTTL

datetime

DurationMinutes

int

ErrorCode

int

gotError

bit

hasTTL

bit

idABSplitCampaign

int

idABSplitCol

int

idABSplitRow

int

idBatch

int

idCompany

int

idMarketingAutoCampaign

int

idMessage

int

idProject

int

idSource_Cancellation

tinyint

idUser

int

idUser_ApprovedBy

int

idUser_CancelledBy

int

idUser_DeliveryCancelledBy

int

idUser_PausedBy

int

idUser_RejectedBy

int

idUser_ResumedBy

int

idVersion

int

isApproved

bit

isCancelled

bit

isCompleted

bit

isDelayed

bit

isDeliveryCancellationRequested

bit

isDeliveryCancelled

bit

isExpirable

bit

isPaused

bit

isRejected

bit

isTestBatch

bit

MaxPerHour

int

MustExcludeDuplicates

bit

SMTP_Originating_IP

varchar(15)

SMTP_Originating_Name

varchar(250)

SourceIndex_Cancellation

int

Stats_ClickCount_Total

int

Stats_ClickCount_Uniques

int

Stats_DeliveredBytes

bigint

Stats_DeliveredCount

int

Stats_DeliveryCancellationCount

int

Stats_FBLAbuseCount

int

Stats_MessageCount

int

Stats_OptoutCount

int

Stats_ProcessedCount

int

Stats_SentCount

int

Stats_TellAFriend_ClickCount_Total

int

Stats_TellAFriend_ClickCount_Uniques

int

Stats_TellAFriend_ConvertedCount

int

Stats_TellAFriend_Sent

int

Stats_TellAFriend_ViewCount_Total

int

Stats_TellAFriend_ViewCount_Uniques

int

Stats_UndeliveredCount

int

Stats_ViewCount_Total

int

Stats_ViewCount_Uniques

int

SubjectPrefix

nvarchar(25)

UserNotes

nvarchar(max)

UserNotes_DeliveryCancellation

nvarchar(max)

 

 

ClickLog

 

 

 

dtClick

datetime

idBatch

int

idClickLog

int

idContact

int

idLink_Generic

int

idLink_Operational

int

idMessage

int

idSendLog

int

idVersion

int

Source

char(1)

 

 

Messages

 

 

 

dtCreated

datetime

dtModified

datetime

dtPublished

datetime

dtWebArchived

datetime

ExternalKey

nvarchar(50)

idActivity

int

idApplication

int

idCompany

int

idMessage

int

idMessageCategory

int

idMessageStatus

int

idMessageType

int

idProject

int

idTemplate

int

idUser_CreatedBy

int

idUser_ModifiedBy

int

idUser_PublishedBy

int

idUser_WebArchivedBy

int

idWorkflow

int

isArchived

bit

isDeleted

bit

isHostingImages

bit

isMessage2

bit

isPublished

bit

isTemplate

bit

isTrackingLinks

bit

isWebArchived

bit

MessageName

nvarchar(125)

mKey

char(6)

 

 

Statistical Links

 

 

 

dtCreated

datetime

idLink

int

idMessage

int

idProject

int

LinkCategory

nvarchar(125)

LinkName

nvarchar(125)

LinkSubCategory

nvarchar(125)

LinkURL

varchar(2000)

lKey

char(6)

TargetEncoding

varchar(10)

XML_LinkClassificationValues

nvarchar(max)

 

 

Operational Links

 

 

 

Admin_EMail_x

varchar(125)

Admin_idMessage

int

Contact_idMessage

int

dtCreated

datetime

hasOverrides

bit

idLink

int

idProject

int

LinkCategory

nvarchar(125)

LinkName

nvarchar(125)

LinkSubCategory

nvarchar(125)

LinkURL

varchar(max)

lKey

char(6)

TargetEncoding

varchar(10)

Update_x_DatePart

varchar(5)

Update_x_doUpdate

bit

Update_x_Field

varchar(27)

Update_x_Field2

varchar(27)

Update_x_Operation

char(3)

Update_x_Value

nvarchar(max)

0 Comments

Please sign in to leave a comment.