monday.com: Most-used fields

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

Ad Dates

Ad Dates

This refers to a monday.com Date column used to specify the start and end dates for an advertisement campaign or period. It supports various date formats and can include time.

dimension

Ad End Date

Ad End Date

The specific end date of an advertising campaign, usually extracted from a Date column or as part of a Timeline column.

dimension

Ad Start Date

Ad Start Date

The specific start date of an advertising campaign, usually extracted from a Date column or as part of a Timeline column.

dimension

Assigned

Assigned

Represents the user(s) or team assigned to an item or task on a monday.com board. This corresponds to a ‘People’ column type in the API, which allows assigning individuals or groups to responsibilities.

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 foundational URL or primary web address associated with an item, often stored in a URL or Text column on a monday.com board.

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

This field identifies the person or team responsible for a purchase or related task, using a monday.com People column. It allows assigning account members and provides access to their user details.

dimension

Category

Category

A classification or grouping for an item, often represented by a Status, Dropdown, or Text column on a monday.com board.

dimension

Checked

Checked

This field is a boolean indicator representing a simple yes/no or complete/incomplete status, implemented as a monday.com Checkbox column. It is used for tracking task completion, approvals, or confirmations.

dimension

Creation Log

Creation Log

System-generated data indicating when an item was created, often represented by a Creation Log column.

dimension

Creation log

Creation log

System-generated data indicating when an item was created, often represented by a Creation Log column.

dimension

Date

Date

A specific calendar date associated with an item, from a Date column type.

dimension

Date Added

Date Added

This field records the date and time when an item or task was created or added to the board, using a monday.com Date column. It can be automatically populated and is useful for tracking item age.

dimension

Due Date

Due Date

This field specifies the deadline for a task or project, implemented as a monday.com Date column. It captures the target completion date and time, critical for task management and reminders.

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

This field represents a monetary value or numerical amount, implemented as a monday.com Numbers column. It can be formatted to display various currencies and is used for tracking expenses, costs, or revenue.

metric

Files

Files

Digital files or documents associated with an item, stored and managed by a Files column type.

dimension

Final URL

Final URL

The ultimate or destination URL for an item, such as a landing page for an ad, often stored in a URL or Text column on a monday.com board.

dimension

Flight Date

Flight Date

This field specifies the date of a flight or related event, stored as a monday.com Date column. It captures the date and optionally time, relevant for travel planning or logistics.

dimension

Formula

Formula

The calculated output of a monday.com Formula column, based on other column values.

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

Represents an email address associated with a monday.com item, typically stored in an Email column type. This field allows users to store and retrieve email contact information directly on their boards.

dimension

Item ID

Item ID

The unique identifier for a specific record or task on a board.

dimension

Length

Length

Represents a numerical value indicating length, duration, or a generic quantity, typically stored in a Numbers, Duration, or similar numerical column type in monday.com.

dimension

Live Date

Live Date

This field indicates the date when an item, project, or campaign becomes active or goes live, using a monday.com Date column. It captures the date and optionally time.

dimension

Location Name

Location Name

The name of a geographical location, which is a component of the broader Location column type.

dimension

Locations/Geo

Locations/Geo

Geographical data including address, city, country, latitude, and longitude, from a Location column type.

dimension

Margin

Margin

Represents a numerical value, often a percentage or currency, indicating a margin. This is typically stored in a Numbers, Currency, or Formula column type in monday.com boards.

metric

Numbers

Numbers

A numerical value associated with an item, stored in a Numbers column type.

dimension

Overall Status

Overall Status

The comprehensive progress or state of an item or project, usually represented by a Status column on a monday.com board, indicating completion, progress, or other states.

dimension

People

People

Users assigned to an item, team, or project, identified by a People column type.

dimension

Product

Product

Represents the name or identifier of a product, likely stored as a Text, Dropdown, or Connect Boards column type, linking to product-related items or providing a product name.

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

This field identifies the sales team member or individual responsible for a sales opportunity or client, utilizing a monday.com People column. It enables assigning and managing sales-related responsibilities.

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, task, or project, defined by a Status column type.

dimension

Subitem IDs

Subitem IDs

The unique identifiers for sub-tasks or child items 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

The individuals assigned to a task or item, identified through a People column type.

dimension

Ticket Date

Ticket Date

This field records the date associated with a ticket, such as its creation or a specific event related to it, using a monday.com Date column. It captures the date and optionally time, useful for tracking ticket lifecycles.

dimension

Timeline

Timeline

A column type representing a date range with a start and end date, often used for project phases or duration.

dimension

Video

Video

Represents a video file or a link to a video, typically stored in a Files or URL column type. This allows users to attach or reference video content within their monday.com items.

dimension