Multi-dimensional analysis with Data Tables

When analyzing a rich dataset, analysts often need to compare multiple metrics at once, and slice and dice that data by different dimensions to generate a custom analysis. Amplitude’s Data Tables enable multi-metric, multi-dimensional analyses in a single view. It is an extremely flexible chart, allowing you to quickly analyze any combination of user behavior, user attributes, and metrics. 

NOTE: Data Tables are currently in a closed beta, available by request for paid customers. Please reach out to your Customer Success Manager if interested in using the feature.

Data Tables are useful for:

• Marketing attribution (total visits, page views, and conversion rate by UTM source)
• Market Segment analysis (comparing several actions broken down by country)
• Experiment analysis (multiple metrics by control vs variant groups)
• Trend investigation (quickly and easily breaking down a number by multiple properties)
• Comparing time periods across multiple metrics (metric A, metric B, and metric C, broken down by category, compared to last quarter)

You can easily sort columns in ascending or descending order (just click the metric header), drag and drop or resize columns, and highlight, copy and paste any number of cells from your Data Table.

TIP: To get a quick overview of how Data Tables work, check out our short Loom tutorial.

Set up a Data Table

To set up and use a Data Table, follow these steps:

1. In the left sidebar, navigate to + New > Analysis > Data Table.
   
2. In the empty Data Table panel, click Add an event or metric and select the event or metric you’re interested in. A new Data Table will open, with your chosen event or metric in the first column. Add more by clicking + Add Event or Metric in the rightmost column in the Data Table.
3. To break out your events and metrics by property values—country, for example, or platform, or week—click Select property… in the leftmost column of the table and choose the property you’re interested in.
   
   
   
   This will run a group-by on your events and metrics, grouping by the property you selected. You can include up to five top-level group-bys in a single Data Table.
   
   
4. Once you’ve added a group-by property, you can run a secondary group-by on that row of your Data Table. For example, you can break your events and metrics out by the Week property nested within Brand.
   
   
   Click in the rightmost group-by column and select the property you’re interested in.
   
   
   
   
5. Next, add user segments, if desired. Saved segments are accessible. Multiple segments will show up in the table as separate columns within the same metric.

NOTE: Within any cell, click the Options icon to: 

• • • Open as chart, which will open a new tab with the chosen metric applied;
    • Copy the data so you can paste elsewhere as needed;
    • Export the data as CSV or Excel file.

Metrics

Metrics allow users to define and save reusable analysis objects in Amplitude. They accelerate workflows and increase confidence for end users when building analyses. Metrics are shared project-wide, and can be created by any member, project manager, or admin. However, only project managers and admins can designate a metric as official.

Set up a metric

To configure metrics for use in your Data Tables, follow these steps:

1. In the Menu dropdown from Step 1 of the previous workflow, open the Metrics tab and click + Define metric.
   
   
2. Specify the metric type you’d like to create. Available types include Event Segmentation, Funnels, Revenue, and Formula. 
   
   
   
3. Add your desired event and property selections. 
4. Give the metric a unique name. You can also add a description to explain the metric to others on your team, as well as verify (or “officiate”) the metric if you desire.

NOTE: Only project managers and admins can verify metrics.

5. Click Save when you’re finished creating the metric to add it to your Data Table.

Once added to the data table, you can edit or remove the metric from the table. To do so, click in the metric header. 

To delete the metric from the project, click Edit metric, followed by Delete, within the metric drawer.

For event total metrics, click on the settings gear next to the datepicker to toggle between absolute numbers, relative percentage of total, or both visualization options.

Filter your events and metrics for specific values within a group-by 

You can click to select which property values you want to keep or hide in the table.

You can also add an ad hoc filter for in-line events or metrics. To do so, click the three dots from the event or metric header and select “Add Filter.” This will let you apply filters on top of your events or metrics. Once applied, you can see what filters are applied by hovering over the icon.