ÃÛ¶¹ÊÓƵ

Datasets UI guide

This user guide provides instructions on performing common actions when working with datasets within ÃÛ¶¹ÊÓƵ Experience Platform user interface.

Getting started

This user guide requires a working understanding of the following components of ÃÛ¶¹ÊÓƵ Experience Platform:

View datasets view-datasets

In the Experience Platform UI, select Datasets in the left-navigation to open the Datasets dashboard. The dashboard lists all available datasets for your organization. Details are displayed for each listed dataset, including its name, the schema the dataset adheres to, and status of the most recent ingestion run.

The Platform UI with the Datasets item highlighted in the left navigation bar.

Select the name of a dataset from the Browse tab to access its Dataset activity screen and see details of the dataset you selected. The activity tab includes a graph visualizing the rate of messages being consumed as well as a list of successful and failed batches.

Metrics and visualizations of your selected dataset are highlighted.
The sample batches that relate to your selected dataset are highlighted.

More actions more-actions

You can Delete or Enable a dataset for Profile from the Dataset details view. To see the available actions, select … More in the top right of the UI. The drop-down menu appears.

The Datasets workspace with the ... More dropdown menu highlighted.

If you select Enable a dataset for Profile, a confirmation dialog appears. Select Enable to confirm your choice.

NOTE
To enable a dataset for Profile, the schema that the dataset adheres to must be compatible for use in Real-Time Customer Profile. See the Enable a dataset for profile section for more information.

The Enable dataset confirmation dialog.

If you select Delete, the Delete dataset confirmation dialog appears. Select Delete to confirm your choice.

NOTE
You cannot delete system datasets.

You can also delete a dataset or add a dataset for use with Real-Time Customer Profile from the inline actions found on the Browse tab. See the inline actions section for more information.

The Delete dataset confirmation dialog.

Inline dataset actions inline-actions

The datasets UI now offers a collections of inline actions for each available dataset. Select the ellipsis (…) of a dataset that you want to manage to see the available options in a pop-up menu. The available actions include;

More information on these available actions can be found in their respective sections. To learn how to manage large numbers of datasets simultaneously, refer to the bulk actions section.

Preview a dataset preview

You can preview dataset sample data from both the inline options of the Browse tab and also the Dataset activity view. From the Browse tab, select the ellipses (…) next to the dataset name you wish to preview. A menu list of options appears. Next, select Preview dataset from the list of available options. If the dataset is empty, the preview link will be deactivated and will instead say that the preview is not available.

The Browse tab of the Datasets workspace with the ellipsis and Preview dataset option highlighted for the chosen dataset.

This opens the preview window, where the hierarchical view of the schema for the dataset is shown on the right.

NOTE
The schema diagram on the left side of the view only displays fields that contain data. Fields without data are automatically hidden to streamline the UI and focus on relevant information.

The dataset preview dialog with information about the structure, as well as sample values, for the dataset are shown.

Alternatively, from the Dataset activity screen, select Preview dataset near the top-right corner of your screen to preview up to 100 rows of data.

The Preview dataset button is highlighted.

For more robust methods to access your data, Experience Platform provides downstream services such as Query Service and JupyterLab to explore and analyze data. See the following documents for more information:

Manage and enforce data governance on a dataset manage-and-enforce-data-governance

You can manage the data governance labels for a dataset by selecting the inline options of the Browse tab. Select the ellipses (…) next to the dataset name you wish to manage, followed by Manage data and access labels from the dropdown menu.

Data usage labels, applied at the schema level, allow you to categorize datasets and fields according to usage policies that apply to that data. See the Data Governance overview to learn more about labels, or refer to the data usage labels user guide for instructions on how to apply labels to schemas for propagation to datasets.

Enable a dataset for Real-Time Customer Profile enable-profile

Every dataset has the ability to enrich customer profiles with its ingested data. To do so, the schema that the dataset adheres to must be compatible for use in Real-Time Customer Profile. A compatible schema satisfies the following requirements:

  • The schema has at least one attribute specified as an identity property.
  • The schema has an identity property defined as the primary identity.

For more information on enabling a schema for Profile, see the Schema Editor user guide.

You can enable a dataset for Profile from both the inline options of the Browse tab and also the Dataset activity view. From the Browse tab of the Datasets workspace, select the ellipsis of a dataset that you want to enable for Profile. A menu list of options appears. Next, select Enable unified profile from the list of available options.

