---
title: "ActiveCampaign Data Model"
description: "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."
language: en
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/activecampaign
original: https://documentation.invantive.eu/en/datamodels/activecampaign
updated: 2026-11-01T17:44:09Z
license: https://documentation.invantive.eu/es/
---

# ActiveCampaign Data Model

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/](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 |

## Tables

### ActiveCampaign.CustomObjects

- [AccountMyTags](ActiveCampaign.CustomObjects.AccountMyTags): Account My Tags
- [BrowseAbandonments](ActiveCampaign.CustomObjects.BrowseAbandonments): Browse Abandonments
- [ContactCars](ActiveCampaign.CustomObjects.ContactCars): Contact Cars
- [DealMyTags](ActiveCampaign.CustomObjects.DealMyTags): Deal My Tags
- [Orders](ActiveCampaign.CustomObjects.Orders): Orders
- [Products](ActiveCampaign.CustomObjects.Products): Products
- [RecurringPayments](ActiveCampaign.CustomObjects.RecurringPayments): Recurring Payments

### ActiveCampaign.Native

- [NATIVEPLATFORMSCALARREQUESTS](ActiveCampaign.Native.NATIVEPLATFORMSCALARREQUESTS): Native Platform Scalar Requests

### ActiveCampaign.V3

- [AccountById](ActiveCampaign.V3.AccountById): Account by ID
- [AccountContactsByContactId](ActiveCampaign.V3.AccountContactsByContactId): Account Contacts by Contact ID
- [AccountCustomFieldValues](ActiveCampaign.V3.AccountCustomFieldValues): Account Custom Field Values
- [AccountCustomFields](ActiveCampaign.V3.AccountCustomFields): Account Custom Fields
- [AccountWithCustomFieldValues](ActiveCampaign.V3.AccountWithCustomFieldValues): Account Custom Fields
- [Accounts](ActiveCampaign.V3.Accounts): Accounts
- [ActivitiesByContactId](ActiveCampaign.V3.ActivitiesByContactId): Activities by Contact ID
- [Addresses](ActiveCampaign.V3.Addresses): Addresses
- [Associations](ActiveCampaign.V3.Associations): Account Contacts
- [AutomationEntryCountsByContactId](ActiveCampaign.V3.AutomationEntryCountsByContactId): Automation Entry Counts by Contact ID
- [Automations](ActiveCampaign.V3.Automations): Automations
- [BounceLogsByContactId](ActiveCampaign.V3.BounceLogsByContactId): Bounce Logs by Contact ID
- [Brandings](ActiveCampaign.V3.Brandings): Brandings
- [Calendars](ActiveCampaign.V3.Calendars): Calendars
- [CampaignLinksByCampaignId](ActiveCampaign.V3.CampaignLinksByCampaignId): Campaign Links by Campaign ID
- [Campaigns](ActiveCampaign.V3.Campaigns): Campaigns
- [Connections](ActiveCampaign.V3.Connections): Connections
- [ContactAutomations](ActiveCampaign.V3.ContactAutomations): Contact Automations
- [ContactAutomationsByContactId](ActiveCampaign.V3.ContactAutomationsByContactId): Contact Automations by Contact ID
- [ContactDataByContactId](ActiveCampaign.V3.ContactDataByContactId): Contact Data by Contact ID
- [ContactDealsByContactId](ActiveCampaign.V3.ContactDealsByContactId): Deals by Contact ID
- [ContactGoalsByContactId](ActiveCampaign.V3.ContactGoalsByContactId): Goals by Contact ID
- [ContactListsByContactId](ActiveCampaign.V3.ContactListsByContactId): Lists by Contact ID
- [ContactLogsByContactId](ActiveCampaign.V3.ContactLogsByContactId): Logs by Contact ID
- [ContactTagsByContactId](ActiveCampaign.V3.ContactTagsByContactId): Tags by Contact ID
- [ContactWithAccountContacts](ActiveCampaign.V3.ContactWithAccountContacts): Contact with Account Contacts
- [ContactWithBounceLogs](ActiveCampaign.V3.ContactWithBounceLogs): Contact Bounce Logs
- [ContactWithCustomFieldValues](ActiveCampaign.V3.ContactWithCustomFieldValues): Contact Custom Fields
- [ContactWithScoreValues](ActiveCampaign.V3.ContactWithScoreValues): Contact with Score Values
- [ContactWithTags](ActiveCampaign.V3.ContactWithTags): Contact Tags
- [Contacts](ActiveCampaign.V3.Contacts): Contacts
- [CustomFieldOptions](ActiveCampaign.V3.CustomFieldOptions): Custom Field Options
- [CustomFieldRelations](ActiveCampaign.V3.CustomFieldRelations): Custom Field Relations
- [CustomFieldValues](ActiveCampaign.V3.CustomFieldValues): Custom Field Values
- [CustomFields](ActiveCampaign.V3.CustomFields): Custom Fields
- [CustomObjectSchemas](ActiveCampaign.V3.CustomObjectSchemas): Custom Object Schemas
- [DealActivities](ActiveCampaign.V3.DealActivities): Deal Activities
- [DealCustomFieldValues](ActiveCampaign.V3.DealCustomFieldValues): Deal Custom Field Values
- [DealCustomFields](ActiveCampaign.V3.DealCustomFields): Deal Custom Fields
- [DealRoles](ActiveCampaign.V3.DealRoles): Deal Roles
- [DealWithActivities](ActiveCampaign.V3.DealWithActivities): Deal Activities
- [DealWithContacts](ActiveCampaign.V3.DealWithContacts): Deal Contacts
- [DealWithNotes](ActiveCampaign.V3.DealWithNotes): Deal Notes
- [DealWithTasks](ActiveCampaign.V3.DealWithTasks): Deal Tasks
- [Deals](ActiveCampaign.V3.Deals): Deals
- [DealsByContactId](ActiveCampaign.V3.DealsByContactId): Deals by Contact ID
- [EmailActivities](ActiveCampaign.V3.EmailActivities): Email Activities
- [EventTracking](ActiveCampaign.V3.EventTracking): Event Tracking
- [Events](ActiveCampaign.V3.Events): Events
- [FieldValuesByContactId](ActiveCampaign.V3.FieldValuesByContactId): Field Values by Contact ID
- [Forms](ActiveCampaign.V3.Forms): Forms
- [GeoIpsByContactId](ActiveCampaign.V3.GeoIpsByContactId): Geo IP-addresses by Contact ID
- [GroupLimits](ActiveCampaign.V3.GroupLimits): Group Limits
- [Groups](ActiveCampaign.V3.Groups): Groups
- [ImportsByBatchId](ActiveCampaign.V3.ImportsByBatchId): Imports by Batch ID
- [Lists](ActiveCampaign.V3.Lists): Lists
- [Me](ActiveCampaign.V3.Me): Me
- [Messages](ActiveCampaign.V3.Messages): Messages
- [Notes](ActiveCampaign.V3.Notes): Notes
- [NotesByContactId](ActiveCampaign.V3.NotesByContactId): Notes by Contact ID
- [OrganizationsByContactId](ActiveCampaign.V3.OrganizationsByContactId): Organizations by Contact ID
- [OutstandingImports](ActiveCampaign.V3.OutstandingImports): Outstanding Imports
- [PipelineWithStages](ActiveCampaign.V3.PipelineWithStages): Pipeline with Stages
- [Pipelines](ActiveCampaign.V3.Pipelines): Pipelines
- [RecentlyCompletedImports](ActiveCampaign.V3.RecentlyCompletedImports): Recently Completed Imports
- [SavedResponses](ActiveCampaign.V3.SavedResponses): Saved Responses
- [ScoreValuesByContactId](ActiveCampaign.V3.ScoreValuesByContactId): Score Values by Contact ID
- [Scores](ActiveCampaign.V3.Scores): Scores
- [SecondaryContacts](ActiveCampaign.V3.SecondaryContacts): Secondary Contacts
- [Segments](ActiveCampaign.V3.Segments): Segments
- [SiteTracking](ActiveCampaign.V3.SiteTracking): Site Tracking
- [SiteTrackingWhitelistedDomains](ActiveCampaign.V3.SiteTrackingWhitelistedDomains): Site Tracking Domains
- [Stages](ActiveCampaign.V3.Stages): Stages
- [Tags](ActiveCampaign.V3.Tags): Tags
- [TaskTypes](ActiveCampaign.V3.TaskTypes): Task Types
- [Tasks](ActiveCampaign.V3.Tasks): Tasks
- [TrackEvents](ActiveCampaign.V3.TrackEvents): Track Event
- [TrackingLogsByContactId](ActiveCampaign.V3.TrackingLogsByContactId): Tracking Logs by Contact ID
- [UserGroupsByGroupId](ActiveCampaign.V3.UserGroupsByGroupId): User Groups by Group ID
- [Users](ActiveCampaign.V3.Users): Users
- [WebhookEvents](ActiveCampaign.V3.WebhookEvents): Webhook Events
- [Webhooks](ActiveCampaign.V3.Webhooks): Webhooks
- [eComCustomers](ActiveCampaign.V3.eComCustomers): eCommerce Customers
- [eComOrderProducts](ActiveCampaign.V3.eComOrderProducts): eCommerce Order Products
- [eComOrders](ActiveCampaign.V3.eComOrders): eCommerce Orders

### ActiveCampaign.Views

- [ContactAut](ActiveCampaign.Views.ContactAut): Contact Aut
- [ContactAutomationEntryCounts](ActiveCampaign.Views.ContactAutomationEntryCounts): Contact Automation Entry Counts
- [ContactBounceLogs](ActiveCampaign.Views.ContactBounceLogs): Contact Bounce Logs
- [ContactGeoIps](ActiveCampaign.Views.ContactGeoIps): Contact Automations
- [ContactNotes](ActiveCampaign.Views.ContactNotes): Contact Notes
- [ContactTrackingLogs](ActiveCampaign.Views.ContactTrackingLogs): Contact Tracking Logs
- [DealActivitiesNonEmail](ActiveCampaign.Views.DealActivitiesNonEmail): Deal Activities Non Email

## Sample Queries

```sql
--
-- 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](attributes).



## Notas de la Versión

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

- [ActiveCampaign](/es/release-notes/drivers?driver=activecampaign)
