Hi,
I'm in the same boat as Alex, Arthur and Martin and I'm also struggling
from one unexpected error message to the next. I would like to add, that
the same errors occur in the *customer*_search_term_insight report. I would
also like to suggest to name these reports as in the UI
<https://support.google.com/google-ads/answer/11386930> - namely with
"..._insight*s"* instead of "..._insight" - if you are already in the
process of correcting the errors.
Thank you
Mat
Martin Roettgerding schrieb am Mittwoch, 23. August 2023 um 21:57:13 UTC+2:
> Hi,
> I've sent you two customer IDs privately. However, as far as I can see,
> it's the same in all accounts.
>
> Here is a little Ads Script that demonstrates the error. It grabs a
> campaign id, uses that to grab an insight id and finally uses both for a
> simple query that fails (I've used Ads Scripts since it seems the easiest
> way to demonstrate what happens with pure API as well.)
>
> function main() {
> // Get campaign.id from the campaign with the highest cost
> let campaignId = AdsApp.report('SELECT campaign.id, metrics.cost_micros
> FROM campaign WHERE segments.date DURING LAST_MONTH ORDER BY
> metrics.cost_micros DESC').rows().next()['campaign.id'];
>
> // Get the top insight's id (avoid uncategorized search terms with id =
> 0)
> let queryInsightId = 'SELECT campaign_search_term_insight.id,
> metrics.impressions FROM campaign_search_term_insight WHERE segments.date
> DURING LAST_MONTH AND campaign_search_term_insight.campaign_id = "' +
> campaignId + '" AND campaign_search_term_insight.id != 0 ORDER BY
> metrics.impressions DESC';
> let insightId = AdsApp.report(queryInsightId).rows().next()['
> campaign_search_term_insight.id'];
>
> // Now query the data for this insightId from this campaignId
> let query = 'SELECT campaign_search_term_insight.category_label,
> segments.search_subcategory, segments.search_term FROM
> campaign_search_term_insight WHERE segments.date DURING LAST_MONTH AND
> campaign_search_term_insight.campaign_id = "' + campaignId + '" AND
> campaign_search_term_insight.id = "' + insightId + '"';
> let searchTermInsightsReport = AdsApp.report(query);
> let fail = searchTermInsightsReport.rows().totalNumEntities();
> }
>
> On Tuesday, 22 August 2023 at 14:07:47 UTC+2 Google Ads API Forum Advisor
> wrote:
>
>> Hi Martin,
>>
>> Thank you for coming back to us and for providing your insights about
>> this matter. I hope you are doing well today.
>>
>> In relation to your concern, for us to validate and further investigate
>> on the mentioned issues, please provide us your complete logs with CID or
>> uncropped screenshot from Google Ads UI (with data filter), this will help
>> us to further check if this is related to API bug and raise this concern to
>> a wider team. We are looking forward to the needed information, thank you
>> for your patience and understanding.
>>
>> Have a great day.
>>
>> This message is in relation to case "ref:_00D1U1174p._5004Q2ntKRb:ref"
>>
>> Thanks,
>>
>> [image: Google Logo] 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/3abee6b6-4ab7-49f2-8129-b563656767dcn%40googlegroups.com.
