My bad, I tested and pasted a wrong GQL. Im trying to get conversion_action_category from asset_group as per below
SELECT asset_group.id, asset_group.name, segments.date, customer.id, customer.descriptive_name, campaign.id, campaign.name, segments.conversion_action_category FROM asset_group WHERE segments.date BETWEEN '2025-01-01' AND '2025-01-31' AND campaign.advertising_channel_type = 'PERFORMANCE_MAX' This one fails validation and this report doesnt allow that segment (https://developers.google.com/google-ads/api/fields/v18/asset_group) Any workaround to get conversions categories per asset group? Thank you again El miércoles, 26 de febrero de 2025 a la(s) 11:28:03 a.m. UTC+1, Google Ads API Forum Advisor escribió: > Hi, > > Thank you for reaching out to the Google Ads API support team. > > The PROHIBITED_SEGMENT_WITH_METRIC_IN_SELECT_OR_WHERE_CLAUSE > <https://developers.google.com/google-ads/api/reference/rpc/v13/QueryErrorEnum.QueryError#prohibited_metric_in_select_or_where_clause> > is > encountered because a segment may have been included together with a metric > that it is incompatible with in the SELECT or WHERE clause. For more > information, you may see this document about segmentation > <https://developers.google.com/google-ads/api/docs/reporting/segmentation> > . > > I have verified the GAQL that you have shared, and I could see that it is > validated successfully in the Query Validator > <https://developers.google.com/google-ads/api/fields/v16/query_validator>. > Also, I tried to replicate your issue on my end and I'm able to fetch the > data successfully while executing the given GAQL query with some random > account without any errors. So, I request you try running the query again > and let us know how it goes at your end. You can try making a request using > the Method:customers.googleAds.search > <https://developers.google.com/google-ads/api/rest/reference/rest/v16/customers.googleAds/search?Concierge__enable_concierge=false> > or Method:customers.googleAds.searchStream > <https://developers.google.com/google-ads/api/rest/reference/rest/v16/customers.googleAds/searchStream?Concierge__enable_concierge=false> > . > > if you still face any issues, kindly provide us with the uncropped UI > screenshot by highlighting the fields that you are trying to retrieve from > the ad_group_ad > <https://developers.google.com/google-ads/api/fields/v18/ad_group_ad> report > via the Google Ads API. > > You can send the details via *Reply privately to the author option*, or > *direct > private reply* to this email. > Thanks, > > [image: Google Logo] Google Ads API Team > Feedback > How was our support today? > > [image: rating1] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=1&entry.295079254=5004Q00002vH3zGQAS> > > [image: rating2] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=2&entry.295079254=5004Q00002vH3zGQAS> > > [image: rating3] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=3&entry.295079254=5004Q00002vH3zGQAS> > > [image: rating4] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=4&entry.295079254=5004Q00002vH3zGQAS> > > [image: rating5] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=5&entry.295079254=5004Q00002vH3zGQAS> > [2025-02-26 10:27:31Z GMT] This message is in relation to case > "ref:!00D1U01174p.!5004Q02vH3zG:ref" (ADR-00289858) > > > > > -- Este mensaje y, en su caso, los ficheros anexos, son confidenciales y se dirigen exclusivamente al destinatario referenciado. Si Ud. no lo es y ha recibido este mensaje por error o tiene conocimiento de éste por cualquier motivo, le informamos que cualquier divulgación, copia, distribución o uso de los contenidos está prohibida, y habrá de comunicarlo por este medio y proceder a destruirlo inmediatamente y, en todo caso, abstenerse de utilizar, reproducir, alterar, archivar o comunicar a terceros el presente mensaje y sus ficheros anexos. El emisor no garantiza la integridad, rapidez o seguridad del presente correo, ni se responsabiliza de posibles perjuicios derivados de la captura, incorporaciones de virus o cualesquiera otras manipulaciones efectuadas por terceros. En cumplimiento de lo dispuesto en la Ley 34/2002, de 11 de Julio, de Servicios de la Sociedad de la Información y del Comercio Electrónico (LSSI-CE) y en el Reglamento (UE) 2016/679 del Parlamento Europeo y del Consejo, de 27 de abril de 2016, relativo a la protección de las personas físicas en lo que respecta al tratamiento de datos personales y a la libre circulación de estos datos (RGPD), ANINPRO-CREATIVE, S.L. garantiza la confidencialidad de sus datos personales. La información gestionada por ANINPRO-CREATIVE, S.L. tiene por finalidad única el desarrollo de su actividad. Ud. podrá en todo momento ejercitar los derechos de acceso, rectificación, cancelación, oposición, limitación y portabilidad de sus datos de carácter personal ante el órgano de control, la Agencia Española de Protección de Datos (AEPD) o dirigiendo la pertinente solicitud a la dirección postal: Calle Zurbarán, nº 16; C.P.: 28010 Madrid, o bien a la dirección electrónica: [email protected] <mailto:[email protected]>, junto con una copia del documento acreditativo de su identidad, indicando en el asunto “Protección de Datos Personales”. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. To view this discussion visit https://groups.google.com/d/msgid/adwords-api/2489a6bf-97f1-4290-980d-29be230f1e76n%40googlegroups.com.
