INTERNAL_ERROR when querying search_term_view

[Demi Yo]

My company manages multiple Ads accounts, and we regularly run this query across all our accounts to check past conversions:

SELECT
search_term_view.search_term,
metrics.conversions
FROM
search_term_view
WHERE
metrics.conversions > 0

This exact query works for all of our accounts except for one, which is rather large. The API throws an "INTERNAL_ERROR" at us.

Trying to place a small LIMIT on the query (like 100) still results in INTERNAL_ERROR.

Trying to add "segments.date" in the WHERE clause for more recent conversions throws back "Invalid argument", which is probably its own issue, since the documentation says I can use that field, and yet I *can* segment by date if I specify a specific ad group in the WHERE clause.

What's going on with search_term_view?

Fault

-------

Status code: 13

Details: Internal error encountered.

Failure: {"errors":[{"errorCode":{"internalError":"INTERNAL_ERROR"},"message":"An internal error has occurred."}],"requestId":"bxCpiSErmTqxUrzT7Oh6Iw"}  

[Google Ads API Forum Advisor]

Hi Demi,

Regarding the segments.date issue, could you provide the exact GAQL you used? In addition, you may check out this guide for more information on how this segment can be used in reporting.

As for the INTERNAL_ERROR, could you confirm if this is being encountered consistently even after retrying after 30 seconds as mentioned in the guide? If yes, could you also provide the complete request and response logs, with the request-id?

If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link.

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2PIj1U:ref

[Google Ads API Forum Advisor]

Hi Demi,

I work with Peter and will assist you. Thank you for sending us your logs privately. I reproduced the issue with your big account and raised it with my team. We will get back to you on this as soon as possible.

Regarding dates in the 'where' clause, here's the error description - https://developers.google.com/google-ads/api/reference/rpc/v8/QueryErrorEnum.QueryError?hl=en#expected_filters_on_date_range. Date ranges gives you only 2 options to state a range of dates, a range or a predefined. Nevertheless the guide doesn't explicitly exclude using one date that happens to create a finite range. I will bring this also up with my team. You may monitor Date ranges for an update.


Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2PIj1U:ref