DIM_CONTENT_SERVICE_CONTENTS

  • Updated on May 1, 2026
  • Published on Sep 9, 2025
  • 7 minute(s) read
Prev Next

The purpose of DIM_CONTENT_SERVICE_CONTENTS is to show meta data for each content item within the platform. It can be joined to various FACT tables on Content ID, 1 to many, to show activity by content. It can also be joined to BRG_CONTENT_TAGS, 1 to many, to show a row for each tag that is applied to the content item

COLUMN NAME

DATA TYPE (FIELD SIZE)

DESCRIPTION

CURRENT AVAILABLE VALUES

EXAMPLE

Archived At

TIMESTAMP_NTZ(9)

Datetime the content was archived

2025-01-01T00:00:00.000+0000

Artefact ID

VARCHAR(16777216)

Identifier for the artefact; various content types such as file, url, elearning will have an artefact id. This identifier changes when new versions of the artefact are uploaded

123a12b3cd4e5f67g890h1ij

Assessment Count

NUMBER(13,0)

The number of assessments within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

0

Assigned Audiences (ID)

VARIANT

List of audience IDs this content is assigned too

[“123a12b3cd4e5f67g890h1ij“]

Assigned Audiences (Name)

VARCHAR(16777216)

List of audience names this content is assigned too

Sales North East

Audiences Shared With (ID)

VARIANT

List of audience IDs this content has been shared with

[“123a12b3cd4e5f67g890h1ij“]

Audiences Shared With (Name)

VARCHAR(16777216)

List of audience names this content has been shared with

Sales North East

Audio Count

NUMBER(13,0)

The number of audio items within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

1

Author

VARCHAR(16777216)

Content author ID

123a12b3cd4e5f67g890h1ij

Author Email

VARCHAR(16777216)

Content author email address

john.smith@emailaddress.com

Author First Name

VARCHAR(16777216)

Content author first name

John

Author Full Name

VARCHAR(16777216)

Content author full name - concatenation of first and last names

John Smith

Author Last Name

VARCHAR(16777216)

Content author last name

Smith

Author Ref

VARCHAR(16777216)

Content author ref

ABC123

Available Translations

VARIANT

List of languages/transalations available (e.g. - en-us, de, en-gb etc.)

[ "en-us", "fr-ca" ]

CPD Category (ID)

VARCHAR(16777216)

ID of the CPD category the content relates to

123a12b3cd4e5f67g890h1ij

Can Reshare

BOOLEAN

Boolean flag (true/false)

TRUE, FALSE, null

TRUE

Collaboration Id

VARCHAR(16777216)

ID of the collaboration who own the content

123a12b3cd4e5f67g890h1ij

Collaboration Name

VARCHAR(16777216)

Name of the collaboration who own the content

Sales Training

Completion

VARCHAR(16777216)

Completion types for the content

Auto, External Confirmation, None - Switched Off, Pathway - Accept Historical Completions, Pathway - Accept Recent Completions, User Confirmation

Auto

Content Body Updated At

TIMESTAMP_NTZ(9)

Datetime the content body was last updated

2025-01-01T00:00:00.000+0000

Content Carousel Count

NUMBER(13,0)

The number of content carousel blocks within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

0

Content ID

VARCHAR(16777216)

Identifier for the content

123a12b3cd4e5f67g890h1ij

Content Tags

VARIANT

Tags linked to this content

[“sales”, “teamwork”]

Content Title

VARCHAR(16777216)

Content title

How to boost your sales this quarter

Content Type

VARCHAR(16777216)

Type of content (e.g. - url, file, video etc.)

mixed

Created At

TIMESTAMP_NTZ(9)

Datetime the content was created

2025-01-01T00:00:00.000+0000

Default Duration

NUMBER(38,0)

Default content duration in minutes

15

Deleted

BOOLEAN

Boolean flag (true/false) to show if the content has been deleted

TRUE, FALSE, null

FALSE

Deleted At

TIMESTAMP_NTZ(9)

