ActiveCampaign

Creating the data source

Requirements

Follow the instructions below using a user account that has permission to administer or read all entities in ActiveCampaign
If your user doesn’t have these permissions, ask an administrator of that account to grant them by following the steps below:

To grant user permissions, you need to create a user group and assign permissions to the group. All permissions applied to that group will affect every user in it

With user permissions, you’ll need access to interact with:

Lists
Campaigns
Subscription Forms
Templates
Deals
Accounts
Contacts
Automations
Reports
Saved Responses
Landing Pages
Web Personalization

Para criar um grupo e dar permissões para ele:

Click “Settings” > “Users and Group” in the left menu
Click on the “Groups” tab
Click “Add Group”
Fill in the information under the “Info” tab and select all permissions for this group
Under the “Permissions” tab, select all permissions
Under the “Limits” tab, leave everything unchecked
Then click “Add group”

Instructions

Log in to your ActiveCampaign account and, in the left sidebar, select “Settings”
In the secondary menu, select “Developer”
Copy the values from “URL” and “Key”
Log in to the Kondado platform, click CRIAR + > Conector, and select the ActiveCampaign connector
Give your connector a name and paste the URL and Key values obtained in step 3

Pipelines

Summary

Accounts
Accounts: contacts
Accounts: custom fields (data)
Accounts: custom fields (meta)
Accounts: notes
Campaigns
Campaigns: messages
Campaigns: messages: content
Contacts
Contacts: custom fields (data)
Contacts: custom fields (meta)
Contacts: list activity
Contacts: notes
Contacts: tags
Contacts: tasks
Deals
Deals: activities
Deals: custom fields (data)
Deals: custom fields (meta)
Deals: secondary contacts
Deals: tasks
Lists
Lists: contacts
Pipelines
Scores
Tasks: outcomes
Tasks: types
User groups
Users

Relationship chart

Click to expand

Accounts

Replication type: Full

Relationships:

owner → Users > id

Accounts managed in ActiveCampaign.

Campo	Tipo
id	float	[en] Account ID.
accounturl	text	[en] URL recorded for the account.
contactcount	float	[en] Number of contacts linked to the account.
createdtimestamp	timestamp	[en] When the account was created.
dealcount	float	[en] Number of deals associated with the account.
name	text	[en] The account name.
owner	float	[en] ID of the account owner. Users > > id
updatedtimestamp	timestamp	[en] When the account was last updated.

Accounts: contacts

Replication type: Full

Relationships:

account_id → Accounts > id
contact_id → Contacts > id

ActiveCampaign relationships between accounts and contacts.

Campo	Tipo
id	float	[en] Association ID between account and contact.
account_id	float	[en] Account ID Accounts > > id
contact_id	float	[en] Contact ID Contacts > > id
createdtimestamp	timestamp	[en] Creation datetime of the account-contact link.
jobtitle	text	[en] Job Title of the contact at the account
updatedtimestamp	timestamp	[en] When the account-contact link was last updated.

Accounts: custom fields (data)

Replication type: Full

Relationships:

accountid → Accounts > id
customfieldid → Accounts: custom fields (meta) > id

ActiveCampaign account custom field values with currency and links to accounts/field meta.

Campo	Tipo
id	float	[en] Custom field value ID.
accountid	float	[en] The ID of the account this field value relates to Accounts > > id
createdtimestamp	timestamp	[en] When the custom field value was created.
customfieldid	float	[en] The ID of the custom field metum this field value relates to Accounts: custom fields (meta) > > id
fieldcurrency	text	[en] Currency code for the money value
fieldvalue	text	[en] Values for the field
updatedtimestamp	timestamp	[en] When the custom field value was last updated.

Accounts: custom fields (meta)

Replication type: Full

Relationships:

createdby → Users > id
updatedby → Users > id

ActiveCampaign account custom field metadata.

Campo	Tipo
id	float	[en] Custom field ID.
createdby	float	[en] User who created the field. Users > > id
createdtimestamp	timestamp	[en] When the field was created.
displayorder	float	[en] Order for displaying the field on Manage Fields page and deal profiles
fielddefault	text	[en] Default value of the field
fielddefaultcurrency	text	[en] Default currency for the field (3-letter code).
fieldlabel	text	[en] Name of the field
fieldoptions	text	[en] Options for the field.
fieldtype	text	[en] Type of field. Possible values are: text, textarea, date, datetime, dropdown, multiselect, radio, checkbox, hidden, currency, or number.
hidefieldflag	float	[en] Whether the field is hidden (1) or visible (0).
isformvisible	float	[en] Whether or not the field is visible on forms
isrequired	float	[en] Whether the field is required (1) or optional (0).
knownfieldid	float	[en] Identifier if the field maps to a known predefined field.
personalization	text	[en] Personalization tag for using the field in messages.
updatedby	float	[en] User who last updated the field. Users > > id
updatedtimestamp	timestamp	[en] When the field was last updated.

Accounts: notes

Replication type: Full

Relationships:

account_id → Accounts > id
owner_id → Users > id
userid → Users > id

Notes recorded on accounts in ActiveCampaign.

Campo	Tipo
id	float	[en] Note ID.
account_id	float	[en] Account ID linked to the note. Accounts > > id
cdate	timestamp	[en] When the note was created.
is_draft	float	[en] Whether the note is in draft status (1) or published (0).
mdate	timestamp	[en] When the note was last modified.
note	text	[en] Text of the note.
owner_id	float	[en] ID of the note owner. Users > > id
owner_type	text	[en] Type of owner tied to the note (e.g., account).
userid	float	[en] ID of the user who created the note. Users > > id

Campaigns

Replication type: Incremental with update window

Parameters:

Update window (days): How many days prior to the Savepoint should records keep being updated
Read start date (Savepoint): Initial date to filter results

Relationships:

userid → Users > id

Campaign settings and metrics.

