Show Menu
TOPICS×

Table Builder

Use the Table Builder to create a report with any configuration of metrics, dimensions, and segments. For example, you can add multiple metrics to the Table Builder, then apply segment to all of them at once. You can apply items from the tool panes as rows and breakdowns, or as columns, and easily pivot the table for a different view. After building the table, you can interact directly with the resulting data table for further analysis. Keep in mind that generating a data table from the Table Builder runs a query and creates a new data table.

Table Builder

Use the Table Builder to create a report with any configuration of metrics, dimensions, and segments. For example, you can add multiple metrics to the Table Builder, then apply segment to all of them at once. You can apply items from the tool panes as rows and breakdowns, or as columns, and easily pivot the table for a different view. After building the table, you can interact directly with the resulting data table for further analysis. Keep in mind that generating a data table from the Table Builder runs a query and creates a new data table.
The Table Builder is not available for certain pathing reports like Site Analysis, Fallout, Flow and Virtual Focus.

Table Builder Descriptions

Element Description
Rows / Breakdowns
Creates rows and breakdowns from added items. The first item you drag to Rows / Breakdowns becomes the left column in the data table, or the parent item in a breakdown. Adding subsequent items creates breakdowns.
For example, if you add Page and then Cities dimensions, the report breaks down the page by cities. You configure how many rows and breakdowns to show for each item, using the following menus:
  • Show and Breakdown : Lets you specify the number of items and breakdowns to display.
  • Default : Uses the settings configured in Breakdown Properties .
You can also configure a fixed value list to, for example, break down one metric by multiple metrics.
Breakdown Properties
Lets you specify default settings for how many rows and breakdowns you want displayed, based on the order in which you add items. You can specify how many total results per page to display, and how many of those rows to break down.
Settings you make in the Table Builder override the default settings in the Breakdown Properties .
Edit Items
Choose a list of dimension items to create a fixed list for breakdowns. When you add items to this list, they become persistent in a saved report and will not be collapsed when you open a saved or scheduled report.
Columns
Lets you build columns with items from dimensions, segments, and metrics. You can also pivot the columns using the arrow icon, which pivots the X and Y axes.
Show : Lets you limit the number of columns generated in the data table.
Summary
Shows the report's structural layout so that you know how many rows and columns will be created. The summary reflects the configuration specified in the Rows / Breakdowns and Columns groups.
Replace Table
Builds (and overrides) the existing table, based on your Table Builder configuration.
Note: Clicking Replace Table reruns the report and overrides the data in the table grid. If you add items to the table grid, the correlation between the table and the Table Builder is no longer valid.
Warning
Indicates that the Table Builder 's configuration will not return data, or that no metrics are selected.

Generate a report from the Table Builder

Steps that describe how to use the Table Builder.
  1. To access the Table Builder, run a supported report, then click Table Builder .
  2. Drag items (dimensions, metrics, segments) from the tool panes to the Table Builder.
  3. Configure the items as rows, breakdowns, and columns.
  4. Click Replace Table to generate the report.
    Clicking Replace Table runs a new query and creates a new data table. Manual edits to the detail table are not reflected in the Table Builder.