Categories

Stores category information (also known as folders) within Content Builder in Salesforce Marketing Cloud. Categories organize assets and content for easier navigation and management. This table allows you to create, update, delete, and query folder structures that help maintain a logical and accessible content hierarchy.

Table Specific Information

Select

Select all categories:

SELECT * FROM Categories

Retrieve all categories which have a specific ParentId:

SELECT * FROM Categories WHERE ParentId = 71839

Retrieve a specific category:

SELECT * FROM Categories WHERE Id = 94766

All the columns except SharedWith and SharingType can be sorted server side:

SELECT * FROM Categories ORDER BY Name ASC

Insert

To create a Category, you will need to specify at least the Name and ParentId column.

INSERT INTO Categories (Name, ParentId, categoryType) VALUES ('New New New Folder', 71839, 'asset')

Update

Categories may be modified by providing the Id of the category and issuing an UPDATE statement.

UPDATE Categories SET SharedWith = '333,555,888', SharingType = 'edit', EnterpriseId = 12345 WHERE Id = 71839

Delete

Categories may be deleted by providing the Id of the category and issuing a DELETE statement.

DELETE FROM Categories WHERE Id = 94843

Columns


Name	Type	ReadOnly	References	Filters	Description
Id [KEY]	Integer	True		=	Identifies the unique record for each category (folder) in Content Builder. This system-generated identifier (Id) is used to organize assets hierarchically and to link them to their parent or shared folders within Salesforce Marketing Cloud.
Name	String	False			Specifies the display name that identifies the category within Content Builder. This name appears in folder navigation, search filters, and sharing dialogs. Clear naming conventions improve asset discoverability and governance across business units.
ParentId	Integer	False		=	Stores the Id of the parent category that contains the current folder. This value defines the folder hierarchy and supports inherited access permissions, breadcrumb navigation, and logical content organization within Content Builder.
CategoryType	String	False			Defines the type of category, which is automatically aligned with the category type of its parent folder.
EnterpriseId	Integer	False			Identifies the enterprise-level business unit that owns the category. This Id links the folder to the root organization in an Enterprise 2.0 account and ensures that folder ownership and content visibility remain consistent across all subordinate business units.
MemberId	Integer	False			Stores the Id of the member (business unit) that created the category. This field defines ownership at the business-unit level and determines who can modify, rename, or delete the folder.
SharedWith	String	False			Lists up to 100 Marketing Cloud Member Ids (MIDs) that identify the business units with which the category is shared. To share the category with all business units in the enterprise, set this value to '0'. This option is available only if the account has access to Content Builder Across Enterprise Sharing. The SharedWith field cannot contain '0' and other MIDs simultaneously. Because shared categories reside in and are owned by the enterprise business unit, the enterprise MID should not be included in this list.
SharingType	String	False			Indicates the level of permission granted to the business units that are listed in the SharedWith field. The allowed values are edit.
Description	String	False			Provides a human-readable explanation of the category's purpose, contents, or usage context. Including a meaningful description improves folder searchability and helps maintain content governance across shared and private workspaces.