Re: Nested where clause and OR clauses

[don....@gmail.com]

I second this request we would like to do query like

SELECT
ad_group_ad.ad.name,
ad_group_ad.ad.call_ad.headline1,
ad_group_ad.ad.expanded_text_ad.headline_part1,

FROM ad_group_ad
WHERE ad_group.status IN ('ACTIVE', 'PAUSED')
AND (metrics.cost_micros > 0 OR metrics.clicks > 0)
AND segments.date = '2022-07-01'

but can't do this..

On Wednesday, May 11, 2022 at 6:52:06 PM UTC+3 elda...@gmail.com wrote:

> Here is an example where OR could be useful:
> SELECT customer.id, metrics.impressions, metrics.all_conversions FROM 
> customer where metrics.impressions != 0 or metrics.all_conversions != 0 
> (using *and *in stead of *or *is valid)
>
> That same query is where nesting is required, for example:
> SELECT customer.id, metrics.impressions, metrics.all_conversions FROM 
> customer where segments.date >= '2022-04-01' and segments.date <= 
> '2022-04-30' and (metrics.impressions != 0 or metrics.all_conversions != 0)
>
> On Wednesday, May 11, 2022 at 4:56:53 PM UTC+2 adsapi wrote:
>
>> Hello Kristijan,
>>
>> Thanks for reaching out to the Google Ads API support. I am afraid if it 
>> is allow to do that because all reports GAQL queries are predefined and has 
>> to be selectable. In case if you want to check on your end then please 
>> refer to the  Google Ads Query Builder 
>> 
>>  
>> tool for the query validation on Google Ads API. Please share your GAQL 
>> query with us so we can also validate for you. Let me know if you have any 
>> questions on this.
>>
>> Please send the requested details via the Reply privately to the author 
>> option. If this option is not available, you may send the details directly 
>> to our googleadsa...@google.com alias by 
>> referring to this thread.
>>
>> Best regards,
>>
> [image: Google Logo] 
>> Jakeia Sabrina 
>> Google Ads API Team  
>>
>> ref:_00D1U1174p._5004Q2arRmI: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/1b45493a-cdbf-4d4c-b12a-c9de5998332an%40googlegroups.com.

Re: Nested where clause and OR clauses

[Kristijan Novaković]

Here is an example where OR could be useful:
SELECT customer.id, metrics.impressions, metrics.all_conversions FROM 
customer where metrics.impressions != 0 or metrics.all_conversions != 0 
(using *and *in stead of *or *is valid)

That same query is where nesting is required, for example:
SELECT customer.id, metrics.impressions, metrics.all_conversions FROM 
customer where segments.date >= '2022-04-01' and segments.date <= 
'2022-04-30' and (metrics.impressions != 0 or metrics.all_conversions != 0)

On Wednesday, May 11, 2022 at 4:56:53 PM UTC+2 adsapi wrote:

> Hello Kristijan,
>
> Thanks for reaching out to the Google Ads API support. I am afraid if it 
> is allow to do that because all reports GAQL queries are predefined and has 
> to be selectable. In case if you want to check on your end then please 
> refer to the  Google Ads Query Builder 
> 
>  
> tool for the query validation on Google Ads API. Please share your GAQL 
> query with us so we can also validate for you. Let me know if you have any 
> questions on this.
>
> Please send the requested details via the Reply privately to the author 
> option. If this option is not available, you may send the details directly 
> to our googleadsapi-supp...@google.com alias 
> by referring to this thread.
>
> Best regards,
> [image: Google Logo] 
> Jakeia Sabrina 
> Google Ads API Team  
>
> ref:_00D1U1174p._5004Q2arRmI: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/621a9dc4-48c9-4d43-abd8-ca0a391d9da7n%40googlegroups.com.

RE: Nested where clause and OR clauses

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hello Kristijan,

Thanks for reaching out to the Google Ads API support. I am afraid if it is 
allow to do that because all reports GAQL queries are predefined and has to be 
selectable. In case if you want to check on your end then please refer to the 
Google Ads Query Builder tool for the query validation on Google Ads API. 
Please share your GAQL query with us so we can also validate for you. Let me 
know if you have any questions on this.

Please send the requested details via the Reply privately to the author option. 
If this option is not available, you may send the details directly to our 
googleadsapi-supp...@google.com alias by referring to this thread.

Best regards,

Jakeia Sabrina
Google Ads API Team
ref:_00D1U1174p._5004Q2arRmI: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/8xCCF0RBQ46A004-WGLmZzTsmU41u8d2Omgg%40sfdc.net.

Nested where clause and OR clauses

[Kristijan Novaković]

Is it possible to write nested where clause in Ads API and is it possible 
to use OR key? If so, how, I couldn't find anything in docs.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/7928fd28-e9e9-404a-b0c3-b01dd4d22dedn%40googlegroups.com.