Troubleshooting Tips for Bulk Management Tools

What to do when the worksheets return an error or your bulk request fails.

Responding to error messages

Attention: The Bulk Management Tools are not supported by Audience Manager. This tool is provided for convenience and as a courtesy only. For bulk changes, we recommend that you work with the Audience Manager APIs instead. RBAC group permissions assigned in the Audience Manager UI are honored in the Bulk Management Tools.

Factors like heavy network traffic, server usage, and large data sets can cause a bulk request to fail or time out. If there is an issue, the worksheet stops writing data and displays an error message. When this happens, you should:

  • Read the error message.
  • Fix the problem.
  • Delete all the rows that have been already updated.
  • Try the bulk request again.

Long delays or unresponsive behavior

The following table lists some common problems you may encounter when making bulk requests with the worksheets. Try to fix these issues with the recommended solutions. If the recommended solutions do not resolve the problem, you should save your work, restart your computer, and try the request again without launching or working with other applications.

Problem Solution
Long delays
  • Turn off compatibility mode: Check if you have other worksheets open in Excel's compatibility mode. Compatibility mode can increase runtimes. Close any spreadsheets you may have open in this mode and try your bulk request again.
  • System resources: Limited system resources contribute to long delays. Try closing all your other programs before making a bulk request.
No response If you click on an action button and nothing happens:
  • Make sure you have the right set of headers for the selection action.
  • Make sure you're using the right worksheet for the copied headers.
  • Check the position of the data you want to use in a bulk operation. All headers start in column A, row 1. All data goes in corresponding headers starting in column A, row 2 (immediately below the headers).