Create a Report Builder data request

IMPORTANT
A new and streamlined Report Builder was released on October 16, 2024. It is supported on Mac, Windows, and web browsers.
This Legacy Report Builder add-in version still works. You can convert your legacy workbooks to the new Report Builder.

Steps to create a basic data request.

  1. In Excel, click Create.

  2. In the Request Wizard: Step 1 window, select a report suite.

  3. (Optional) Select a segment to apply to the request. Once you have selected one or more segments, they will move to the top of the list.

    Report Builder uses segments in the same way Adobe Analytics uses them. See the Analytics Segmentation Guide.

  4. Select a report type.

  5. Specify a date range and report granularity.

  6. Click Next.

  7. In the Layout - Request Wizard Step 2 window, specify a layout:

    table 0-row-2 1-row-2 2-row-2
    Element Description
    Pivot Layout Provides a row, column, and metric grid for layout, similar to standard Excel tables. Using this layout, you can add breakdown requests within an original request.
    Custom Layout Provides most of the functionality of the Pivot Layout but lets you choose where each item in the grid should be located in the spreadsheet. This layout provides the flexibility available in previous releases.
  8. On the Metrics tab, double-click (or drag) metrics in the tree to add them to the Metrics grid.

  9. On the Dimensions tab, double-click (or drag) dimensions to the Row Labels grid.

    The dimensions available in Step 2 depend on the base report you selected in Step 1, and on the configuration of your report suite. The dimensions are items that correlate, sub-relate, or are a classification of the original report type metric you selected on the Request Wizard: Step 1 window. Adding more than one dimension in Step 2 is how you create a breakdown in your data request.

    See Add Metrics and Dimensions for more information.

recommendation-more-help
a83f8947-1ec6-4156-b2fc-94b5551b3efc