Campo	Tipo
id	float	[en] id of the automation
activerss_interval	text	[en] Interval used for ActiveRSS schedule.
activerss_items	float	[en] Number of items pulled from the RSS feed.
activerss_url	text	[en] RSS feed URL connected to the campaign.
addressid	float	[en] Sender address profile ID for the campaign.
analytics_campaign_name	text	[en] Custom campaign name used in analytics tracking.
automation	float	[en] Automation ID tied to the campaign.
basemessageid	float	[en] Base message ID from which the campaign was created.
basetemplateid	text	[en] Base template ID applied to the campaign.
bounceid	float	[en] Bounce handling profile ID.
can_skip_approval	float	[en] Flag indicating if the campaign can skip approval.
cdate	timestamp	[en] When the campaign was created.
created_timestamp	timestamp	[en] Timestamp when the campaign record was created.
embed_images	float	[en] Flag to embed images in the email body.
facebook	float	[en] Flag enabling Facebook sharing.
formid	float	[en] Form ID associated with the campaign.
forwards	float	[en] Number of forwards.
hardbounces	float	[en] Hard bounce count.
has_predictive_content	float	[en] Flag indicating predictive content availability.
htmlunsub	float	[en] HTML content used for unsubscribe.
htmlunsubdata	text	[en] Additional HTML data for unsubscribe content.
ip	text	[en] IP address logged when the campaign was created.
ip4	text	[en] IPv4 address logged for the campaign.
laststep	text	[en] Last workflow step executed for the campaign.
ldate	timestamp	[en] When the campaign was last modified.
linkclicks	float	[en] Total link clicks.
mail_cleanup	float	[en] Flag controlling mailbox cleanup after send.
mail_send	float	[en] Flag controlling whether the campaign should send.
mail_transfer	float	[en] Flag controlling mail transfer handling.
mailer_log_file	float	[en] Name of the mailer log file.
managetext	float	[en] Plain-text manage-subscription content.
mdate	timestamp	[en] When the campaign was last updated.
name	text	[en] Campaign name.
opens	float	[en] Total opens.
public	float	[en] Flag indicating if the campaign is public.
realcid	float	[en] Internal real campaign identifier.
recurring	text	[en] Flag indicating if the campaign recurs.
reminder_field	text	[en] Reminder field value for scheduled sends.
reminder_format	text	[en] Format used for reminders.
reminder_last_cron_run	text	[en] When the reminder cron last ran.
reminder_offset	float	[en] Offset value for reminder timing.
reminder_offset_sign	text	[en] Offset sign applied to reminder timing.
reminder_offset_type	text	[en] Offset unit for reminder timing.
reminder_type	text	[en] Reminder type used for the campaign.
replies	float	[en] Number of replies.
replysys	float	[en] Flag for using system reply address.
responder_existing	float	[en] Auto-responder behavior for existing contacts.
responder_offset	float	[en] Delay offset applied to responder sends.
responder_type	text	[en] Type of responder sequence.
schedule	float	[en] Scheduling status for the campaign.
scheduleddate	text	[en] Scheduled date and time for sending.
screenshot	text	[en] URL of the campaign screenshot.
sdate	timestamp	[en] Send date/time of the campaign.
segmentid	float	[en] Segment ID applied to the campaign.
segmentname	text	[en] Name of the segment applied to the campaign.
send_amt	float	[en] Number of recipients targeted.
sendid	float	[en] Send batch identifier.
series_send_lock_time	text	[en] Lock time before series send executes.
seriesid	float	[en] Series ID linked to the campaign.
socialshares	float	[en] Number of social shares.
softbounces	float	[en] Soft bounce count.
source	text	[en] Source indicator for how the campaign was created.
split_content	float	[en] Content variant details for split tests.
split_offset	float	[en] Offset value used in split scheduling.
split_offset_type	text	[en] Offset unit used in split scheduling.
split_type	text	[en] Type of split test configured.
split_winner_awaiting	float	[en] Flag indicating winner selection is pending.
split_winner_messageid	float	[en] Message ID of the winning variant.
status	float	[en] Status code of the campaign.
subscriberclicks	float	[en] Clicks recorded from subscribers.
survey	text	[en] Survey ID associated with the campaign.
textunsub	float	[en] Plain-text content used for unsubscribe.
textunsubdata	text	[en] Additional text data for unsubscribe content.
threadid	float	[en] Email thread identifier.
total_amt	float	[en] Total size of the campaign audience.
tracklinks	text	[en] Link tracking mode indicator.
tracklinksanalytics	float	[en] Analytics tracking setting for links.
trackreads	float	[en] Open tracking mode indicator.
trackreadsanalytics	float	[en] Analytics tracking setting for opens.
tweet	float	[en] Flag enabling Twitter sharing.
type	text	[en] Campaign type identifier.
uniqueforwards	float	[en] Unique forward count.
uniquelinkclicks	float	[en] Unique link clicks.
uniqueopens	float	[en] Unique opens.
uniquereplies	float	[en] Unique replies.
unsubreasons	float	[en] Aggregated reasons for unsubscribes.
unsubscribes	float	[en] Unsubscribe count.
updates	float	[en] Number of updates processed for the campaign.
use_quartz_scheduler	float	[en] Flag indicating the Quartz scheduler is used.
userid	float	[en] User ID that owns the campaign. Users > > id
waitpreview	float	[en] Flag to wait for preview processing.
willrecur	float	[en] Flag indicating the campaign will recur.

Campaigns: messages

Replication type: Incremental with update window

Parameters:

Update window (days): How many days prior to the Savepoint should records keep being updated
Read start date (Savepoint): Initial date to filter results

Relationships:

automation_or_campaign_id → Campaigns > id

Metrics for campaign messages.

Campo	Tipo
id	float	[en] Message metrics record ID.
automation_or_campaign_id	float	[en] automation or campaign id Campaigns > > id
forwards	float	[en] Number of times the message was forwarded.
hardbounces	float	[en] Count of hard bounces for the message.
initial_split_percentage	float	[en] Percentage used to split traffic for this variant.
linkclicks	float	[en] Total link clicks in the message.
messageid	float	[en] message id
opens	float	[en] Total opens for the message.
percentage	float	[en] Percentage of audience this message variant received.
replies	float	[en] Number of replies recorded.
screenshot	text	[en] URL of the message screenshot.
send_amt	float	[en] Number of messages sent.
socialshares	float	[en] Count of social shares.
softbounces	float	[en] Count of soft bounces for the message.
sourcesize	float	[en] Size of the audience source for the send.
spamcheck_max	float	[en] Maximum spam score allowed.
spamcheck_score	float	[en] Spam score calculated for the message.
subject	text	[en] Message subject line.
subscriberclicks	float	[en] Unique subscriber link clicks.
total_amt	float	[en] Total recipients targeted by the message.
uniqueforwards	float	[en] Unique forward count.
uniquelinkclicks	float	[en] Unique link clicks.
uniqueopens	float	[en] Unique opens.
uniquereplies	float	[en] Unique replies.
unsubreasons	float	[en] Aggregated reasons for unsubscribe actions.
unsubscribes	float	[en] Unsubscribe count.
updates	float	[en] Number of updates processed for the message metrics.

