---
title: "Campaigns (ActiveCampaign)"
description: "Campaigns"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/activecampaign/ActiveCampaign.V3.Campaigns
original: https://documentation.invantive.eu/en/datamodels/activecampaign/ActiveCampaign.V3.Campaigns
updated: 2026-11-01T17:44:09Z
license: https://documentation.invantive.eu/en/
---

# Campaigns: ActiveCampaign Campaigns

`delete` `REST`

- Catalog: `ActiveCampaign`
- Schema: `V3`
- Primary Keys: `id`
- Label: Campaigns

Can retrieve data and change data using `delete`.

## API Source

- Endpoint: `/campaigns`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 247 |
| Full scan rows per minute | 4,860 |

The result can be cached on the client.

## 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 | Marks | Documentation |
|---|---|---|:---:|---|---|
| `activerss_interval` | `varchar2` | Active RSS Interval | [x] | filters on the platform, writable |  |
| `activerss_items` | `int64` | Active RSS Items | [x] | filters on the platform, writable |  |
| `activerss_url` | `varchar2` | Active RSS URL | [ ] | filters on the platform, writable |  |
| `addressid` | `int64` | Address ID | [x] | filters on the platform, writable |  |
| `analytics_campaign_name` | `varchar2` | Analytics Campaign Name | [ ] | filters on the platform, writable |  |
| `automation` | `int64` | Automation | [ ] | filters on the platform, writable |  |
| `basemessageid` | `int64` | Base Message ID | [x] | filters on the platform, writable |  |
| `basetemplateid` | `varchar2` | Base Template ID | [x] | filters on the platform, writable |  |
| `bounceid` | `int64` | Bounce ID | [x] | filters on the platform, writable |  |
| `cdate` | `datetime` | Created | [x] | filters on the platform, writable, computed |  |
| `deletestamp` | `datetime` | Deleted | [ ] | filters on the platform, writable |  |
| `embed_images` | `int64` | Embed Images | [x] | filters on the platform, writable |  |
| `facebook` | `int64` | Facebook | [x] | filters on the platform, writable |  |
| `formid` | `int64` | Form ID | [x] | filters on the platform, writable |  |
| `forwards` | `int64` | Forwards | [x] | filters on the platform, writable |  |
| `hardbounces` | `int64` | Hard Bounces | [x] | filters on the platform, writable |  |
| `htmlunsub` | `varchar2` | HTML Unsubscribe | [x] | filters on the platform, writable |  |
| `htmlunsubdata` | `int64` | HTML Unsubscribe Data | [ ] | filters on the platform, writable |  |
| `id` | `int64` | ID | [x] | filters on the platform, writable, computed |  |
| `ip4` | `int64` | IPv4 Address | [x] | filters on the platform, writable |  |
| `laststep` | `varchar2` | Last Step | [ ] | filters on the platform, writable |  |
| `ldate` | `datetime` | itgen_acn_ldate | [ ] | filters on the platform, writable |  |
| `linkclicks` | `int64` | Link Clicks | [x] | filters on the platform, writable |  |
| `mail_cleanup` | `int64` | Mail Cleanup | [x] | filters on the platform, writable |  |
| `mail_send` | `int64` | Mail Send | [x] | filters on the platform, writable |  |
| `mail_transfer` | `int64` | Mail Transfer | [x] | filters on the platform, writable |  |
| `mailer_log_file` | `int64` | Mailer Log File | [x] | filters on the platform, writable |  |
| `managetext` | `int64` | Manage Text | [x] | filters on the platform, writable |  |
| `mdate` | `datetime` | Last Modified | [ ] | filters on the platform, writable, computed |  |
| `name` | `varchar2` | Name | [x] | filters on the platform, writable |  |
| `opens` | `int64` | Number of Opens | [x] | filters on the platform, writable |  |
| `public` | `int64` | Public | [x] | filters on the platform, writable |  |
| `realcid` | `int64` | Real CID | [x] | filters on the platform, writable |  |
| `recurring` | `varchar2` | Recurring | [x] | filters on the platform, writable |  |
| `reminder_field` | `varchar2` | Reminder Field | [x] | filters on the platform, writable |  |
| `reminder_format` | `varchar2` | Reminder Format | [ ] | filters on the platform, writable |  |
| `reminder_last_cron_run` | `varchar2` | Reminder Last Cron Run | [ ] | filters on the platform, writable |  |
| `reminder_offset` | `int64` | Reminder Offset | [x] | filters on the platform, writable |  |
| `reminder_offset_sign` | `varchar2` | Reminder Offset Sign | [x] | filters on the platform, writable |  |
| `reminder_offset_type` | `varchar2` | Reminder Offset Type | [x] | filters on the platform, writable |  |
| `reminder_type` | `varchar2` | Reminder Type | [x] | filters on the platform, writable |  |
| `replies` | `int64` | Replies | [x] | filters on the platform, writable |  |
| `replysys` | `int64` | Reply System | [x] | filters on the platform, writable |  |
| `responder_existing` | `int64` | Responder Existing | [x] | filters on the platform, writable |  |
| `responder_offset` | `int64` | Responder Offset | [x] | filters on the platform, writable |  |
| `responder_type` | `varchar2` | Responder Type | [x] | filters on the platform, writable |  |
| `schedule` | `int64` | Schedule | [x] | filters on the platform, writable |  |
| `scheduleddate` | `datetime` | Scheduled Date | [ ] | filters on the platform, writable |  |
| `sdate` | `datetime` | itgen_acn_sdate | [ ] | filters on the platform, writable |  |
| `segmentid` | `int64` | Segment ID | [x] | filters on the platform, writable |  |
| `send_amt` | `int64` | Send Amount | [x] | filters on the platform, writable |  |
| `sendid` | `int64` | Sender ID | [x] | filters on the platform, writable |  |
| `seriesid` | `int64` | Series ID | [x] | filters on the platform, writable |  |
| `socialshares` | `int64` | Social Shares | [x] | filters on the platform, writable |  |
| `softbounces` | `int64` | Soft Bounces | [x] | filters on the platform, writable |  |
| `source` | `varchar2` | Source | [x] | filters on the platform, writable |  |
| `split_content` | `int64` | Split Content | [x] | filters on the platform, writable |  |
| `split_offset` | `int64` | Split Offset | [x] | filters on the platform, writable |  |
| `split_offset_type` | `varchar2` | Split Offset Type | [ ] | filters on the platform, writable |  |
| `split_type` | `varchar2` | Split Type | [ ] | filters on the platform, writable |  |
| `split_winner_awaiting` | `int64` | Split Winner Awaiting | [x] | filters on the platform, writable |  |
| `split_winner_messageid` | `int64` | Split Winner Message ID | [x] | filters on the platform, writable |  |
| `status` | `int64` | Status | [x] | filters on the platform, writable |  |
| `subscriberclicks` | `int64` | Subscriber Clicks | [x] | filters on the platform, writable |  |
| `survey` | `varchar2` | Survey | [ ] | filters on the platform, writable |  |
| `textunsub` | `varchar2` | Text Unsubscribe | [x] | filters on the platform, writable |  |
| `textunsubdata` | `int64` | Text Unsubscribe Data | [ ] | filters on the platform, writable |  |
| `threadid` | `int64` | Thread ID | [x] | filters on the platform, writable |  |
| `total_amt` | `int64` | Total Amount | [x] | filters on the platform, writable |  |
| `tracklinks` | `varchar2` | Track Links | [x] | filters on the platform, writable |  |
| `tracklinksanalytics` | `int64` | Track Link Analytics | [x] | filters on the platform, writable |  |
| `trackreads` | `int64` | Track Reads | [x] | filters on the platform, writable |  |
| `trackreadsanalytics` | `int64` | Track Reads Analytics | [x] | filters on the platform, writable |  |
| `tweet` | `int64` | Tweet | [x] | filters on the platform, writable |  |
| `type` | `varchar2` | Type | [x] | filters on the platform, writable |  |
| `uniqueforwards` | `int64` | Unique Forwards | [x] | filters on the platform, writable |  |
| `uniquelinkclicks` | `int64` | Unique Link Clicks | [x] | filters on the platform, writable |  |
| `uniqueopens` | `int64` | Unique Opens | [x] | filters on the platform, writable |  |
| `uniquereplies` | `int64` | Unique Replies | [x] | filters on the platform, writable |  |
| `unsubreasons` | `int64` | Unsubscription Reasons | [x] | filters on the platform, writable |  |
| `unsubscribes` | `int64` | Unsubscribes | [x] | filters on the platform, writable |  |
| `updates` | `int64` | Updates | [x] | filters on the platform, writable |  |
| `user` | `int64` | User | [x] | filters on the platform, writable |  |
| `userid` | `int64` | User ID | [x] | filters on the platform, writable |  |
| `waitpreview` | `int64` | Wait Preview | [x] | filters on the platform, writable |  |
| `willrecur` | `int64` | Will Recur | [x] | filters on the platform, writable |  |



## Release Notes

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

- [ActiveCampaign](/en/release-notes/drivers?driver=activecampaign)

### Changes of This Table, 26.0 to 27.0

<div class="rn-item" id="ACN-27.0-C005">

##### ActiveCampaign.V3.Campaigns can no longer insert

The driver no longer supports insert on ActiveCampaign.V3.Campaigns. The capability never worked in 26.0, so no working statement is affected.

<div class="rn-chips">

- `true` &rarr; `false`
- importance 2

</div>

</div>

<div class="rn-item" id="ACN-27.0-C006">

##### ActiveCampaign.V3.Campaigns can no longer update

The driver no longer supports update on ActiveCampaign.V3.Campaigns. The capability never worked in 26.0, so no working statement is affected.

<div class="rn-chips">

- `true` &rarr; `false`
- importance 2

</div>

</div>

[All changes of the driver, 26.0 to 27.0](/en/release-notes/drivers?driver=activecampaign&step=26.0-to-27.0#activecampaign-26.0-to-27.0)

