campaign: Odoo itgen_odoo_campaign
read only per partition
- Catálogo:
Odoo - Esquema:
utm - Etiqueta: itgen_odoo_campaign
UTM Campaign
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla campaign. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ab_ |
boolean |
A/B Testing Campaign Finished | |||
ab_ |
int32 |
A/B Test Mailings # | |||
ab_ |
int32 |
A/B Test Mailings SMS # | |||
ab_ |
datetime |
Send Final On | Date that will be used to know when to determine and send the winner mailing | ||
ab_ |
varchar2 |
SMS Winner Selection | |||
ab_ |
int32 |
Total A/B test percentage | |||
ab_ |
varchar2 |
Winner Selection | Selection to determine the winner mailing that will be sent. | ||
bounced_ |
int32 |
Bounced Ratio | |||
click_ |
int32 |
Number of clicks generated by the campaign | |||
color |
int32 |
Color Index | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
crm_ |
int32 |
Leads/Opportunities count | |||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
display_ |
varchar2 |
Nombre para mostrar | |||
id |
int32 |
ID | |||
invoiced_ |
int32 |
Revenues generated by the campaign | |||
is_ |
boolean |
Automatically Generated Campaign | Allows us to filter relevant Campaigns | ||
is_ |
boolean |
Is Mailing Campaign Activated | |||
mailing_ |
int32 |
Number of Mass Mailing | |||
mailing_ |
varchar2 |
||||
mailing_ |
int32 |
Number of Mass SMS | |||
mailing_ |
varchar2 |
||||
name |
varchar2 |
Campaign Identifier | |||
opened_ |
int32 |
Opened Ratio | |||
quotation_ |
int32 |
Quotation Count | |||
received_ |
int32 |
Received Ratio | |||
replied_ |
int32 |
Replied Ratio | |||
social_ |
int32 |
Number of interactions (likes, shares, comments ...) with the social posts | |||
social_ |
varchar2 |
||||
social_ |
int32 |
Social Media Posts | |||
social_ |
varchar2 |
||||
social_ |
int32 |
Number Of Push Notifications | |||
stage_ |
varchar2 |
||||
stage_ |
varchar2 |
||||
tag_ |
varchar2 |
||||
title |
varchar2 |
Nombre de la campaña | |||
use_ |
boolean |
Use Leads | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: