campaign: Odoo itgen_odoo_campaign
read only per partition
- Catalog:
Odoo - Schema:
marketing - Label: itgen_odoo_campaign
Marketing Campaign
Can only retrieve data.
Table Columns
The columns of the table campaign are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | 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 |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
crm_ |
int32 |
Leads/Opportunities count | |||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
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 |
Model Name | |||
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 |
Campaign Name | |||
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 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: