Mailing Work: Most-used fields

The table below gives information about most-used fields that you can import from Mailing Work. 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
account id	account id	The unique identifier for the Mailing Work account.	metric
accountId	accountId	The unique identifier for the Mailing Work account.	metric
clickDate	clickDate	The date and time when a recipient clicked a link in an email.	dimension
count_blacklisted	count_blacklisted	The total number of recipients who have been blacklisted.	metric
count_bounce_hard	count_bounce_hard	The total number of emails that resulted in a hard bounce, indicating a permanent delivery failure.	metric
count_bounce_soft	count_bounce_soft	The total number of emails that resulted in a soft bounce, indicating a temporary delivery failure.	metric
count_bounce_total	count_bounce_total	The total number of all bounces (hard and soft) for an email campaign or list.	metric
count_bounced	count_bounced	The total number of emails that have bounced. This includes both hard and soft bounces.	metric
count_click_total	count_click_total	The total number of clicks on links within an email campaign, including multiple clicks by the same recipient.	metric
count_click_unique	count_click_unique	The total number of unique recipients who clicked on at least one link within an email campaign.	metric
count_complained	count_complained	The total number of recipients who marked the email as spam or complained about the mailing.	metric
count_delayed	count_delayed	The total number of emails whose delivery was delayed.	metric
count_delivered	count_delivered	The total number of emails successfully delivered to recipients’ inboxes.	metric
count_error	count_error	The total number of errors encountered during email processing or delivery.	metric
count_invalid	count_invalid	The total number of invalid email addresses or recipients that could not be processed.	metric
count_opening_total	count_opening_total	The total number of times an email was opened, including multiple opens by the same recipient.	metric
count_opening_unique	count_opening_unique	The total number of unique recipients who opened an email at least once.	metric
count_subscriber	count_subscriber	The total number of subscribers on a specific mailing list or target group.	metric
count_unsubscribe	count_unsubscribe	The total number of recipients who unsubscribed from a mailing list.	metric
date	date	A date, often used to filter or timestamp data, such as campaign statistics or events.	dimension
date_time	date_time	The precise date and time of an event or record.	dimension
description	description	A general description associated with an entity, such as a list or campaign.	dimension
email id	email id	The unique identifier for an email campaign or individual email.	metric
html	html	The HTML content of an email.	dimension
id	id	A generic unique identifier for an entity (e.g., email ID, list ID, recipient ID).	dimension
link	link	The specific URL of a link within an email.	dimension
list description	list description	A description associated with a specific recipient list.	dimension
list id	list id	The unique identifier for a recipient list.	metric
list name	list name	The name of a recipient list.	dimension
listId	listId	The unique identifier for a recipient list.	metric
listName	listName	The name of a recipient list.	dimension
name	name	The name of an entity, such as a campaign, list, or target group.	dimension
openingRate	openingRate	The percentage of unique recipients who opened an email, calculated from unique openings.	metric
recipient	recipient	Represents an individual recipient, potentially including their details and subscription status.	dimension
recipient count	recipient count	The total number of recipients within a specific list.	metric
recipient id	recipient id	The unique identifier for an individual recipient.	metric
recipient.list_id.1	recipient.list_id.1	The unique identifier of a mailing list associated with a recipient, possibly indicating a primary or first list.	dimension
recipient.list_name.1	recipient.list_name.1	The name of a mailing list associated with a recipient, possibly indicating a primary or first list.	dimension
replyEmail	replyEmail	The email address designated to receive replies from recipients of an email campaign.	dimension
role_ids	role_ids		dimension
scheduleStart	scheduleStart	The date and time when an email campaign is scheduled to start sending.	dimension
senderEmail	senderEmail	The email address from which an email campaign is sent.	dimension
senderName	senderName	The name associated with the sender email address of an email campaign.	dimension
status	status	The current status of an email campaign (e.g., sent, scheduled, draft).	dimension
subject	subject	The subject line of an email campaign.	dimension
targetgroupId	targetgroupId	The unique identifier for a target group of recipients.	dimension
targetgroupName	targetgroupName	The name of a target group.	dimension
templateId	templateId	The unique identifier of the email template used for a campaign.	dimension
text	text	The plain text content of an email.	dimension
trackingHtml	trackingHtml	The HTML code snippet used for tracking opens and clicks within the HTML version of an email.	metric
trackingText	trackingText	The plain text code snippet used for tracking opens and clicks within the plain text version of an email.	metric
type	type	The category or classification of an event or entity, such as a bounce type (hard/soft) or email type.	dimension
url	url	A URL associated with an email, such as a link within the email or a campaign URL.	dimension