RE: Understanding how files work when same Floodlight report is run multiple times with different Campaign IDs

[Nihal Parchand]

Hi,

I'm running Floodlight reports for multiple campaign IDs, but even when executing a synchronous report for a single campaign, it still gets queued. Is there a way to include multiple campaign IDs in the dimensionFilters, reuse the same Floodlight report by patching and running it, and then retrieve multiple file IDs to check on them individually?

• Prepare a list of campaign IDs that need to be processed in the Floodlight report.
• Modify an existing Floodlight report by updating the dimensionFilters with a batch of campaign IDs.
• Run the updated Floodlight report and get a file ID for the report output.
• Store the file ID and repeat the process for additional campaign batches if needed.
• Individually check the status of each file ID to see if the report is ready.
• Once the reports are completed, retrieve and process the data as needed.

[DCM API (DoubleClick Campaign Mgr)]

Hi,

Thank you for reaching out to the DCM API support team.

To address your query, you can check this dimensions, metrics and Filters documentation within the Floodlight report definition to specify your campaign IDs.

The reports.patch method allows you to update an existing Floodlight report definition, including the dimensionFilters, without creating a new report each time. This is the key to reusing the report. After patching the report you can use the reports.run method to execute the report. To check the status of a specific report file, use the files.get method, providing the file ID. The status field in the response will indicate the file's processing status (e.g., "PROCESSING", "REPORT_AVAILABLE"). Once the status is "REPORT_AVAILABLE", the file is ready to download.

Additionally, you can use the Download Report Files, which allows you to download report files, which are the result of running a Report Builder report. 

It also enables direct file access through a link. Depending on your download needs, there are two methods to download the files:

1. Direct download - Use Files.get with the alt=media parameter.
2. Download files in a browser - Use the browserUrl from the Files resource.

For both methods, you'll need some prerequisite information:

• Report ID: The ID of the report to which the file belongs. You can get this by creating a new report or looking up an existing report.
• File ID: The ID of the file you want to download. You can find this after running the report or by querying the list of existing files.

The remaining sections of the guide will provide detailed instructions on how to download these files via the Files resource.

I hope this helps!

Thanks,
 

DCM API Team

Feedback
How was our support today?

               
[2025-03-10 20:57:26Z GMT] This message is in relation to case "ref:!00D1U01174p.!5004Q02vH8Km:ref" (ADR-00293178)