invantive documentation
Invantive Support ForumsLog In / Sign Up

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_testing_completed boolean A/B Testing Campaign Finished
ab_testing_mailings_count int32 A/B Test Mailings #
ab_testing_mailings_sms_count int32 A/B Test Mailings SMS #
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 varchar2 SMS Winner Selection
ab_testing_total_pc int32 Total A/B test percentage
ab_testing_winner_selection varchar2 Winner Selection Selection to determine the winner mailing that will be sent.
bounced_ratio int32 Bounced Ratio
click_count int32 Number of clicks generated by the campaign
color int32 Color Index
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
crm_lead_count int32 Leads/Opportunities count
currency_id varchar2
currency_id_label varchar2
display_name varchar2 Display Name
id int32 ID
invoiced_amount int32 Revenues generated by the campaign
is_auto_campaign boolean Automatically Generated Campaign Allows us to filter relevant Campaigns
is_mailing_campaign_activated boolean Is Mailing Campaign Activated
mailing_mail_count int32 Number of Mass Mailing
mailing_mail_ids varchar2
mailing_sms_count int32 Number of Mass SMS
mailing_sms_ids varchar2
name varchar2 Campaign Identifier
opened_ratio int32 Opened Ratio
quotation_count int32 Quotation Count
received_ratio int32 Received Ratio
replied_ratio int32 Replied Ratio
social_engagement int32 Number of interactions (likes, shares, comments ...) with the social posts
social_post_ids varchar2
social_posts_count int32 Social Media Posts
social_push_notification_ids varchar2
social_push_notifications_count int32 Number Of Push Notifications
stage_id varchar2
stage_id_label varchar2
tag_ids varchar2
title varchar2 Campaign Name
use_leads boolean Use Leads
user_id varchar2
user_id_label varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: