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