Campaigns: messages: content

Replication type: Full

Relationships:

userid → Users > id

Campaign message content details.

Campo	Tipo
id	float	[en] id of the message
cdate	timestamp	[en] When the message content was created.
charset	text	[en] Character set used for the message content.
ed_instanceid	float	[en] Editor instance identifier for the message.
ed_version	float	[en] Editor version used for the content.
encoding	text	[en] Email encoding type for the message.
format	text	[en] Format of the message content.
fromemail	text	[en] Sender email configured for the message.
fromname	text	[en] Sender name configured for the message.
has_predictive_content	float	[en] Flag indicating predictive content is enabled.
hidden	float	[en] Visibility flag for the message content.
htmlfetch	text	[en] When HTML content should be fetched.
mdate	timestamp	[en] When the message content was last modified.
name	text	[en] Internal name of the message content.
preheader_text	text	[en] Preheader Text
preview_data	text	[en] Preview payload used for rendering tests.
preview_mime	text	[en] MIME type used in the preview.
priority	float	[en] Priority level assigned to the message.
reply2	text	[en] Reply email for the recipient to reply to
subject	text	[en] Subject of message
text	text	[en] text of the mensage. Obs. 1000 charecters limit
textfetch	text	[en] When plain-text content should be fetched.
userid	float	[en] User ID owning this message content. Users > > id

Contacts

Replication type: Incremental or Full (user configurable)

Relationships:

orgid → Accounts > id

Contacts managed in ActiveCampaign.

Campo	Tipo
id	float	[en] Contact ID.
adate	timestamp	[en] When the contact was added.
anonymized	float	[en] Flag indicating the contact was anonymized.
bounced_date	date	[en] Date of the last bounce event.
bounced_hard	float	[en] Hard bounce status flag.
bounced_soft	float	[en] Soft bounce status flag.
cdate	timestamp	[en] When the contact was created.
created_timestamp	timestamp	[en] When the contact record was created.
created_utc_timestamp	timestamp	[en] Creation timestamp stored without timezone.
deleted	float	[en] Flag indicating the contact was deleted.
deleted_at	timestamp	[en] When the contact was deleted.
edate	timestamp	[en] When the contact record was last edited.
email	text	[en] Email address of the new contact.
email_domain	text	[en] Domain portion of the contact email.
email_empty	boolean	[en] Flag indicating the email field is empty.
email_local	text	[en] Local part of the contact email.
firstname	text	[en] First name of the new contact.
gravatar	float	[en] Flag indicating if a Gravatar image is available.
hash	text	[en] Hashed identifier for the contact.
ip	text	[en] IP address captured for the contact.
lastname	text	[en] Last name of the new contact.
mpp_tracking	float	[en] Indicator for mail privacy protection tracking.
orgid	float	[en] Organization ID linked to the contact. Accounts > > id
orgname	text	[en] Organization name linked to the contact.
phone	text	[en] Phone number of the contact.
rating_tstamp	date	[en] When the contact rating was last updated.
segmentio_id	text	[en] Segment.io identifier stored for the contact.
sentcnt	float	[en] Number of emails sent to the contact.
socialdata_lastcheck	timestamp	[en] When social data was last refreshed.
ua	text	[en] User agent string captured for the contact.
udate	timestamp	[en] When the contact was last updated.
updated_timestamp	timestamp	[en] When the record was last updated.
updated_utc_timestamp	timestamp	[en] Last update stored without timezone.

Contacts: custom fields (data)

Replication type: Incremental or Full (user configurable)

Relationships:

contact → Contacts > id
field → Contacts: custom fields (meta) > id
owner → Accounts > id

Contact custom field values in ActiveCampaign.

Campo	Tipo
id	float	[en] Custom field value ID.
cdate	timestamp	[en] When the contact custom field value was created.
contact	float	[en] ID of the contact Contacts > > id
field	float	[en] ID of the custom field Contacts: custom fields (meta) > > id
owner	float	[en] ID of the user who owns the field value. Accounts > > id
udate	timestamp	[en] When the custom field value was last updated.
value	text	[en] Value for the field

Contacts: custom fields (meta)

Replication type: Full

Relationships:

created_by → Users > id

Main object

Contact custom field metadata in ActiveCampaign.

Campo	Tipo
id	float	[en] Custom field ID.
cdate	timestamp	[en] When the field was created.
cols	float	[en] Number of columns for layout (when applicable).
created_by	float	[en] User who created the field. Users > > id
created_timestamp	timestamp	[en] When the field metadata was created.
defval	text	[en] Default value of the field created
descript	text	[en] Description of field being created
isrequired	float	[en] Whether the field is required (1) or optional (0).
ordernum	float	[en] Order of appearance in ‘My Fields’ tab.
perstag	text	[en] The perstag that represents the field created
rows	float	[en] Number of rows for layout (when applicable).
show_in_list	float	[en] Whether the field is shown in list views.
title	text	[en] Title of the field created
type	text	[en] Possible Values: dropdown, hidden, checkbox, date, text, datetime, textarea, NULL, listbox, radio
udate	timestamp	[en] When the field metadata was last updated (string).
updated_by	float	[en] User who last updated the field.
updated_timestamp	timestamp	[en] When the field metadata was last updated.
service	text	[en] Possible Vales: nimble, contactually, mindbody, salesforce, highrise, google_spreadsheets, pipedrive, onepage, google_contacts, freshbooks, shopify, zendesk, etsy, NULL, bigcommerce, capsule, bigcommerce_oauth, sugarcrm, zohocrm, batchbook
visible	float	[en] Show or hide this field when using the Form Builder

