---
title: "campaign (Odoo)"
description: "itgen_odoo_campaign"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.marketing.campaign
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.marketing.campaign
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# 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_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` | 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 | [ ] |  |  |
| `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` | Model Name | [ ] |  |  |
| `name` | `varchar2` | Campaign Identifier | [x] |  |  |
| `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` | Campaign Name | [x] |  |  |
| `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` |  | [ ] |  |  |



## Release Notes

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

- [Odoo](/en/release-notes/drivers?driver=odoo)