The Browse tab of the Datasets workspace with the ellipses and Enable unified profile highlighted.

Alternatively, from the dataset’s Dataset activity screen, select the Profile toggle within the Properties column. Once enabled, data that is ingested into the dataset will also be used to populate customer profiles.

NOTE
If a dataset already contains data and is then enabled for Profile, the existing data is not automatically consumed by Profile. After a dataset is enabled for Profile, it is recommended that you re-ingest any existing data to have it contribute to customer profiles.

The Profile toggle is highlighted within the dataset details page.

Datasets that have been enabled for Profile can also be filtered on this criteria. See the section on how to filter Profile enabled datasets for more information.

Manage dataset tags manage-tags

Add custom created tags to organize datasets and improve search, filtering, and sorting capabilities. From the Browse tab of the Datasets workspace, select the ellipsis of a dataset that you want to manage followed by Manage tags from the dropdown menu.

The Browse tab of the Datasets workspace with the ellipsis and Manage tags option highlighted for the chosen dataset.

The Manage tags dialog appears. Enter a short description to create a custom tag, or choose from a pre-existing tag to label your dataset. Select Save to confirm your settings.

The Manage tags dialog with custom tags highlighted.

The Manage tags dialog can also remove existing tags from a dataset. Simply select the ‘x’ next to the tag you wish to remove and select Save.

Once a tag has been aded to a dataset, the datasets can be filtered based on the corresponding tag. See the section on how to filter datasets by tags for more information.

For more information on how to classify business objects for easier discovery and categorization, see the guide on managing metadata taxonomies. This guide details how a user with appropriate permissions can create pre-defined tags, assigning categories to tags, and perform all related CRUD operations on tags and tag categories in the Platform UI.

(Beta) Set data retention policy data-retention-policy

AVAILABILITY
Data retention settings are currently in beta and available only in a limited release for select organizations. Your UI might not reflect the feature described below.

Manage dataset expiration and retention policies at the dataset level from the Browse tab of the Datasets workspace. You can use this feature to configure retention policies for data already ingested into data lake and Profile services. The expiration date is based on when data was ingested into Platform and your retention rules.

To open the Set data retention dialog, select the ellipsis next to the dataset followed by Set data retention policy from the dropdown menu.

The Browse tab of the Datasets workspace with the ellipsis and Set data retention policy option highlighted.

The Set data retention dialog appears. The dialog shows the sandbox level license usage metrics , dataset-level details, and data lake settings. These metrics show your usage compared to your entitlements. The dataset details include the dataset name, type, Profile enablement status, and current data lake storage usage.

NOTE
The sandbox-level licensed data lake storage metrics is still in development and not available.

The Set data retention dialog.

Before you configure the dataset retention policy, the dialog shows recommended retention settings. One month is the default recommended retention period. To adjust the standard retention policy, select and update the number, then choose the desired time period (days, months, years). You can configure your retention settings for the data lake and Profile Service independently.

NOTE
The minimum data retention duration for data lake is 30 days. The minimum data retention duration for Profile Service is one day.

The Set data retention dialog with the duration dropdown and Save highlighted.

See the frequently asked questions page for more information on the rules that define dataset expirations date ranges and best practices for configuring your data retention policy.

(Beta) Enhanced visibility of retention periods and storage metrics retention-and-storage-metrics

Four new columns are available to beta users that provide greater visibility into your data management: Data Lake Storage, Data Lake Retention, Profile Storage, and Profile Retention. These metrics show how much storage your data consumes and its retention duration in both data lake and Profile services. These details help you optimize retention policies, track usage against entitlements, and ensure compliance with organizational and regulatory standards. This increased visibility empowers you to make informed decisions, manage costs, streamline governance, and clearly understand your data landscape.

The Browse tab of the Datasets workspace with The four new storage and retention columns highlighted.

The following table provides an overview of the new retention and storage metrics available in the beta release. It details each column’s purpose and how it aids in managing data retention and storage within the Platform UI.

Column title
Description
Data lake retention
Shows the current retention duration for each dataset. This value can be modified in each dataset’s retention settings. The data lake retention policy sets rules for how long data is stored and when it should be deleted in different services.
Data Lake Storage
Displays the current storage usage for each dataset in the data lake. This metric helps track how much space each dataset occupies, aiding in managing storage limits and optimizing usage.
Profile Storage
Shows the current storage usage for each dataset within Profile services. Use this information to monitor storage consumption and ensure it aligns with your data management goals.
Profile Retention
Indicates the retention duration for each Profile dataset. This value can be adjusted in the dataset’s retention settings, helping you control how long Profile data is stored before deletion.

