Support Needed : Unable to Extract Missing Creative Report

[Ashwini shankar]

Hi Team,

I have a requirement to extract the Missing Creatives report from GAM Via API.

In the GAM UI, the report is generated using the following filters under the Line item section:

• Archived = False

• Creative upload status = Missing Creatives

• Start time = In the next 30 days

• Type = Sponsorship and Standard

• Name does not contain "test"

• Export format = .xls (Excel 2003)

And, I am using the below schema to extract this report via the API, but it is not working as i expected.

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope
  xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <soapenv:Header>
    <ns1:RequestHeader
      soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next"
      soapenv:mustUnderstand="0"
      xmlns:ns1="https://www.google.com/apis/ads/publisher/v202505">
      <ns1:networkCode>[networkCode]</ns1:networkCode>
      <ns1:applicationName>Missing-Creatives-Report</ns1:applicationName>
    </ns1:RequestHeader>
  </soapenv:Header>

  <soapenv:Body>
    <getLineItemsByStatement xmlns="https://www.google.com/apis/ads/publisher/v202505">

      <statement>

        <query><![CDATA[
          WHERE
            isArchived = false
            AND creativePlaceholderStatus = 'MISSING'
            AND startDateTime >= :startDate
            AND startDateTime <= :endDate
            AND lineItemType IN ('SPONSORSHIP','STANDARD')
            AND NOT name LIKE '%test%'
          ORDER BY id ASC
          LIMIT 500 OFFSET :offset
        ]]></query>

  
        <values>
          <key>startDate</key>
          <value>
            <dateTimeValue>
              <date>
                <year>[YYYY]</year>
                <month>[MM]</month>
                <day>[DD]</day>
              </date>
              <hour>0</hour>
              <minute>0</minute>
              <second>0</second>
              <timeZoneId>Europe/London</timeZoneId>
            </dateTimeValue>
          </value>
        </values>

 
        <values>
          <key>endDate</key>
          <value>
            <dateTimeValue>
              <date>
                <year>[YYYY]</year>
                <month>[MM]</month>
                <day>[DD]</day>
              </date>
              <hour>23</hour>
              <minute>59</minute>
              <second>59</second>
              <timeZoneId>Europe/London</timeZoneId>
            </dateTimeValue>
          </value>
        </values>

        <!-- Pagination -->
        <values>
          <key>offset</key>
          <value>
            <numberValue>0</numberValue>
          </value>
        </values>

      </statement>
    </getLineItemsByStatement>
  </soapenv:Body>
</soapenv:Envelope>

Could you please provide the schema to extract the Missing Creatives report according to my requirements.  

Thanks,

Ashwini 

[Ad Manager API Forum Advisor]

Hi,

Regarding your requirement to extract the "Missing Creatives" report as an Excel file, we have reviewed your current SOAP schema.

The reason the previous approach was not working as expected is that it utilized the LineItemService, which is designed for management and configuration. To generate a downloadable export (like the .xls format you mentioned), the ReportService must be used instead.

To replicate the UI report accurately, your implementation should follow these two steps:

1. Define and Run the Report Job

You must use the runReportJob method. Within the ReportQuery, use the following parameters to match your UI filters:

• Dimensions: LINE_ITEM_ID, LINE_ITEM_NAME.

• Date Range: Set to CUSTOM_DATE. You will need to calculate the 30-day window dynamically .

• PQL Filter: Specifies a filter to use for reporting on data. This filter will be used in conjunction (joined with an AND statement) with the date range selected through dateRangeType, startDate, and endDate. You can check  Statement.query where property is the enumeration name of a Dimension that can be filtered.

Once the job status is COMPLETED, use the getReportDownloadUrlWithOptions method. To get the Excel format, set the ExportFormat to XLSX (the modern equivalent of the legacy .xls format).

Please reach out to us if you have more query regarding Ad Manager API.

Thanks,

 

Ad Manager API Team

Feedback
How was our support today?

               
[2026-01-13 23:35:02Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01wo5Jn:ref" (ADR-00349386)