Need custom filter for my report

[Suhas Hai]

I will paste my soap xml here ,i want to search with a custom dimension here ,but i am receiving an error CUSTOM_TARGETING_VALUE_11933400' is not filterable

Please see my soap request

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
                   xmlns:ns1="https://www.google.com/apis/ads/publisher/v202505">
  <SOAP-ENV:Header>
    <ns1:RequestHeader>
      <ns1:networkCode>{$networkCode}</ns1:networkCode>
      <ns1:applicationName>{$applicationName}</ns1:applicationName>
    </ns1:RequestHeader>
  </SOAP-ENV:Header>
  <SOAP-ENV:Body>
    <ns1:runReportJob>
      <ns1:reportJob>
        <ns1:reportQuery>
         
           <ns1:dimensions>CUSTOM_TARGETING_VALUE_ID</ns1:dimensions>
           
            <ns1:columns>AD_EXCHANGE_LINE_ITEM_LEVEL_IMPRESSIONS</ns1:columns>
            <ns1:columns>AD_EXCHANGE_LINE_ITEM_LEVEL_CLICKS</ns1:columns>
              <ns1:columns>AD_EXCHANGE_LINE_ITEM_LEVEL_CTR</ns1:columns>
                <ns1:columns>AD_EXCHANGE_LINE_ITEM_LEVEL_REVENUE</ns1:columns>
              <ns1:columns>AD_EXCHANGE_LINE_ITEM_LEVEL_AVERAGE_ECPM</ns1:columns>
              <ns1:columns>AD_EXCHANGE_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS</ns1:columns>
   <ns1:columns>AD_EXCHANGE_ACTIVE_VIEW_VIEWABLE_IMPRESSIONS_RATE</ns1:columns>
  <ns1:dateRangeType>TODAY</ns1:dateRangeType>
 
  <ns1:statement>
            <ns1:query>
             WHERE CUSTOM_TARGETING_VALUE_11933400 IN (448535797861)
           
            </ns1:query>
           
          </ns1:statement>
         
        </ns1:reportQuery>
      </ns1:reportJob>
    </ns1:runReportJob>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

[Ad Manager API Forum Advisor]

Hi,

Thank you for contacting the Ad Manager API support team.

The 'CUSTOM_TARGETING_VALUE_ID' dimension breaks down reporting data by CustomTargetingValue.id. Can be used to filter by CustomTargetingValue.id. I would suggest you modify your filter statement as "WHERE CUSTOM_TARGETING_VALUE_ID IN (448535797861)" and try calling the API. If you still face any issues, provide us with the below details.

• Network code
• UserService.getCurrentUser (if you are unable to provide this information, please provide the email address of the account used to authenticate the API)
• Latest complete SOAP request and response logs (SOAP logging must be enabled) from API
• Uncropped screenshot of 'CUSTOM_TARGETING_VALUE_ID' from Ad Manager UI which you are trying to retrieve via API.

You can send the details via Reply privately to the author option, or direct private reply to this email.
???????

Thanks,
 

Ad Manager API Team

Feedback
How was our support today?

               
[2025-08-11 15:15:55Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01syfqX:ref" (ADR-00329510)