Create New Columns

Add columns to an audience to define the shape of data it holds. Do this before loading rows — columnId values returned here are required by Bulk Upsert Rows. Choose dataType carefully — it cannot be changed after creation.

Supported dataType values for CUSTOM columns:

  • Text: TEXT (short labels, names, <2000 chars), LARGE_TEXT (notes, descriptions, >2000 chars)
  • Contact data: EMAIL (single address), PHONE (single number), URL (website or domain)
  • Numbers: INTEGER (whole numbers), DECIMAL (floating-point), PERCENT, CURRENCY
  • Boolean: BOOLEAN, CHECKBOX
  • Dates: DATE (calendar date, no time component)
  • Arrays: STRING_LIST, NUMBER_LIST, EMAIL_LIST, PHONE_LIST, URL_LIST
  • Structured: OBJECT (JSON)

Column types:

  • CUSTOM — Values you load directly via Bulk Upsert Rows. Requires name and dataType.
  • FORMULA — Values computed from a prompt expression evaluated across other columns in the audience.
  • AI — Values generated by a ZoomInfo AI tool. Requires prompt. Optionally specify tool (AI_DATA_ANALYSIS, AI_WEB_RESEARCH, AI_CONVERSATION_INTELLIGENCE, AI_EMAILER) and dataDependencies (other column IDs or knowledge base sources for grounding). Use Get Column Data Dependencies to discover valid context sources.
  • ZOOMINFO_MATCH — Values populated by ZoomInfo enrichment matching. Accepts only ZI_CONTACT_ID or ZI_COMPANY_ID as dataType. Configure match criteria via Upsert Column Match Criteria after creation.

Returns 201 Created with all column resources including system-assigned columnId values and read-only behavior flags (isDeletable, isEditable, isFilterable, isSortable).
Returns 400 if required fields are missing or dataType is invalid.
Returns 404 if no audience matches the provided audienceId.

Path Params
uuid
required

The unique identifier for the audience

Body Params

Request body containing the column creation details

JSON API model for create Column.

data
array of objects
required

The primary data of the document

data*
Responses

Language
Credentials
OAuth2
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/vnd.api+json