Navigation: Catalog: ActiveCampaign > Schemas > Schema: V3 > Tables

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
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	☑

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Please enable JavaScript to view this site.

ActiveCampaign API Data Model

Campaigns: ActiveCampaign Campaigns

Table Columns

Important Safety and Usage Information