campaign: Odoo itgen_odoo_campaign
read only per partition
- Catalogo:
Odoo - Schema:
marketing - Etichetta: itgen_odoo_campaign
Marketing Campaign
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella campaign. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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. | ||
active |
boolean |
Active | |||
bounced_ |
int32 |
Bounced Ratio | |||
click_ |
int32 |
Number of clicks generated by the campaign | |||
color |
int32 |
Color Index | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
completed_ |
int32 |
# of completed participants | |||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
crm_ |
int32 |
Leads/Opportunities count | |||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
display_ |
varchar2 |
Nome visualizzato | |||
domain |
varchar2 |
Filter | |||
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 | |||
last_ |
datetime |
Last activities synchronization | |||
link_ |
int32 |
# Clicks | |||
mailing_ |
int32 |
# Favorite Filters | |||
mailing_ |
varchar2 |
Favorite filter domain | |||
mailing_ |
varchar2 |
||||
mailing_ |
varchar2 |
||||
mailing_ |
int32 |
Number of Mass Mailing | |||
mailing_ |
varchar2 |
||||
mailing_ |
int32 |
# SMS Mailings | |||
mailing_ |
varchar2 |
||||
marketing_ |
varchar2 |
||||
mass_ |
int32 |
# Mailings | |||
model_ |
varchar2 |
||||
model_ |
varchar2 |
||||
model_ |
varchar2 |
Nome del modello | |||
name |
varchar2 |
Campaign Identifier | |||
opened_ |
int32 |
Opened Ratio | |||
participant_ |
varchar2 |
||||
quotation_ |
int32 |
Quotation Count | |||
received_ |
int32 |
Received Ratio | |||
replied_ |
int32 |
Replied Ratio | |||
require_ |
boolean |
Sync of participants is required | |||
running_ |
int32 |
# of active participants | |||
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 |
||||
state |
varchar2 |
State | |||
tag_ |
varchar2 |
||||
test_ |
int32 |
# of test participants | |||
title |
varchar2 |
Nome della campagna | |||
total_ |
int32 |
# of active and completed participants | |||
unique_ |
varchar2 |
Used to avoid duplicates based on model field. e.g. For model 'Customers', select email field here if you don't want to process records which have the same email address | |||
unique_ |
varchar2 |
Used to avoid duplicates based on model field. e.g. For model 'Customers', select email field here if you don't want to process records which have the same email address | |||
use_ |
boolean |
Use Leads | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
utm_ |
varchar2 |
||||
utm_ |
varchar2 |
||||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: