invantive documentation
Forum di supporto InvantiveAccedi / Registrati

ActiveCampaign Data Model

Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.

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 sul modello di dati

PDF, 1 foglio A0

Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.

ActiveCampaign Modello di dati, Foglio 1 di 1ActiveCampaign Modello di datida utilizzare con Invantive UniversalSQLComunicato 27.1.3-BETA+6294 · 01-11-2026V3 · Accounts · V3 · Connections · V3 · CustomFieldsFoglio 1 di 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: WebhooksWebhooksVisualizzazioniActiveCampaign.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.Dizionario dei datiOgni tabella e colonna di questo modello di dati è descritta nella relativa documentazionedisponibile su documentation.invantive.eu, dove il poster è disponibile anche in altre lingue.NoteLe box sono raggruppate per argomento e contrassegnate da colori diversi a seconda dellacategoria. Nel nodo della tabella che contiene la chiave viene tracciata una relazione; in un altronodo viene definito un Box di colore grigio chiaro.ArgomentiV3 · Accounts1V3 · Connections1V3 · CustomFields1Tabella senza relazioni1LeggendaTransazionaleInstallazioneAspetti tecniciValori hardcodedDescritto in un altro argomentoChiave dichiarataRelazione descritta a paroleCandidato derivato dai nomi delle colonneIn grassetto: una tabella molto diffusa+Bulk, +Read: la tabella è disponibile anche in queste varianti\u00D7n: n chiavi tra le stesse tabelleGenerato dai metadati di Invantive UniversalSQL 27.1.3-BETA+6294 il 01-11-2026. Ogni tabella rimanda allarelativa pagina con le colonne, le chiavi e le Query di esempio.documentation.invantive.eu/it/datamodels/activecampaign
Il poster come testo: tabelle per argomento e le loro relazioni

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 (senza relazioni)

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

Native (senza relazioni)

NATIVEPLATFORMSCALARREQUESTS

V3 (senza relazioni)

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

Visualizzazioni (senza relazioni)

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

Relazioni

  • 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 (chiave)
  • 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 (chiave)
  • Deals → Stages (chiave)
  • Deals → Users (chiave)
  • 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 (chiave)
  • 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.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: