Understanding your Universal Exploration Analysis

  • Updated

Template Structure

An Event Segmentation template consists of five modules and they are as follows:

uni-explore-modules-14b2c1c5f3e9b50a465b0a5aa9e051d9.png

Let's see how each module is configured in the template.

Measure Module

The Measure module in the Universal Exploration template contains a + icon that lets you choose a measure to calculate for the selected events and segments. All measures that you add in the Measure module can be reordered using drag and drop.

uni-explore-measure-mod-c7c0fd1f35214eadf2ad64017f29dfa7.png

The following measures are available in the Universal Exploration template:

MEASURE DESCRIPTION
Aggregate Aggregates a specific column
Event Aggregate Allows users to use the "Measure" portion of the Event Segmentation template anywhere else in the product - this includes other explorations, metrics, derived column and cohorts.
Metric A metric from the catalog or a custom block.
Formula Allows you to write custom logic using formulas.

Inside the Measures module, you can also enable period-over-period comparison for each measure by clicking on the over time toggle next to the Measure drop-down.

uni-measure-mod-overtime-71611541c4bce1c4d43933a72d0c5b7c.png

Segmentation Module

The Segmentation module enables you to choose a cohort of actors, such as users, or one or more attributes to include in the analysis. It has two sub-sections: Segment by cohort and Grouped by that allow users to add cohorts and attributes respectively. You can choose to create a cohort either by choosing an existing cohort from the drop-down or use the + New Cohort option to create a behavioural cohort block in one click.

universal-explore-demo-2-e27f3b325cbd8d008273b02e4c0880cd.gif

Filters Module

Filters can be used to narrow down data in a visualization. Filters make it easier for the user to answer exploratory questions, for example if the user wants to see results for a specific region, they can define a region filter and see the narrowed down data.

Analytics also allows users to choose JSON columns in this module. When you click on a JSON column, it expands to display all the keys that are available for that particular column. You can choose a key and click Apply. Once this is done, the end key that is selected will be chosen as the display name for that column.

univ-explore-filters-mod-c920d0288c107c677df13d5141bd81c8.gif

Visualization Module

The Visualization module in the Universal Exploration template enables you to run and view the analysis. It also provides the ability to edit visualization, examine the underlying SQL query, and add the chart to a dashboard.

univ-explore-viz-module-a98404963eb13bffc9b0cb06209e7cd1.png

The following features are available in this module:

SECTION DESCRIPTION
# and % Allow you to switch between numbers and percentage values on your chart.
Top 'N' segments Allows you to choose the number of top segments you want to display in the visualization.
Time Range and Time Grain Allows you to configure time range and time grain for the analysis.
Sampling Allows you to configure sampling and responses for the analysis.
Edit visualization (Other actions) Allows you to inspect a query, edit visualization, add an analysis to a dashboard, and download as CSV.

Switching between numbers and percentage

These options allow users to switch the values on the Y-axis from absolute values to percentage and vice versa in one click. This feature is particularly useful when dealing with multiple segments, as using absolute values allows users to see a clearer breakdown of how many individuals are in each segment.

Time Range and Time Grain section

At the top of the Visualization window, users will be able to configure the time range and time grain for the analysis. Time Range refers to the complete period of time during which events will be taken into account for the analysis. Examples include the last 2 years or the time range between two specific dates. Time Grain refers to the granularity of analysis, such as Daily (1 day), Weekly (7 days), etc.

You can set the time range using a simple drop-down or even choose from the quick options and quickly iterate through different choices of time range and time grain without leaving the chart. It is also possible to set a lag using the Ending option.

univ-explore-timerange-6bcc3de8945b56a7f699b6043b9a4e7e.gif

Sampling section

In the visualization module, you can configure sampling modes for your exploration by clicking on the lightning icon on top of the exploration. The drop-down that appears will display 2 sampling modes - Enabled Faster Response or Enabled Higher Precision.

Edit visualization section

Clicking the three dots next to the lightning icon displays a drop-down with 4 options - Inspect Query, Add to Dashboard, Edit visualization, and Download As.

  • Inspect Query - When you click this option in the drop-down, a query inspector opens. It has three tabs - SQL, Warehouse SQL, and NetScript. You can make changes to the SQL and NetScript queries by clicking the Open as SQL Explore and Open as NetScript Explore buttons in the respective sections.
  • Add to Dashboard - This option allows you to add the exploration that you have created to a dashboard. You can choose from two options - Pick a dashboard and New Dashboard.
  • Edit visualizationThis section houses all the chart settings. It has 2 sub-sections: Visualization and Sorting.
    • Under visualization, you can configure:
        • Automatic refresh for your chart
        • Chart type
        • X-axis and Y-axis configuration
        • Tooltip
        • Size configuration
    • Under sorting, you can
        • Enable the sorting option on the graph
        • Configure sorting rules and the limit
  • Download As​ - This option will let you download your analysis in either CSV or EXCEL format. The column formatting will be preserved for the downloaded files as well.
edit-visn-univexp-b889f5458ce0c794dbc08fadf313f41e.gif