ActiveCampaign: Most-used fields

ActiveCampaign: Most-used fields#

The table below gives information about most-used fields that you can import from ActiveCampaign. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name

Adverity UI name

Description

Use in Adverity

activitycount

activitycount

The total count of activities.

dimension

cdate

cdate

The creation date for a record.

dimension

contact.adate

contact.adate

The archive date or another relevant activity date for the contact.

dimension

contact.anonymized

contact.anonymized

Indicates if the contact’s data has been anonymized.

dimension

contact.bounced_date

contact.bounced_date

The date an email to this contact bounced.

dimension

contact.bounced_hard

contact.bounced_hard

Indicates if an email to this contact resulted in a hard bounce.

dimension

contact.bounced_soft

contact.bounced_soft

Indicates if an email to this contact resulted in a soft bounce.

dimension

contact.cdate

contact.cdate

The creation date of the contact.

dimension

contact.created_by

contact.created_by

The user who created the contact.

dimension

contact.created_timestamp

contact.created_timestamp

The timestamp when the contact was created.

dimension

contact.created_utc_timestamp

contact.created_utc_timestamp

The UTC timestamp when the contact was created.

dimension

contact.deleted

contact.deleted

Indicates if the contact has been deleted.

dimension

contact.deleted_at

contact.deleted_at

The timestamp when the contact was deleted.

dimension

contact.edate

contact.edate

The last activity date for the contact.

dimension

contact.email

contact.email

The email address of the contact.

dimension

contact.email_domain

contact.email_domain

The domain part of the contact’s email address.

dimension

contact.email_local

contact.email_local

The local part (username) of the contact’s email address.

dimension

contact.firstName

contact.firstName

The first name of the contact.

dimension

contact.gravatar

contact.gravatar

The Gravatar hash for the contact’s email.

dimension

contact.hash

contact.hash

A unique hash identifier for the contact.

dimension

contact.id

contact.id

The unique identifier for the contact.

dimension

contact.ip

contact.ip

The IP address associated with the contact.

dimension

contact.lastName

contact.lastName

The last name of the contact.

dimension

contact.organization

contact.organization

The organization the contact belongs to.

dimension

contact.orgid

contact.orgid

The unique identifier for the contact’s organization.

dimension

contact.orgname

contact.orgname

The name of the contact’s organization.

dimension

contact.phone

contact.phone

The phone number of the contact.

dimension

contact.rating_tstamp

contact.rating_tstamp

The timestamp of the last rating update for the contact.

dimension

contact.sentcnt

contact.sentcnt

The count of emails sent to the contact.

dimension

contact.socialdata_lastcheck

contact.socialdata_lastcheck

The timestamp of the last check for social data for the contact.

dimension

contact.ua

contact.ua

The user agent string associated with the contact’s activity.

dimension

contact.udate

contact.udate

The last update date for the contact.

dimension

contact.updated_by

contact.updated_by

The user who last updated the contact.

dimension

contact.updated_timestamp

contact.updated_timestamp

The timestamp when the contact was last updated.

dimension

contact.updated_utc_timestamp

contact.updated_utc_timestamp

The UTC timestamp when the contact was last updated.

dimension

currency

currency

The currency used for a financial value.

dimension

customerAccount

customerAccount

The customer account associated with an order or transaction.

dimension

dealGroup.allgroups

dealGroup.allgroups

An indicator representing all deal groups within a deal pipeline.

dimension

dealGroup.allusers

dealGroup.allusers

An indicator representing all users associated with a deal group.

dimension

dealGroup.autoassign

dealGroup.autoassign

Indicates if auto-assignment is enabled for the deal group.

dimension

dealGroup.cdate

dealGroup.cdate

The creation date of the deal group (pipeline).

dimension

dealGroup.currency

dealGroup.currency

The currency used for deals within this group (pipeline).

dimension

dealGroup.id

dealGroup.id

The unique identifier for the deal group (pipeline).

dimension

dealGroup.title

dealGroup.title

The title or name of the deal group (pipeline).

dimension

dealGroup.udate

dealGroup.udate

The last update date of the deal group (pipeline).

dimension

dealGroup.win_probability_initialize_date

dealGroup.win_probability_initialize_date

The initialization date for the win probability calculation for the deal group.

dimension

dealStage.cardRegion1

dealStage.cardRegion1

A configurable region on the deal card for display purposes.

dimension

dealStage.cardRegion2

dealStage.cardRegion2

A configurable region on the deal card for display purposes.

dimension

dealStage.cardRegion3

dealStage.cardRegion3

A configurable region on the deal card for display purposes.

dimension

dealStage.cardRegion4

dealStage.cardRegion4

A configurable region on the deal card for display purposes.

dimension

dealStage.cardRegion5

dealStage.cardRegion5

A configurable region on the deal card for display purposes.

dimension

dealStage.cdate

dealStage.cdate

The creation date of the deal stage.

dimension

dealStage.color

dealStage.color

The color assigned to the deal stage.

dimension

dealStage.dealOrder

dealStage.dealOrder

The order of deals within this stage.

dimension

dealStage.group

dealStage.group

The deal group (pipeline) to which this stage belongs.

dimension

dealStage.id

dealStage.id

The unique identifier for the deal stage.

dimension

dealStage.order

dealStage.order

The display order of the deal stage within its pipeline.

dimension

dealStage.title

dealStage.title

The title or name of the deal stage.

dimension

dealStage.udate

dealStage.udate

The last update date of the deal stage.

dimension

dealStage.width

dealStage.width

The width setting for the deal stage display.

dimension

description

description

A descriptive text for the record.

dimension

edate

edate

The end date or last activity date for a record.

dimension

group

group

The group or pipeline to which a deal belongs.

dimension

hash

hash

A unique hash value for the record.

dimension

id

id

The unique identifier for the record.

dimension

isDisabled

isDisabled

Indicates if a user or entity is disabled.

dimension

mdate

mdate

The modification date for a record.

dimension

nextTask

nextTask

Information about the next task in a sequence.

dimension

nextdate

nextdate

The date of the next scheduled event or action.

dimension

nextdealid

nextdealid

The unique identifier of the next deal in a sequence.

dimension

nexttaskid

nexttaskid

The unique identifier of the next task in a sequence.

dimension

organization

organization

The organization associated with a contact or deal.

dimension

owner.cdate

owner.cdate

The creation date of the owner.

dimension

owner.email

owner.email

The email address of the owner.

dimension

owner.firstName

owner.firstName

The first name of the owner.

dimension

owner.id

owner.id

The unique identifier of the owner.

dimension

owner.lastName

owner.lastName

The last name of the owner.

dimension

owner.localZoneid

owner.localZoneid

The local time zone ID of the owner.

dimension

owner.phone

owner.phone

The phone number of the owner.

dimension

owner.udate

owner.udate

The last update date of the owner.

dimension

owner.username

owner.username

The username of the owner.

dimension

percent

percent

A percentage value.

dimension

stage

stage

The current stage of a deal in a sales pipeline.

dimension

status

status

The current status of the record or item.

dimension

title

title

A descriptive, human-readable name for an ActiveCampaign entity, commonly used for sales pipeline definitions (Pipelines), deal stages, or deal task types.

dimension

value

value

The monetary value associated with a deal or another record in ActiveCampaign.

dimension

winProbability

winProbability

Represents the likelihood of a deal closing successfully in a sales pipeline.

dimension

winProbabilityMdate

winProbabilityMdate

The date and time when the win probability of a deal was last modified.

dimension