Campaigns
Query the campaigns information in ActiveCampaign.
Table Specific Information
Select
The connector 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. |