invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

ActiveCampaign Data Model

Esta página aún no está disponible en tu idioma; se muestra la versión original.

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

Póster del Modelo de Datos

PDF, hoja A0 1

En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.

ActiveCampaign Modelo de Datos, Hoja 1 de 1ActiveCampaign Modelo de Datospara su uso con Invantive UniversalSQLComunicado 27.1.3-BETA+6294 · 01-11-2026V3 · Accounts · V3 · Connections · V3 · CustomFieldsHoja 1 de 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: WebhooksWebhooksVistasActiveCampaign.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.Diccionario de datosCada tabla y columna de este Modelo de Datos se describe en su documentación, disponible endocumentation.invantive.eu, donde el documento también está disponible en otros idiomas.NotasLas cajas están agrupadas por tema y se distinguen por colores según la categoría. Se estableceuna relación en el tema de la tabla que contiene la clave; en otro tema se define un Box de colorgris pálido.TemasV3 · Accounts1V3 · Connections1V3 · CustomFields1Tablas sin relaciones1LeyendaTransaccionalConfiguraciónTécnicoValores fijosSe explica en otro temaClave declaradaRelación descrita con palabrasCandidato derivado de los nombres de las columnasNegrita: una tabla muy popular+Bulk, +Read: la tabla también existe en estas variantes\u00D7n: n claves entre las mismas tablasGenerado a partir de los metadatos de Invantive UniversalSQL 27.1.3-BETA+6294 el 01-11-2026. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/activecampaign
El póster en forma de texto: tablas por tema y sus relaciones

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 (sin relaciones)

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

Native (sin relaciones)

NATIVEPLATFORMSCALARREQUESTS

V3 (sin relaciones)

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

Vistas (sin relaciones)

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

Relaciones

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

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: