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

The combined start and end dates for an advertising campaign, typically captured from a Timeline column which represents a date range.

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 part of a web address, typically stored in a Link column type.

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

The person or entity responsible for a purchase, likely identified through a People column or a Text column.

dimension

Category

Category

A classification or type assigned to an item, often from a Dropdown, Status, or Text column.

dimension

Checked

Checked

A boolean indicator showing if an item has been marked as complete or selected, typically derived from a Checkbox column type.

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

The date when an item was included in a board, typically from a Date column type.

dimension

Due Date

Due Date

The deadline for a task or project, typically from a Date column type.

dimension

End Date

End Date

The completion date for a task or period, typically from a Date column or as part of a Timeline column.

dimension

Fees

Fees

Monetary charges or costs, typically stored in a Numbers or Currency column type.

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 complete and resolved web address, typically stored in a Link column type.

dimension

Flight Date

Flight Date

A specific date related to a campaign or event, typically from a Date or Timeline column type.

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 ID

Item ID

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

dimension

Length

Length

A measurement of duration or size, typically stored in a Numbers column type.

dimension

Live Date

Live Date

The date when an item or project becomes active or publicly available, typically from a Date column type.

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

The difference between revenue and costs, typically stored in a Numbers or Currency column type.

metric

Numbers

Numbers

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

dimension

Overall Status

Overall Status

The aggregated or primary status of an item or project, typically from a Status column type.

dimension

People

People

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

dimension

Product

Product

The specific product associated with an item, likely from a Text, Dropdown, or Connect Boards column type.

dimension

Report Date

Report Date

The date designated for reporting purposes, typically from a Date column type.

dimension

Sales Contact

Sales Contact

The individual responsible for sales interactions, typically from a People column type.

dimension

Start Date

Start Date

The commencement date for a task or period, typically from a Date column or as part of a Timeline column.

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

The date associated with a support ticket or event, typically from a Date column type.

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

A video file or a link to a video, potentially stored in a Files column type or a Link column type.

dimension