Good day So I was using this query below to find a matching keyword to update its MaxCPC:
select segments.date, ad_group.id,ad_group.status,ad_group_criterion.status, campaign.id, ad_group_criterion.criterion_id, ad_group_criterion.keyword.text from keyword_view where segments.date between '2022-06-13' and '2022-07-13' There are matches on the add campaign platform and it's a live campaign, but the Google Ads API doesn't return Criterion IDs even with that wide date range. I have increased the output to 50 records - see below. Hope this provides more clarity? C:\WINDOWS\system32>curl --header "Authorization: Bearer ya29.A0AVA9y1v1NS6PHVF1MBxshOVTdUwzB2TaltQbXU-2n6YiNh3mJVyUmhPjdFb09325SuMXKYFcq-nFPlZdlGO8CrTUBLk5TEYTkBvdnbRhsTFiPvPnxw6mvcA697TM1JKqqo4SaKpg_U992dYeprCavOEe1xIkYUNnWUtBVEFTQVRBU0ZRRTY1ZHI4dXptRm5Ubjd0ZnQ0UFdSbG1DTG1jUQ0163" --header "developer-token: yVSGRK6SaKNv386UnNnDXA" --header "login-customer-id: 8919258818" --data "{ 'query': 'SELECT ad_group_criterion.criterion_id FROM keyword_view LIMIT 50' }" -X POST -H "Content-Type: application/json" https://googleads.googleapis.com/v9/customers/1928483495/googleAds:searchStream [{ "results": [ { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~10001207", "criterionId": "10001207" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~10001207" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~10050753", "criterionId": "10050753" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~10050753" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~10261242", "criterionId": "10261242" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~10261242" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~10329900", "criterionId": "10329900" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~10329900" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~10349172", "criterionId": "10349172" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~10349172" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~10432763", "criterionId": "10432763" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~10432763" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~10818541", "criterionId": "10818541" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~10818541" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~10992781", "criterionId": "10992781" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~10992781" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~11038091", "criterionId": "11038091" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~11038091" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~11040250", "criterionId": "11040250" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~11040250" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~11169740", "criterionId": "11169740" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~11169740" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~11232111", "criterionId": "11232111" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~11232111" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~11522913", "criterionId": "11522913" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~11522913" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~11868406", "criterionId": "11868406" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~11868406" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~12266332", "criterionId": "12266332" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~12266332" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~12490883", "criterionId": "12490883" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~12490883" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~12491343", "criterionId": "12491343" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~12491343" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~12528867", "criterionId": "12528867" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~12528867" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~12984116", "criterionId": "12984116" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~12984116" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~13376452", "criterionId": "13376452" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~13376452" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~13456723", "criterionId": "13456723" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~13456723" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~13739700", "criterionId": "13739700" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~13739700" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~13919910", "criterionId": "13919910" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~13919910" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14280241", "criterionId": "14280241" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14280241" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14280251", "criterionId": "14280251" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14280251" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14308422", "criterionId": "14308422" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14308422" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14373962", "criterionId": "14373962" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14373962" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14374152", "criterionId": "14374152" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14374152" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14375462", "criterionId": "14375462" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14375462" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14375622", "criterionId": "14375622" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14375622" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14375712", "criterionId": "14375712" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14375712" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14376032", "criterionId": "14376032" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14376032" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14376322", "criterionId": "14376322" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14376322" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14376542", "criterionId": "14376542" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14376542" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14377372", "criterionId": "14377372" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14377372" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14377782", "criterionId": "14377782" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14377782" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14378102", "criterionId": "14378102" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14378102" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14378132", "criterionId": "14378132" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14378132" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14379282", "criterionId": "14379282" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14379282" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14431740", "criterionId": "14431740" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14431740" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14431750", "criterionId": "14431750" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14431750" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14438741", "criterionId": "14438741" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14438741" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14438761", "criterionId": "14438761" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14438761" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14438771", "criterionId": "14438771" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14438771" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14446461", "criterionId": "14446461" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14446461" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14446531", "criterionId": "14446531" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14446531" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14446561", "criterionId": "14446561" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14446561" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14472542", "criterionId": "14472542" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14472542" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14588192", "criterionId": "14588192" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14588192" } }, { "adGroupCriterion": { "resourceName": "customers/1928483495/adGroupCriteria/44927913251~14605212", "criterionId": "14605212" }, "keywordView": { "resourceName": "customers/1928483495/keywordViews/44927913251~14605212" } } ], "fieldMask": "adGroupCriterion.criterionId", "requestId": "y-gGmSZhlp8IP8tnYtN89g" } ] C:\WINDOWS\system32> On Thu, Jul 21, 2022 at 6:39 PM Google Ads API Forum Advisor <adsapi@forumsupport.google> wrote: > Hello, > > Thanks for providing more information. Please see my observations below: > > - I see that an ad group criterion and its ID was returned in you > request > - The query in the screenshot is limited to only 1 result > - The query that you provided in your initial email is different from > the query in your screenshot > - The question in your most recent email seems different from the > question in your initial email > > Can you please help clarify the issue so that our team can better > investigate? > > Thanks, > > [image: Google Logo] > Matt > Google Ads API Team > > > ref:_00D1U1174p._5004Q2cWAmk:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/CAMrH_-kt562zeVKnXaMAoDbm8ctouupAbPgr9w0Zr5Ui7so%3D8A%40mail.gmail.com.