Move to folders move-to-folders

You can place datasets within folders for better dataset management. To move a dataset into a folder, select the ellipses (…) next to the dataset name you wish to manage, followed by Move to folder from the dropdown menu.

The Datasets dashboard with the ellipses and Move to folder highlighted.

The Move dataset to folder dialog appears. Select the folder you want to move the audience to, then select Move. A popup notification informs you that the dataset move has been successful.

The Move dataset dialog with Move highlighted.

TIP
You can also create folders directly from the Move dataset dialog. To create a folder, select the create folder icon ( The create folder icon. ) in the top right of the dialog.
The Move dataset dialog with the create folder icon highlighted.

Once the dataset is in a folder, you can choose to only display datasets that belong to a specific folder. To open your folder structure, select the show folders icon ( The show folders icon ). Next, select your chosen folder to see all associated datasets.

The Datasets dashboards with the datasets folder structure displayed, the show folders icon, and a selected folder highlighted.

Delete a dataset delete

You can delete a dataset from either the dataset inline actions in the Browse tab or the top right of the Dataset activity view. From the Browse view, select the ellipses (…) next to the dataset name you wish to delete. A menu list of options appears. Next, select Delete from the dropdown menu.

The Browse tab of the Datasets workspace with the ellipsis and the Delete option highlighted for the chosen dataset.

A confirmation dialog appears. Select Delete to confirm.

Alternatively, select Delete dataset from the Dataset activity screen.

NOTE
Datasets created and utilized by ÃÛ¶¹ÊÓƵ applications and services (such as ÃÛ¶¹ÊÓƵ Analytics, ÃÛ¶¹ÊÓƵ Audience Manager, or Offer Decisioning) cannot be deleted.

The Delete dataset button is highlighted within the dataset details page.

A confirmation box appears. Select Delete to confirm the deletion of the dataset.

The confirmation modal for deletion is displayed, with the Delete button highlighted.

Delete a Profile-enabled dataset

If a dataset is enabled for Profile, deleting that dataset through the UI will delete it from the data lake, Identity Service, and also any profile data associated with that dataset in the Profile store.

You can delete profile data associated with a dataset from the Profile store (leaving the data in the data lake) using the Real-Time Customer Profile API. For more information, see the profile system jobs API endpoint guide.

Search and filter datasets search-and-filter

To search or filter the list of available datasets, select the filter icon ( The filter icon. ) at the top left of the workspace. A set of filter options in the left rail appears. There are several methods to filter your available datasets. These include: Show System Datasets, Included in profile, Tags, Creation date, Modified date, Created by, and Schema.

The list of applied filters is displayed above the filtered results.

The Browse tab of the Datasets workspace with the list of applied filters highlighted.

Show system datasets show-system-datasets

By default, only datasets that you have ingested data into are shown. If you want to see the system-generated datasets, select the Yes checkbox in the Show system datasets section. System-generated datasets are only used to process other components. For example, the system-generated profile export dataset is used to process the profile dashboard.

The filter options of the Datasets workspace with the Show system datasets section highlighted.

Filter Profile enabled datasets filter-profile-enabled-datasets

The datasets that have been enabled for Profile data are used to populate customer profiles after data has been ingested. See the section on enabling datasets for Profile to learn more.

To filter your dataset based on whether they have been enabled for Profile, select the Yes check box from the filter options.

The filter options of the Datasets workspace with the Included in Profile section highlighted.

Filter datasets by tag filter-by-tag

Enter your custom tag name in the Tags input, then select your tag from the list of available options to search and filter datasets that correspond to that tag.

The filter options of the Datasets workspace with the Tags input and filter icon highlighted.

Filter datasets by creation date filter-by-creation-date

Datasets can be filtered by creation date over a custom time period. This can be used to exclude historic data or to generate specific chronological data insights and reporting. Choose a Start date and an End date by selecting the calendar icon for each field. After which, only datasets that conform to that criteria will appear in the Browse tab.

Filter datasets by modified date filter-by-modified-date

Similar to the filter for creation date, you can filter your datasets based on the date they were last modified. In the Modified date section, Choose a Start date and an End date by selecting the calendar icon for each field. After which, only datasets that were modified during that period will appear in the Browse tab.

