Report builder and ExcelClient are Excel add-ins that display data requests in worksheets.
Report builder simplifies request layouts and adopts key features of ExcelClient, including the support of the same metrics, dimensions, and Pivot data layouts used in ExcelClient. You can also convert ExcelClient workbooks to report builder.
In most situations, you can run report builder and HBX Report Builder along with ExcelClient. When publishing a workbook, only the requests for that application are refreshed, so you must refresh all of them to keep them synchronized.
The following topics describe a few basic differences between ExcelClient and report builder:
Both applications provide an add-on toolbar in Excel and let you log in using Analytics marketing report credentials (Company, Username, and Password).
The ExcelClient toolbars contain the following icons and text:
Report Builder Toolbar
The toolbar is shown below:
For more information, see Report Builder Toolbar.
Report builder and ExcelClient use data blocks that dynamically reference cells within a worksheet. In both applications, you select the report suite, configure dates, and add metrics and dimension. However, report builder provides a more robust layout editor with features that let you copy and create dependent requests, and propagate the request by pasting it multiple times in the spreadsheet.
In report builder, if you increase the date range, columns are added to the request in order to accommodate the new dates.
Suppose you run a trended report with more than one dimension, and the data pivot on the dimensions. If at least one of the dimensions is not using a selected filter, ExcelClient and report builder report the top values differently. In this case, ExcelClient displays zeros for values reported outside of the request. Report builder, however, retrieves the data, because it performs a second request and applies the select filter.