Datetime the content was deleted

2025-01-01T00:00:00.000+0000

Deleted By (ID)

VARCHAR(16777216)

ID of the user who deleted the content

123a12b3cd4e5f67g890h1ij

Description

VARCHAR(16777216)

Content description

A quick guide to support you to achieve your sales goals

Distinct Item Count

NUMBER(18,0)

A distinct count of items included within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

7

Distinct Item Types

ARRAY

A list of distinct items included within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

[ "Video", "Text", "Audio", "Image", "Link", "Social Feed", "PDF/File", ]

Doc Created At

TIMESTAMP_NTZ(9)

Timestamp inherited from parent snowflake object(s)

2025-01-01T00:00:00.000+0000

Doc Updated At

TIMESTAMP_NTZ(9)

Timestamp inherited from parent snowflake object(s)

2025-01-01T00:00:00.000+0000

Embed Count

NUMBER(13,0)

The number of embedded content blocks within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

0

Erasure

VARIANT

Details of the content deletion including deleted datetime, deleted by details and whether it is a hard or soft deletion

{ "deletedAt": "2025-01-01T00:00:00.000Z", "deletedBy": { "type": "user", "value": "123a12b3cd4e5f67g890h1ij" }, "isHard": true, "isSoft": false }

Error Messages

VARIANT

Error messages related to the creation and uploading of content (e.g. - Unsupported format type, Scorm CAM 1.3 version is not supported”, No asset or sco items found etc.)

[ "Unsupported format type" ]

Event Log

VARIANT

Details of the content and related events such as draft created and content published. Along with associated timestamps

[ { "createdAt": "2025-01-01T00:00:00.000", "eventType": "contentDraftCreated", "loggedBy": { "type": "service", "value": "video-artefact-service" } }, { "createdAt": "2025-01-01T00:00:00.000", "eventType": "contentPublished", "loggedBy": { "type": "user", "value": "123a12b3cd4e5f67g890h1ij" } }, { "createdAt": "2025-01-01T00:00:00.000", "eventType": "contentArchived", "loggedBy": { "type": "user", "value": "123a12b3cd4e5f67g890h1ij" } }, { "createdAt": "2025-01-01T00:00:00.000", "eventType": "contentDeleted", "loggedBy": { "type": "user", "value": "123a12b3cd4e5f67g890h1ij" } } ]

External Reference

VARCHAR(16777216)

External reference for the content

123456789

Has Picture

BOOLEAN

Boolean flag (true/false) to show if the content has an image

TRUE, FALSE, null

FALSE

Image Count

NUMBER(13,0)

The number of images within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

1

Internal Version (__v)

VARCHAR(16777216)

Internal version number derived from the number of events within Versions

1

Is Allowed To Comment

BOOLEAN

Boolean flag (true/false) to show if comments are enabled for this piece of content

TRUE, FALSE, null

TRUE

Is Archived

BOOLEAN

Boolean flag (true/false) to show if the content has been archived

TRUE, FALSE, null

FALSE

Is Official

BOOLEAN

Boolean flag (true/false) to show if the content is endorsed

TRUE, FALSE, null

TRUE

Is Private

BOOLEAN

Boolean flag (true/false)

TRUE, FALSE, null

FALSE

Is Published

BOOLEAN

Boolean flag (true/false)

TRUE, FALSE, null

FALSE

Is Visible

BOOLEAN

Boolean flag (true/false)

TRUE, FALSE, null

TRUE

Item Count

NUMBER(18,0)

A total count of items included within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

11

Last Viewed Date

DATE

The date this content item was last viewed

2025-01-01

Last Viewed Time

VARCHAR(16777216)

The time this content item was last viewed

00:00:00

Last Viewed Timestamp

TIMESTAMP_NTZ(9)

The datetime this content item was last viewed

2025-01-01T00:00:00.000+0000

Link Count

NUMBER(13,0)

The number of links within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

1

Linked Contents

BOOLEAN

List of content IDs this content is linked with

