I'm trying to extract Search queries by certain rules and I need to get Queries that contain one of the given strings:

    " WHERE " +               " Impressions > " + IMPRESSIONS_THRESHOLD +        " AND AverageCpc > " + AVERAGE_CPC_THRESHOLD +        " AND Query CONTAINS_ANY ['for sale in', 'buy'] " +            " DURING YESTERDAY "); 

But I'm getting error message (tryed different variations):

One of the conditions in the query is invalid. (file Code.gs, line 19) 

Although it seems like I do everything according to Formal Grammar:

String           -> StringSingleQ | StringDoubleQ StringSingleQ    -> '(char)' StringDoubleQ    -> "(char)" StringList       -> [ String (, String)* ] 

If I do just 1 string it works fine:

 " WHERE " +               " Impressions > " + IMPRESSIONS_THRESHOLD +        " AND AverageCpc > " + AVERAGE_CPC_THRESHOLD +        " AND Query CONTAINS 'for sale in' " +             " DURING YESTERDAY "); 

When I execute google-ads python sample code I get the following error

DEBUG:google.auth.transport.requests:Making request: POST https://accounts.google.com/o/oauth2/token DEBUG:urllib3.connectionpool:Starting new HTTPS connection (1): accounts.google.com:443 DEBUG:urllib3.connectionpool:https://accounts.google.com:443 "POST /o/oauth2/token HTTP/1.1" 200 None E0421 09:57:53.365121806   21019 ssl_transport_security.cc:1455] Handshake failed with fatal error SSL_ERROR_SSL: error:1000007d:SSL routines:OPENSSL_internal:CERTIFICATE_VERIFY_FAILED. INFO:google.ads.googleads.client:Request ------- Method: /google.ads.googleads.v6.services.GoogleAdsService/SearchStream Host: googleads.googleapis.com Headers: {   "developer-token": "REDACTED",   "x-goog-api-client": "gl-python/3.8.6 grpc/1.37.0 gax/1.26.3",   "x-goog-request-params": "customer_id=" } Request: query: "\n        SELECT\n          campaign.id,\n          campaign.name\n        FROM campaign\n        ORDER BY campaign.id" Response ------- Headers: {} Fault: {   "created": "@1619013473.365323139",   "description": "Failed to pick subchannel",   "file": "src/core/ext/filters/client_channel/client_channel.cc",   "file_line": 5419,   "referenced_errors": [     {       "created": "@1619013473.365317068",       "description": "failed to connect to all addresses",       "file": "src/core/ext/filters/client_channel/lb_policy/pick_first/pick_first.cc",       "file_line": 397,       "grpc_status": 14     }   ] } 

I am behind a corporate network that uses its own certificate for every Internet connection.

1. Our servers trust the internal certificates. I replaced the CA certs in certifi with our CA certs and urllib3 connects fine to both accounts.google.com and googleads.googleapis.com.

2. curl to both URLs work fine as well

3. From the error above looks like urllib3 connected fine but GRPC had an issue. Given curl works, the OS ca certs are fine so where does GRPC pick the ca certs from that I would need to add our corporate issuer certs to?

google-ads: 10.0.0 / python: 3.8.0 / RHEL7

Does google ads API work?

When I click the google ads API document, I get "Service Unavailable".

1. Where can I see this API status, and when it's back?
2. Can I use this API to create custom audience/lookalike audience just like facebook ads API?
3. (Additional) I am NodeJS developer, is there any library that is already working well with ads API?

Thank you so much!

I am trying to set up a data extract in BigQuery to pull data from a Google Ads Account. But I keep getting Auth errors (AuthenticationError.NOT_ADS_USER) when the extract tries starting pulling data.

<ApiError><type>AuthenticationError.NOT_ADS_USER</type><trigge 

What did I do?-

• Set up Big Query and the data extract (as depicted here: https://cloud.google.com/bigquery-transfer/docs/adwords-transfer)

• Invited and added the same email address that big query is using to the Google Ads account with read access level (at first) and then standard access level when the problem persisted.

Is there something that I missed, that I have to enable/accept/configure in order for Big query extract to be able to pull the data from Google Ads?

Thanks,

p.s I have another extract in the same big query account with a different Google Ads account that is working, I recall have followed the same steps.

Recently my application started spamming logs with the following set of messages

W/ColorUtils: expected specified color aspects (0:0:0:0) D/ReflectedParamUpdater: extent() != 1 for single value type: algo.buffers.max-count.values D/ReflectedParamUpdater: extent() != 1 for single value type: output.subscribed-indices.values D/ReflectedParamUpdater: extent() != 1 for single value type: input.buffers.allocator-ids.values D/ReflectedParamUpdater: extent() != 1 for single value type: output.buffers.allocator-ids.values D/ReflectedParamUpdater: extent() != 1 for single value type: algo.buffers.allocator-ids.values D/ReflectedParamUpdater: extent() != 1 for single value type: output.buffers.pool-ids.values D/ReflectedParamUpdater: extent() != 1 for single value type: algo.buffers.pool-ids.values 

I can't see the "expected specified color aspects" in the sources my IDE has downloaded or by Googling and I have struggled to identify what triggers this, since the log is quickly overwhelmed by these messages

The only reference I found which could be related is this question but I do not use exoplayer. The only thing which may be using videos is the Google Ads SDK.

Does anyone know what the root cause is for this spam? If it's in ads, is there a way to disable it?