ActiveCampaign

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.

Creating the data source

Requirements

Instructions

Pipelines

Summary

Relationship chart

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

Notes