activecampaign_contacts_custom_fields_meta__fieldOptions

Options associated to contact custom fields.

Campo	Tipo
field_id	float	[en] Identifier of the field metadata.
fieldoptions_id	float	[en] Identifier of the field option.
fieldoptions_cdate	timestamp	[en] When the option was created.
fieldoptions_label	text	[en] Label shown for the option.
fieldoptions_orderid	float	[en] Display order of the option.
fieldoptions_udate	timestamp	[en] When the option was last updated.
fieldoptions_value	text	[en] Underlying value stored for the option.

Contacts: list activity

Replication type: Incremental

Relationships:

campaign → Campaigns > id
contact → Contacts > id
list → Lists > id

List subscription activities for contacts in ActiveCampaign.

Campo	Tipo
id	float	[en] Activity ID.
automation	float	[en] Automation ID related to the activity.
autosynclog	text	[en] Metadata captured when the activity came from an automatic sync.
campaign	text	[en] Campaign ID tied to the list action. Campaigns > > id
contact	float	[en] Contact ID. Contacts > > id
created_timestamp	timestamp	[en] When the list activity was created.
form	float	[en] Form ID used in the list action.
first_name	text	[en] First name captured in the activity.
ip4sub	text	[en] IPv4 address used when subscribing.
ip4unsub	text	[en] IPv4 address used when unsubscribing.
ip4_last	text	[en] Last IPv4 address recorded for the list activity.
last_name	text	[en] Last name captured in the activity.
list	float	[en] List ID involved in the activity. Lists > > id
message	text	[en] Message content related to the list event.
responder	float	[en] Responder ID if the action relates to an autoresponder.
sdate	timestamp	[en] When the subscription event happened.
seriesid	float	[en] Identifier for the list automation series.
sourceid	float	[en] Source ID that generated the list event.
status	float	[en] Status in the list: 0 unconfirmed, 1 subscribed, 2 unsubscribed, 3 bounced.
sync	float	[en] Flag indicating if the activity came from a sync.
udate	timestamp	[en] When the record was last updated.
unsubreason	text	[en] Reason provided for unsubscribing.
unsubscribeautomation	text	[en] Automation triggered on unsubscribe.
updated_timestamp	timestamp	[en] When the activity record was last updated.

Contacts: notes

Replication type: Incremental

Relationships:

relid → Contacts > id
userid → Users > id

Notes registered for contacts in ActiveCampaign.

Campo	Tipo
id	float	[en] Note ID.
cdate	timestamp	[en] When the note was created.
is_draft	float	[en] Whether the note is in draft status (1) or published (0).
mdate	timestamp	[en] When the note was last modified.
note	text	[en] Text of the note.
relid	float	[en] Contact ID linked to the note. Contacts > > id
reltype	text	[en] Type of entity related to the note.
userid	float	[en] ID of the user who created the note. Users > > id

Contacts: tags

Replication type: Incremental or Full (user configurable)

Relationships:

contact → Contacts > id

Tags linked to contacts in ActiveCampaign.

Campo	Tipo
contact	float	[en] ID of the contact. Contacts > > id
id	float	[en] ID of the tag-to-contact association.
tag_name	text	[en] Name of the tag.
tag_description	text	[en] Description of the tag.
tag_id	float	[en] ID of the tag.
tag_cdate	timestamp	[en] When the tag record was created.
tag_created_by	text	[en] User who created the tag.
tag_created_timestamp	timestamp	[en] When the tag was created.
tag_deleted	float	[en] Whether the tag is marked as deleted (1) or active (0).
tag_tagtype	text	[en] Tag type, such as template or contact.
tag_updated_timestamp	timestamp	[en] When the tag record was last updated.
cdate	timestamp	[en] When the tag was added to the contact.
created_by	text	[en] User who created the tag-to-contact association.
created_timestamp	timestamp	[en] When the tag association was created.
updated_by	text	[en] User who last updated the tag association.
updated_timestamp	timestamp	[en] When the tag association was last updated.

Contacts: tasks

Replication type: Full

Relationships:

assignee → Users > id
done_by → Users > id
outcomeid → Tasks: outcomes > id
contact_id → Contacts > id

Tasks linked to contacts in ActiveCampaign.

Campo	Tipo
id	float	[en] Task ID.
assigned_date	timestamp	[en] When the task was assigned.
assignee	float	[en] The id of an user the task is assigned to Users > > id
automation	text	[en] Automation associated to trigger on task completion (optional).
cdate	timestamp	[en] When the task record was created.
created_utc_timestamp	timestamp	[en] When the task record was created (UTC).
donedate	timestamp	[en] When the task was completed.
tasktype	float	[en] The type of the task based on the available Task Types in the account
doneautomation	text	[en] Id of an automation that will be triggered when the task is completed.
done_by	float	[en] User who completed the task. Users > > id
done_utc_timestamp	timestamp	[en] When the task was completed (UTC).
duedate	timestamp	[en] Due date of the task
duration	float	[en] Duration of the task.
edate	timestamp	[en] Due date of the task.
note	text	[en] The content describing the task
outcomeid	float	[en] Outcome selected when completing the task. Tasks: outcomes > > id
outcomeinfo	text	[en] Extra information about the task outcome.
contact_name	text	[en] Title of the related object (contact).
contact_id	float	[en] Id of relational object Contacts > > id
status	float	[en] Task status means complete or incomplete. 1 is complete and 0 is incomplete.
tasktitle	text	[en] The title of the task
udate	timestamp	[en] When the task was last updated.
updated_utc_timestamp	timestamp	[en] When the task was last updated (UTC).
user	float	[en] User responsible for the task.

Deals

Replication type: Incremental or Full (user configurable)

Relationships:

account → Accounts > id
contact → Contacts > id
pipeline_id → Pipelines > id
nexttask → Deals: tasks > id
owner → Users > id
stage → Pipelines > dealStages > dealstages_id

Deals managed in ActiveCampaign.

