Hi, thanks for responding to my question.
I really need to filter the 0 case.
But I just need to filter out cases where all three are 0.
But if metrics.impressions is 0 but metrics.conversions is greater than 0
and metrics.conversions_value is greater than 0.
I still need to get the data under this condition.
The same is true if metrics.impressions is not 0.metrics.conversions is 0
and metrics.conversions_value is 0.
I also need to get the data that fits the criteria.
These three conditions are the correlation of or instead of and.
If one of the three conditions is met, all of them are the data I need to
obtain. In this case, exclusion by subdivision is not sufficient.
So what am I supposed to do.
Best regards,
Yangyang
在2024年3月4日星期一 UTC+8 08:53:00<YangYang Wang> 写道：
>
> Hi, thanks for responding to my question.
>
> I now need to filter the above information SQL information,
>
> I use the date first
>
> segments.date BETWEEN '2024-02-29' AND '2024-03-01'
>
> I did an interval range filtering, but for what I need to generate
>
> The report information is not very accurate, I need to add another filter
> to the filter
>
> metrics.impressions is greater than 0 or metrics.all_conversions_value is
> greater than 0
>
> Or metrics.all_conversions > 0 to pull data into the report.
>
> However, the api does not support or query mode. And now I don't know what
> to do.
>
> Here is my request query and the result returned.
>
>
> - Here, > means greater than.
> -
>
>
>
> query SELECT ad_group.id, segments.date, metrics.all_conversions,
> metrics.all_conversions_value, metrics.clicks, metrics.conversions,
> metrics.conversions_value, metrics.average_cost, metrics.cost_micros,
> metrics.impressions, geographic_view.location_type,
> geographic_view.resource_name, geographic_view.country_criterion_id,
> customer.id, customer.currency_code, campaign.id,
> campaign.app_campaign_setting.app_id,
> campaign.app_campaign_setting.app_store FROM geographic_view WHERE
> segments.date BETWEEN '2024-03-02' AND '2024-03-02'AND (metrics.impressions
> > 0 OR metrics.all_conversions_value > 0 OR metrics.all_conversions
> > 0).
>
> result "message": "Request contains an invalid argument.",
> "code": 3,
> "status": "INVALID_ARGUMENT",
> "details": [
> {
> "@type": "type.googleapis.com
> \/google.ads.googleads.v14.errors.GoogleAdsFailure",
> "errors": [
> {
> "errorCode": {
> "queryError": "BAD_VALUE"
> },
> "message": "Error in WHERE clause: invalid value '."
> }
> ],
> "requestId": "nUcEemZJelavpUNlMBSFTw"
> }
> ]
> 在2024年3月1日星期五 UTC+8 23:36:54<Google Ads API Forum Advisor> 写道：
>
>> Hi,
>>
>> Thank you for reaching out to the Google Ads API support team.
>>
>> By reviewing your concern, I understand that you need information
>> regarding zero impressions that could be excluded using segments.
>>
>> Kindly note that zero metrics are always excluded when segmenting a
>> report, provided all selected metrics are zero. I would recommend you to
>> check this guide to Exclude zero metrics by segmenting
>> <https://developers.google.com/google-ads/api/docs/reporting/zero-metrics#exclude_zero_metrics_by_segmenting>
>> for
>> more information.
>>
>> In order to assist you further, could you please provide us with an
>> uncropped UI screenshot with better visibility of the customer ID
>> and complete updated API logs (*request*
>> <https://developers.google.com/google-ads/api/docs/concepts/field-service#request>
>> and
>> <https://developers.google.com/google-ads/api/docs/concepts/field-service#response>
>> *response*
>> <https://developers.google.com/google-ads/api/docs/concepts/field-service#response>
>> with
>> <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id>
>> *request-id*
>> <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id>
>> and
>> <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers>*request
>>
>> header*
>> <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers>)
>>
>> generated at your end.
>>
>> If you are using a client library and haven't enabled the logging yet, I
>> would request you to enable logging for the specific client library
>> that you are using. You can refer to the guides Java
>> <https://developers.google.com/google-ads/api/docs/client-libs/java/logging>,
>>
>> .Net
>> <https://developers.google.com/google-ads/api/docs/client-libs/dotnet/logging>
>> , PHP
>> <https://developers.google.com/google-ads/api/docs/client-libs/php/logging>
>> , Python
>> <https://developers.google.com/google-ads/api/docs/client-libs/python/logging>
>> , Ruby
>> <https://developers.google.com/google-ads/api/docs/client-libs/ruby/logging>
>> or Perl
>> <https://developers.google.com/google-ads/api/docs/client-libs/perl/logging>
>> to
>> enable logging at your end. For REST interface requests, you can
>> enable logging via the curl command by using the -i flag.
>>
>>
>> This message is in relation to case "ref:!00D1U01174p.!5004Q02rzarV: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/57617df4-1199-4f33-9458-6c11b0a3a45an%40googlegroups.com.
