Try your query here: https://developers.google.com/google-ads/api/fields/v10/ad_group_query_builder
You will see: Fix your query to address the errors below and re-submit. - 'ad_group_ad.name' is not a valid field in the SELECT clause when 'ad_group_ad' is the resource in the FROM clause. Fields in the SELECT must be 'Selectable'. - 'ad_group_ad.text_ad' is not a valid field in the SELECT clause when 'ad_group_ad' is the resource in the FROM clause. Fields in the SELECT must be 'Selectable'. - 'ad_group_ad.expanded_text_ad' is not a valid field in the SELECT clause when 'ad_group_ad' is the resource in the FROM clause. Fields in the SELECT must be 'Selectable'. You can also click very easily your query from start: SELECT ad_group_ad.ad.id, ad_group_ad.resource_name, ad_group_ad.ad.name, ad_group_ad.ad.expanded_text_ad.headline_part1, ad_group_ad.ad.expanded_text_ad.headline_part2, ad_group_ad.ad.expanded_text_ad.headline_part3, ad_group_ad.ad.expanded_text_ad.description, ad_group_ad.ad.expanded_text_ad.description2, ad_group_ad.ad.text_ad.headline, ad_group_ad.ad.text_ad.description1, ad_group_ad.ad.text_ad.description2 FROM ad_group_ad marwen...@esprit.tn schrieb am Freitag, 8. Juli 2022 um 11:28:05 UTC+2: > Hello There, > > I'm trying to query the ad entity mentioned in the google ads api > documentation ( > https://developers.google.com/google-ads/api/reference/rpc/v10/Ad) > using this code : (I will mention just some of my code) > > query = """ > SELECT > Ad.id > FROM Ad """ > stream = ga_service.search(customer_id=customer_id, query=query) > > And I'm getting message: "Unrecognized field in the query: \'Ad.id\'." ( > for all fields) > Can someone help with this ? > > > I did even change my query and it works for id but it not working for > other fields: > query = """ > SELECT > ad_group_ad.ad.id, > ad_group_ad.resource_name, > ad_group_ad.name, > ad_group_ad.text_ad, > ad_group_ad.expanded_text_ad > FROM ad_group_ad """ > > message: "Unrecognized fields in the query: \'ad_group_ad.text_ad\', \' > ad_group_ad.name\', \'ad_group_ad.expanded_text_ad\'." > ( I need to get ads data from the api) > > Thank you in advance. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/ddcda24f-3fcb-4eb4-af68-c1ace637399cn%40googlegroups.com.