Campo	Tipo
id	float	[en] Deal ID.
account	float	[en] Deals account id Accounts > > id
activitycount	float	[en] Number of activities linked to the deal.
cdate	timestamp	[en] When the deal was created.
contact	float	[en] Deal's primary contact's id. Contacts > > id
currency	text	[en] Deal's currency in 3-digit ISO format, lowercased.
customeraccount	float	[en] Customer account ID related to the deal.
description	text	[en] Deal's description
edate	timestamp	[en] Expected close date of the deal.
pipeline_id	float	[en] Deal's pipeline id. Pipelines > > id
hash	text	[en] Unique hash identifier for the deal.
isdisabled	boolean	[en] Whether the deal is marked as disabled/archived.
mdate	timestamp	[en] When the deal was last modified.
nexttask	float	[en] Upcoming task ID associated to the deal. Deals: tasks > > id
nextdate	timestamp	[en] Date of the next scheduled activity.
nextdealid	float	[en] ID of the next deal in sequence.
nexttaskid	float	[en] ID of the next task linked to the deal.
organization	float	[en] Organization ID tied to the deal.
owner	float	[en] Deal's owner id. Users > > id
percent	float	[en] Deal's percentage.
stage	float	[en] Deal's stage id. Pipelines > dealStages > dealstages_id
status	float	[en] Deal's status.
title	text	[en] Deal's title.
value	float	[en] Deal's value in cents
winprobability	float	[en] Current win probability percentage for the deal.
winprobabilitymdate	timestamp	[en] When win probability was last updated.

Deals: activities

Replication type: Incremental

Relationships:

deal_id → Deals > id
d_stageid → Pipelines > dealStages > dealstages_id
stage → Pipelines > dealStages > dealstages_id
userid → Users > id

Activity logs for deals in ActiveCampaign.

Campo	Tipo
id	float	[en] Activity ID.
automation	float	[en] Automation ID related to the activity.
cdate	timestamp	[en] When the activity occurred.
deal_id	float	[en] Deal id Deals > > id
d_stageid	float	[en] Stage ID of the deal at the time of the activity. Pipelines > dealStages > dealstages_id
dataaction	text	[en] Action type recorded in the activity.
dataid	float	[en] Identifier of the entity affected by the action.
dataoldval	text	[en] Previous value before the change.
datatype	text	[en] Entity type involved in the activity (e.g., contact or deal).
deleted	float	[en] Indicates if the activity marks a deletion (1) or not (0).
isaddtask	float	[en] Whether the activity adds a task (1) or not (0).
seriesid	float	[en] Series ID if the activity belongs to a sequence.
sortdate	timestamp	[en] Date used for sorting activities.
stage	float	[en] Name or ID of the deal stage involved. Pipelines > dealStages > dealstages_id
userid	float	[en] User who performed the activity. Users > > id

Deals: custom fields (data)

Replication type: Incremental or Full (user configurable)

Relationships:

custom_field_id → Deals: custom fields (meta) > id
deal_id → Deals > id

Deal custom field values in ActiveCampaign.

Campo	Tipo
id	float	[en] Custom field value ID.
created_timestamp	timestamp	[en] When the custom field value was created.
custom_field_currency_type	text	[en] Currency code used in the field value.
custom_field_currency_value	float	[en] Monetary amount stored for the field.
custom_field_date_value	timestamp	[en] Date value stored for the field.
custom_field_id	float	[en] ID of the custom field metadata. Deals: custom fields (meta) > > id
custom_field_number_value	float	[en] Numeric value stored for the field.
custom_field_text_blob	text	[en] Long text content stored for the field.
custom_field_text_value	text	[en] Text value stored for the field.
dealcustomfieldmetum	float	[en] Alias name of the custom field.
deal_id	float	[en] ID of the deal the value belongs to. Deals > > id
updated_timestamp	timestamp	[en] When the custom field value was last updated.

Deals: custom fields (meta)

Replication type: Full

Relationships:

createdby → Users > id
updatedby → Users > id

Deal custom field metadata in ActiveCampaign.

Campo	Tipo
id	float	[en] Custom field ID.
createdby	float	[en] User who created the field. Users > > id
createdtimestamp	timestamp	[en] When the field was created.
displayorder	float	[en] Order for displaying the field on Manage Fields page and deal profiles
fielddefault	text	[en] Default value of the field
fielddefaultcurrency	text	[en] The 3-letter currency code of the default currency for the field.
fieldlabel	text	[en] Name of the field
fieldoptions	text	[en] Options for the field.
fieldtype	text	[en] Type of field. Possible values are: text, textarea, date, datetime, dropdown, multiselect, radio, checkbox, hidden, currency, or number.
hidefieldflag	float	[en] Whether the field is hidden (1) or visible (0).
isformvisible	float	[en] Whether or not the field is visible on forms
isrequired	float	[en] Whether the field is required (1) or optional (0).
knownfieldid	float	[en] Identifier when the field maps to a predefined field.
personalization	text	[en] Personalization tag for using the field in messages.
updatedby	float	[en] User who last updated the field. Users > > id
updatedtimestamp	timestamp	[en] When the field was last updated.

Deals: secondary contacts

Replication type: Incremental

Relationships:

contact → Contacts > id
deal → Deals > id

Secondary contacts linked to deals in ActiveCampaign.

Campo	Tipo
id	float	[en] Association ID between deal and secondary contact.
cdate	timestamp	[en] When the secondary contact was added.
contact	float	[en] Contact's id Contacts > > id
created_timestamp	timestamp	[en] When the record was created.
deal	float	[en] Deal's id Deals > > id
role	text	[en] Role of the contact on the deal.
updated_timestamp	timestamp	[en] When the record was last updated.

Deals: tasks

Replication type: Full

Relationships:

assignee → Users > id
done_by → Users > id
outcomeid → Tasks: outcomes > id
deal_id → Deals > id
user → Users > id

Tasks linked to deals in ActiveCampaign.

