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
En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.
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)
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
- AccountMyTags: Account My Tags
- BrowseAbandonments: Browse Abandonments
- ContactCars: Contact Cars
- DealMyTags: Deal My Tags
- Orders: Orders
- Products: Products
- RecurringPayments: Recurring Payments
ActiveCampaign.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
ActiveCampaign.V3
- AccountById: Account by ID
- AccountContactsByContactId: Account Contacts by Contact ID
- AccountCustomFieldValues: Account Custom Field Values
- AccountCustomFields: Account Custom Fields
- AccountWithCustomFieldValues: Account Custom Fields
- Accounts: Accounts
- ActivitiesByContactId: Activities by Contact ID
- Addresses: Addresses
- Associations: Account Contacts
- AutomationEntryCountsByContactId: Automation Entry Counts by Contact ID
- Automations: Automations
- BounceLogsByContactId: Bounce Logs by Contact ID
- Brandings: Brandings
- Calendars: Calendars
- CampaignLinksByCampaignId: Campaign Links by Campaign ID
- Campaigns: Campaigns
- Connections: Connections
- ContactAutomations: Contact Automations
- ContactAutomationsByContactId: Contact Automations by Contact ID
- ContactDataByContactId: Contact Data by Contact ID
- ContactDealsByContactId: Deals by Contact ID
- ContactGoalsByContactId: Goals by Contact ID
- ContactListsByContactId: Lists by Contact ID
- ContactLogsByContactId: Logs by Contact ID
- ContactTagsByContactId: Tags by Contact ID
- ContactWithAccountContacts: Contact with Account Contacts
- ContactWithBounceLogs: Contact Bounce Logs
- ContactWithCustomFieldValues: Contact Custom Fields
- ContactWithScoreValues: Contact with Score Values
- ContactWithTags: Contact Tags
- Contacts: Contacts
- CustomFieldOptions: Custom Field Options
- CustomFieldRelations: Custom Field Relations
- CustomFieldValues: Custom Field Values
- CustomFields: Custom Fields
- CustomObjectSchemas: Custom Object Schemas
- DealActivities: Deal Activities
- DealCustomFieldValues: Deal Custom Field Values
- DealCustomFields: Deal Custom Fields
- DealRoles: Deal Roles
- DealWithActivities: Deal Activities
- DealWithContacts: Deal Contacts
- DealWithNotes: Deal Notes
- DealWithTasks: Deal Tasks
- Deals: Deals
- DealsByContactId: Deals by Contact ID
- EmailActivities: Email Activities
- EventTracking: Event Tracking
- Events: Events
- FieldValuesByContactId: Field Values by Contact ID
- Forms: Forms
- GeoIpsByContactId: Geo IP-addresses by Contact ID
- GroupLimits: Group Limits
- Groups: Groups
- ImportsByBatchId: Imports by Batch ID
- Lists: Lists
- Me: Me
- Messages: Messages
- Notes: Notes
- NotesByContactId: Notes by Contact ID
- OrganizationsByContactId: Organizations by Contact ID
- OutstandingImports: Outstanding Imports
- PipelineWithStages: Pipeline with Stages
- Pipelines: Pipelines
- RecentlyCompletedImports: Recently Completed Imports
- SavedResponses: Saved Responses
- ScoreValuesByContactId: Score Values by Contact ID
- Scores: Scores
- SecondaryContacts: Secondary Contacts
- Segments: Segments
- SiteTracking: Site Tracking
- SiteTrackingWhitelistedDomains: Site Tracking Domains
- Stages: Stages
- Tags: Tags
- TaskTypes: Task Types
- Tasks: Tasks
- TrackEvents: Track Event
- TrackingLogsByContactId: Tracking Logs by Contact ID
- UserGroupsByGroupId: User Groups by Group ID
- Users: Users
- WebhookEvents: Webhook Events
- Webhooks: Webhooks
- eComCustomers: eCommerce Customers
- eComOrderProducts: eCommerce Order Products
- eComOrders: eCommerce Orders
ActiveCampaign.Views
- ContactAut: Contact Aut
- ContactAutomationEntryCounts: Contact Automation Entry Counts
- ContactBounceLogs: Contact Bounce Logs
- ContactGeoIps: Contact Automations
- ContactNotes: Contact Notes
- ContactTrackingLogs: Contact Tracking Logs
- DealActivitiesNonEmail: Deal Activities Non Email
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: