invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

ActiveCampaign Datamodel

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.

Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/activecampaign

Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.

Platform

  • Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
  • Type: een applicatie die via de API toegankelijk is.
  • De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
  • Gegevens kunnen zowel worden geschreven als gelezen.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.activecampaign.com/.

Cijfers

Figure Count
Tables 100
Columns 1,738
Tabeller med invoegsel 46
Tabeller med update 31
Tabellen met de functie 'verwijderen' 38
Tabeller gedocumenteerd 7

Poster met datamodel

PDF, 1 A0-vel

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

ActiveCampaign Datamodel, Pagina 1 van 1ActiveCampaign Datamodelvoor gebruik met Invantive UniversalSQLPersbericht 27.1.3-BETA+6294 · 01-11-2026V3 · Accounts · V3 · Connections · V3 · CustomFieldsPagina 1 van 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.Data DictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.OnderwerpenV3 · Accounts1V3 · Connections1V3 · CustomFields1Tabeller uden relationen1LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten\u00D7n: n toetsen tussen dezelfde tabellenGegenereerd op basis van de metagegevens van Invantive UniversalSQL 27.1.3-BETA+6294 op 01-11-2026. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/activecampaign
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

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 (zonder relaties)

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

Native (zonder relaties)

NATIVEPLATFORMSCALARREQUESTS

V3 (zonder relaties)

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 (zonder relaties)

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

Relaties

  • AccountCustomFieldValues → AccountCustomFields (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (kandidaat, 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 (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (sleutel)
  • Deals → Accounts (kandidaat): 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 (sleutel)
  • Deals → Stages (sleutel)
  • Deals → Users (sleutel)
  • PipelineWithStages → Pipelines (kandidaat): 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 (kandidaat): 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 (sleutel)
  • Tasks → TaskTypes (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (kandidaat): 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.

Tabellen

ActiveCampaign.CustomObjects

ActiveCampaign.Native

ActiveCampaign.V3

ActiveCampaign.Views

Voorbeeldqueries

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

Attributen

The attributes of this platform are on the page Attributes.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: