Data Studio is your central hub for exploring schemas in your Blueshift account. It provides a user-friendly interface to help you gain insights into your data structure and manage it efficiently.

Currently, Data Studio focuses on customer attributes, allowing you to:

• View and explore key details of your schema, including standard, custom, predictive, derived, and computed attributes.
• Navigate nested attributes effortlessly for a deeper understanding of your data.
• Edit descriptions for custom attributes to ensure consistency and clarity.
• Download schema details in JSON format for offline analysis and integration with other tools.

In addition to exploring your existing customer attributes, you can also create your own computed attributes from within Data Studio. These let you define custom logic based on event activity or user behavior.

Where to find Data Studio

• Navigate to the Customer Data section in the left-hand menu.
• Click on Data Studio to access the feature.

Customer Schema tab

Table view

The Customer Schema tab houses a table view containing customer attributes. It provides a structured overview of customer attributes with the following columns:

• Attribute name: The name of the attribute.
• Category: Indicates whether the attribute is Standard, Derived, Predictive, or Custom.
• Data type: Specifies the data format, such as String, Boolean, or Date.
• Description: Editable for Custom attributes to provide additional context.
• Created at: Shows when the attribute was created.

For an expanded, detailed view, click the row or select View Details from the three-dot menu at the right corner of the row.

On the expanded view, you can perform the following actions:

• Update the description for custom attributes.
• View sample values for all attributes. Sample values are displayed within their nested structure for nested or object data types.

• View nested attributes by clicking the expand icon for an object or nested data type.

Filters and sort options

To help you locate specific attributes quickly, Data Studio provides:

• Search: Find specific attributes using the "Search by Attribute Name" bar.
• Filters: Narrow down results by:
  • Category: Standard, Derived, Predictive, or Custom.
  • Data type: String, Integer, Date, Boolean, etc.
• Sorting: Click on column headers (e.g., Attribute name, Category) to sort attributes alphabetically or by type.

JSON view

The JSON view offers a detailed, developer-friendly representation of the schema. It includes:

• Attribute names as keys.
• Attribute details like labels, categories, data types, and sample values as values.

How to access the JSON view

• Click the JSON toggle at the top of the screen.
• Use the search bar to locate specific attributes by key name. You can also change the theme and copy the JSON.
• Download the schema by clicking the download JSON icon at the top right of the screen.

Attribute usage report

The Attribute usage report helps you identify where customer attributes are used across your account, such as in segments, campaigns, and templates.

To generate the report, go to the Customer Schema tab in Data Studio and click the download icon near the top-right corner of the screen (next to the "Custom Attribute" button).

When you click the download icon, a link to download the report will be emailed to you. The report is downloaded as a CSV file containing attribute usage details. If a report has already been generated within the last 24 hours, the same download link will be sent again.

The downloaded CSV report provides a detailed view of how customer attributes are used across your account. Each row represents an attribute, and the report includes the following columns:

• Attribute name: The name of the customer attribute being used.
• Entity type: The type of object where the attribute is used, such as a segment, campaign, or template.
• Entity name: The name of the specific segment, campaign, or template referencing the attribute.
• Path: The path or context within the entity where the attribute appears.