Campo	Tipo
id	float	[en] Task ID.
assigned_date	timestamp	[en] When the task was assigned.
assignee	float	[en] The id of an user the task is assigned to Users > > id
automation	text	[en] Automation identifier associated to the task.
cdate	timestamp	[en] When the task was created.
created_utc_timestamp	timestamp	[en] When the task was created (UTC).
donedate	timestamp	[en] When the task was completed.
dealtasktype	float	[en] The type of the task based on the available Task Types in the account
doneautomation	text	[en] Id of an automation that will be triggered when the task is completed.
done_by	float	[en] User who completed the task. Users > > id
done_utc_timestamp	timestamp	[en] When the task was completed (UTC).
duedate	timestamp	[en] Due date of the task
duration	float	[en] Duration of the task.
edate	timestamp	[en] Due date of the task.
note	text	[en] The content describing the task
outcomeid	float	[en] Outcome selected when completing the task. Tasks: outcomes > > id
outcomeinfo	text	[en] Extra information about the task outcome.
deal_name	text	[en] Title of the related object (deal).
deal_id	float	[en] Id of relational object Deals > > id
status	float	[en] Task status means complete or incomplete. 1 is complete and 0 is incomplete.
tasktitle	text	[en] The title of the task
udate	timestamp	[en] When the task was last updated.
updated_utc_timestamp	timestamp	[en] When the task was last updated (UTC).
user	float	[en] User responsible for the task. Users > > id

Lists

Replication type: Full

Relationships:

userid → Users > id

Lists configured in ActiveCampaign.

Campo	Tipo
id	float	[en] List ID.
analytics_domains	text	[en] Analytics domains configured for the list.
analytics_source	text	[en] Analytics source identifier for the list.
analytics_ua	text	[en] Analytics user agent or tracking ID.
carboncopy	text	[en] Comma-separated list of email addresses to send a copy of all mailings to upon send
cdate	timestamp	[en] When the list was created.
created_timestamp	timestamp	[en] When the list record was created.
deletestamp	text	[en] Raw deletion marker for the list.
facebook_session	text	[en] Stored Facebook session data for the list.
fulladdress	text	[en] Full sender address text.
get_unsubscribe_reason	float	[en] Flag to collect unsubscribe reasons.
name	text	[en] Name of the list to create
optinmessageid	float	[en] Confirmation message ID used for opt-in.
optinoptout	float	[en] Opt-in or opt-out mode indicator.
optoutconf	float	[en] Flag to confirm opt-out actions.
p_embed_image	float	[en] Embed images in emails flag.
p_use_analytics_link	float	[en] Enable analytics tracking on links.
p_use_analytics_read	float	[en] Enable analytics for email opens.
p_use_captcha	float	[en] Flag to require captcha on forms.
p_use_facebook	float	[en] Enable Facebook integration for the list.
p_use_tracking	float	[en] General tracking flag for the list.
p_use_twitter	float	[en] Enable Twitter integration for the list.
private	float	[en] Flag indicating if the list is private.
require_name	float	[en] Flag requiring subscriber name on forms.
send_last_broadcast	float	[en] Value indicating whether or not to send the last sent campaign to this list to a new subscriber upon subscribing. 1 = yes, 0 = no
sender_addr1	text	[en] Sender address line 1.
sender_addr2	text	[en] Sender address line 2.
sender_city	text	[en] Sender city.
sender_country	text	[en] Sender country.
sender_name	text	[en] Sender name displayed in emails.
sender_phone	text	[en] Sender phone number.
sender_reminder	text	[en] A reminder for your contacts as to why they are on this list and you are messaging them.
sender_state	text	[en] State or region of the sender.
sender_url	text	[en] The website URL this list is for.
sender_zip	text	[en] Sender ZIP or postal code.
stringid	text	[en] URL-safe list name. Example: 'list-name-sample'
subscription_notify	text	[en] Comma-separated list of email addresses to notify when a new subscriber joins this list.
to_name	text	[en] Value used to personalize the recipient name.
udate	text	[en] Raw update marker for the list.
unsubscription_notify	text	[en] Comma-separated list of email addresses to notify when a subscriber unsubscribes from this list.
updated_timestamp	timestamp	[en] When the list record was last updated.
userid	float	[en] User Id of the list owner. Users > > id

Lists: contacts

Replication type: Incremental

Relationships:

campaign → Campaigns > id
contact → Contacts > id
list → Contacts > id

Associations between contacts and lists in ActiveCampaign.

Campo	Tipo
id	float	[en] Contact ID.
automation	text	[en] Automation ID linked to the list action.
autosynclog	text	[en] Metadata from automatic sync related to the list activity.
campaign	text	[en] Campaign ID tied to the list action. Campaigns > > id
contact	float	[en] Contact ID linked to the list record. Contacts > > id
created_timestamp	timestamp	[en] When the list activity was created.
first_name	text	[en] First name captured in the activity.
form	text	[en] Form ID used in the list action.
ip4sub	text	[en] IPv4 address used when subscribing.
ip4unsub	text	[en] IPv4 address used when unsubscribing.
ip4_last	text	[en] Last IPv4 address recorded for the list activity.
last_name	text	[en] Last name captured in the activity.
list	float	[en] List ID related to the contact action. Contacts > > id
message	text	[en] Message text tied to the list activity.
responder	float	[en] Flag indicating the action came from an auto-responder.
sdate	timestamp	[en] Date recorded for the list action.
seriesid	float	[en] Identifier for the list automation series.
status	float	[en] Status in the list: 0 unconfirmed, 1 subscribed, 2 unsubscribed, 3 bounced.
sync	float	[en] Flag indicating if the activity came from a sync.
udate	timestamp	[en] When the record was last updated.
unsubreason	text	[en] Reason provided for unsubscribing.
unsubscribeautomation	text	[en] Automation triggered on unsubscribe.
updated_timestamp	timestamp	[en] When the activity record was last updated.

Pipelines

Replication type: Full

Main object

Deal pipelines configured in ActiveCampaign.

Campo	Tipo
id	float	[en] Pipeline ID.
allgroups	float	[en] Flag for visibility to all groups (1 true, 0 false).
allusers	float	[en] Flag for visibility to all users (1 true, 0 false).
autoassign	float	[en] Auto-assign setting for deals in this pipeline.
cdate	timestamp	[en] When the pipeline was created.
currency	text	[en] Currency code used in the pipeline.
dealstages_cardregion4	text	[en] Field shown in card region 4.
dealstages_cardregion5	text	[en] Field shown in card region 5.
title	text	[en] Title of the pipeline.
udate	timestamp	[en] When the pipeline was last updated.
win_probability_initialize_date	timestamp	[en] When win probability calculations were initialized for the pipeline.

