Please let me know what you find, but to clarify, the code works for the
following GAQL query (All results are returned, and match the results in
the UI):
SELECT
campaign_search_term_insight.category_label,
metrics.clicks,
metrics.impressions,
metrics.conversions,
metrics.conversions_value
FROM
campaign_search_term_insight
WHERE
segments.date DURING LAST_7_DAYS
AND campaign_search_term_insight.campaign_id ='19548801299'
ORDER BY
metrics.impressions ASC
Similarly, the code works for the following query (change highlighted in
yellow) - a single result from the previous query is returned:
SELECT
campaign_search_term_insight.category_label,
metrics.clicks,
metrics.impressions,
metrics.conversions,
metrics.conversions_value
FROM
campaign_search_term_insight
WHERE
segments.date DURING LAST_7_DAYS
AND campaign_search_term_insight.campaign_id ='19548801299'
AND campaign_search_term_insight.id ='1563229965490945024'
However, the internal error is generated when the query is modified into
the following:
SELECT
campaign_search_term_insight.category_label,
segments.date,
segments.search_subcategory,
segments.search_term,
metrics.clicks,
metrics.impressions,
metrics.conversions,
metrics.conversions_value
FROM
campaign_search_term_insight
WHERE
segments.date DURING LAST_7_DAYS
AND campaign_search_term_insight.campaign_id ='19548801299'
AND campaign_search_term_insight.id ='1563229965490945024'
There seems to be no issue with the logic of the query, or the code.
Thanks,
Moshik
On Tuesday, November 7, 2023 at 4:39:36 PM UTC+2 Google Ads API Forum
Advisor wrote:
> >>The error only occurs for this particular query.
>
> I'm still not clear what you mean. Do you mean with the values specified
> and that if you change
>
> When you say a different query, what does that mean? You just change the
> campaign id?
>
> Since the Curl query returns an internal error it points to a back end
> problem that was being propagated to grpc.
>
> I'll need to open an consultation with our back end team. For that, I'll
> need the request and response without any redactions. As soon as I have
> that I will open the consultation.
>
>
>
> This message is in relation to case "ref:!00D1U01174p.!5004Q02q9T1G:ref"
>
> Thanks,
>
> [image: Google Logo]
> Bob Hancock
> Google Ads API Team
>
>
>
>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/dbfa6a99-c9b3-4ba3-8cb7-43ae95e586ban%40googlegroups.com.
