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  | 
string  | 
  | 
☑  | 
  | 
activerss_items  | 
int64  | 
  | 
☑  | 
  | 
activerss_url  | 
string  | 
  | 
☐  | 
  | 
addressid  | 
int64  | 
Address ID  | 
☑  | 
  | 
analytics_campaign_name  | 
string  | 
Analytics Campaign Name  | 
☐  | 
  | 
automation  | 
int64  | 
Automation  | 
☐  | 
  | 
basemessageid  | 
int64  | 
Base Message ID  | 
☑  | 
  | 
basetemplateid  | 
string  | 
Base Template ID  | 
☑  | 
  | 
bounceid  | 
int64  | 
Bounce ID  | 
☑  | 
  | 
cdate  | 
datetime  | 
Created  | 
☑  | 
  | 
deletestamp  | 
datetime  | 
Deleted  | 
☐  | 
  | 
embed_images  | 
int64  | 
Embed Images  | 
☑  | 
  | 
int64  | 
☑  | 
  | 
||
formid  | 
int64  | 
Form ID  | 
☑  | 
  | 
forwards  | 
int64  | 
  | 
☑  | 
  | 
hardbounces  | 
int64  | 
  | 
☑  | 
  | 
htmlunsub  | 
string  | 
  | 
☑  | 
  | 
htmlunsubdata  | 
int64  | 
  | 
☐  | 
  | 
id  | 
int64  | 
ID  | 
☑  | 
  | 
ip4  | 
int64  | 
IPv4 Address  | 
☑  | 
  | 
laststep  | 
string  | 
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  | 
string  | 
Name  | 
☑  | 
  | 
opens  | 
int64  | 
Number of Opens  | 
☑  | 
  | 
public  | 
int64  | 
Public  | 
☑  | 
  | 
realcid  | 
int64  | 
Real CID  | 
☑  | 
  | 
recurring  | 
string  | 
Recurring  | 
☑  | 
  | 
reminder_field  | 
string  | 
  | 
☑  | 
  | 
reminder_format  | 
string  | 
  | 
☐  | 
  | 
reminder_last_cron_run  | 
string  | 
  | 
☐  | 
  | 
reminder_offset_sign  | 
string  | 
  | 
☑  | 
  | 
reminder_offset_type  | 
string  | 
  | 
☑  | 
  | 
reminder_offset  | 
int64  | 
  | 
☑  | 
  | 
reminder_type  | 
string  | 
  | 
☑  | 
  | 
replies  | 
int64  | 
Replies  | 
☑  | 
  | 
replysys  | 
int64  | 
  | 
☑  | 
  | 
responder_existing  | 
int64  | 
  | 
☑  | 
  | 
responder_offset  | 
int64  | 
  | 
☑  | 
  | 
responder_type  | 
string  | 
  | 
☑  | 
  | 
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  | 
string  | 
Source  | 
☑  | 
  | 
split_content  | 
int64  | 
Split Content  | 
☑  | 
  | 
split_offset_type  | 
string  | 
Split Offset Type  | 
☐  | 
  | 
split_offset  | 
int64  | 
Split Offset  | 
☑  | 
  | 
split_type  | 
string  | 
Split Type  | 
☐  | 
  | 
split_winner_awaiting  | 
int64  | 
  | 
☑  | 
  | 
split_winner_messageid  | 
int64  | 
  | 
☑  | 
  | 
status  | 
int64  | 
Status  | 
☑  | 
  | 
subscriberclicks  | 
int64  | 
Subscriber Clicks  | 
☑  | 
  | 
survey  | 
string  | 
Survey  | 
☐  | 
  | 
textunsub  | 
string  | 
  | 
☑  | 
  | 
textunsubdata  | 
int64  | 
  | 
☐  | 
  | 
threadid  | 
int64  | 
Thread ID  | 
☑  | 
  | 
total_amt  | 
int64  | 
Total Amount  | 
☑  | 
  | 
tracklinks  | 
string  | 
Track Links  | 
☑  | 
  | 
tracklinksanalytics  | 
int64  | 
Track Link Analytics  | 
☑  | 
  | 
trackreads  | 
int64  | 
Track Reads  | 
☑  | 
  | 
trackreadsanalytics  | 
int64  | 
Track Reads Analytics  | 
☑  | 
  | 
tweet  | 
int64  | 
Tweet  | 
☑  | 
  | 
type  | 
string  | 
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  | 
☑  | 
  | 
22-12-2022 20:43 Version 22.1.101-BETA+3681
ActiveCampaign API Data Model