ActiveCampaign Modèle de données
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.
Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/activecampaign
Les comparaisons de texte sur cette plateforme tiennent compte de la casse.
Plate-forme
- Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
- Type : une application accessible via son API.
- Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
- Les données peuvent être aussi bien écrites que lues.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status of the platform: https://status.activecampaign.com/.
Chiffres
| Figure | Count |
|---|---|
| Tables | 100 |
| Columns | 1,738 |
| Tableaux avec insert | 46 |
| Tables avec mise à jour | 31 |
| Tables avec la clause DELETE | 38 |
| Tableaux documentés | 7 |
Affiche sur le modèle de données
Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.
L'affiche sous forme de texte : tableaux par thème et leurs relations
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 (sans relations)
AccountMyTags, BrowseAbandonments, ContactCars, DealMyTags, Orders, Products, RecurringPayments
Native (sans relations)
V3 (sans relations)
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
Vues (sans relations)
ContactAut, ContactAutomationEntryCounts, ContactBounceLogs, ContactGeoIps, ContactNotes, ContactTrackingLogs, DealActivitiesNonEmail
Relations
- AccountCustomFieldValues → AccountCustomFields (candidat): 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 (candidat): 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 (candidat): 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 (candidat): 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 (candidat): 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 (candidat, 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 (candidat): 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 (candidat): 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 (candidat): 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 (candidat): 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 (candidat): 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 (candidat): 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 (candidat): 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 (candidat): 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 (candidat): 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 (clé)
- Deals → Accounts (candidat): 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 (clé)
- Deals → Stages (clé)
- Deals → Users (clé)
- PipelineWithStages → Pipelines (candidat): 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 (candidat): 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 (clé)
- Tasks → TaskTypes (candidat): 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 (candidat): 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 (candidat): 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 (candidat): 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 (candidat): 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.
Tableaux
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
Exemples de 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
Attributs
The attributes of this platform are on the page Attributes.
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :