Interactive controls
- You have until August 12, 2026 to migrate your workbooks from the legacy Report Builder to the new Report Builder. See convert your legacy workbooks for detailed information.
- With the end of life of the Adobe Analytics 1.4 API’s, the legacy Report Builder add-in will no longer be available for download.
- After August 12, 2026, customers with workbooks requiring migration will need to contact customer support to obtain the orignial workbooks. These workbooks will need to be migrated as documented in convert your legacy workbooks.
Interactive Controls allow you to edit segments and date ranges for one or more requests directly from the worksheet. This gives you more flexibility when updating Report Builder requests.
Interactive controls were created in response to a common workflow where analysts create workbooks and share these workbooks with the marketing organization. Interactive controls give marketers the ability to modify and refresh requests without having to have in-depth knowledge of how Report Builder works. (Note that in order to refresh a request, the workbook recipient must be a Report Builder user.) These controls work inside of scheduled workbooks. Two types of interactive controls are currently available:
- Rolling Date Range
- Segments
- If you are running Microsoft Excel on Windows but are running a lower version of Report Builder, or if you do not have Report Builder installed: You can change the value in the interactive control, but it will not refresh the associated request, nor update the request’s associated parameters.
- If you are running Excel on Mac, changing the value in the control will cause the following message to be displayed: “The macro ‘Adobe.ReportBuilder.Bridge.FormControlClick.Event’ cannot be found.”
Implement interactive date range control section_39B228F2D2C44985863D31424C953280
-
In Step 1 of the Request Wizard select, for example, the Page report.
-
Next to the Commonly Used Dates drop down, click the Control Settings icon:
-
In the Control Settings dialog, select all the date range items that you want displayed in the interactive control. In addition, specify the upper left cell location of the control.
-
Notice the option to “Automatically refresh linked requests upon item selection”.
- If checked, all requests that use this control are refreshed.
- If not checked, the associated request parameters are updated, but the request is not refreshed.
-
Click OK. The control appears in the cell location that you specified:
-
You can now change the date range and the request will refresh with that date range.
-
You can also copy the request and right click to use one of two Paste Request options:
-
Paste Request > Use Absolute Input Cell. This means that the copied request will point to the same interactive date range control as the original request.
-
Paste Request> Use Relative input Cell. This mean that the copied request will point to its own control.
note NOTE You can use the native Microsoft Excel Cut/Copy/Paste control functionality. Report builder automatically recognizes the newly added controls.
-
Implement interactive segment control section_5003D3F724644280BF1BCD6E1B0CB784
Implementing the interactive segment control is similar to implementing the date range control.
-
In Step 1 of the Request Wizard, next to the Segment drop-down list, select the Segment Control Settings icon:
-
In the Segment Control Settings dialog, select the segments you want to include in the drop-down. In addition, specify the upper left cell location of the control.
-
The new interactive control will now appear in the workbook:
