invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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_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.
active boolean Active
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
completed_participant_count int32 # of completed participants
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
crm_lead_count int32 Leads/Opportunities count
currency_id varchar2
currency_id_label varchar2
display_name varchar2 Nome visualizzato
domain varchar2 Filter
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
last_sync_date datetime Last activities synchronization
link_tracker_click_count int32 # Clicks
mailing_filter_count int32 # Favorite Filters
mailing_filter_domain varchar2 Favorite filter domain
mailing_filter_id varchar2
mailing_filter_id_label varchar2
mailing_mail_count int32 Number of Mass Mailing
mailing_mail_ids varchar2
mailing_sms_count int32 # SMS Mailings
mailing_sms_ids varchar2
marketing_activity_ids varchar2
mass_mailing_count int32 # Mailings
model_id varchar2
model_id_label varchar2
model_name varchar2 Nome del modello
name varchar2 Campaign Identifier
opened_ratio int32 Opened Ratio
participant_ids varchar2
quotation_count int32 Quotation Count
received_ratio int32 Received Ratio
replied_ratio int32 Replied Ratio
require_sync boolean Sync of participants is required
running_participant_count int32 # of active participants
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
state varchar2 State
tag_ids varchar2
test_participant_count int32 # of test participants
title varchar2 Nome della campagna
total_participant_count int32 # of active and completed participants
unique_field_id 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_field_id_label 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_leads boolean Use Leads
user_id varchar2
user_id_label varchar2
utm_campaign_id varchar2
utm_campaign_id_label varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: