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/79c9cb27-d093-4c71-adff-2e455e81c584n%40googlegroups.com.
