monday.com: Most-used fields

The table below gives information about most-used fields that you can import from monday.com. 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
Asset Name	Asset Name	The name of an attached file or asset associated with an item. This data is usually derived from a Files column, which stores various digital assets.	dimension
Assigned	Assigned	The user or team assigned to a specific item. Data is collected from a People column.	dimension
Attachments	Attachments	Files, documents, or media linked to an item, stored and managed by a Files column type.	dimension
Base URL	Base URL	The root URL for the monday.com API, which is ‘https://api.monday.com/v2/’.	dimension
Board ID	Board ID	The unique identifier for a monday.com board.	metric
Board Name	Board Name	The user-defined name of a monday.com board.	dimension
Board Status	Board Status	The current operational state of a monday.com board (e.g., active, archived, deleted).	dimension
Buyer	Buyer	Identifies the person or team responsible for a purchase or a specific item. This information is usually stored in a People column, representing the assigned user(s) on monday.com.	dimension
Category	Category	A classification or grouping label for an item. This is commonly implemented using a Status or Dropdown column, allowing users to select from predefined options.	dimension
Checked	Checked	A binary indicator (checked/unchecked) reflecting the completion or verification status of an item. Data is collected from a Checkbox column.	dimension
Creation Log	Creation Log	Automatically generated timestamp and user information detailing when a board item was created. This is a read-only field.	dimension
Creation log	Creation log	System-generated data indicating when an item was created, often represented by a Creation Log column.	dimension
Creative Production Status	Creative Production Status	Represents the current stage of creative production. This data is typically stored in a Status column, which provides predefined labels (e.g., “Working on it”, “Stuck”, “Done”) and their corresponding index and color.	dimension
Date	Date	A specific calendar date associated with an item, from a Date column type.	dimension
Date Added	Date Added	The specific date when an item was added or created. This data is stored in a Date column type, allowing for tracking of important timelines.	dimension
Due Date	Due Date	The date by which a task or item is expected to be completed, usually a Date column.	dimension
End Date	End Date	This field represents the conclusion date of a task, project, or event, stored as a monday.com Date column. It supports date and time values and can be used for tracking deadlines.	dimension
Fees	Fees	A monetary amount or numerical value representing charges or costs. This is stored in a Numbers column, which supports various numerical inputs.	metric
Files	Files	References attached documents, images, or other media files. This data is managed through a Files column, which supports uploading and linking various file types.	dimension
Final URL	Final URL	The conclusive web address or hyperlink associated with a board item. Data is collected from a Link column.	dimension
Formula	Formula	A calculated value derived from other columns on the board, using a Formula column.	dimension
Group	Group	The logical grouping of items on a board, identified by its unique ID and title.	dimension
Item	Item	The name or title of a specific record or task on a board.	dimension
Item Email	Item Email	The email address associated with a specific monday.com item. It is usually found in an Email column, providing contact information relevant to the item.	dimension
Item ID	Item ID	The unique identifier for a specific record or task on a board.	dimension
Length	Length	Refers to a numerical value indicating duration, size, or quantity. This is generally represented by a Numbers column, storing quantitative data.	dimension
Live Date	Live Date	The scheduled or actual date when an item or project becomes active or goes live. This is managed using a Date column type.	dimension
Location Name	Location Name	The geographical name associated with a board item, such as a city or address. Data is collected from a Location column.	dimension
Locations/Geo	Locations/Geo	Geographical information associated with an item, including details like address, city, country, latitude, and longitude. This data is represented by a Location column type.	dimension
Margin	Margin	Represents a numerical value, typically a financial margin or percentage. This data is best captured in a Numbers column, designed for numerical input.	metric
Monday Item Email	Monday Item Email	The email address associated with a board item. Data is collected from an Email column.	dimension
Numbers	Numbers	A numerical value associated with an item, stored in a Numbers column type.	dimension
Overall Status	Overall Status	The general progress or state of an item or project, often a Status column.	dimension
People	People	Refers to users or team members associated with an item, handled by a Person column.	dimension
Portal Status	Portal Status	Indicates the operational status or visibility of a portal. This field usually maps to a Status column, providing different states (e.g., “Active”, “Inactive”, “Under Review”) for managing portal-related tasks or projects.	dimension
Product	Product	Specifies the product associated with an item or task. This can be a Text column for a simple product name or a Dropdown column with predefined product options.	dimension
Report Date	Report Date	This field indicates the specific date on which a report is generated or due, implemented as a monday.com Date column. It captures the date and optionally time, relevant for tracking reporting cycles.	dimension
Sales Contact	Sales Contact	The sales representative or contact person for a deal or client, using a Person or Email column.	dimension
Start Date	Start Date	This field specifies the commencement date of a task, project, or event, stored as a monday.com Date column. It captures the date and optionally time, crucial for project planning and scheduling.	dimension
Status	Status	The current state or progress of an item or task, managed by a Status column.	dimension
Subitem IDs	Subitem IDs	Unique identifiers for subitems linked to a parent item.	dimension
Subitems	Subitems	A list of sub-tasks or child items linked to a parent item, including their IDs and names.	dimension
Team Members	Team Members	A collection of users or a team associated with an item. This is managed using a People column, allowing assignment of multiple team members.	dimension
Ticket Date	Ticket Date	The date a ticket or issue was created or recorded. This is stored in a Date column type.	dimension
Timeline	Timeline	The start and end dates of a task or project phase, managed by a Timeline column.	dimension
Video	Video	A file or link representing video content associated with a board item. Data is collected from a File or Link column.	dimension