عربي ارجو الكتابه بلعربي احصل على Outlook لـ iOS<https://aka.ms/o0ukef> ________________________________ من: [email protected] <[email protected]> تم الإرسال: Friday, January 29, 2021 1:58:59 PM إلى: Digest recipients <[email protected]> الموضوع: Digest for [email protected] - 7 updates in 6 topics
[email protected]<https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/adwords-api/topics> Google Groups<https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> [http://www.google.com/images/icons/product/groups-32.png] <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> Topic digest View all topics<https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/adwords-api/topics> * GAQL query - get campaigns with advertising_channel_sub_type not set - 2 Updates * Locations - Per store report - 1 Update * Access issue - 1 Update * ACTION_NOT_PERMITTED for Upload Click Conversion - 1 Update * Iteration of metrics [PHP] - 1 Update * Credential could not be refreshed, "error" : "invalid_grant", "error_description" : "Bad Request" - 1 Update GAQL query - get campaigns with advertising_channel_sub_type not set <http://groups.google.com/group/adwords-api/t/c69b9fcf6156717c?utm_source=digest&utm_medium=email> Google Ads API Forum Advisor Prod <[email protected]>: Jan 29 07:37AM Hi Ales, You can refer to our Query grammar guide to know more on what operators you can use, depending on your reporting requirement. Regarding your question about the advertising_channel_sub_type if the value is not set, you can try and use the IS NULL operator. I hope this helps. Best regards, Peter Laurence Napa Oliquino Google Ads API Team ref:_00D1U1174p._5004Q2BbfhK:ref Ales Sturala <[email protected]>: Jan 29 02:54AM -0800 Hi Peter, I read the documentation already before and tested different options with no luck. Query grammar only gives you syntactical options but not semantical so it doesn't say which operators are valid for which fields. I tested *IS NULL *and couple of other approaches but I had no luck getting only rows where *advertising_channel_sub_type *is not set. Also I guess that the *NOT IN* operator shouldn't implicitly exclude NULL values. If you would manage to do such a query please let me know. For now we will load all the data from the API and do additional filtering in the backend. Best, Ales On Friday, 29 January 2021 at 08:37:34 UTC+1 adsapiforumadvisor wrote: -- Back to top Locations - Per store report <http://groups.google.com/group/adwords-api/t/819cd2e5afadfbd0?utm_source=digest&utm_medium=email> Lukasz Tomala <[email protected]>: Jan 29 02:45AM -0800 Hello, I'm looking for a API Report to get the same data as in the "per store report" in the interface. Best Lukasz Back to top Access issue <http://groups.google.com/group/adwords-api/t/5aa780d134992619?utm_source=digest&utm_medium=email> Alexey <[email protected]>: Jan 29 12:40AM -0800 Hello. I have google account ads account and g-suite account. On g-suite account I have app to read ads data. I share ads customers from ads account to g-suite account, but when I'm trying to get these customers data I get access error. When I filled out the form for developer token I received something like this: "The company you applied for already has an approved API token through their Ads Manager (MCC) account ID {id}. in accordance with the Ads API policy, we provide only one developer token per legal entity. If you would like to receive contact information for a party with an already approved developer token, please reply to this email indicating this." I'm usind php SDK GoogleAds V5 and getting all clients with this methods: $this->client = (new GoogleAdsClientBuilder()) ->fromFile(config('google_ads.config_file')) ->withOAuth2Credential((new OAuth2TokenBuilder()) ->fromFile(config('google_ads.config_file')) ->withRefreshToken($token) ->build()) ->build(); ... $customerServiceClient = $this->client->getCustomerServiceClient(); $accessibleCustomers = $customerServiceClient->listAccessibleCustomers(); When i iterate throw array of customers to have names I get: foreach ($accessibleCustomers->getResourceNames() as $customerResourceName) { $customer = CustomerServiceClient::parseName($customerResourceName)['customer']; $current_customer = $customerServiceClient->getCustomer(ResourceNames::forCustomer($customer)); $name = $current_customer->getDescriptiveName(); $result = [ 'name' => $name, 'id' => intval($customer) ]; array_push($accessibleCustomerIds, $result); } Exception: { "message": "The caller does not have permission", "code": 7, "status": "PERMISSION_DENIED", "details": [ { "@type": "google.ads.googleads.v5.errors.googleadsfailure-bin", "data": "<Unknown Binary Data>" }, { "@type": "grpc-status-details-bin", "data": "<Unknown Binary Data>" }, { "@type": "request-id", "data": "51xDV-nU3NsoLzScC1bU5g" } ] } Is it somehow related to the developer token? If so, how to get access. Thank. Back to top ACTION_NOT_PERMITTED for Upload Click Conversion <http://groups.google.com/group/adwords-api/t/2296afbf1f2a6f30?utm_source=digest&utm_medium=email> Qi Wang <[email protected]>: Jan 28 11:49PM -0800 Finally we found the issue, it is because of the refresh we created doesn't have permission to upload conversion data to the customer. So the refresh token generate by the user who have the permission to upload conversion to this customer is working fine. Thank you very much! On Friday, January 29, 2021 at 4:02:33 AM UTC+8 adsapiforumadvisor wrote: Back to top Iteration of metrics [PHP] <http://groups.google.com/group/adwords-api/t/12bb04c97c9f855a?utm_source=digest&utm_medium=email> Google Ads API Forum Advisor Prod <[email protected]>: Jan 29 06:12AM Hi Floyd, Could you confirm if the main concern is about accessing the metrics you included in your query using PHP? If yes, then you may continue your discussion with the PHP client library owners instead. In addition, to ensure as well that you are not encountering issues with the API's reporting, could you confirm if your requests are not returning any errors? If errors are being returned or if there are no data being returned at all, or if there are discrepancies, you may provide the complete request and response logs so our API team can investigate further. Best regards, Peter Laurence Napa Oliquino Google Ads API Team ref:_00D1U1174p._5004Q2B28RT:ref Back to top Credential could not be refreshed, "error" : "invalid_grant", "error_description" : "Bad Request" <http://groups.google.com/group/adwords-api/t/d960c239e0c972b7?utm_source=digest&utm_medium=email> "[email protected]" <[email protected]>: Jan 28 08:48PM -0800 We receive error "Credential could not be refreshed" when sending request to get report data. Please help me to clear this issue, why did this issue happend and how can we need handle it? Response error jp.co.everrise.batch.error.GetReportException: com.google.api.ads.common.lib.exception.OAuthException: Credential could not be refreshed. at jp.co.everrise.batch.service.GetReportAdwordsService.<init>(GetReportAdwordsService.java:50) at jp.co.everrise.batch.multitasking.DownloadReportAdword.run(DownloadReportAdword.java:71) Caused by: com.google.api.ads.common.lib.exception.OAuthException: Credential could not be refreshed. at com.google.api.ads.common.lib.auth.OfflineCredentials.generateCredential(OfflineCredentials.java:240) at jp.co.everrise.batch.util.AdwordsUtils.createOfflineCredentials(AdwordsUtils.java:56) at jp.co.everrise.batch.service.GetReportAdwordsService.<init>(GetReportAdwordsService.java:48) ... 1 more Caused by: com.google.api.client.auth.oauth2.TokenResponseException: 400 Bad Request { "error" : "invalid_grant", "error_description" : "Bad Request" } at com.google.api.client.auth.oauth2.TokenResponseException.from(TokenResponseException.java:105) at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:287) at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307) at com.google.api.client.auth.oauth2.Credential.executeRefreshToken(Credential.java:570) at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:362) at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489) at com.google.api.ads.common.lib.auth.OAuth2Helper.callRefreshToken(OAuth2Helper.java:69) at com.google.api.ads.common.lib.auth.OfflineCredentials.generateCredential(OfflineCredentials.java:234) ... 3 more Thank you very much. I hope to receive your response soon. Du Doan. Back to top You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page<https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/adwords-api/join>. To unsubscribe from this group and stop receiving emails from it send an email to [email protected]<mailto:[email protected]>. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/DBBPR04MB7548BED3C320F60501A2CEC5AAB99%40DBBPR04MB7548.eurprd04.prod.outlook.com.
