invantive documentation
Invantive SupportforenAnmelden / Eintragen

ActiveCampaign Data Model

Diese Seite ist in Ihrer Sprache noch nicht verfügbar; es wird die Originalversion angezeigt.

ActiveCampaign is cloud software to automate the marketing, sales and support process of prospects, leads and customers. ActiveCampaign includes email campaigns, sales management, website integration, chat and advanced automatic workflows.

Authentication Authentication can be done using using a token. An API token can be generated from the ActiveCampaign menu: 'Settings' > 'Developer' > 'Key', as described on https://developers.activecampaign.com/reference#authentication.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/activecampaign

Text comparisons on this platform are case sensitive.

Platform

  • Used from: Invantive Cloud and the Invantive products on your own computer or server.
  • Kind: an application reached over its API.
  • The data is partitioned, such as per company or administration.
  • Data can be written as well as read.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.activecampaign.com/.

Figures

Figure Count
Tables 100
Columns 1,738
Tables with insert 46
Tables with update 31
Tables with delete 38
Tables documented 7

Poster zum Daten Muster

PDF, 1 A0-Blatt

Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.

ActiveCampaign Daten Muster, Seite 1 von 1ActiveCampaign Daten Musterzur Verwendung mit Invantive UniversalSQLVeröffentlichung 27.1.3-BETA+6294 · 01-11-2026V3 · Accounts · V3 · Connections · V3 · CustomFieldsSeite 1 von 1 · documentation.invantive.euV3 · Accounts×2ActiveCampaign.V3.AccountCustomFieldValues: Account Custom Field ValuesAccountCustomFieldValuesActiveCampaign.V3.AccountCustomFields: Account Custom FieldsAccountCustomFieldsActiveCampaign.V3.AccountWithCustomFieldValues: Account Custom FieldsAccountWithCustomFieldValuesActiveCampaign.V3.Accounts: AccountsAccountsActiveCampaign.V3.Associations: Account ContactsAssociationsActiveCampaign.V3.Automations: AutomationsAutomationsActiveCampaign.V3.ContactAutomations: Contact AutomationsContactAutomationsActiveCampaign.V3.ContactWithAccountContacts: Contact with Account ContactsContactWithAccountContactsActiveCampaign.V3.ContactWithTags: Contact TagsContactWithTagsActiveCampaign.V3.DealCustomFieldValues: Deal Custom Field ValuesDealCustomFieldValuesActiveCampaign.V3.DealCustomFields: Deal Custom FieldsDealCustomFieldsActiveCampaign.V3.DealWithActivities: Deal ActivitiesDealWithActivitiesActiveCampaign.V3.Deals: DealsDealsActiveCampaign.V3.PipelineWithStages: Pipeline with StagesPipelineWithStagesActiveCampaign.V3.Pipelines: PipelinesPipelinesActiveCampaign.V3.SecondaryContacts: Secondary ContactsSecondaryContactsActiveCampaign.V3.Stages: StagesStagesActiveCampaign.V3.Tags: TagsTagsActiveCampaign.V3.TaskTypes: Task TypesTaskTypesActiveCampaign.V3.Tasks: TasksTasksActiveCampaign.V3.Users: UsersUsersV3 · ConnectionsActiveCampaign.V3.Connections: ConnectionsConnectionsActiveCampaign.V3.eComCustomers: eCommerce CustomerseComCustomersActiveCampaign.V3.eComOrderProducts: eCommerce Order ProductseComOrderProductsActiveCampaign.V3.eComOrders: eCommerce OrderseComOrdersV3 · CustomFieldsActiveCampaign.V3.ContactWithCustomFieldValues: Contact Custom FieldsContactWithCustomFieldValuesActiveCampaign.V3.CustomFieldOptions: Custom Field OptionsCustomFieldOptionsActiveCampaign.V3.CustomFieldValues: Custom Field ValuesCustomFieldValuesActiveCampaign.V3.CustomFields: Custom FieldsCustomFieldsCustomObjectsActiveCampaign.CustomObjects.AccountMyTags: Account My TagsAccountMyTagsActiveCampaign.CustomObjects.BrowseAbandonments: Browse AbandonmentsBrowseAbandonmentsActiveCampaign.CustomObjects.ContactCars: Contact CarsContactCarsActiveCampaign.CustomObjects.DealMyTags: Deal My TagsDealMyTagsActiveCampaign.CustomObjects.Orders: OrdersOrdersActiveCampaign.CustomObjects.Products: ProductsProductsActiveCampaign.CustomObjects.RecurringPayments: Recurring PaymentsRecurringPaymentsNativeActiveCampaign.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSV3ActiveCampaign.V3.Addresses: AddressesAddressesActiveCampaign.V3.Brandings: BrandingsBrandingsActiveCampaign.V3.Calendars: CalendarsCalendarsActiveCampaign.V3.Campaigns: CampaignsCampaignsActiveCampaign.V3.ContactWithBounceLogs: Contact Bounce LogsContactWithBounceLogsActiveCampaign.V3.ContactWithScoreValues: Contact with Score ValuesContactWithScoreValuesActiveCampaign.V3.CustomFieldRelations: Custom Field RelationsCustomFieldRelationsActiveCampaign.V3.CustomObjectSchemas: Custom Object SchemasCustomObjectSchemasActiveCampaign.V3.DealRoles: Deal RolesDealRolesActiveCampaign.V3.DealWithContacts: Deal ContactsDealWithContactsActiveCampaign.V3.DealWithNotes: Deal NotesDealWithNotesActiveCampaign.V3.DealWithTasks: Deal TasksDealWithTasksActiveCampaign.V3.EmailActivities: Email ActivitiesEmailActivitiesActiveCampaign.V3.EventTracking: Event TrackingEventTrackingActiveCampaign.V3.Events: EventsEventsActiveCampaign.V3.Forms: FormsFormsActiveCampaign.V3.GroupLimits: Group LimitsGroupLimitsActiveCampaign.V3.Groups: GroupsGroupsActiveCampaign.V3.Lists: ListsListsActiveCampaign.V3.Me: MeMeActiveCampaign.V3.Messages: MessagesMessagesActiveCampaign.V3.Notes: NotesNotesActiveCampaign.V3.OutstandingImports: Outstanding ImportsOutstandingImportsActiveCampaign.V3.RecentlyCompletedImports: Recently Completed ImportsRecentlyCompletedImportsActiveCampaign.V3.SavedResponses: Saved ResponsesSavedResponsesActiveCampaign.V3.Scores: ScoresScoresActiveCampaign.V3.Segments: SegmentsSegmentsActiveCampaign.V3.SiteTracking: Site TrackingSiteTrackingActiveCampaign.V3.SiteTrackingWhitelistedDomains: Site Tracking DomainsSiteTrackingWhitelistedDomainsActiveCampaign.V3.TrackEvents: Track EventTrackEventsActiveCampaign.V3.WebhookEvents: Webhook EventsWebhookEventsActiveCampaign.V3.Webhooks: WebhooksWebhooksViewsActiveCampaign.Views.ContactAut: Contact AutContactAutActiveCampaign.Views.ContactAutomationEntryCounts: Contact Automation Entry CountsContactAutomationEntryCountsActiveCampaign.Views.ContactBounceLogs: Contact Bounce LogsContactBounceLogsActiveCampaign.Views.ContactGeoIps: Contact AutomationsContactGeoIpsActiveCampaign.Views.ContactNotes: Contact NotesContactNotesActiveCampaign.Views.ContactTrackingLogs: Contact Tracking LogsContactTrackingLogsActiveCampaign.Views.DealActivitiesNonEmail: Deal Activities Non EmailDealActivitiesNonEmailActiveCampaignAuthentication Authentication can be done using using a token.An API token can be generated from the ActiveCampaignmenu: 'Settings' > 'Developer' > 'Key', as described onhttps://developers.activecampaign.com/reference#authentication.DatadictionaryJede Tabelle und jede Spalte dieses Daten Musters wird mit einer entsprechenden Dokumentationauf documentation.invantive.eu beschrieben, wo die Dokumentation auch in anderen Sprachenverfügbar ist.NotizenDie Boxen sind nach Themen gruppiert und je nach Kategorie farblich gekennzeichnet. Im Themader Tabelle, die den Schlüssel enthält, wird eine Beziehung eingezeichnet; in einem anderen Themawird eine hellgraue Box definiert.ThemenV3 · Accounts1V3 · Connections1V3 · CustomFields1Tabellen ohne Beziehungen1LegendeTransaktionalSetupTechnischFest codierte WerteIn einem anderen Thema definiertDeklarierter SchlüsselIn Worten beschriebene BeziehungAus Spaltennamen abgeleiteter KandidatFett: eine beliebte Tabelle+Bulk, +Read: Die Tabelle ist auch in diesen Varianten verfügbar\u00D7n: n Schlüssel zwischen denselben TabellenErstellt anhand der Metadaten von Invantive UniversalSQL 27.1.3-BETA+6294 am 01-11-2026. Jede Tabelle enthälteinen Link zu ihrer Seite mit Spalten, Schlüsseln und Beispiel-Queries.documentation.invantive.eu/de/datamodels/activecampaign
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge

