Campaigns
Query the campaigns information in ActiveCampaign.
Table Specific Information
Select
The add-in uses the ActiveCampaign API to process some of the filters.
For example, the following query is processed server side:
SELECT * FROM Campaigns WHERE Id = 10003
Columns
| Name | Type | Description |
| Id [KEY] | String | The Id column of the Campaigns table. |
| ActiveRssInterval | String | The ActiveRssInterval column of the Campaigns table. |
| ActiveRssItems | String | The ActiveRssItems column of the Campaigns table. |
| ActiveRssUrl | String | The ActiveRssUrl column of the Campaigns table. |
| AddressId | String | The AddressId column of the Campaigns table. |
| AnalyticsCampaignName | String | The AnalyticsCampaignName column of the Campaigns table. |
| Automation | String | The Automation column of the Campaigns table. |
| BaseMessageId | String | The BaseMessageId column of the Campaigns table. |
| BaseTemplateId | String | The BaseTemplateId column of the Campaigns table. |
| BounceId | String | The BounceId column of the Campaigns table. |
| CanSkipApproval | String | The can_skip_approval column of the Campaigns table. |
| Cdate | Datetime | The Cdate column of the Campaigns table. |
| CreatedBy | String | The Created By column of the Campaigns table. |
| CreatedTimestamp | Datetime | The Created Timestamp column of the Campaigns table. |
| DeleteStamp | String | The DeleteStamp column of the Campaigns table. |
| EmbedImages | String | The EmbedImages column of the Campaigns table. |
| String | The Facebook column of the Campaigns table. | |
| FormId | String | The FormId column of the Campaigns table. |
| Forwards | String | The Forwards column of the Campaigns table. |
| HardBounces | String | The HardBounces column of the Campaigns table. |
| HasPredictiveContent | Bit | The HasPredictiveContent column of the Campaigns table. |
| HtmlUnsub | String | The HtmlUnsub column of the Campaigns table. |
| HtmlUnsubdata | String | The HtmlUnsubdata column of the Campaigns table. |
| Ip | String | The Ip column of the Campaigns table. |
| Ip4 | String | The Ip4 column of the Campaigns table. |
| LastStep | String | The LastStep column of the Campaigns table. |
| Ldate | String | The Ldate column of the Campaigns table. |
| LinkClicks | String | The LinkClicks column of the Campaigns table. |
| AutomationLink | String | The AutomationLink column of the Campaigns table. |
| CampaignAggregateRevenuesLink | String | The AggregateRevenues column of the Campaigns table. |
| CampaignListsLink | String | The CampaignListsLink column of the Campaigns table. |
| CampaignMessageLink | String | The CampaignMessageLink column of the Campaigns table. |
| CampaignMessagesLink | String | The CampaignMessagesLink column of the Campaigns table. |
| LinksLink | String | The LinksLink column of the Campaigns table. |
| LinksSegment | String | The Segment column of the Campaigns table. |
| UserLink | String | The UserLink column of the Campaigns table. |
| MailCleanup | String | The MailCleanup column of the Campaigns table. |
| MailSend | String | The MailSend column of the Campaigns table. |
| MailTransfer | String | The MailTransfer column of the Campaigns table. |
| MailerLogFile | String | The MailerLogFile column of the Campaigns table. |
| ManageText | String | The ManageText column of the Campaigns table. |
| Mdate | Datetime | The Mdate column of the Campaigns table. |
| Name | String | The Name column of the Campaigns table. |
| Opens | String | The Opens column of the Campaigns table. |
| Public | String | The Public column of the Campaigns table. |
| RealCid | String | The RealCid column of the Campaigns table. |
| Recurring | String | The Recurring column of the Campaigns table. |
| ReminderField | String | The ReminderField column of the Campaigns table. |
| ReminderFormat | String | The ReminderFormat column of the Campaigns table. |
| ReminderLastCronRun | String | The ReminderLastCronRun column of the Campaigns table. |
| ReminderOffset | String | The ReminderOffset column of the Campaigns table. |
| ReminderOffsetSign | String | The ReminderOffsetSign column of the Campaigns table. |
| ReminderOffsetType | String | The ReminderOffsetType column of the Campaigns table. |
| ReminderType | String | The ReminderType column of the Campaigns table. |
| Replies | String | The Replies column of the Campaigns table. |
| ReplySys | String | The ReplySys column of the Campaigns table. |
| ResponderExisting | String | The ResponderExisting column of the Campaigns table. |
| ResponderOffset | String | The ResponderOffset column of the Campaigns table. |
| ResponderType | String | The ResponderType column of the Campaigns table. |
| Schedule | String | The Schedule column of the Campaigns table. |
| ScheduledDate | String | The ScheduledDate column of the Campaigns table. |
| Screenshot | String | The Screenshot column of the Campaigns table. |
| Sdate | String | The Sdate column of the Campaigns table. |
| SegmentId | String | The SegmentId column of the Campaigns table. |
| SegmentName | String | The SegmentName column of the Campaigns table. |
| SendAmt | String | The SendAmt column of the Campaigns table. |
| SendId | String | The SendId column of the Campaigns table. |
| SeriesId | String | The SeriesId column of the Campaigns table. |
| Series Send Lock Time | String | The SeriesSendLockTime column of the Campaigns table. |
| SocialShares | String | The SocialShares column of the Campaigns table. |
| SoftBounces | String | The SoftBounces column of the Campaigns table. |
| Source | String | The Source column of the Campaigns table. |
| SplitContent | String | The SplitContent column of the Campaigns table. |
| SplitOffset | String | The SplitOffset column of the Campaigns table. |
| SplitOffsetType | String | The SplitOffsetType column of the Campaigns table. |
| SplitType | String | The SplitType column of the Campaigns table. |
| SplitWinnerAwaiting | String | The SplitWinnerAwaiting column of the Campaigns table. |
| SplitWinnerMessageId | String | The SplitWinnerMessageId column of the Campaigns table. |
| Status | String | The Status column of the Campaigns table. |
| SubscriberClicks | String | The SubscriberClicks column of the Campaigns table. |
| Survey | String | The Survey column of the Campaigns table. |
| TextUnsub | String | The TextUnsub column of the Campaigns table. |
| TextUnsubData | String | The TextUnsubData column of the Campaigns table. |
| ThreadId | String | The ThreadId column of the Campaigns table. |
| TotalAmt | String | The TotalAmt column of the Campaigns table. |
| TrackLinks | String | The TrackLinks column of the Campaigns table. |
| TrackLinksAnalytics | String | The TrackLinksAnalytics column of the Campaigns table. |
| TrackReads | String | The TrackReads column of the Campaigns table. |
| TrackReadsAnalytics | String | The TrackReadsAnalytics column of the Campaigns table. |
| Tweet | String | The Tweet column of the Campaigns table. |
| Type | String | The Type column of the Campaigns table. |
| UniqueForwards | String | The UniqueForwards column of the Campaigns table. |
| UniqueLinkClicks | String | The UniqueLinkClicks column of the Campaigns table. |
| UniqueOpens | String | The UniqueOpens column of the Campaigns table. |
| UniqueReplies | String | The UniqueReplies column of the Campaigns table. |
| UnsubReasons | String | The UnsubReasons column of the Campaigns table. |
| Unsubscribes | String | The Unsubscribes column of the Campaigns table. |
| Updated By | String | The UpdatedBy column of the Campaigns table. |
| Updated Timestamp | String | The UpdatedTimestamp column of the Campaigns table. |
| Updates | String | The Updates column of the Campaigns table. |
| User | String | The User column of the Campaigns table. |
| UserId | String | The UserId column of the Campaigns table. |
| WaitPreview | String | The WaitPreview column of the Campaigns table. |
| WillRecur | String | The WillRecur column of the Campaigns table. |