Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: mailing > Tables

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

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer