campaign: Odoo itgen_odoo_campaign
read only per partition
- Catalog:
Odoo - Schema:
utm - Label: itgen_odoo_campaign
UTM 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. | ||
bounced_ |
int32 |
Bounced Ratio | |||
click_ |
int32 |
Number of clicks generated by the campaign | |||
color |
int32 |
Color Index | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
crm_ |
int32 |
Leads/Opportunities count | |||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
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 |
Campaign Name | |||
use_ |
boolean |
Use Leads | |||
user_ |
varchar2 |
||||
user_ |
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: