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.
Asset Name Dimension
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.
Assigned Dimension
The user or team assigned to a specific item. Data is collected from a People column.
Attachments Dimension
Files, documents, or media linked to an item, stored and managed by a Files column type.
Base URL Dimension
The root URL for the monday.com API, which is 'https://api.monday.com/v2/'.
Board ID Metric
The unique identifier for a monday.com board.
Board Name Dimension
The user-defined name of a monday.com board.
Board Status Dimension
The current operational state of a monday.com board (e.g., active, archived, deleted).
Buyer Dimension
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.
Category Dimension
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.
Change Date Dimension
Represents the date when a specific item or a column value within an item was last modified. This can be a custom Date column or reflect the system's Last Updated column.
Checked Dimension
A binary indicator (checked/unchecked) reflecting the completion or verification status of an item. Data is collected from a Checkbox column.
Cost of Media Dimension
The numerical value representing the cost of media associated with an item. This is typically stored as a Numbers column or derived from a Formula column.
Country Dimension
This field represents a country column on a monday.com board, which stores country names or codes.
Creation Log Dimension
Automatically generated timestamp and user information detailing when a board item was created. This is a read-only field.
Creation log Dimension
System-generated data indicating when an item was created, often represented by a Creation Log column.
Creative Production Status Dimension
Represents the status of a creative production item, such as 'Working on it', 'Stuck', or 'Done'. This field captures the current state of a task or project, including its label, color, and completion status.
Date Dimension
A specific calendar date associated with an item, from a Date column type.
Date Added Dimension
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.
Due Date Dimension
The date by which a task or item is expected to be completed, usually a Date column.
End Date Dimension
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.
Fees Metric
A monetary amount or numerical value representing charges or costs. This is stored in a Numbers column, which supports various numerical inputs.
Files Dimension
References attached documents, images, or other media files. This data is managed through a Files column, which supports uploading and linking various file types.
Final URL Dimension
The conclusive web address or hyperlink associated with a board item. Data is collected from a Link column.
Formula Dimension
A calculated value derived from other columns on the board, using a Formula column.
Group Dimension
The logical grouping of items on a board, identified by its unique ID and title.
Item Dimension
The name or title of a specific record or task on a board.
Item Email Dimension
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.
Item ID Dimension
The unique identifier for a specific record or task on a board.
Length Dimension
Refers to a numerical value indicating duration, size, or quantity. This is generally represented by a Numbers column, storing quantitative data.
Live Date Dimension
The scheduled or actual date when an item or project becomes active or goes live. This is managed using a Date column type.
Location Dimension
This field represents a location column on a monday.com board, which stores geographical information or addresses.
Location Name Dimension
The geographical name associated with a board item, such as a city or address. Data is collected from a Location column.
Locations/Geo Dimension
Geographical information associated with an item, including details like address, city, country, latitude, and longitude. This data is represented by a Location column type.
Margin Metric
A numerical value representing the profit margin for an item. This is commonly a calculated field using a Formula column.
Mirror Dimension
The Mirror column type displays values from another board through a linked item, allowing users to surface data from connected boards without duplication. It works in conjunction with a 'Connect Boards Column' which links items. Via the API, the mirror column supports read and create operations, but values cannot be updated or cleared directly as they reflect the source column's value.
Monday Item ID Metric
This field represents the unique identifier assigned to an item (row) on a monday.com board.
Net Media Dimension
A numerical value representing the net media value for an item. This can be a direct input in a Numbers column or a calculated value from a Formula column.
Numbers Dimension
A numerical value associated with an item, stored in a Numbers column type.
Overall Comments Dimension
A free-form text field used to store general comments or additional descriptive information related to an item. This typically corresponds to a Long Text column.
Overall Status Dimension
The general progress or state of an item or project, often a Status column.
People Dimension
Refers to users or team members associated with an item, handled by a Person column.
Person Dimension
Represents one or more users assigned to an item. This corresponds to the People column type in monday.com.
Phone Metric
This field represents a phone column on a monday.com board, which stores phone numbers.
Product Dimension
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.
Report Date Dimension
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.
Request Date Dimension
The specific date when a request was initiated or recorded for an item. This is stored using a Date column type.
Sales Contact Dimension
The sales representative or contact person for a deal or client, using a Person or Email column.
Setup Date Dimension
The date on which a particular setup or configuration for an item was completed or scheduled. This is stored using a Date column type.
Start Date Dimension
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.
Status Dimension
The current state or progress of an item or task, managed by a Status column.
Subitem IDs Dimension
Unique identifiers for subitems linked to a parent item.
Subitems Dimension
A list of sub-tasks or child items linked to a parent item, including their IDs and names.
Submission Date Dimension
This field captures a specific date and optionally a time, indicating when an item or task was submitted. It is used for tracking deadlines, milestones, or any date-based progress on a monday.com board.
Team Members Dimension
A collection of users or a team associated with an item. This is managed using a People column, allowing assignment of multiple team members.
Ticket Date Dimension
The date a ticket or issue was created or recorded. This is stored in a Date column type.
Timeline Dimension
The start and end dates of a task or project phase, managed by a Timeline column.
Total Cost Dimension
The aggregated numerical value representing the total cost associated with an item. This can be stored in a Numbers column or derived via a Formula column.
Total Profit Dimension
The calculated numerical value representing the total profit generated by an item. This is typically implemented as a Formula column.
Video Dimension
A file or link representing video content associated with a board item. Data is collected from a File or Link column.