deals_pipelines_all__dealStages

Deal stages within each pipeline.

Campo	Tipo
pipeline_id	float	[en] Pipeline ID.
dealstages_id	float	[en] Stage id
dealstages_cardregion1	text	[en] Field shown in card region 1.
dealstages_cardregion2	text	[en] Field shown in card region 2.
dealstages_cardregion3	text	[en] Field shown in card region 3.
dealstages_cardregion4	text	[en] Field shown in card region 4.
dealstages_cardregion5	text	[en] Field shown in card region 5.
dealstages_cdate	timestamp	[en] When the stage was created.
dealstages_color	text	[en] Hex color used to display the stage.
dealstages_dealorder	text	[en] Default ordering of deals inside the stage.
dealstages_order	float	[en] Position of the stage within the pipeline.
dealstages_title	text	[en] Title of the stage.
dealstages_udate	timestamp	[en] When the stage was last updated.
dealstages_width	float	[en] Column width for the stage in the board view.

Scores

Replication type: Full

Scoring configurations applied to contacts or deals in ActiveCampaign.

Campo	Tipo
id	float	[en] Score ID.
cdate	timestamp	[en] When the score was created.
descript	text	[en] Description of the score.
mdate	timestamp	[en] When the score was last modified.
name	text	[en] Score name
reltype	text	[en] Entity type the score applies to (contact or deal).
status	float	[en] Status of the score (1 active, 0 inactive).

Tasks: outcomes

Replication type: Full

Relationships:

created_by → Users > id
updated_by → Users > id

ActiveCampaign task outcomes with sentiment and audit details.

Campo	Tipo
id	float	[en] Outcome id
created_by	float	[en] User who created the outcome. Users > > id
created_utc_timestamp	timestamp	[en] When the outcome was created (UTC).
disabled	float	[en] 1 for disabled outcome, 0 for active.
sentiment	text	[en] Outcome sentiment (POSITIVE, NEGATIVE or NEUTRAL).
title	text	[en] Outcome title.
updated_by	float	[en] User who last updated the outcome. Users > > id
updated_utc_timestamp	timestamp	[en] When the outcome was last updated (UTC).

Tasks: types

Replication type: Full

Relationships:

created_by → Users > id
updated_by → Users > id
outcomes_id > outcomes → Tasks: outcomes > id

Main object

ActiveCampaign task types with metadata and audit info.

Campo	Tipo
id	float	[en] Task type id
cdate	timestamp	[en] Datetime when the task type was created.
created_by	float	[en] ID of the user; '0' or None for predefined fields. Users > > id
created_utc_timestamp	timestamp	[en] Creation datetime in UTC.
defduration	float	[en] Default duration for the task type.
display_order	float	[en] Order to display the task type.
status	float	[en] Status indicator for the task type.
title	text	[en] Task type title.
udate	timestamp	[en] Last update datetime of the task type.
updated_by	float	[en] ID of the user who last updated the task type. Users > > id
updated_utc_timestamp	timestamp	[en] Update datetime in UTC.

tasks_types__outcomes

Outcomes available for each task type.

Campo	Tipo
type_id	float	[en] Task type id
outcomes_id	float	[en] Task outcome id Tasks: outcomes > > id
outcomes_display_order	float	[en] Display order for the outcome.

Campo

Tipo

type_id

float

[en] Task type id

outcomes_id

float

[en] Task outcome id

Tasks: outcomes > > id

outcomes_display_order

float

[en] Display order for the outcome.

User groups

Replication type: Full

User permission groups in ActiveCampaign.

