# Campaigns: ActiveCampaign Campaigns
- Catalog: `ActiveCampaign`
- Schema: `V3`
- Primary Keys: `id`
- Label: Campaigns
Can retrieve data and change data using insert, update and delete.
## Table Columns
The columns of the table `Campaigns` 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 | Documentation |
|---|:---:|---|:---:|---|
| `activerss_interval` | `varchar2` | | ☑ | |
| `activerss_items` | `int64` | | ☑ | |
| `activerss_url` | `varchar2` | | ☐ | |
| `addressid` | `int64` | Address ID | ☑ | |
| `analytics_campaign_name` | `varchar2` | Analytics Campaign Name | ☐ | |
| `automation` | `int64` | Automation | ☐ | |
| `basemessageid` | `int64` | Base Message ID | ☑ | |
| `basetemplateid` | `varchar2` | Base Template ID | ☑ | |
| `bounceid` | `int64` | Bounce ID | ☑ | |
| `cdate` | `datetime` | Created | ☑ | |
| `deletestamp` | `datetime` | Deleted | ☐ | |
| `embed_images` | `int64` | Embed Images | ☑ | |
| `facebook` | `int64` | Facebook | ☑ | |
| `formid` | `int64` | Form ID | ☑ | |
| `forwards` | `int64` | | ☑ | |
| `hardbounces` | `int64` | | ☑ | |
| `htmlunsub` | `varchar2` | | ☑ | |
| `htmlunsubdata` | `int64` | | ☐ | |
| `id` | `int64` | ID | ☑ | |
| `ip4` | `int64` | IPv4 Address | ☑ | |
| `laststep` | `varchar2` | Last Step | ☐ | |
| `ldate` | `datetime` | | ☐ | |
| `linkclicks` | `int64` | Link Clicks | ☑ | |
| `mail_cleanup` | `int64` | Mail Cleanup | ☑ | |
| `mail_send` | `int64` | Mail Send | ☑ | |
| `mail_transfer` | `int64` | Mail Transfer | ☑ | |
| `mailer_log_file` | `int64` | Mailer Log File | ☑ | |
| `managetext` | `int64` | Manage Text | ☑ | |
| `mdate` | `datetime` | Last Modified | ☐ | |
| `name` | `varchar2` | Name | ☑ | |
| `opens` | `int64` | Number of Opens | ☑ | |
| `public` | `int64` | Public | ☑ | |
| `realcid` | `int64` | Real CID | ☑ | |
| `recurring` | `varchar2` | Recurring | ☑ | |
| `reminder_field` | `varchar2` | | ☑ | |
| `reminder_format` | `varchar2` | | ☐ | |
| `reminder_last_cron_run` | `varchar2` | | ☐ | |
| `reminder_offset_sign` | `varchar2` | | ☑ | |
| `reminder_offset_type` | `varchar2` | | ☑ | |
| `reminder_offset` | `int64` | | ☑ | |
| `reminder_type` | `varchar2` | | ☑ | |
| `replies` | `int64` | Replies | ☑ | |
| `replysys` | `int64` | | ☑ | |
| `responder_existing` | `int64` | | ☑ | |
| `responder_offset` | `int64` | | ☑ | |
| `responder_type` | `varchar2` | | ☑ | |
| `schedule` | `int64` | Schedule | ☑ | |
| `scheduleddate` | `datetime` | Scheduled Date | ☐ | |
| `sdate` | `datetime` | | ☐ | |
| `segmentid` | `int64` | Segment ID | ☑ | |
| `send_amt` | `int64` | Send Amount | ☑ | |
| `sendid` | `int64` | | ☑ | |
| `seriesid` | `int64` | Series ID | ☑ | |
| `socialshares` | `int64` | Social Shares | ☑ | |
| `softbounces` | `int64` | Soft Bounces | ☑ | |
| `source` | `varchar2` | Source | ☑ | |
| `split_content` | `int64` | Split Content | ☑ | |
| `split_offset_type` | `varchar2` | Split Offset Type | ☐ | |
| `split_offset` | `int64` | Split Offset | ☑ | |
| `split_type` | `varchar2` | Split Type | ☐ | |
| `split_winner_awaiting` | `int64` | | ☑ | |
| `split_winner_messageid` | `int64` | | ☑ | |
| `status` | `int64` | Status | ☑ | |
| `subscriberclicks` | `int64` | Subscriber Clicks | ☑ | |
| `survey` | `varchar2` | Survey | ☐ | |
| `textunsub` | `varchar2` | | ☑ | |
| `textunsubdata` | `int64` | | ☐ | |
| `threadid` | `int64` | Thread ID | ☑ | |
| `total_amt` | `int64` | Total Amount | ☑ | |
| `tracklinks` | `varchar2` | Track Links | ☑ | |
| `tracklinksanalytics` | `int64` | Track Link Analytics | ☑ | |
| `trackreads` | `int64` | Track Reads | ☑ | |
| `trackreadsanalytics` | `int64` | Track Reads Analytics | ☑ | |
| `tweet` | `int64` | Tweet | ☑ | |
| `type` | `varchar2` | Type | ☑ | |
| `uniqueforwards` | `int64` | Unique Forwards | ☑ | |
| `uniquelinkclicks` | `int64` | Unique Link Clicks | ☑ | |
| `uniqueopens` | `int64` | Unique Opens | ☑ | |
| `uniquereplies` | `int64` | Unique Replies | ☑ | |
| `unsubreasons` | `int64` | Unsubscription Reasons | ☑ | |
| `unsubscribes` | `int64` | Unsubscribes | ☑ | |
| `updates` | `int64` | Updates | ☑ | |
| `user` | `int64` | User | ☑ | |
| `userid` | `int64` | User ID | ☑ | |
| `waitpreview` | `int64` | Wait Preview | ☑ | |
| `willrecur` | `int64` | Will Recur | ☑ | |