mailing |
Mass Mailing
Catalog: Odoo
Schema: mailing
Documentation:
MassMailing models a wave of emails for a mass mailign campaign.
A mass mailing is an occurence of sending emails.
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table mailing are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ab_testing_completed |
boolean |
A/B Testing Campaign Finished |
☐ |
|
ab_testing_description |
string |
A/B Testing Description |
☐ |
|
ab_testing_enabled |
boolean |
Allow A/B Testing |
☐ |
If checked, recipients will be mailed only once for the whole campaign. This lets you send different mailings to randomly selected recipients and test the effectiveness of the mailings, without causing duplicate messages. |
ab_testing_mailings_count |
int32 |
A/B Test Mailings # |
☐ |
|
ab_testing_pc |
int32 |
A/B Testing percentage |
☐ |
Percentage of the contacts that will be mailed. Recipients will be chosen randomly. |
ab_testing_schedule_datetime |
datetime |
Send Final On |
☐ |
Date that will be used to know when to determine and send the winner mailing |
ab_testing_sms_winner_selection |
string |
SMS Winner Selection |
☐ |
|
ab_testing_winner_selection |
string |
Winner Selection |
☐ |
Selection to determine the winner mailing that will be sent. |
active |
boolean |
Active |
☐ |
|
activity_calendar_event_id_label |
string |
|
☐ |
|
activity_calendar_event_id |
string |
|
☐ |
|
activity_date_deadline |
datetime |
Next Activity Deadline |
☐ |
|
activity_exception_decoration |
string |
Activity Exception Decoration |
☐ |
Type of the exception activity on record. |
activity_exception_icon |
string |
Icon |
☐ |
Icon to indicate an exception activity. |
activity_ids |
string |
|
☐ |
|
activity_state |
string |
Activity State |
☐ |
Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities. |
activity_summary |
string |
Next Activity Summary |
☐ |
|
activity_type_icon |
string |
Activity Type Icon |
☐ |
Font awesome icon e.g. fa-tasks |
activity_type_id_label |
string |
|
☐ |
|
activity_type_id |
string |
|
☐ |
|
activity_user_id_label |
string |
|
☐ |
|
activity_user_id |
string |
|
☐ |
|
attachment_ids |
string |
|
☐ |
|
body_arch |
string |
Body |
☐ |
|
body_html |
string |
Body converted to be sent by mail |
☐ |
|
body_plaintext |
string |
SMS Body |
☐ |
|
bounced_ratio |
int32 |
Bounced Ratio |
☐ |
|
bounced |
int32 |
Bounced |
☐ |
|
calendar_date |
datetime |
Calendar Date |
☐ |
Date at which the mailing was or will be sent. |
campaign_id_label |
string |
|
☐ |
|
campaign_id |
string |
|
☐ |
|
canceled |
int32 |
Canceled |
☐ |
|
clicked |
int32 |
Clicked |
☐ |
|
clicks_ratio |
int32 |
Number of Clicks |
☐ |
|
color |
int32 |
Color Index |
☐ |
|
contact_list_ids |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
crm_lead_count |
int32 |
Leads/Opportunities Count |
☐ |
|
delivered |
int32 |
Delivered |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
email_from |
string |
Send From |
☑ |
|
expected |
int32 |
Expected |
☐ |
|
failed |
int32 |
Failed |
☐ |
|
favorite_date |
datetime |
Favorite Date |
☐ |
When this mailing was added in the favorites |
favorite |
boolean |
Favorite |
☐ |
|
has_message |
boolean |
Has Message |
☐ |
|
id |
int32 |
ID |
☐ |
|
is_body_empty |
boolean |
Is Body Empty |
☐ |
|
keep_archives |
boolean |
Keep Archives |
☐ |
|
kpi_mail_required |
boolean |
KPI mail required |
☐ |
|
lang |
string |
Language |
☐ |
Optional translation language (ISO code) to select when sending out an email. If not set, the english version will be used. This should usually be a placeholder expression that provides the appropriate language, e.g. {{ object.partner_id.lang }}. |
mail_server_available |
boolean |
Mail Server Available |
☐ |
Technical field used to know if the user has activated the outgoing mail server option in the settings |
mail_server_id_label |
string |
|
☐ |
Use a specific mail server in priority. Otherwise Odoo relies on the first outgoing mail server available (based on their sequencing) as it does for normal mails. |
mail_server_id |
string |
|
☐ |
Use a specific mail server in priority. Otherwise Odoo relies on the first outgoing mail server available (based on their sequencing) as it does for normal mails. |
mailing_domain |
string |
Domain |
☐ |
|
mailing_filter_count |
int32 |
# Favorite Filters |
☐ |
|
mailing_filter_domain |
string |
Favorite filter domain |
☐ |
|
mailing_filter_id_label |
string |
|
☐ |
|
mailing_filter_id |
string |
|
☐ |
|
mailing_model_id_label |
string |
|
☐ |
|
mailing_model_id |
string |
|
☐ |
|
mailing_model_name |
string |
Recipients Model Name |
☐ |
|
mailing_model_real |
string |
Recipients Real Model |
☐ |
|
mailing_on_mailing_list |
boolean |
Based on Mailing Lists |
☐ |
|
mailing_trace_ids |
string |
|
☐ |
|
mailing_type_description |
string |
Mailing Type Description |
☐ |
|
mailing_type |
string |
Mailing Type |
☑ |
|
marketing_activity_ids |
string |
|
☐ |
|
medium_id_label |
string |
|
☐ |
UTM Medium: delivery method (email, sms, ...) |
medium_id |
string |
|
☐ |
UTM Medium: delivery method (email, sms, ...) |
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
|
my_activity_date_deadline |
datetime |
My Activity Deadline |
☐ |
|
name |
string |
Name |
☐ |
|
next_departure |
datetime |
Scheduled date |
☐ |
|
opened_ratio |
int32 |
Opened Ratio |
☐ |
|
opened |
int32 |
Opened |
☐ |
|
preview |
string |
Preview |
☐ |
Catchy preview sentence that encourages recipients to open this email.In most inboxes, this is displayed next to the subject.Keep it empty if you prefer the first characters of your email content to appear instead. |
received_ratio |
int32 |
Received Ratio |
☐ |
|
render_model |
string |
Rendering Model |
☐ |
|
replied_ratio |
int32 |
Replied Ratio |
☐ |
|
replied |
int32 |
Replied |
☐ |
|
reply_to_mode |
string |
Reply-To Mode |
☐ |
Thread: replies go to target document. Email: replies are routed to a given email. |
reply_to |
string |
Reply To |
☐ |
Preferred Reply-To Address |
sale_invoiced_amount |
int32 |
Invoiced Amount |
☐ |
|
sale_quotation_count |
int32 |
Quotation Count |
☐ |
|
schedule_date |
datetime |
Scheduled for |
☐ |
|
schedule_type |
string |
Schedule |
☑ |
|
scheduled |
int32 |
Scheduled |
☐ |
|
sent_date |
datetime |
Sent Date |
☐ |
|
sent |
int32 |
Sent |
☐ |
|
sms_allow_unsubscribe |
boolean |
Include opt-out link |
☐ |
|
sms_force_send |
boolean |
Send Directly |
☐ |
Immediately send the SMS Mailing instead of queuing up. Use at your own risk. |
sms_has_insufficient_credit |
boolean |
Insufficient IAP credits |
☐ |
|
sms_has_unregistered_account |
boolean |
Unregistered IAP account |
☐ |
|
sms_subject |
string |
Title |
☐ |
For an email, the subject your recipients will see in their inbox.For an SMS, the internal title of the message. |
sms_template_id_label |
string |
|
☐ |
|
sms_template_id |
string |
|
☐ |
|
source_id_label |
string |
|
☐ |
|
source_id |
string |
|
☐ |
|
state |
string |
Status |
☑ |
|
subject |
string |
Subject |
☑ |
|
total |
int32 |
Total |
☐ |
|
use_in_marketing_automation |
boolean |
Specific mailing used in marketing campaign |
☐ |
Marketing campaigns use mass mailings with some specific behavior; this field is used to indicate its statistics may be suspicious. |
use_leads |
boolean |
Use Leads |
☐ |
|
user_id_label |
string |
|
☐ |
|
user_id |
string |
|
☐ |
|
warning_message |
string |
Warning Message |
☐ |
Warning message displayed in the mailing form view |
website_message_ids |
string |
|
☐ |
Website communication history |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826