Filter by schema filter-by-schema

You can filter datasets based on the schema that defines their structure. Either select the dropdown icon or input the schema name into the text field. A list of potential matches appears. Select the appropriate schema from the list.

Bulk actions bulk-actions

Use bulk actions to enhance your operational efficiency and perform multiple actions on numerous datasets simultaneously. You can save time and maintain an organized data structure with bulk actions such as Move to folder, Edit tags, and Delete datasets.

To act on more than one dataset at a time, select individual datasets with the checkbox on each row, or select an entire page with the column header checkbox. Once selected, the bulk action bar appears.

The Datasets Browse tab with numerous datasets selected and the bulk action bar highlighted.

When you apply bulk actions to datasets, the following conditions apply:

  • You can select datasets from different pages of the UI.
  • If you select a filter, the selected datasets will reset.

Sort datasets by created date sort

Datasets in the Browse tab can be sorted by either ascending or descending dates. Select the Created or Last updated column headings to alternate between ascending and descending. Once selected, the column indicates this with either an up or down arrow to the side of the column header.

The Browse tab of the Datasets workspace with the Created and Last updated column highlighted.

Create a dataset create

To create a new dataset, start by selecting Create dataset in the Datasets dashboard.

The Create dataset button is highlighted.

In the next screen, you are presented with the following two options for creating a new dataset:

Create a dataset with an existing schema schema

In the Create dataset screen, select Create dataset from schema to create a new empty dataset.

The Create dataset from schema button is highlighted.

The Select schema step appears. Browse the schema listing and select the schema that the dataset will adhere to before selecting Next.

A list of schemas is shown. The schema that will be used to create the dataset is highlighted.

The Configure dataset step appears. Provide the dataset with a name and optional description, then select Finish to create the dataset.

Configuration details of the dataset are inserted. This includes details such as the dataset name and description.

Datasets can be filtered from the list of available datasets in the UI with the schema filter. See the section on how to filter datasets by schema for more information.

Create a dataset with a CSV file csv

When a dataset is created using a CSV file, an ad hoc schema is created to provide the dataset with a structure that matches the provided CSV file. In the Create dataset screen, select Create dataset from CSV file.

The Create dataset from CSV file button is highlighted.

The Configure step appears. Provide the dataset with a name and optional description, then select Next.

Configuration details of the dataset are inserted. This includes details such as the dataset name and description.

The Add data step appears. Upload the CSV file by either dragging and dropping it onto the center of your screen, or select Browse to explore your file directory. The file can be up to ten gigabytes in size. Once the CSV file is uploaded, select Save to create the dataset.

NOTE
CSV column names must start with alphanumeric characters, and can contain only letters, numbers, and underscores.

The Add data screen is displayed. The location where you can upload the CSV file for the dataset is highlighted.

Monitor data ingestion

In the Experience Platform UI, select Monitoring in the left-navigation. The Monitoring dashboard lets you view the statuses of inbound data from either batch or streaming ingestion. To view the statuses of individual batches, select either Batch end-to-end or Streaming end-to-end. The dashboards list all batch or streaming ingestion runs, including those that are successful, failed, or still in progress. Each listing provides details of the batch, including the batch ID, the name of the target dataset, and the number of records ingested. If the target dataset is enabled for Profile, the number of ingested identity and profile records is also displayed.

The monitoring batch end-to-end screen is shown. Both monitoring and batch-to-batch are highlighted.

You can select on an individual Batch ID to access the Batch overview dashboard and see details for the batch, including error logs should the batch fail to ingest.

Details of the selected batch are displayed. This includes the number of records ingested, the number of records failed, the batch status, the file size, the ingestion start and end times, the dataset and batch IDs, the organization ID, the dataset name, and the access information.

If you wish to delete the batch, select Delete batch near the top right of the dashboard. Deleting a batch also removes its records from the dataset that the batch was originally ingested to.

NOTE
If the ingested data has been enabled for Profile and processed, then deleting a batch does not delete that data from the Profile store.

The Delete batch button is highlighted on the dataset details page.

Next steps

This user guide provided instructions for performing common actions when working with datasets in the Experience Platform user interface. For steps on performing common Platform workflows involving datasets, please refer to the following tutorials:

recommendation-more-help
c5c02be6-79a3-4a2f-b766-136bffe8b676