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
Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.
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)
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
- 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
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: