Table structure¶
This is the standard structure that the integration expects and needs to function properly, however every table and field name can be configured in the Lime CRM admin config for TRAML tracking.
If using the email function, create the limetypes tramlemail and tramlmergecode. Optional to use linkclick and emailopening.
If using sms function, create the limetype tramlsms
Limetype linkclick and linkopening¶
If you will be using linkclick and linkopening, check the tables here or here but instead of adding a relation to automatedflowparticipant, automatedflowparticipantaction or mailing only add a relation to the tramlemail limetype.
Limetype tramlemail¶
transactional_message (Transactional message/Transaktionellt meddelande)
| Field name | Required | Suggested local name(en/sv) | Field type(length) |
|---|---|---|---|
| from_name | False | Sender name/Namn avsändare | Text(128) |
| from_email | False | Sender email/E-post avsändare | Text(128) |
| recipient_name | False | Recipient name/Namn mottagare | Text(128) |
| recipient_email | False | Recipient email/E-post mottagare | Text(128) |
| subject | False | Subject/Ämnesrad | Text(128) |
| templatename | False | Template/Mall | Text(128) |
| templateid | False | Template ID/Mall ID | Integer |
| transactionmail_id | False | Transactionmail ID/Transactionmail ID | Integer |
| scheduledsendtime | False | Scheduled send time/Schemalagd utskickstid | Time |
| sent | False | Sent/Skickad | Time |
| delivered | False | Delivered/Levererad | Time |
| send_status | False | Sendout status/Utskicksstatus | Option |
| errormessage | False | Error message/Felmeddelande | Text(512) |
| person *optional | False | Person/Person | Relation - belongs to (person) |
| tramlmergecode | False | Merge codes/Styrkoder | Relation - have many (tramlmergecode) |
| linkclick *optional | False | Link click/Länkklick | Relation - have many (linkclick) |
| emailopening *optional | False | Email Opened/Email öppnat | Relation - have many (emailopening) |
transactional_message.send_status¶
| Key | Suggested local name(en/sv) |
|---|---|
| empty | |
| bounced (or bounce) | Bounced/Studsat |
| link_clicked (or clicked) | Clicked/Klickat |
| error | Error/Fel |
| opened (or open) | Opened/Öppnat |
| sent_to_marketing | Sending/Skickas |
| sent | Sent/Skickad |
| test | Test/Test |
| not_sent (or notsent) | Not sent/Inte skickad |
| delivered | Delivered/Levererad |
Limetype tramlmergecode¶
tramlmergecode (Merge code/Styrkod)
Field
If the length of a mergecode name or mergecode value is greater than the length of the data given to the save function, it will truncate the value to not create a commit error.
| Field name | Required | Suggested local name(en/sv) | Field type(length) |
|---|---|---|---|
| mergecode | False | Marketing string/Marketing sträng | Text(256) |
| value | False | Value/Värde | Text(2000) - increase the length if working with long mergecodes. |
| transactional_message | False | Transactional message/Transaktionellt meddelande | Relation - belongs to (transactional_message) |
Limetype tramlsms¶
If using sms function, create the limetype tramlsms
tramlsms (Transactional SMS/Transaktionellt SMS)
| Field name | Required | Suggested local name(en/sv) | Field type(length) |
|---|---|---|---|
| sendernumber | False | Phone number sender/Telefonummer avständare | Text(32) |
| recipientnumber | False | Phone number recipient/Telefonummer mottagare | Text(32) |
| text | False | Sent text/Skickad text | Text(512) |
| transactionsms_id | False | Transactionsms ID/Transactionsms ID | Integer |
| scheduledsendtime | False | Scheduled send time/Schemalagd utskickstid | Time |
| sent | False | Sent/Skickad | Time |
| person *optional | False | Person/Person | Relation - belongs to (person) |
| errormessage | False | Error message/Felmeddelande | Text(512) |
| sendoutstatus | False | Sendout status/Utskicksstatus | Option |
tramlsms.sendoutstatus¶
| Key | Suggested local name(en/sv) |
|---|---|
| empty | |
| deliveryfailed | Delivery failed/Leveransen misslyckades |
| deliverysucceded | Delivery succeded/Leveransen lyckades |
| error | Error/Fel |
| sent_to_marketing | Sending/Skickas |
| sent | Sent/Skickad |
| test | Test/Test |