Re: Digest for adwords-api@googlegroups.com - 7 updates in 6 topics

65 views
Skip to first unread message

بيع الجوالات والاكسسوارات بيع جوالات أبل‎

unread,
Jan 29, 2021, 9:47:12 AM1/29/21
to adwor...@googlegroups.com
عربي ارجو الكتابه بلعربي 

احصل على Outlook لـ iOS
من: adwor...@googlegroups.com <adwor...@googlegroups.com>
‏‏تم الإرسال: Friday, January 29, 2021 1:58:59 PM
إلى: Digest recipients <adwor...@googlegroups.com>
‏‏الموضوع: Digest for adwor...@googlegroups.com - 7 updates in 6 topics
 
Google Ads API Forum Advisor Prod <adsapifor...@gmail.com>: 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 <al...@trueclicks.com>: 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:
 
 
--
Lukasz Tomala <lukasz...@home24.de>: 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
Alexey <demchenko...@gmail.com>: 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.
Qi Wang <qi.b...@rakuten.com>: 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:
 
Google Ads API Forum Advisor Prod <adsapifor...@gmail.com>: 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
"dudoa...@gmail.com" <dudoa...@gmail.com>: 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.
You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an email to adwords-api...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages