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/2c3e1172-552c-40f8-b44a-0728a9537ea2n%40googlegroups.com.
