The Invantive drivers make all somewhat usable tables available for ActiveCampaign in real-time.
The ActiveCampaign tables are available for use in SQL, Power BI Desktop, Power BI Service, Power Query, Azure Data Factory, Qlik, Tableau and other popular packages.
The steps to link ActiveCampaign with Power BI can be found in Connect Power BI to ActiveCampaign.
A few ActiveCampaign tables were the most used over the past year. The table below shows which ActiveCampaign tables are the most popular and will help you selecting tables.
| Position | Table name | Description |
|---|---|---|
| 1 | Contacts / ContactWith* | Contacts |
| 2 | Accounts / AccountWith* | Relaties |
| 3 | ContactAutomations | Contact automations |
| 4 | CustomFieldValues | Custom field values |
| 5 | Messages | Messages |
| 6 | Associations | Account contacts |
| 7 | Deals / DealWith* | Deals |
| 8 | Tasks | Tasks |
| 9 | Tags | Tags |
| 10 | DealCustomFieldValues | Deal custom field values |
A complete listing of all 66 ActiveCampaign tables is at: