- Analytics Tools Guide
- Analytics Release Notes
- Get started with Adobe Analytics
- Landing page
- Analysis Workspace
- Analysis Workspace overview
- Projects
- Reports
- Templates
- Components
- Visualizations
- Visualizations overview
- Manage data sources
- Freeform table
- Cohort Table
- Fallout
- Flow
- Area and area stacked
- Bar and bar stacked
- Bullet graph
- Combo chart
- Donut
- Histogram
- Horizontal Bar and Horizontal Bar Stacked
- Key metric summary
- Line
- Map
- Scatterplot
- Section header
- Summary Number and Summary Change
- Text
- Tree map
- Venn
- Panels
- Curate, Share, and Schedule projects
- Attribution
- Journey IQ
- Segment IQ
- Anomaly Detection
- User preferences
- Workspace FAQs
- Report Builder
- Legacy Report Builder
- Legacy Adobe Report Builder help
- Legacy Report Builder setup
- Report Builder toolbar
- Data requests
- Data requests - Request Wizard Step 1
- Create a data request
- Report suites
- Manage segments
- Report types
- Import bookmarked reports and dashboard reportlets
- Date ranges
- Interactive controls
- Layout - Request Wizard Step 2
- Layout overview
- Metrics and dimensions
- Anomaly Detection
- Configure an anomaly detection request
- Format the date
- Format display headers
- Hide or show headers
- Delete output mapping
- Name a request
- Prepend and postpend text to cells
- Configure the custom layout
- Map metrics and dimensions to cells
- Create a microchart
- Filter dimensions
- Manage requests
- Manage requests - definitions
- Diagnostic messages
- Sort ascending or descending
- Protected worksheet elements
- Edit multiple requests
- Edit metrics across multiple requests
- Refresh a request
- Refresh requests for all sheets
- Add dependent requests
- Classification
- Copy requests
- Save a workbook with requests
- Specify conditional formatting
- Offline mode for creating and editing requests
- Report Builder options
- Schedule report requests
- Schedule a workbook
- Scheduled Task Manager
- Workbook Library
- Publish to Power BI with Report Builder 5.5
- Visual Basic macros
- Report Builder troubleshooting
- Report Builder FAQ
- Activity Map
- Adobe Analytics dashboards
- Labs
Report Builder FAQ
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.
Frequently asked questions around Report Builder.
Can I use the TODAY() or DATERANGE() function in workbooks?
The TODAY() function in Excel returns the current day. The DATEVALUE() function converts a date string into a serial value. While helpful for many features within Excel, Adobe strongly recommends against using these functions as part of Report Builder scheduled requests. Adobe Customer Care does not support troubleshooting requests using either of these functions.
Scheduled reports are processed on servers that likely do not share time zones as the report suite. The TODAY() a user expects and the TODAY() the processing server uses can often be different. Also, the date used is based on when processing starts. If many reports are run simultaneously, the date can change between the time it is requested and when it starts processing due to delays. This issue is present if the scheduled time is close to midnight.
Scheduled reports are also processed on servers that likely do not share date syntax. For example, 7/1/YYYY can refer to July 1 or January 7 depending on your country or region. Using the DATEVALUE() function on this date would result in differing serial values depending on the computer that executes it.
As an alternative to using these Excel functions, Adobe highly recommends using date ranges within Report Builder requests. On the first page of the request wizard, select Preset Dates in the drop-down, then under Commonly Used Dates, select Today or another desired date range. This setting takes the time of the report suite at the time it was run, and not the time of the server processing the request.
How large and complex can I make my workbooks?
Report Builder supports workbooks up to the following limits:
- 1000 requests: A single workbook can contain up to 1000 data requests. If you have reports or projects that require more than 1000 requests, Adobe recommends separating them into multiple workbooks.
- 20K requests per hour per company: Report Builder uses the Analytics reporting API to retrieve data. Each individual request uses an API call whenever it is created or refreshed. If your organization accumulates more that 20,000 API calls in a given hour, you must wait until the next hour to retrieve data again.
- 4-hour processing time: Scheduled reports time out after processing for more than 4 hours. If your workbook contains many complex requests using large data sets, the scheduled report can fail.
How do I know whether I have access to Report Builder?
You need to be granted Report Builder access by your Adobe Analytics Admin. The Admin sets up product profiles in the Adobe Admin Console. Ask your Admin to grant you access.