[“123a12b3cd4e5f67g890h1ij“]

Linked Contents (Title)

VARCHAR(16777216)

List of content titles this content is linked with

Sales Top Tips

Marked Ready

BOOLEAN

Boolean flag (true/false)

TRUE, FALSE, null

FALSE

Material Type

VARCHAR(16777216)

Type of content material (e.g. - zip, mp3, jpeg etc.)

pptx

Mentorship Programme Count

NUMBER(13,0)

The number of mentorship programme blocks within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

0

Notifications

VARIANT

Legacy field which is no longer in use, around who would receive notifications for the content

{ "userName": { "firstName": "John", "lastName": "Smith" } }

Ordered Item Types

ARRAY

An ordered list of items included within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

[ "Image", "Video", "Text", "Audio", "Text", "Link", "Video", "Text", "PDF/File", "Social Feed", "PDF/File", ]

PDF/File Count

NUMBER(13,0)

The number of PDFs/files within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

2

Page Navigation Count

NUMBER(13,0)

The number of page navigation blocks within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

0

Processing Status

VARCHAR(16777216)

Shows the processing status of the content

failed, processing, null, complete, preprocessing

processing

Provider

VARCHAR(16777216)

The name of the content provider (e.g. - udemy, linkedIn, blinkist etc.)

andersPink

Published At

TIMESTAMP_NTZ(9)

Datetime the content was published2025-01-01T00:00:00.000+0000

Quiz Count

NUMBER(13,0)

The number of quizzes within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

0

Raw Items

VARIANT

The raw items document which includes all items within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

[ { "_id": "123a12b3cd4e5f67g890h1ij", "ai": null, "createdAt": "2025-01-01T00:00:00.000", "meta": { "body": "", "mentions": [], "uniqueId": "" }, "rank": 1, "status": "ok", "summary": "test-summary", "type": "rich_text", "updatedAt": "2025-01-01T00:00:00.000" } ................ ]

Set Duration

NUMBER(38,0)

Set content duration in minutes

15

Skill Boosts

VARIANT

Where completion of the content is linked to boosting learner skills the skill name and level is recorded

[ { "criteria": "on_completion", "level": 1024, "name": "sales" } ]

Social Feed Count

NUMBER(13,0)

The number of social feeds within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

1

Tenant ID

VARCHAR(16777216)

Identifier for the tenant

eu-west-2_abcdefGh1

Text Count

NUMBER(13,0)

The number of text blocks within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

3

Thumbnail Updated At

TIMESTAMP_NTZ(9)

Datetime the content thumbnail was last updated

2025-01-01T00:00:00.000+0000

Updated At

TIMESTAMP_NTZ(9)

Datetime the content was last updated - this may include audience updates

2025-01-01T00:00:00.000+0000

User IDs with Private Content Access

ARRAY

List of all user ids who can access this content, if the content is set to private

[“123a12b3cd4e5f67g890h1ij“]

Users Shared With (Full Name)

VARCHAR(16777216)

List of user names this content has been shared with

[“John Smith“]

Users Shared With (ID)

VARIANT

List of user IDs this content has been shared with

[“123a12b3cd4e5f67g890h1ij“]

Users from Assigned Audiences (ID)

ARRAY

Array of all user IDs the content has been assigned too

[“123a12b3cd4e5f67g890h1ij“]

Users from Audiences Shared With (ID)

ARRAY

Array of all user IDs the content has been shared with

[“123a12b3cd4e5f67g890h1ij“]

Version

NUMBER(38,0)

Shows the current version of the content

1

Versions

VARIANT

Shows the content version history including the artefactId for each version

[ { "artefactId": "123a12b3cd4e5f67g890h1ij", "version": 1 } ]

Video Count

NUMBER(13,0)

The number of videos within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

2

ZIP Files & Archive Count

NUMBER(13,0)

The number of zip files & archives within a content item created using the content creator

If no items exist in the record or the content has not been created by the content creator this will show null

0

Related articles