Contacts
| idContact Integer | Contact ID. |
| clKey Text | Contact's identification key. |
| Domain Text | Domain name for the email address of the contact (e.g., Gmail, Outlook). |
| SMSNumber Text | Contact's phone number that is used to receive SMS. |
| SMSCountryCode Text | Country code associated with the SMS configuration. |
| idTimeZone Integer | ID of the contact's timezone. |
| Personas Text | ID of the personas associated with the contact, separated with a comma. |
| OpenfieldScore Integer | Scoring associated with the contact. |
| Platform_Mobile Integer | Platform used for the last view of an email on a mobile phone. 0 =Unknown 1 = PC 2 = Apple 3 = SunOS 4 = Linux 6 = Android 7 = MTKNucleus 8 = WindowsMobile 9 = webOS 10 = PalmOS 12 = Symbian 13 = MeeGo 14 = Hiptop 15 = iOS 16 = Brew 17 = RIMOS 19 = Bada 20 = QCOML4BREW 21 = Synergy 22 = PPSM 23 = WindowsPhone 24 = Java 25 = MacOS 101 = Windows 201 = Blackberry 208 = MotorolaOS 209 = HTC |
| dtModified_Platform_Mobile Date (AAAA.MM.DD HH:MM:SS) | Date of the last view of an email on a mobile phone. |
| Platform_Tablet Integer | Type of the device used for the last view of an email. 0 = Unknown 1 = Mobile 2 = Console 3 = Desktop 4 = Tablet |
| dtModified_Platform_Tablet Date (AAAA.MM.DD HH:MM:SS) | Date of the last email view on a tablet. |
| isActive 1 = true / 0 = false | Boolean indicating if the contact has an Active status in the project. |
| isInvalidMailbox 1 = true / 0 = false | Boolean indicating if the contact is in email quarantine. This field takes quarantined email addresses and invalid email syntax into account. |
| dtInvalidMailbox Date (AAAA.MM.DD HH:MM:SS) | Date the contact's email was placed in quarantine. |
| dtInvalidMailboxReset Date (AAAA.MM.DD HH:MM:SS) | Date the quarantine was lifted for that contact. |
| isInvalidMailboxByCleanup 1 = true / 0 = false | Boolean indicating if the contact was in email quarantine because of repeated errors. |
| isSeedList 1 = true / 0 = false | Boolean indicating if the contact is identified as a seed list contact. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date of the contact creation. |
| idSource_Creation | See the ContactsSources table below. |
| SourceIndex_Creation | See the ContactsSources table below. |
| SourceData_Creation | See the ContactsSources table below. |
| dtModified Date (AAAA.MM.DD HH:MM:SS) | Date of the last modification for that contact (for any field, including system fields). |
| dtProfileUpdate Date (AAAA.MM.DD HH:MM:SS) | Date of the last modification for that contact (for any field, except system fields). |
| idSource_Modification Integer | See the ContactsSources table below. |
| SourceIndex_Modification Integer | See the ContactsSources table below. |
| SourceData_Modification | See the ContactsSources table below. |
| dtActivated Date (AAAA.MM.DD HH:MM:SS) | Date of the contact activation. |
| idSource_Activation Integer | See the ContactsSources table below. |
| SourceIndex_Activation Integer | See the ContactsSources table below. |
| SourceData_Activation | See the ContactsSources table below. |
| dtDeactivated Date (AAAA.MM.DD HH:MM:SS) | Date of the contact deactivation. |
| idSource_Deactivation Integer | See the ContactsSources table below. |
| SourceIndex_Deactivation Integer | See the ContactsSources table below. |
| SourceData_Deactivation | See the ContactsSources table below. |
| hasTrackingConsent 1 = true / 0 = false | Boolean indicating if the behavioral tracking in the communications is active for that contact. |
| dtTrackingConsent Date (AAAA.MM.DD HH:MM:SS) | Date the behavioral tracking consent was obtained or last updated. |
| isInvalidMailbox_SMS 1 = true / 0 = false | Boolean indicating if the contact is in SMS quarantine. |
| dtInvalidMailbox_SMS Date (AAAA.MM.DD HH:MM:SS) | Date the contact was placed in quarantine for SMS. |
| dtInvalidMailboxReset_SMS Date (AAAA.MM.DD HH:MM:SS) | Date the SMS quarantine was lifted for that contact. |
| isInvalidMailboxByCleanup_SMS 1 = true / 0 = false | Boolean indicating if the contact is in SMS quarantine because of repeated errors. |
| IP Text | IP address collected using the Geolocation by IP address when it is activated in the project. |
| CustomerLifeCycles Text | Code of the lifecycle associated in the lifecycle table (this table is not exported). |
| RCU_idContact_Parent Integer (can be NULL if the contact is not connected to a parent contact) | In a CDP structure context, this field indicates the idContact of the associated contact in the parent project. Note that parent/unified projects will not have any information regarding the contacts that are connected to it in child projects. |
| RCU_isMergedWithParent 1 = true / 0 = false | In a CDP structure context, this field indicates if this contact is the source contact connected to the parent/unified contact in the case that multiple contacts have the same parent. |
| f_ (All fields starting with) | Fields that start with f_ are contact fields (Last Name, First Name, City, etc.). |
| optin_ (All fields starting with) | Fields for the status of an opt-in. These fields either have a value of 1 (subscribed) or 0 (unsubscribed). If the field value is empty, it means the contact has never subscribed, nor unsubscribed to the communications linked to this field. |
| dtOptin_ (All fields starting with) | Date of the last opt-in update (with a value change or not). |
| dtOptinValueChange_ (All fields starting with) | Date of the last opt-in update that implies a value change (e.g., from 1 to 0 or from 0 to 1). |
| RightActive_ (All fields starting with) | Fields for the status of an implicit consent. These fields either have a value of 1 (subscribed) or 0 (unsubscribed). If the field value is empty, it means the contact has never subscribed, nor unsubscribed to the communications linked to this field. |
| RightExpiration_ (All fields starting with) | Expiration date of an implicit consent. |
| RightRevoked 1 = true / 0 = false | Boolean indicating if the contact has unsubscribed from all implicit consents of the project. |
Reference for ContactSources | ||
idSource_* | SourceIndex_* | SourceData_* |
| 1 (Import) Contact added or modified using an import file. | idImport | |
| 2 (Manual) Contact added or modified manually in Dialog Insight. | idUser | URL of the page responsible for the modification (optional). |
| 3 (WebService) Contact added with a call to web services. | idUser | |
| 4 (Profile) Contact added using a profile update form. | idcontactEditForm | IP address |
| 5 (Optin) Contact added or modified using an opt-in form (obsolete forms). | IP address | |
| 6 (Optout) Contact added or modified using an opt-out form. | idSendLog | |
| 7 (Oplink) Contact added or modified using an operational link in a message. | idLink | IP address |
| 8 (FeedbackLoop) Contact modified by Feedback Loop (e.g., spam). | idSendlog | isAbuse ? 1 : 2 |
| 9 (ListUnsubscribe) Contact modified after being added to an unsubscribing list. | idSendLog | |
| 10 (Scheduler) Contact added or modified using an automated task. | idTask | |
| 11 (Workflow) Contact added or modified with a workflow. | idWorkFlow | Primary key of the node. |
| 12 (Microsite) | idMicrosite | URL of the page responsible for the modification. |
| 13 (SQLInserter) | idWorkFlow | Primary key of the node. |
| 14 (SQLUpdater) | ||
| 15 (Router) Contact modified with a click on a link in a message. | idLink | IP address |
| 16 (CustomTableImport) | N/A | |
| 17 (SMSInbound) Contact added or modified following an inbound SMS. | idSMSInboundLog | First 140 characters of the message. |
| 18 (Survey) Contact added or modified after participating to a survey. | idSurvey | |
| 19 (MktgAuto) Contact added or modified by an automated campaign. | idScenario | idRun|nodeKey (exemple : « 1234|5 »). In the case of unitary launches (no run), it could be something like "RealTime|5". |
| 21 (SMTPRelay) Contact added or modified by a message sent using an SMTP relay. | idAuth (voir SMTP.Auth) | IP address |
| 22 (TrackingConsentOptout) | ||
| 23 (AzureBus) | ||
| 24 (Integration) Contact added or modified with a call to a Dialog Insight handler that participates in integrations, such as the Connector web service. | idIntegration | |
| 25 (Webhook) Contact added or modified by a call to a Dialog Insight WebhookInsight. | idWebhook | |
| 26 (SmtpAccountingReader) Procedure for SMTP calculation. | ||
| 27 (BaseScoring) Procedure for Scoring calculation. | idOpenfieldScore | |
| 28 (ScheduledTasks) Automated task. | idTask | |
| 29 (SmsAccountingReader) Procedure for SMS statistics calculation. | ||
| 30 (BounceAnalyzer) Procedure for bounce analysis. | idSendLog | |
Email campaigns
| idBatch Integer | ID of the campaign. If the data is empty, it is a unitary sending. |
| idUser Integer | ID of the Dialog Insight user who created the campaign. |
| idMessage Integer | ID of the message sent in the campaign. |
| idVersion Integer | ID of the version of the message sent. |
| isTestBatch 1 = true / 0 = false | Boolean indicating if the campaign targets a test group. |
| isDelayed 1 = true / 0 = false | Boolean indicating if the campaign is delayed. |
| isPaused 1 = true / 0 = false | Boolean indicating if the campaign is paused. |
| isCancelled 1 = true / 0 = false | Boolean indicating if the campaign has been cancelled. |
| isCompleted 1 = true / 0 = false | Boolean indicating if the campaign is completed. |
| isInitialized 1 = true / 0 = false | Boolean indicating if the campaign has been initialized. This is the first step of the sending process. |
| isLaunched 1 = true / 0 = false | Obsolete field. |
| isPrepared 1 = true / 0 = false | The list of targeted contacts is finalized. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date of the campaign creation. |
| dtInitialized Date (AAAA.MM.DD HH:MM:SS) | Date of the initialization. |
| dtInitializing Date (AAAA.MM.DD HH:MM:SS) | Date of the beginning of the initialization. |
| dtLaunch Date (AAAA.MM.DD HH:MM:SS) | Scheduled date of the campaign launch. |
| dtLaunchComputed Date (AAAA.MM.DD HH:MM:SS) | Effective date of the campaign launch. |
| dtFirstMessage Date (AAAA.MM.DD HH:MM:SS) | Date of the first message preparation. |
| dtLastMessage Date (AAAA.MM.DD HH:MM:SS) | Date of the last message preparation. |
| Stats_MessageCount Integer | Number of messages sent within the campaign. |
| Stats_DeliveredCount Integer | Number of message deliveries within the campaign. |
| Stats_ViewCount_Uniques Integer | Number of unique views of the message. |
| Stats_ViewCount_Total Integer | Number of total views of the message. |
| Stats_ClickCount_Uniques Integer | Number of unique clicks in the message. |
| Stats_ClickCount_Total Integer | Number of total clicks in the message. |
| Stats_OptoutCount Integer | Number of unsubscribes. |
| Bounces_Invalid Integer | Number of delivery errors caused by an invalid recipient email. |
| Stats_DeliveredBytes Integer | Number of bytes for all messages within the campaign. |
| dtFirstDelivery Date (AAAA.MM.DD HH:MM:SS) | Date of delivery of the first message. |
| dtLastDelivery Date (AAAA.MM.DD HH:MM:SS) | Date of delivery of the last message. |
| Bounces_Hard Integer | Obsolete field. |
| Bounces_Soft Integer | Obsolete field. |
| Bounces Integer | Number of contacts who have a delivery error for that campaign. |
| Bounces_Quarantines Integer | Number of contacts who have been placed in quarantine after a delivery error for that campaign. |
| Bounces_SmtpReply Integer | Number of contacts who have a delivery error in SMTP response for that campaign. |
| Bounces_SmtpReply_Quarantines Integer | Number of contacts who have been placed in quarantine after a delivery error in SMTP response for that campaign. |
| Bounces_Quarantines_Cleanup Integer | Number of contacts who have been placed in quarantine by this campaign after the delivery errors limit was reached over a certain period. |
| MaxPerHour Integer | Maximum number of messages sent per hour. |
| gotError 1 = true / 0 = false | Boolean indicating if the campaign received a delivery error. |
| Stats_ProcessedCount Integer | Number of processed messages. |
| ErrorCode Text | Error code. |
| isApproved 1 = true / 0 = false | Boolean indicating if the campaign has been approved for sending. |
| isRejected 1 = true / 0 = false | Boolean indicating if the campaign received a reject request. |
| idUser_ApprovedBy Integer | ID of the Dialog Insight user who approved the campaign. |
| idUser_RejectedBy Integer | ID of the Dialog Insight user who rejected the campaign. |
| idUser_CancelledBy Integer | ID of the Dialog Insight user who cancelled the campaign. |
| idUser_PausedBy Integer | ID of the Dialog Insight user who paused the campaign. |
| idUser_ResumedBy Integer | ID of the user in Dialog Insight who resumed the campaign. |
| dtApproved Date (AAAA.MM.DD HH:MM:SS) | Date of the campaign approbation. |
| dtRejected Date (AAAA.MM.DD HH:MM:SS) | Date the campaign has been rejected. |
| dtCancelled Date (AAAA.MM.DD HH:MM:SS) | Date the campaign has been cancelled. |
| dtPaused Date (AAAA.MM.DD HH:MM:SS) | Date the campaign has been paused. |
| dtResumed Date (AAAA.MM.DD HH:MM:SS) | Date the campaign has been resumed. |
| UserNotes Text | Notes for the users. |
| Stats_TellAFriend_Sent Integer | Statistics Tell A Friend: Number of messages sent. |
| Bounces_Invalid_Decreased | Obsolete field. |
| Bounces_Hard_Decreased | Obsolete field. |
| Bounces_Soft_Decreased | Obsolete field. |
| Stats_TellAFriend_ViewCount_Uniques Integer | Statistics Tell A Friend: Number of unique views for the message. |
| Stats_TellAFriend_ViewCount_Total Integer | Statistics Tell A Friend: Number of total views for the message. |
| Stats_TellAFriend_ClickCount_Uniques Integer | Statistics Tell A Friend: Number of unique clicks in the message. |
| Stats_TellAFriend_ClickCount_Total Integer | Statistics Tell A Friend: Number of total clicks in the message. |
| SubjectPrefix Text | Prefix added to the message subject when it was sent. |
| isFinalized 1 = true / 0 = false | Boolean indicating if the campaign has been finalized. |
| idABSplitCampaign Integer | ID of the campaign (A/B Split or Multi-segments). |
| idABSplitRow Integer | ID of the campaign's row (A/B Splits or Multi-segments). |
| idABSplitCol Integer | ID of the campaign's column (A/B Splits or Multi-segments). |
| DurationMinutes Integer | If the value is not NULL, the value will be the number indicating the total duration over which the message production is to be spread. |
| idMarketingAutoCampaign Integer | ID of the automated campaign. |
| idSource_Cancellation Integer | See the ContactsSources table below. |
| SourceIndex_Cancellation Integer | See the ContactsSources table below. |
| dtExpire Date (AAAA.MM.DD HH:MM:SS) | Expiration date (internal field). |
| isDeliveryCancelled 1 = true / 0 = false | Boolean indicating if the delivery has been cancelled. |
| dtDeliveryCancelled Date (AAAA.MM.DD HH:MM:SS) | Date the campaign delivery was cancelled. |
| idUser_DeliveryCancelledBy Integer | ID of the user in Dialog Insight who cancelled the campaign. |
| UserNotes_DeliveryCancellation Text | User notes for cancelling the campaign delivery. |
| Stats_UndeliveredCount Integer | Number of messages not delivered. |
| isDeliveryCancellationRequested 1 = true / 0 = false | Boolean indicating if there is a cancellation request for the campaign delivery. |
| Stats_DeliveryCancellationCount Integer | Number of cancelled messages. |
| dtDeliveryCancellationRequested Date (AAAA.MM.DD HH:MM:SS) | Date of the delivery cancellation. |
| hasTTL | Obsolete field. |
| dtTTL | Obsolete field. |
| Stats_FBLAbuseCount Integer | Number of contacts who used the Feedback Loop mechanism. |
| MustExcludeDuplicates 1 = true / 0 = false | Boolean indicating if the contact list excludes duplicate email addresses. |
| preparationDuration Integer | Duration for the production of messages. |
| ProcessingErrors Integer | Number of contacts in production error for the campaign. |
| Stats_Initialized Integer | Number of prepared contacts. |
| InvalidEMailSyntaxes Integer | Number of invalid email addresses. |
| idMAScenario Integer | ID of the automated campaign. |
| idMARevision Integer | ID of the automated campaign revision. |
| idMARun Integer | ID of the automated campaign execution. |
| MANodeKey Integer | Code of automated campaign node that generated the sending. |
| Data_MessageParameters Text | Values that can be used to target recipients or personalize the message. |
| Stats_ViewCount_Uniques_Real Integer | Number of unique views, excluding views from robots. |
| Stats_ViewCount_Total_Real Integer | Number of total views, excluding views from robots. |
| SecAttr_ (All fields starting with) | Value of the security attribute for the corresponding field. |
Reference for ContactSources | ||
idSource_* | SourceIndex_* | SourceData_* |
| 1 (Import) Contact added or modified using an import file. | idImport | |
| 2 (Manual) Contact added or modified manually in Dialog Insight. | idUser | URL of the page responsible for the modification (optional). |
| 3 (WebService) Contact added with a call to web services. | idUser | |
| 4 (Profile) Contact added using a profile update form. | idcontactEditForm | IP address |
| 5 (Optin) Contact added or modified using an opt-in form (obsolete forms). | IP address | |
| 6 (Optout) Contact added or modified using an opt-out form. | idSendLog | |
| 7 (Oplink) Contact added or modified using an operational link in a message. | idLink | IP address |
| 8 (FeedbackLoop) Contact modified by Feedback Loop (e.g., spam). | idSendlog | isAbuse ? 1 : 2 |
| 9 (ListUnsubscribe) Contact modified after being added to an unsubscribing list. | idSendLog | |
| 10 (Scheduler) Contact added or modified using an automated task. | idTask | |
| 11 (Workflow) Contact added or modified with a workflow. | idWorkFlow | Primary key of the node. |
| 12 (Microsite) | idMicrosite | URL of the page responsible for the modification. |
| 13 (SQLInserter) | idWorkFlow | Primary key of the node. |
| 14 (SQLUpdater) | ||
| 15 (Router) Contact modified with a click on a link in a message. | idLink | IP address |
| 16 (CustomTableImport) | N/A | |
| 17 (SMSInbound) Contact added or modified following an inbound SMS. | idSMSInboundLog | First 140 characters of the message. |
| 18 (Survey) Contact added or modified after participating to a survey. | idSurvey | |
| 19 (MktgAuto) Contact added or modified by an automated campaign. | idScenario | idRun|nodeKey (exemple : « 1234|5 »). In the case of unitary launches (no run), it could be something like "RealTime|5". |
| 21 (SMTPRelay) Contact added or modified by a message sent using an SMTP relay. | idAuth (voir SMTP.Auth) | IP address |
| 22 (TrackingConsentOptout) | ||
| 23 (AzureBus) | ||
| 24 (Integration) Contact added or modified with a call to a Dialog Insight handler that participates in integrations, such as the Connector web service. | idIntegration | |
| 25 (Webhook) Contact added or modified by a call to a Dialog Insight WebhookInsight. | idWebhook | |
| 25 (Webhook) Contact added or modified by a call to a Dialog Insight WebhookInsight. | idWebhook | |
| 26 (SmtpAccountingReader) Procedure for SMTP calculation. | ||
| 27 (BaseScoring) Procedure for Scoring calculation. | idOpenfieldScore | |
| 28 (ScheduledTasks) Automated task. | idTask | |
| 29 (SmsAccountingReader) Procedure for SMS statistics calculation. | ||
| 30 (BounceAnalyzer) Procedure for bounce analysis. | idSendLog | |
Mailings
| idSendLog Integer | ID of the send log entry. |
| idBatch Integer | ID of the mailing. If the data is empty, this is a unitary sending. |
| idContact Integer | ID of the contact to which the message was sent. |
| idMessage Integer | ID of the message sent. |
| idVersion Integer | ID of the version of the message sent. |
| isTest 1 = true / 0 = false | Boolean indicating if the sending is a test. |
| isRedirected 1 = true / 0 = false | Boolean indicating if the sending was done using SMTP to a redirection email address (not the contact's email). |
| slKey Text | Key used to validate the record in the handlers for click and view management. |
| gotView 1 = true / 0 = false | Boolean indicating if the message has views. |
| ViewCount Integer | Number of views for the message. |
| dtFirstView Date (AAAA.MM.DD HH:MM:SS) | Date of the first view for the message. |
| dtLastView Date (AAAA.MM.DD HH:MM:SS) | Date of the last view for the message. |
| gotClick 1 = true / 0 = false | Boolean indicating if at least one tracking link has been clicked in the mailing. |
| ClickCount Integer | Number of tracking links that have been clicked in the mailing. |
| dtFirstClick Date (AAAA.MM.DD HH:MM:SS) | Date of the first click in the message. |
| dtLastClick Date (AAAA.MM.DD HH:MM:SS) | Date of the last click of the message. |
| gotOptout 1 = true / 0 = false | Boolean indicating if a contact has unsubscribed following this mailing by using the opt-out form. |
| dtOptout Date (AAAA.MM.DD HH:MM:SS) | Date the contact has unsubscribed. |
| gotBounce 1 = true / 0 = false | Boolean indicating if a delivery error was detected in the mailing. If the "isDelivered" column contains the value "1", it is an error after delivery ("bounceback"). |
| isInvalid 1 = true / 0 = false | Boolean indicating if the email address syntax of the recipient is invalid. |
| isSoftBounce 1 = true / 0 = false | Obsolete field. |
| isHardBounce 1 = true / 0 = false | Obsolete field. |
| dtBounce Date (AAAA.MM.DD HH:MM:SS) | Date of the delivery error. |
| BounceCode Text | Contains a "dsn Status" code if possible. If not, the response is SMTP or a generic indicator, such as "HARD/SOFT" for bouncebacks. |
| dtDelivered Date (AAAA.MM.DD HH:MM:SS) | Delivery date of the message. There will be a value only if the "isDelivered" column contains the value "1". |
| isDelivered 1 = true / 0 = false | Boolean indicating if the SMTP servor accepted the message. |
| isInvalidMailbox 1 = true / 0 = false | Boolean indicating if the delivery error is recognized as a case of invalid email inbox. |
| BytesDelivered Integer | Size of the message in bytes. |
| isProcessed 1 = true / 0 = false | Boolean indicating if the message was processed by the message production services of Dialog Insight. |
| dtProcessed Date (AAAA.MM.DD HH:MM:SS) | Date of the message production. There will be a value only if the "isProcessed" column contains the value "1". |
| gotProcessingError 1 = true / 0 = false | Boolean indicating if there was an error during the message production. |
| processingErrorCode Integer | Error code received in production. There will be a value only if the "gotProcessingError" column contains the value "1". 0 = No error 1 = Incorrect syntax for the contact's email address 2 = Message compiling error 3 = Message executing error 4 = Incorrect syntax for the sender's email address 5 = Message rejected by the SMTP agent. 6 = Missing data (e.g., deleted records during processing) 99 = Other / Undocumented error |
| isTellAFriend 1 = true / 0 = false | Boolean indicating if the "Tell a friend" was triggered by the original recipient of the message. |
| dsnMTA Text | The Virtual MTA with whom the SMTP servor had an SMTP conversation. This is the server that provided the bounce error code. |
| dsnDiag Text | Bounce description. e.g, "5.1.1 invalid email address" |
| gotFBL 1 = true / 0 = false | Boolean indicating if the recipient used a "Feedback Loop" to fill a spam complaint or an unsubscribe request. |
| dtFBL Date (AAAA.MM.DD HH:MM:SS) | Date of the "Feedback Loop" report processing. |
| FBL_type Integer | "Feedback Loop" report type. 1 = ABUSE (e.g., spam complaint) 2 = UNSUBSCRIBE |
| FBL_Report Text | Description of the problem or the spam complaint that initiated the FBL. |
| isMultiPart 1 = true / 0 = false | Boolean indicating if the SMTP message has a text and an HTML version. |
| idMessageCategory Integer | ID of the communication type of the message sent. |
| dtReleasedForDelivery Date (AAAA.MM.DD HH:MM:SS) | Date the email was transmitted to the delivery system. |
| isReleasedForDelivery 1 = true / 0 = false | Boolean indicating if the email was transmitted to the delivery system. |
| gotView_Real 1 = true / 0 = false | Boolean indicating if the message has views (excludes views from robots). |
| Data_MessageParameters JSON | Values provided to the mailing that can be used to target contacts or personalize the message content. |
| Tag Text | Personalized ID for the send log entry. |
Messages
| idMessage Integer | ID of the email. |
| idApplication Integer | ID of the application. 1: OFSYS 2: OFC4 3: OFS3 4: OFA2 5: OFP1 |
| idMessageCategory Integer | ID of the communication type used for that email. |
| idMessageStatus Integer | ID of the message status. 1 - New: The message was recently created and has not been edited yet. 2 - Modified: The message has been modified in the editor since the last test or the last sending. 3 - Tested: The message was sent in test mode in the Test tab of the editor. 5 - Sent: The message was transmitted to a group. The status has no functional impact. It is only used to sort messages in the appropriate lists. |
| isArchived 1 = true / 0 = false | Boolean indicating if the message is archived. |
| isTemplate 1 = true / 0 = false | Boolean indicating if the message is a template. |
| mKey Text | Identification key of the message. |
| MessageName Text | Name of the message. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date the message was created. |
| dtModified Date (AAAA.MM.DD HH:MM:SS) | Date the message was modified. |
| idUser_CreatedBy Integer | ID of the user in Dialog Insight who created the sending. |
| idUser_ModifiedBy Integer | ID of the user in Dialog Insight who modified the sending. |
| isPublished 1 = true / 0 = false | Boolean indicating if the message is published. |
| dtPublished Date (AAAA.MM.DD HH:MM:SS) | Date of the message publication. |
| idUser_PublishedBy Integer | ID of the user in Dialog Insight who published the sending. |
| ExternalKey Text | External key of the message. |
| isMessage2 1 = true / 0 = false | Boolean indicating if the message is in version 2. |
| isWebArchived 1 = true / 0 = false | Boolean indicating if the message is a web archive. |
| dtWebArchived Date (AAAA.MM.DD HH:MM:SS) | Date a web archive was created for that message. |
| idUser_WebArchivedBy Integer | ID of the user in Dialog Insight who created a web archive. |
| isTrackingLinks 1 = true / 0 = false | Boolean indicating if the links are tracked in the message. |
| isHostingImages 1 = true / 0 = false | Boolean indicating if the images of the message are hosted in Dialog Insight. |
| idWorkflow Integer | ID of the workflow. |
| Subject Text | Subject line of the message. |
| SecAttr_ (All fields starting with) | Value of the security attribute for the corresponding field. |
Clicks
| idClickLog Integer | ID of the click log entry. |
| idLink_Generic Integer | ID of the standard link which was clicked. |
| idLink_Operational Integer | ID of the operational link which was clicked. |
| idContact Integer | ID of the contact who clicked the link. Duplication of the value of the same field from the Mailings table. |
| idSendLog Integer | ID of the Mailings table from which the link was clicked. |
| idBatch Integer | ID of the campaign from which the link was clicked. Duplication of the value of the same field from the Mailings table. If the data is empty, this record represents a unitary sending. |
| idMessage Integer | ID of the message in which the link was clicked. Duplication of the value of the same field from the Mailings table. |
| idVersion Integer | ID of the message version in which the link has been clicked. Duplication of the value of the same field in the Mailings table. |
| LinkOrder Integer | Display Index (rank) of the link in the body of the message. |
| Source Text | Source of the click. |
| DeviceType Integer | Device used to click in the email. 0 = Unknown 1 = Mobile 2 = Console 3 = Desktop 4 = Tablet |
| Platform Integer | Platform used to click in the email. 0 = Unnown 1 = PC 2 = Apple 3 = SunOS 4 = Linux 6 = Android 7 = MTKNucleus 8 = WindowsMobile 9 = webOS 10 = PalmOS 12 = Symbian 13 = MeeGo 14 = Hiptop 15 = iOS 16 = Brew 17 = RIMOS 19 = Bada 20 = QCOML4BREW 21 = Synergy 22 = PPSM 23 = WindowsPhone 24 = Java 25 = MacOS 101 = Windows 201 = Blackberry 208 = MotorolaOS 209 = HTC |
| dtClick Date (AAAA.MM.DD HH:MM:SS) | Date of the click. |
| idAction Integer | ID of the link processing managed by an authorized application. 0 = RedirectedToWeb 1 = HandleByApp 2 = Intercepted 6 = Declined 10 = Accepted 26 = InstallationConfirmation |
Communication types
| idMessageCategory Integer | ID of the communication type. |
| CategoryName Text | Name of the communication type. |
| HasReviewOptions 1 = true / 0 = false | Boolean indicating if the communication type has a list of additional verifications to do before sending the message. |
| HasEventManagementOptions 1 = true / 0 = false | Boolean indicating if the communication type has event options. |
| dtModified Date (AAAA.MM.DD HH:MM:SS) | Date of the communication type modification. |
| idUser_ModifiedBy Integer | ID of the user in Dialog Insight who modified the communication type. |
| AllowUnitSending 1 = true / 0 = false | Boolean indicating if unitary sendings can be done with messages using this communication type. |
| NoOptoutAllowed 1 = true / 0 = false | Boolean indicating if the communication type allows unsubscribing. |
| OptoutFallbackMode Integer | Default mode for unsubscribing in a message that uses this communication type. 0 = Default action (if NULL) 1 = Does not allow unsubscribing 2 = No default action |
| TargetRatioView Integer | View rate for messages using this communication type. |
| TargetRatioClick Integer | Click rate for messages using this communication type. |
| EligibilityRule_isActive 1 = true / 0 = false | Boolean indicating if an eligibility rule is active for this communication type. |
| EligibilityRule_TableType Integer | Type of table used for the eligibility rule. 2 = Contact table 3 = Relational table |
| EligibilityRule_idTable Integer | ID of the table used for the eligibility rule. |
| EligibilityRule_Filter Text | Filter of the eligibility rule for the communication type. |
| EligibilityRule_UseQuery 1 = true / 0 = false | Boolean indicating if the eligibility rule uses a query. |
| EligibilityRule_idQuery Integer | ID of the query used for the eligibility rule. |
| CanSendSMS 1 = true / 0 = false | Boolean indicating if the communication type allows using the SMS channel. |
| SMSLongCodeMode Integer | Type of sender number used with this communication type. 0 =All numbers 1 = defined list 2 = Selection rules 3 = Communication type |
| ProtectImplicitConsent 1 = true / 0 = false | Boolean indicating if the implicit consent remains active after an opt-out in a message using this communication type. |
| isAdministrative 1 = true / 0 = false | Boolean indicating if the communication type is administrative. |
| idType Integer | ID of the communication type category. 0 = Event 1 = Contest 2 = Lead generation form 3 = Subscription 4 = RSVP |
| idUser_CreatedBy Integer | ID of the user in Dialog Insight who created the communication type. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date of the communication type creation. |
| emailAlertsMinContacts Integer | Minimum of contacts targeted that a sending must reach to send an alert email. |
| emailAlertsMinPct Integer | Minimum of errors that a sending using this communication type must reach to send an alert email. |
| CanSendEmail 1 = true / 0 = false | Boolean indicating if the communication type allows sending communications with the email channel. |
| CanSendMobilePush 1 = true / 0 = false | Boolean indicating if the communication type allows sending communications with the Mobile Push channel. |
| CanSendWebPush 1 = true / 0 = false | Boolean indicating if the communication type allows sending communications with the Web Push channel. |
| IsSmtpKillFileExempted 1 = true / 0 = false | Boolean indicating if the communication type allows sending messages to contacts on the kill file. |
| IsSmsKillFileExempted 1 = true / 0 = false | Boolean indicating if the communication type allows sending SMS to contacts on the kill file. |
| CanSendPostal 1 = true / 0 = false | Boolean indicating if the communication type allows sending communication with the postal channel. |
| idStatSegmentorConfigDefault Integer | ID of the configuration of the segmentation statistics associated with this communication type. |
Personas
| idProject Integer | ID of the project associated with the persona. |
| idxPersona Integer | Index (rank) of the persona within the project it is associated with. |
| Name Text | Name of the persona. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date of the persona creation. |
| idUser_CreatedBy Integer | ID of the user who created the persona. |
| dtModified Date (AAAA.MM.DD HH:MM:SS) | Date of the persona modification. |
| idUser_ModifiedBy Integer | ID of the user who modified the persona. |
| dtLastRun Date (AAAA.MM.DD HH:MM:SS) | Date of the last calculation of contacts who correspond to the persona criteria. |
| dtNextRun Date (AAAA.MM.DD HH:MM:SS) | Date of the upcoming calculation of contacts who correspond to the persona criteria. |
| idHostedFile_Avatar Integer | ID of the image used to represent the persona. |
| isCalculated 1 = true / 0 = false | Boolean indicating if the calculation of the contacts who correspond to the persona criteria has been processed. |
| gotError 1 = true / 0 = false | Boolean indicating if the most recent calculation of the contacts that correspond to the persona criteria is in error. |
Email platforms
| idBatch Integer | ID of the batch. |
| UserAgentType Integer | Device type used to view a message. 0 = Unknown 1 = Mobile 2 = Console 3 = Desktop 4 = Tablet |
| UserAgentPlatform Integer | Platform (operating system) used to view a message. 0 = Unknown 1= PC 2 = Apple 3 = SunOS 4 = Linux 6 = Android 7 = MTK Nucleus 8 = WindowsMobile 9 = webOS 10 = PalmOS 12 = Symbian 13 = MeeGo 14 = Hiptop 15 = iOS 16 = Brew 17 = RIMOS 19 = Bada 20 = QCOML4Brew 21 = Synergy 22 = PPSM 23 = WindowsPhone 24 = Java 25 = MacOS 101 = Windows 201 = Blackberry 208 = MotorolaOS 209 = HTC |
| ViewCount_Total Integer | Total views for this batch depending on the devices and platforms. |
| ViewCount_Uniques Integer | Unique views for this batch depending on the devices and platforms. |
| ClickCount_Total Integer | Total clicks for this batch depending on the devices and platforms. |
| ClickCount_Uniques Integer | Unique clicks for this batch depending on the devices and platforms. |
Journey's visits
| idVisit Integer | ID of the visit (a visit is a website's navigation session). |
| idContact Integer | ID of the contact who visits the website. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date and time depending on the timezone of the Dialog Insight platform you use (Canada or France). |
| idSiteTracking_Site Integer | ID of the Journey website. If you have multiple websites configured with Journey, this field allows you to distinguish which website is associated with this record. |
| ScreenWidth Integer | Width of the browser in pixels. |
| ScreenHeight Integer | Height of the browser in pixels. |
| PlatformType Integer | Type of platform (operating system) used to visit the website. 0 =Unknown 1 = PC 2 = Apple 3 = SunOS 4 = Linux 6 = Android 7 = MTKNucleus 8 = WindowsMobile 9 = webOS 10 = PalmOS 12 = Symbian 13 = MeeGo 14 = Hiptop 15 = Ios 16 = Brew 17 = RIMOS 19 = Bada 20 = QCOML4Brew 21 = Synergy 22 = PPSM 23 = WindowsPhone 24 = Java 25 = MacOS 101 = Windows 201 = Blackberry 208 = MotorolaOS 209 = HTC |
| DeviceType Integer | Type of device used to visit the website. 0 = Unknown 1 = Mobile 2 = Console 3 = Desktop 4 = Tablet |
| BrowserType Integer | Type of browser used to visit the website. 0 = Unknown 1 = Blackberry 2 = Chrome 3 = Edge 4 = Firefox 5 = IEMobile 6 = InternetExplorer 7 = Mozilla 8 = Opera 9 = Safari 10 = UCBrowser |
| SourceDomainType Integer | Origine de la visite. 0 = Domain 1 = Search engine 2 = Social network 3 = Email 4 = Direct access 5 = Campaign |
| idClickLog Integer | If the visit is linked to a click in an email, this field corresponds to the ID of the click in the Clicks table. |
| idBatch Integer | If the visit is linked to a campaign, this field corresponds to the ID of the campaign in the Messages table. |
| idMessage Integer | If the visit is linked to an email, this field corresponds to the ID of the email in the Messages table. |
| idSendLog Integer | If the visit is linked with an email batch, this field corresponds to the ID of the Mailings table. |
| idSMSSendLog Integer | If the visit is linked to an SMS batch, this field corresponds to the ID of the SMS sendings table. |
| Campaign Integer | If the visit is linked to a campaign (e.g., using the oft_campaign URL parameter), this field corresponds to the Email campaigns table. |
Journey hits
| idHit Integer | ID of the event on a Journey's website (if the same user visits several pages during the same navigation session, it creates only one idVisit for the whole session, but it creates one different idHit for each visited page). A "hit" without other information is a single page access (other fields will specify the type of action). |
| idVisit Integer | ID of the visit (if the same user visits several pages during one session, it creates only one idVisit for the whole session, but it creates one idHit for each visited page). |
| idSiteTracking_Site Integer | ID of the Journey's website. If you have multiple websites, this field allows to distinguish which website is associated with the record. |
| idContact Integer | ID of the contact who visited the website. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date and time of the visit, depending on the project's timezone. |
| QueryString Text | Part of the URL following ? (e.g., "page=home&lang=fr"). |
| Scheme Integer | 0 = http 1 = https |
| Domain Text | URL of the visited domain. |
| Path Text | Path of the visited URL. (e.g., "/promotions/featured-products"). |
| FragmentIdentifier Integer | Anchor part of the URL starting with "#". |
| Name Text | Type of event of this hit. If no typoe is specified, the action a single page visit access. Interceptors have multiple types of events: "OFSYS_AcceptInterception", "OFSYS_CloseInterception", "OFSYS_DisplayInterception", "OFSYS_SuccessInterception". There are other types of events for e-commerce: "OFSYS_ECommerce_Cart", "OFSYS_ECommerce_Transaction", "OFSYS_ECommerce_View". Other types of events can be custom. |
SMS sendings
| idSMSSendLog Integer | ID of the record in the SMS sendings table. |
| idSMSBatch Integer | ID of the sending. |
| idSMSEvent Integer | ID of the event. |
| idContact Integer | ID of the contact who received the SMS. |
| idSource Integer | Details about the sending origin (linked to sourceType). |
| idLongCode Integer | ID of the SMS provider. |
| sourceType Integer | Origin of the sending (linked to idSource). 0 = Sent manually by a user in Dialog Insight (idSource = idUser) 1 = Sent using a workflow (idSource = idWorkflow 2 = Sent using an automated campaign (idSource = idRun du scénario) 3 = Sent using an automated task (idSource =idJob) 4 = Sent using a web service (idSource = idUser) |
| MessageID Text | ID key of the message. |
| Message Text | Message content. |
| SMSNumber Text | Recipient's phone number. |
| isProcessed 1 = true / 0 = false | Boolean indicating if the message was processed. |
| gotProcessingError 1 = true / 0 = false | Boolean indicating if there was an error during the processing. |
| processingErrorCode Integer | Code of an error that happened during the processing. 0 = Unknown 1= The contact did not have a mobile phone number. 2 = The message encoding didn't correspond to the options available in the project/account. 3 = No phone number (longcode) was available to send the SMS according to the outbound rules. 4 = After multiple attempts, the provider did not answer. 5 = The SMS content (text) had an empty string or blank spaces. 6 = The SMS was both sent and not sent. It is a rare case that happens when the mailer crashes between the time the message is sent and the time the reply is logged. 7 = Execution error during the message processing. 8 = Paramaters compilation error. A parameter value may be invalid. 9 = Impossible to load the message. 10 = Impossible to create the processing context. Contact Dialog Insight. |
| status Integer | Status of the SMS. 0 = Default value at the start of the processing. 1 = The call to Twilio was done successfully, but there is still no reply from Twilio. 2 =Twilio returned a code indicating that the SMS is being sent. 3 = Twilio confirmed that the SMS was forwarded to the provider for sending. 4 = Twilio received a confirmation from the provider that the message was delivered. This value is not always updated. It is possible that the message is delivered even if the "Delivered" status is not confirmed. 5 = For incoming SMS, Twilio is processing an incoming message. 6 = For incoming SMS, the SMS was received. 7 = Error, either from Twilio or from Dialog Insight. 999 = The API returns a status=null when the message is not found. |
| SegmentsCount Integer | Number of segments in the SMS. |
| DeliveryErrorCode Text | Error code returned by the SMS provider during delivery. If the SMS provider is Twilio, the error code is 5 digits. See Twilio documentation: www.twilio.com/docs/api/errors. |
| dtQueued Date (AAAA.MM.DD HH:MM:SS) | Date the SMS was queued for sending. |
| dtSent Date (AAAA.MM.DD HH:MM:SS) | Date the SMS was sent. |
| dtDelivered Date (AAAA.MM.DD HH:MM:SS) | Date of delivery of the SMS. |
| dtError Date (AAAA.MM.DD HH:MM:SS) | Date the error happened. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date of the SMS creation. |
| idMessageCategory Integer | ID of the SMS communication type. |
| idSMSMessage Integer | ID of the SMS message. |
| Tag Text | Tag applied to this sending. |
SMS reception
| idSMSInboundLog Integer | ID of the entry in the SMS reception table. |
| idContact Integer | ID of the contact who sent the SMS. |
| idProvider Integer | ID of the SMS provider. |
| MessageID Text | ID key of the SMS. |
| Message Text | Content of the SMS. |
| SMSNumber Text | Phone number used to send the SMS. |
| dtReceived Date (AAAA.MM.DD HH:MM:SS) | Date of the SMS reception. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date of the SMS creation. |
| InboundRulesTriggered Integer | Number of actions after the SMS reception. |
| hasOptout 1 = true / 0 = false | Boolean indicating if the SMS contains an unsubscribe request. |
| hasOptin 1 = true / 0 = false | Boolean indicating if the SMS contains a subscription request. |
| hasKillfile 1 = true / 0 = false | Boolean indicating if the SMS contains a request to put a contact on the kill file. |
| LongCode Text | Phone number (long code) linked to the provider who received the SMS. |
Calls log
| idVoiceLog Integer | ID of the entry in the Calls log table. |
| idContact Integer | ID of the contact associated with the call. |
| idCompanyVoiceLog Integer | ID of the entry of the call in the account. |
| dtReceived Date (AAAA.MM.DD HH:MM:SS) | Date of the call reception. |
| dtEndCall Date (AAAA.MM.DD HH:MM:SS) | Date of the call end. |
| Status Integer | Status of the call. |
| Direction Integer | Call direction. 0 = Outbound 1 = Inbound |
| SMSNumber Text | Phone number of the contact. |
| LongCode Text | Standard phone number (10 digits), linked to the SMS provider. |
| Duration Integer | Call duration in seconds. |
| CallID Text | ID key of the call. |
| idProvider Integer | ID of the SMS provider. |
SMS clicks
| idSMSClickLog Integer | ID of the entry in the SMS clicks table. |
| idContact Integer | ID of the contact who clicked. |
| idSMSSendLog Integer | ID in the SMS sendings table. |
| idSMSBatch Integer | ID of the SMS sending. |
| LinkType Integer | Type of link. 1 = Link to an URL provided by the customer (idTarget = idSMS from the SMS Links table) 2 = Landing page (idTarget = idLandingPage from the Landing pages table) |
| idTarget Integer | ID of the target (varies depending on the LinkType field). |
| dtClick Date (AAAA.MM.DD HH:MM:SS) | Date of the click. |
| Platform Integer | Operating system (platform) used to click. 0 = Unknown 1 = PC 2 = Apple 3 = SunOS 4 = Linux 6 = Android 7 = MTKNucleus 8 = WindowsMobile 9 = webOS 10 = PalmOS 12 = Symbian 13 = MeeGo 14 = Hiptop 15 = Ios 16 = Brew 17 = RIMOS 19 = Bada 20 = QCOML4Brew 21 = Synergy 22 = PPSM 23 = WindowsPhone 24 = Java 25 = MacOS 101 = Windows 201 = Blackberry 208 = MotorolaOS 209 = HTC |
SMS campaigns
| idSMSBatch Integer | ID of the campaign. |
| idUser Integer | ID of the user in Dialog Insight who created the campaign. |
| idSMSMessage Integer | ID of the SMS transmitted. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date of the campaign creation. |
| idSource_Creation Integer | Campaign creation source (linked to sourceIndex_Creation). 0 = Sent manually by a user in Dialog Insight (idSource = idUser) 1 = Sent using a workflow (idSource = idWorkflow 2 = Sent using an automated campaign (idSource = scenario idRun) 3 = Sent using an automated task (idSource = idJob) 4 = Sent using a web service (idSource = idUser) |
| SourceIndex_Creation Integer | Details on the campaign (linked to idSourceCreation). |
| isTestBatch 1 = true / 0 = false | Boolean indicating if the campaign targets a test group. |
| isDelayed 1 = true / 0 = false | Boolean indicating if the campaign is delayed. |
| dtLaunch Date (AAAA.MM.DD HH:MM:SS) | Date of the campaign launch. |
| dtDelivery Date (AAAA.MM.DD HH:MM:SS) | Date of the campaign delivery. |
| isPrepared 1 = true / 0 = false | Boolean indicating if the list of targeted contacts is fixed. |
| isCompleted 1 = true / 0 = false | Boolean indicating if the campaign is completed. |
| dtFirstMessage Date (AAAA.MM.DD HH:MM:SS) | Date of the first SMS preparation. |
| dtLastMessage Date (AAAA.MM.DD HH:MM:SS) | Date of the last SMS preparation. |
| Stats_MessageCount Integer | Number of sent SMS. |
| Stats_ProcessedCount Integer | Number of SMS processed. |
| Stats_RelayedByOFSYSCount Integer | Number of SMS relayed successfully to Dialog Insight's provider. |
| Stats_RelayedByProviderCount Integer | Number of SMS relayed successfully by Dialog Insight's provider. |
| Stats_ProcessingErrors Integer | Number of processing errors. |
| Stats_InvalidSMSNumbers Integer | Number of invalid phone numbers. |
| isApproved 1 = true / 0 = false | Boolean indicating if the campaign is approved for sending. |
| idUser_ApprovedBy Integer | ID of the user in Dialog Insight who approved the campaign. |
| dtApproved Date (AAAA.MM.DD HH:MM:SS) | Date of the campaign approbation. |
| isRejected 1 = true / 0 = false | Boolean indicating if the campaign was rejected. |
| idUser_RejectedBy Integer | ID of the user in Dialog Insight who rejected the campaign. |
| dtRejected Date (AAAA.MM.DD HH:MM:SS) | Date the campaign was rejected. |
| isPaused 1 = true / 0 = false | Boolean indicating if the campaign is paused. |
| idUser_PausedBy Integer | ID of the user in Dialog Insight who paused the campaign. |
| dtPaused Date (AAAA.MM.DD HH:MM:SS) | Date the campaign was paused. |
| idUser_ResumedBy Integer | ID of the user in Dialog Insight who resumed the campaign. |
| dtResumed Date (AAAA.MM.DD HH:MM:SS) | Date the campaign was resumed. |
| isCancelled 1 = true / 0 = false | Boolean indicating if the campaign is cancelled. |
| idUser_CancelledBy Integer | ID of the user who cancelled the campaign. |
| dtCancelled Date (AAAA.MM.DD HH:MM:SS) | Date the campaign was cancelled. |
| UserNotes Text | User notes. |
| gotError 1 = true / 0 = false | Boolean indicating if the campaign is in error (linked to ErrorCode). |
| ErrorCode Integer | Error code. 1 = Object not found (e.g., the SMS has been deleted) 2 = Inconsistency in the preparation 3 = Invalid communication type 4 = Failure in loading request 5 = No phone number (long code) available 99 = Other |
| MustExcludeDuplicates 1 = true / 0 = false | Boolean indicating if the contact list excludes duplicate recipients. |
| Stats_Initialized Integer | Number of prepared contacts. |
| isInitialized 1 = true / 0 = false | Boolean indicating if the campaign is initialized. This is the first step of the sending process. |
| dtInitialized Date (AAAA.MM.DD HH:MM:SS) | Date of the initialization. |
| preparationDuration Integer | Duration of the SMS production. |
| dtLaunchComputed Date (AAAA.MM.DD HH:MM:SS) | Effective date of the campaign launch. |
| Stats_DeliveredCount Integer | Number of SMS delivered. |
| Stats_ProviderErrors_Mailer Integer | Number of SMS that were not delivered due to an error to Dialog Insight's provider. |
| Stats_ProviderErrors_RelayedOFSYS Integer | Number of SMS that were not delivered due to an error that occurred after the SMS was relayed Dialog Insight's provider. |
| Stats_ProviderErrors_RelayedProvider Integer | Number of SMS that were not delivered due to an error after the SMS was sent to Dialog Insight's provider. |
| idMAScenario Integer | ID of the automated campaign. |
| idMARevision Integer | ID of the automated campaign revision. |
| MANodeKey Integer | Node code in the automated campaign that generated the sending. |
| Stats_ClickCount_Total Integer | Number of total clicks. |
| Stats_ClickCount_Uniques Integer | Number of unique clicks. |
| SecAttr_ (All fields starting with) | Value of the security attribute for the corresponding field. |
SMS messages
| idSMSMessage Integer | ID of the SMS. |
| idApplication Integer | Application ID. 1 = N/A 2 = Contact Application (SMS in a project) |
| idUser_Owner Integer | ID of the user in Dialog Insight who is the SMS owner. |
| idMessageCategory Integer | ID of the communication type associated with the SMS. |
| idMessageType Integer | ID of the SMS type. 0 = Created in the SMS editor 1 = Created in an automated campaign 2 = Created in an acquisition workflow (contests, events) |
| idMessageStatus Integer | ID of the message status. 0 = New 1 = Modified 2 = Tested 3 = Sent |
| isArchived 1 = true / 0 = false | Boolean indicating if the SMS is archived. |
| MessageName Text | Name of the message. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date of the SMS creation. |
| dtModified Date (AAAA.MM.DD HH:MM:SS) | Date of the message modification. |
| idUser_CreatedBy Integer | ID of the user in Dialog Insight who created the SMS. |
| idUser_ModifiedBy Integer | ID of the user in Dialog Insight who modified the SMS. |
| SenderName Text | Name of the sender. |
| idWorkflow Integer | ID of the workflow. |
| idMAScenario Integer | ID of the automated campaign. |
| SecAttr_ (All fields starting with) | Value of the security attribute for the corresponding field. |
SMS links
| idSMSLink Integer | ID of the link. |
| idSMSMessage Integer | ID of the SMS that contains the link. |
| LinkName Text | Name of the link. |
| LinkURL Text | URL of the link. |
Pages de destination
| idLandingPage Integer | ID of the landing page. |
| idLandingPageFolder Integer | ID of the landing page folder. |
| FileName Text | Name of the file. |
| PageName Text | Name of the landing page. |
| Cultures Text | Languages of the landing page "en-CA" or "fr-CA"). Separated by a comma if multiple cultures. |
| isModel 1 = true / 0 = false | Boolean indicating if the landing page is a template. |
| isArchived 1 = true / 0 = false | Boolean indicating if the landing page is archived. |
| isPublished 1 = true / 0 = false | Boolean indicating if the landing page is published. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date the landing page was created. |
| idUser_CreatedBy Integer | ID of the user in Dialog Insight who created the landing page. |
| dtModified Date (AAAA.MM.DD HH:MM:SS) | Date of the landing page modification. |
| idUser_ModifiedBy Integer | ID of the user in Dialog Insight who modified the landing page. |
| dtPublished Date (AAAA.MM.DD HH:MM:SS) | Date the landing page was published. |
| idUser_PublishedBy Integer | ID of the user in Dialog Insight who published the landing page. |
| dtUpdated Date (AAAA.MM.DD HH:MM:SS) | Date the landing page was updated. |
| idUser_UpdatedBy Integer | ID of the user in Dialog Insight who updated the landing page. |
| dtUnpublished Date (AAAA.MM.DD HH:MM:SS) | Date the landing page was unpublished. |
| idUser_UnpublishedBy Integer | ID of the user in Dialog Insight who unpublished the landing page. |
| dtArchived Date (AAAA.MM.DD HH:MM:SS) | Date the landing page was archived. |
| idUser_ArchivedBy Integer | ID of the user in Dialog Insight who archived the landing page. |
| dtStart Date (AAAA.MM.DD HH:MM:SS) | Date of the landing page availability start. |
| dtEnd Date (AAAA.MM.DD HH:MM:SS) | Date of the landing page availability end. |
| Status Integer | Status of the landing page. 0 = Deactivated 1 = Success 2 = Warning 3 = Error |
| dtLastStatsReset Date (AAAA.MM.DD HH:MM:SS) | Date of the statistics reset. |
Push campaigns
| idPushBatch Integer | ID of the Push campaign. |
| idUser Integer | ID of the user in Dialog Insight who created the campaign. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date of the campaign creation. |
| dPart Date (AAAA.MM.DD HH:MM:SS) | Date of the campaign creation. |
| idSource_Creation Integer | ID of the creation source campagne. 0 = Manual 1 = Webservice 2 = Automated campaign 3 = Scheduler 5 = Workflow |
| SourceIndex_Creation Integer | ID of the source which created the campaign. |
| isTestBatch 1 = true / 0 = false | Boolean indicating if the campaign targets a test group. |
| isDelayed 1 = true / 0 = false | Boolean indicating if the campaign is delayed. |
| dtLaunch Date (AAAA.MM.DD HH:MM:SS) | Date of the campaign launch. |
| isPrepared 1 = true / 0 = false | Boolean indicating if the list of contacts targeted by the campaign is fixed. |
| isCompleted 1 = true / 0 = false | Boolean indicating if the campaign is completed. |
| dtFirstMessage Date (AAAA.MM.DD HH:MM:SS) | Preparation date of the first message of the campaign. |
| dtLastMessage Date (AAAA.MM.DD HH:MM:SS) | Preparation date of the last message of the campaign. |
| stats_MessageCount Integer | Number of messages prepared for the campaign. |
| stats_ProcessedCount Integer | Number of messages processed in the campaign. |
| stats_Processing_Errors Integer | Number of processed messages in error in the campaign. |
| stats_DeliveredCount Integer | Number of message delivered in the campaign. |
| dtDelivery Date (AAAA.MM.DD HH:MM:SS) | Delivery date of the campaign. |
| dtLaunch_OriginalValue Date (AAAA.MM.DD HH:MM:SS) | Planned delivery date. |
| filterCount Integer | Number of groups targeted by the campaign. |
| idFilter_Single Integer | ID of the group targeted by the campaign. |
| idFilter_Multiple Text | ID list of groups targeted by the campaign. |
| isApproved 1 = true / 0 = false | Boolean indicating if the campaign is approved for sending. |
| idUser_ApprovedBy Integer | ID of the user in Dialog Insight who approved the campaign. |
| dtApproved Date (AAAA.MM.DD HH:MM:SS) | Approval date of the campaign. |
| isRejected 1 = true / 0 = false | Boolean indicating if the campaign has been rejected. |
| idUser_RejectedBy Integer | ID of the user in Dialog Insight who rejected the campaign. |
| dtRejected Date (AAAA.MM.DD HH:MM:SS) | Reject date of the campaign. |
| isPaused 1 = true / 0 = false | Boolean indicating if the campaign is paused. |
| idUser_PausedBy Integer | ID of the user in Dialog Insight who paused the campaign. |
| dtPaused Date (AAAA.MM.DD HH:MM:SS) | Date the campaign was paused. |
| idUser_ResumedBy Integer | ID of the user in Dialog Insight who resumed the campaign. |
| dtResumed Date (AAAA.MM.DD HH:MM:SS) | Resume date of the campaign. |
| isCancelled 1 = true / 0 = false | Boolean indicating if the campaign is cancelled. |
| idUser_CancelledBy Integer | ID of the user in Dialog Insight who cancelled the campaign. |
| dtCancelled Date (AAAA.MM.DD HH:MM:SS) | Cancellation date of the campaign. |
| gotError 1 = true / 0 = false | Boolean indicating if the campaign is in error. |
| errorCode Integer | ID of the campaign error. 0 = Unknown 1 = Message body is empty 2 = Compilation error 3 = Incomplete communication type 4 = Truncated personalized title 5 = Truncated unpersonalized title 6 = Truncated personalized body 7 = Truncated unpersonalized body |
| userNotes Text | Notes for the user when there is rejection or cancellation of the campaign. |
| stats_Initialized Integer | Number of messages prepared for the campaign. |
| isInitialized 1 = true / 0 = false | Boolean indicating if the campaign was initialized by the delivery service. |
| dtInitialized Date (AAAA.MM.DD HH:MM:SS) | Date the campaign was handled by the delivery service. |
| idMAScenario Integer | ID of the automated campaign that triggered the campaign. |
| idMARevision Integer | ID of the revision of the automated campaign that triggered the campaign. |
| idMARun Integer | ID of the execution of the automated campaign that triggered the campaign. |
| MANodeKey Integer | ID of the trigger of the automated campaign. |
| dtLaunchComputed Date (AAAA.MM.DD HH:MM:SS) | Effective date of the launch. |
| preparationDuration Integer | Preparation duration in seconds. |
| stats_ViewCount_Uniques Integer | Number of unique views of the campaign. |
| stats_ViewCount_Total Integer | Number of total views of the campaign. |
| stats_BouncedCount Integer | Number of delivery errors of the campaign. |
| platforms Integer | ID of the platforms targeted by the campaign. 0 =Unknown 1 = iOS 2 = Android 4 = Chrome 8 = Firefox 16 = Edge 32 = Opera |
| stats_ContactCount Integer | Number of contacts targeted by the campaign. |
| idObject Integer | ID of the notification to send. |
| idObjectType Integer | ID of the notification type to send. 1 = Push Message 2 = Web Push Message 3 = Offer |
| stats_ClickCount_Unique Integer | Number of viewed unique notifications. |
| idPushApplication Integer | ID of the push platform used for the push campaign. |
| idPlatformPushType Integer | ID of the platform type targeted by the campaign. |
| Stats_AnonTokenCount Integer | Number of anonymous notifications. |
| Stats_ClickCount_Anonymous Integer | Number of clicks anonymous notifications. |
| stats_ViewCount_Anonymous Integer | Number of displayed anonymous notifications. |
| Stats_Processing_Errors_Anonymous Integer | Number of anonymous notifications with a preparation error. |
| Stats_ProcessedCount_Anonymous Integer | Number of prepared anonymous notifications. |
| Stats_BouncedCount_Anonymous Integer | Number of anonymous delivery errors. |
| toKnownSubscribers 1 = true / 0 = false | Boolean indicating if the campaign can target known visitors. |
| toAnonymousSubscribers 1 = true / 0 = false | Boolean indicating if the campaign can target anonymous visitors. |
| idCalendarEvent Integer | ID of the event calendar associated with the campaign. |
| dtPrepared Date (AAAA.MM.DD HH:MM:SS) | Preparation date of the campaign. |
| idSource_Cancellation Integer | ID of the source who cancelled the campaign. 0 = Manual 1 = Web Service 2 = Automated Campaign 3 = Scheduler 4 = System |
| SourceIndex_Cancellation Integer | ID of the source who cancelled the campaign. |
| MaxPerHour Integer | Maximal number of notifications to deliver per hour. |
| Stats_CommercialPressure_ ExcludedContactsCount Integer | Number of contacts excluded in a frequency optimizer context. |
| isCommercialPressureIncremented 1 = true / 0 = false | Boolean indicating if the delivery frequency incremented. |
| SecAttr_ (All fields starting with) | Value of the security attribute for the corresponding field. |
Mobile push messages
| idPushMessage Integer | ID of the message. |
| messageName Text | Name of the message. |
| idPushBatch Integer | ID of the campaign. |
| idUser_Owner Integer | ID of the user in Dialog Insight who is the owner of the message. |
| idUserCreatedBy Integer | ID of the user in Dialog Insight who created the message. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Creation date of the message. |
| idUser_ModifiedBy Integer | ID of the user in Dialog Insight who modified the message. |
| dtModified Date (AAAA.MM.DD HH:MM:SS) | Modification date of the message. |
| hasActiveSources 1 = true / 0 = false | Boolean indicating if the message has active sources (queries). |
| idWorkflow Integer | ID of the workflow. |
| idMAScenario Integer | ID of the automated campaign owning the message. |
| isPushType 1 = true / 0 = false | Boolean indicating if the message is a template. |
| idType_Parent Integer | ID of the message's template. |
| isDeleted 1 = true / 0 = false | Boolean indicating if the message has been deleted. |
| isArchived 1 = true / 0 = false | Boolean indicating if the message is archived. |
| idMessageStatus Integer | ID of the message status. 0 = New 1 = Modified 2 = Tested 3 = Sent 4 = Delivered 5 = Viewed 6 = Error |
| ApprovalStatus Integer | ID of the approval status of the message. 1 =Draft 2 = Awaiting approval 3 = Approved 4 = Rejected |
| dtApprovalRequested Date (AAAA.MM.DD HH:MM:SS) | Date a message approval has been requested. |
| idUser_ApprovalRequestedBy Integer | ID of the user in Dialog Insight who requested the approval of the message. |
| dtApproved Date (AAAA.MM.DD HH:MM:SS) | Date the message has been approved. |
| idUser_ApprovedBy Integer | ID of the user in Dialog Insight who approved the message. |
| dtRejected Date (AAAA.MM.DD HH:MM:SS) | Date the message has been rejected. |
| idUser_RejectedBy Integer | ID of the user in Dialog Insight who rejected the message. |
| RejectReason Text | Reason for the message rejection. |
| idPushApplication Integer | ID of the application used for the message. |
| Tags Integer | List of the tag IDs associated with the message. |
| idMessageCategory Integer | ID of the communication type associated with the message. |
| idCalendarEvent Integer | ID of the event calendar associated with the message. |
| SecAttr_ (All fields starting with) | Value of the security attribute for the corresponding field. |
Mobile push deployment
| idPush Integer | ID of the entry in the Mobile Push deployment table. |
| dPart Date (AAAA.MM.DD HH:MM:SS) | Creation date of the entry in the Mobile Push deployment table. |
| pslKey Text | Key generated by the validation parameters. |
| idToken Integer | ID of the token used by the notification. |
| idContact Integer | ID of the contact who is the recipient of the notification. |
| idPushMessage Integer | ID of the message. |
| idPushBatch Integer | ID of the campaign. |
| idPushEvent Integer | ID of the event that triggered the campaign. |
| isProcessed 1 = true / 0 = false | Boolean indicating if the message has been processed. |
| gotProcessingError 1 = true / 0 = false | Boolean indicating if the message has execution errors. |
| ProcessingErrorCode Integer | ID of the message processing error. |
| PushErrorCode Integer | ID of the delivery error. |
| PushStatus Integer | ID of the message status. |
| isInvalidToken 1 = true / 0 = false | Boolean indicating if the token used for the notification is invalid. |
| gotView 1 = true / 0 = false | Boolean indicating if the notification has displays. |
| dtProcessed Date (AAAA.MM.DD HH:MM:SS) | Execution date of the notification. |
| dtView Date (AAAA.MM.DD HH:MM:SS) | Display date of the notification. |
| idPushApplicationVersion Integer | ID of the application version used for the Mobile Push. |
| isTest 1 = true / 0 = false | Boolean indicating if the notification is a test. |
| idMessageCategory Integer | ID of the communication type used by the message. |
Web push messages
| idWebPushMessage Integer | ID of the message. |
| MessageName Text | Name of the message. |
| idUser_Owner Integer | ID of the user in Dialog Insight who is the owner of the message. |
| idUser_CreatedBy Integer | ID of the user in Dialog Insight who created the message. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date of the message creation. |
| idUser_ModifiedBy Integer | ID of the user in Dialog Insight who modified the message. |
| dtModified Date (AAAA.MM.DD HH:MM:SS) | Date of the message modification. |
| hasActiveSources 1 = true / 0 = false | Boolean indicating if the message contains active sources (queries). |
| idWorkflow Integer | ID of the workflow associated with the message. |
| idMAScenario Integer | ID of the workflow that owns the message. |
| isPushType 1 = true / 0 = false | Boolean indicating if the message is a template. |
| idType_Parent Integer | ID of the message's template. |
| isDeleted 1 = true / 0 = false | Boolean indicating if the message is deleted. |
| isArchived 1 = true / 0 = false | Boolean indicating if the message is archived. |
| idMessageStatus Integer | ID of the message status. 0 = New 1 = Modified 2 = Tested 3 = Sent 4 = Delivered 5 = Viewed 6 = Error |
| ApprovalStatus Integer | Message approval status. 1 = Draft 2 = Awaiting approval 3 = Approved 4 = Rejected |
| dtApprovalRequested Date (AAAA.MM.DD HH:MM:SS) | Creation date of the message approval request. |
| idUser_ApprovalRequestedBy Integer | ID of the user in Dialog Insight who requested the message approval. |
| dtApproved Date (AAAA.MM.DD HH:MM:SS) | Approval date of the message. |
| idUser_ApprovedBy Integer | ID of the user in Dialog Insight who approved the message. |
| dtRejected Date (AAAA.MM.DD HH:MM:SS) | Date the message has been rejected. |
| idUser_RejectedBy Integer | ID of the user in Dialog Insight who rejected the message. |
| RejectReason Text | Reason the message has been rejected. |
| idPushApplication Integer | ID of the Push application used by the message. |
| idMessageCategory Integer | ID of the communication type of the message. |
| Tags Integer | ID list of the tags associated with the message. |
| NotificationType Integer | ID of the notification type. |
| idCalendarEvent Integer | ID of the event calendar associated with the message. |
| SecAttr_ (All fields starting with) | Value of the security attribute for the corresponding field. |
Web Push deployment
| idWebPushSendLog Integer | ID of the entry in the Web Push deployment table. |
| dPart Date (AAAA.MM.DD HH:MM:SS) | Creation date of entry in the Web Push deployment table. |
| slKey Text | Key generated to validate the parameters. |
| idContact Integer | ID of the contact who is the recipient of the message. |
| idObject Integer | ID of the notification. |
| idObjectType Integer | ID of the notification type. |
| idPushBatch Integer | ID of the campaign. |
| idPushEvent Integer | ID of the event that triggered the notification. |
| isProcessed 1 = true / 0 = false | Boolean indicating if the notification has been processed by the delivery service. |
| gotProcessingError 1 = true / 0 = false | Boolean indicating if there was an error during the notification processing. |
| ProcessingErrorCode Integer | ID of the notification processing error. 0 = Unknown 1 = Execution error 2 = Impossible to build the parameters 3 = Impossible to load the message 4 = Error whil executing the mesage context of the execution error 5 = Impossible to load the contact |
| PushStatus Integer | ID of the notification status. 0 = Processing 1 = Awaiting process 2 = Processing error 3 = Delivery service error 4 = Delivery service restart 5 = Push message acknowledgement 6 = Negative push message acknowledgement 7 = Execution time limit reached 8 = Push message in error 9 = Push message retries error 10 = Configuration error |
| gotView 1 = true / 0 = false | Boolean indicating if the notification has displays. |
| dtProcessed Date (AAAA.MM.DD HH:MM:SS) | Date the notification has been processed. |
| idPushApplicationVersion Integer | ID of the Push application version used for the notification. |
| gotClick 1 = true / 0 = false | Boolean indicating if the notification was clicked. |
| TokenCount Integer | Number of devices the notification was sent to. |
| isTest 1 = true / 0 = false | Boolean indicating if the notification is a test. |
| idMessageCategory Integer | ID of the communication type associated with the message. |
Web Push clicks
| idWebPushClickLog Integer | ID of the entry in the Web Push clicks log. |
| idWebPushSendLog Integer | ID of the entry in the Web Push deployment table. |
| dPart Date (AAAA.MM.DD HH:MM:SS) | Creation date of the entry in the Web Push clicks log. |
| idContact Integer | ID of the contact who is the recipient of the notification. |
| idToken Integer | ID of the token used for the notification. |
| idObject Integer | ID of the notification. |
| idObjectType Integer | ID of the notification type. 0 = Push Message 1 = Web Push Message 3 = Offer |
| idPushBatch Integer | ID of the campaign that owns the notification. |
| dtClick Date (AAAA.MM.DD HH:MM:SS) | Date the contact clicked the notification. |
| idxAction Integer | Index of the action (click) by the contact. |
Campaign links
| idBatch Integer | ID of the campaign. |
| LinkOrder Integer | Display order (index) of all the campaign links. |
| idLink Integer | ID of the link included in the campaign. |
| LinkInstance Integer | Identification number of the link based on the render in this campaign, including all message versions. |
| RenderCount Integer | Number of contacts for whom the link was present inside a message of this campaign. |
| ViewCount Integer | Number of contacts who saw this link instance for this campaign. |
| ClickCount Integer | Number of contacts who clicked this link instance for this campaign. |
Campaign link Statistics
| idStatsLink Integer | ID of the link statistics. |
| idBatch Integer | ID of the campaign containing the link. |
| idLink_Generic Integer | ID of the generic link included in the campaign (NULL if the link is operational). |
| idLink_Operational Integer | ID of the operational link included in the campaign (NULL if the link is generic). |
| LinkOrder Integer | Display order (index) of all the campaign's links. |
| ClickCount_Uniques Integer | Number of unique clicks on this link instance for this campaign. |
| ClickCount_Total Integer | Number of total clicks on this link in this campaign. |
| WebClickCount_Uniques Integer | Number of unique clicks on this link in this campaign coming from a website. |
| WebClickCount_Total Integer | Number of total clicks in this campaign coming from a website. |
| AppClickCount_Uniques Integer | Number of unique clicks on this link in this campaign coming from a configured app. |
| AppClickCount_Total Integer | Number of total clicks on this link in this campaign coming from a configured app. |
Operational links
| idLink Integer | ID of the operational link. |
| lKey Text | ID key of the operational link. |
| LinkName Text | Name of the operational link. |
| LinkURL Text | URL of the operational link. |
| LinkCategory Text | Category of the operational link. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Date the operational link has been created. |
| Update_1_doUpdate 1 = true / 0 = false | Boolean indicating if a field must be updated. |
| Update_1_Field Text | Field that must be updated. |
| Update_1_Operation Text | Operator. |
| Update_1_DatePart Text | Obsolete field. |
| Update_1_Value Text | Value updated. |
| Contact_idMessage Integer | ID of the message. |
| Admin_idMessage Integer | ID of the admin message. |
| Admin_Email_1 Text | Email of the Admin 1 to notify. |
| TargetEncoding Text | Encoding of the message. |
Link statistics
| idLink Integer | ID of the link. |
| idMessage Integer | ID of the message. |
| IKey Text | ID key of the link. |
| LinkName Text | Name of the link. |
| LinkURL Text | URL of the link. |
| dtCreated Date (AAAA.MM.DD HH:MM:SS) | Creation date of the link. |
Link attributes
| idLink Integer | ID of the link. |
| LinkInstancenumber Integer | Display order (index) of the link in the HTML code in the email. |
| f_CODEATTRIBUT | Attribute code configured in the link attributes of the project. |