V3 · Accounts

AccountCustomFieldValues, AccountCustomFields, AccountWithCustomFieldValues, Accounts, Associations, Automations, ContactAutomations, ContactWithAccountContacts, ContactWithTags, DealCustomFieldValues, DealCustomFields, DealWithActivities, Deals, PipelineWithStages, Pipelines, SecondaryContacts, Stages, Tags, TaskTypes, Tasks, Users

V3 · Connections

Connections, eComCustomers, eComOrderProducts, eComOrders

V3 · CustomFields

ContactWithCustomFieldValues, CustomFieldOptions, CustomFieldValues, CustomFields

CustomObjects (ohne Beziehungen)

AccountMyTags, BrowseAbandonments, ContactCars, DealMyTags, Orders, Products, RecurringPayments

Native (ohne Beziehungen)

NATIVEPLATFORMSCALARREQUESTS

V3 (ohne Beziehungen)

Addresses, Brandings, Calendars, Campaigns, ContactWithBounceLogs, ContactWithScoreValues, CustomFieldRelations, CustomObjectSchemas, DealRoles, DealWithContacts, DealWithNotes, DealWithTasks, EmailActivities, EventTracking, Events, Forms, GroupLimits, Groups, Lists, Me, Messages, Notes, OutstandingImports, RecentlyCompletedImports, SavedResponses, Scores, Segments, SiteTracking, SiteTrackingWhitelistedDomains, TrackEvents, WebhookEvents, Webhooks