Campo	Tipo
id	float	[en] Group ID.
descript	text	[en] Group description
optinconfirm	float	[en] Whether or not to force optin confirm for this group
p_admin	float	[en] Admin privileges flag for the group.
pgaccountadd	float	[en] Permission to add accounts.
pgaccountdelete	float	[en] Permission to delete accounts.
pgaccountedit	float	[en] Permission to edit accounts.
pgaccountexport	float	[en] Permission to export accounts.
pgaccountimport	float	[en] Permission to import accounts.
pgaccountmanagecustomfield	float	[en] Permission to manage account custom fields.
pgaccountnoteadd	float	[en] Permission to add account notes.
pgaccountnotedelete	float	[en] Permission to delete account notes.
pgaccountnoteedit	float	[en] Permission to edit account notes.
pgautomationmanage	float	[en] Permission for manage automations
pgcontactactions	float	[en] Permission for managing contact actions
pgcontactadd	float	[en] Permission for adding contacts
pgcontactapprove	float	[en] Permission for approving contacts
pgcontactdelete	float	[en] Permission for deleting contacts
pgcontactedit	float	[en] Permission for editing contacts
pgcontactexport	float	[en] Permission for exporting contacts
pgcontactfields	float	[en] Permission for managing contact custom fields
pgcontactfilters	float	[en] Permission for managing contact list segments
pgcontactimport	float	[en] Permission for importing contacts
pgcontactmerge	float	[en] Permission for merging contacts
pgcontactresubscribe	float	[en] Permission to resubscribe contacts.
pgcontactsync	float	[en] Permission for syncing contacts
pgdeal	float	[en] Permission for viewing deals
pgdealdelete	float	[en] Permission for deleting deals
pgdealexport	float	[en] Permission to export deals.
pgdealfields	float	[en] Permission to manage deal fields.
pgdealgroupadd	float	[en] Permission for adding deal groups
pgdealgroupdelete	float	[en] Permission for deleting deals groups
pgdealgroupedit	float	[en] Permission for editing deal groups
pgdealimport	float	[en] Permission to import deals.
pgdeallistall	float	[en] Permission to list all deals.
pgdealmanageroles	float	[en] Permission to manage deal roles.
pgdealnoteadd	float	[en] Permission to add deal notes.
pgdealnotedelete	float	[en] Permission to delete deal notes.
pgdealnoteedit	float	[en] Permission to edit deal notes.
pgdealreassign	float	[en] Permission for reassigning deals
pgformedit	float	[en] Permission for editing subscription forms
pggroupadd	float	[en] Permission for adding groups
pggroupdelete	float	[en] Permission for deleting groups
pggroupedit	float	[en] Permission for adding groups
pglandingpagesaccess	float	[en] Permission to access landing pages.
pglistadd	float	[en] Permission for adding lists
pglistbounce	float	[en] Permission for accessing list bounce settings
pglistdelete	float	[en] Permission for deleting lists
pglistedit	float	[en] Permission for editing lists
pglistemailaccount	float	[en] Permission for managing Unsubscribe By Email
pglistheaders	float	[en] Permission for managing custom email headers
pgmessageadd	float	[en] Permission for adding messages
pgmessagedelete	float	[en] Permission for deleting messages
pgmessageedit	float	[en] Permission for editing messages
pgmessagesend	float	[en] Permission for sending messages
pgmfaadmin	float	[en] Permission to administer multi-factor settings.
pgpersonalizationadd	float	[en] Permission for adding personalization tags
pgpersonalizationdelete	float	[en] Permission for editing personalization tags
pgpersonalizationedit	float	[en]
pgreportscampaign	float	[en] Permission for viewing campaign reports
pgreportsdeal	float	[en] Permission to view deal reports.
pgreportslist	float	[en] Permission for viewing list reports
pgreportstrend	float	[en] Permission for viewing trend reports
pgreportsuser	float	[en] Permission for viewing user reports
pgsavedresponsesmanage	float	[en] Permission for managing saved responses
pgstartupgettingstarted	float	[en] Whether or not to show the (getting started) tutorial on overview page
pgstartupreports	float	[en] Campaign ID of last campaign report viewed to decide whether to show link on startup
pgtagmanage	float	[en] Permission for managing tags
pgtemplateadd	float	[en] Permission for adding templates
pgtemplatedelete	float	[en] Permission for deleting templates
pgtemplateedit	float	[en] Permission for editing templates
pgwebpersonalizationmanage	float	[en] Permission to manage web personalization.
pg_user_add	float	[en] Permission for adding users
pg_user_delete	float	[en] Permission for deleting users
pg_user_edit	float	[en] Permission for editing users
reqapproval	float	[en] Whether or not this group requires all campaigns to be approved
reqapproval1st	float	[en] Whether or not this group requires first campaign to be approved
reqapprovalnotify	text	[en] Who to notify for approval related issues (email)
sdate	timestamp	[en] When the group was created.
socialdata	float	[en] Whether or not to show social links in campaigns sent from this group
title	text	[en] Title of the group
unsubscribelink	float	[en] Whether or not to force unsubscribe links

Users

Replication type: Full

Relationships:

usergroups_groupid > userGroups → User groups > id

Main object

Users configured in ActiveCampaign.

Campo	Tipo
id	float	[en] User ID.
username	text	[en] Username
cdate	timestamp	[en] When the user account was created.
email	text	[en] Email address
firstname	text	[en] First name
lang	text	[en] Preferred language of the user.
lastname	text	[en] Last name
localzoneid	text	[en] Local timezone of the user.
mfaenabled	float	[en] Flag indicating if MFA is enabled (1) or not (0).
password_updated_utc_timestamp	timestamp	[en] When the user password was last updated (UTC).
phone	text	[en] Phone number of the user.
signature	text	[en] Email signature of the user.
udate	timestamp	[en] When the user record was last updated.

users__userGroups

Groups associated to users.

Campo	Tipo
user_id	float	[en] User ID replicated for the group membership.
usergroups_cdate	timestamp	[en] When the user was added to the group.
usergroups_groupid	float	[en] Group id User groups > > id
usergroups_udate	timestamp	[en] When the membership was last updated.

Notes

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Add ActiveCampaign as a Kondado data source

Connect your ActiveCampaign account to Kondado by configuring API credentials and permissions, then load marketing data into your data warehouse.

Prepare ActiveCampaign user permissions

Ensure your ActiveCampaign user has admin or read-only permissions for all entities (Lists, Campaigns, Contacts, Deals, Automations, etc.). If not, create a user group via Settings > Users and Group > Groups, assign all permissions, and add the user to that group.

Retrieve ActiveCampaign API credentials

In ActiveCampaign, go to Settings > Developer in the left sidebar. Copy the URL and Key values—you'll need these to authenticate the connection on Kondado.

Add ActiveCampaign as a data source on Kondado

Log in to the Kondado platform, navigate to the data sources section, and select ActiveCampaign. Give your source a descriptive name.

Configure and save the connection

Paste the URL and Key from step 2 into the corresponding fields. Click SAVE to start syncing ActiveCampaign data—including Accounts, Campaigns, Contacts, Deals, and more—to your data warehouse or data lake.

Frequently asked questions

What ActiveCampaign permissions are required to connect with Kondado?▼

You need a user with permission to administer or read-only access to all ActiveCampaign entities, including Lists, Campaigns, Contacts, Deals, Automations, Reports, and Landing pages. If your user lacks these, an administrator must create a group with full permissions via Settings > Users and Group > Groups and assign your user to it.

Where do I find the API URL and Key for ActiveCampaign?▼

Log in to ActiveCampaign, select Settings from the left sidebar, then click Developer in the second menu. The URL and Key values displayed there are what you paste into Kondado when adding the ActiveCampaign data source.

What ActiveCampaign data can I sync through Kondado?▼

Kondado supports syncing a comprehensive set of ActiveCampaign objects, including Accounts, Campaigns (with messages and content), Contacts (with custom fields, list activity, notes, and tasks), Deals (with activities, custom fields, and tasks), Lists, Pipelines, Scores, and User data. You can explore all supported data integrations on our platform.

Can I send ActiveCampaign data to BI tools or spreadsheets?▼

Yes—once connected, your ActiveCampaign data flows to your chosen destination. You can route it to a data warehouse, or use Kondado to push it to spreadsheets and BI tools for reporting and visualization.

Do I need to create a user group if my ActiveCampaign user already has admin rights?▼

No. If your user already has administrator or read-only permissions across all entities, you can proceed directly to retrieving the API credentials. User groups are only needed when existing permissions are insufficient.

Written by

Thassyo Pereira·Published 2023-07-07·Updated 2026-04-25