why download url is null for the bing ads reporting api

ReportDownloadUrl is null even though Status is Success when the report completed successfully but there is no data for the parameters used in the request.

The Reporting API explicitly allows this case:

• Status = Success means the report job finished without errors and would be downloadable if it contained rows.
• ReportDownloadUrl can still be nil/null when no data matches the requested filters (date range, accounts, campaigns, etc.).

From the service definition:

• The ReportDownloadUrl element: “Use the download URL only if the Status element is set to Success. Even when the Status is set to Success, this element can be nil if no data is available for the submitted report parameters.”

To resolve this in the script:

1. Verify in the Microsoft Advertising UI that the same account, date range, and filters for the Campaign Performance report actually return data.
2. If the UI shows data but the API still returns ReportDownloadUrl = null for the same parameters, the guidance is to contact support with details.
3. In code, always check both:
   • Status == 'Success', and
   • ReportDownloadUrl is not None before attempting to download.

References:

• ReportRequestStatus Data Object - Reporting
• Handling Service Errors and Exceptions
• Request and Download a Report
• Reporting Service Model