Views (ohne Beziehungen)

ContactAut, ContactAutomationEntryCounts, ContactBounceLogs, ContactGeoIps, ContactNotes, ContactTrackingLogs, DealActivitiesNonEmail

Beziehungen

  • AccountCustomFieldValues → AccountCustomFields (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • AccountCustomFieldValues → Accounts (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • AccountWithCustomFieldValues → AccountCustomFields (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • AccountWithCustomFieldValues → Accounts (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • Associations → Accounts (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • ContactAutomations → Automations (Kandidat, 2 keys): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • ContactWithAccountContacts → Accounts (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • ContactWithCustomFieldValues → CustomFields (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • ContactWithTags → Tags (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • CustomFieldOptions → CustomFields (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • CustomFieldValues → CustomFields (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • DealCustomFieldValues → DealCustomFields (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • DealCustomFieldValues → Deals (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • DealWithActivities → Deals (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • DealWithActivities → Stages (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • Deals → Accounts (Schlüssel)
  • Deals → Accounts (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • Deals → Pipelines (Schlüssel)
  • Deals → Stages (Schlüssel)
  • Deals → Users (Schlüssel)
  • PipelineWithStages → Pipelines (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • SecondaryContacts → Deals (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • Stages → Pipelines (Schlüssel)
  • Tasks → TaskTypes (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • eComOrderProducts → Connections (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • eComOrderProducts → eComOrders (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • eComOrders → Connections (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.
  • eComOrders → eComCustomers (Kandidat): Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read.

Tables

ActiveCampaign.CustomObjects

ActiveCampaign.Native

ActiveCampaign.V3

ActiveCampaign.Views

Sample Queries

--
-- List of contacts in ActiveCampaign. Use ContactWithCustomFieldValues to retrieve and/or update contact custom fields.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/activecampaign-data-model/webhelp/activecampaign-connector-v3-contacts.html
--
select *
from   ActiveCampaign.V3.Contacts@acn
limit  100

Attributes

The attributes of this platform are on the page Attributes.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: