Hello,
yes, the problem still persists although the latency is now around 8
seconds instead of 35--45 but still drastically slower than it used to be.
Please find attached the full logs, I truncated the response payload a bit
because it is irrelevant.
Paul
On Monday, March 20, 2023 at 10:52:09 AM UTC+1 Google Ads API and AdWords
API Forum wrote:
Hi Paul,
Thank you for reaching out to our team.
Regarding your concern, could you confirm if you are still encountering the
said issue? If so, can you please provide the complete *request*
<https://developers.google.com/google-ads/api/docs/concepts/field-service#request>
and *response*
<https://developers.google.com/google-ads/api/docs/concepts/field-service#response>
logs
with *request ID*
<https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id>
and *request header*
<https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers>
generated
on your end? We will be needing this information to investigate this issue.
You may then send the requested logs via the *Reply privately to author*
option. If this option is not available, you may send the details directly
to our googleadsa...@google.com alias instead.
Regards,
Google Ads API Team
On Thursday, March 16, 2023 at 9:21:52 PM UTC+8 Paul wrote:
Hello,
we are experiencing a severe performance degradation when listing bidding
strategies. We run the following query against
/google.ads.googleads.v13.services.GoogleAdsService/Search:
SELECT
bidding_strategy.id,
bidding_strategy.name,
bidding_strategy.type,
bidding_strategy.target_roas.target_roas,
bidding_strategy.maximize_conversion_value.target_roas,
customer.id,
bidding_strategy.non_removed_campaign_count
FROM
bidding_strategy
WHERE
bidding_strategy.type IN ('MAXIMIZE_CONVERSION_VALUE', 'TARGET_ROAS')
AND bidding_strategy.status != 'REMOVED'
ORDER BY
bidding_strategy.name
The latency for this query (returning just 127 rows) used to be well within
one second, we are now seeing response times in the range of 35--45+
seconds. Using the SearchStream method does not significantly change the
timings.
Exemplary request id: yYVovV7E3qUe7DZo-DFiYQ
Is this service degradation expected?
Thanks,
Paul
--
*GetYourGuide Deutschland GmbH*
Sonnenburger Strasse 73,
10437 Berlin, Germany
Geschäftsführer: Johannes Reck, Tao Tao, Nils
Chrestin
Amtsgericht Charlottenburg HRB 132059 B; USt-IdNr. DE27645xz
<https://www.facebook.com/GetYourGuide> <https://twitter.com/GetYourGuide>
<https://www.instagram.com/getyourguide/>
<https://www.linkedin.com/company/getyourguide-ag>
<http://www.getyourguide.com/>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/221dccef-8151-436a-ba4c-83af43b3dab7n%40googlegroups.com.
[2023-03-20 14:48:16,505 - DEBUG] Request
-------
Method: /google.ads.googleads.v13.services.GoogleAdsService/Search
Host: googleads.googleapis.com
Headers: {
"developer-token": "REDACTED",
"login-customer-id": "6350619301",
"x-goog-api-client": "gl-python/3.9.5 grpc/1.51.3 gax/2.11.0 gccl/20.0.0
pb/4.22.1",
"x-goog-request-params": "customer_id=6350619301"
}
Request: customer_id: "6350619301"
query: "\nSELECT\n bidding_strategy.id,\n bidding_strategy.name, \n
bidding_strategy.type, \n bidding_strategy.target_roas.target_roas, \n
bidding_strategy.maximize_conversion_value.target_roas,\n customer.id,\n
bidding_strategy.non_removed_campaign_count\nFROM\n bidding_strategy\nWHERE\n
bidding_strategy.type IN (\'MAXIMIZE_CONVERSION_VALUE\', \'TARGET_ROAS\')\n
AND bidding_strategy.status != \'REMOVED\'\nORDER BY\n bidding_strategy.name\n
\n"
Response
-------
Headers: {
"alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000",
"content-disposition": "attachment",
"date": "Mon, 20 Mar 2023 14:48:16 GMT",
"request-id": "ZE9rB3_i_HljwlbApFNJrQ"
}
Response: results {
bidding_strategy {
resource_name: "customers/6350619301/biddingStrategies/10370725463"
id: 10370725463
name: "AU"
type_: MAXIMIZE_CONVERSION_VALUE
non_removed_campaign_count: 73942
maximize_conversion_value {
target_roas: 1.45
}
}
customer {
resource_name: "customers/6350619301"
id: 6350619301
}
}
results {
bidding_strategy {
resource_name: "customers/6350619301/biddingStrategies/10367428858"
id: 10367428858
name: "DACH"
type_: MAXIMIZE_CONVERSION_VALUE
non_removed_campaign_count: 47673
maximize_conversion_value {
target_roas: 1.47
}
}
customer {
resource_name: "customers/6350619301"
id: 6350619301
}
}
results {
bidding_strategy {
resource_name: "customers/6350619301/biddingStrategies/10367425129"
id: 10367425129
name: "DACH_ttd"
type_: MAXIMIZE_CONVERSION_VALUE
non_removed_campaign_count: 25612
maximize_conversion_value {
target_roas: 1.16
}
}
customer {
resource_name: "customers/6350619301"
id: 6350619301
}
}
results {
bidding_strategy {
resource_name: "customers/6350619301/biddingStrategies/10366011909"
id: 10366011909
name: "ES"
type_: MAXIMIZE_CONVERSION_VALUE
non_removed_campaign_count: 47637
maximize_conversion_value {
target_roas: 1.33
}
}
customer {
resource_name: "customers/6350619301"
id: 6350619301
}
}
results {
bidding_strategy {
resource_name: "customers/6350619301/biddingStrategies/10366011987"
id: 10366011987
name: "ES_ttd"
type_: MAXIMIZE_CONVERSION_VALUE
non_removed_campaign_count: 22079
maximize_conversion_value {
target_roas: 1.04
}
}
customer {
resource_name: "customers/6350619301"
id: 6350619301
}
}
results {
bidding_strategy {
resource_name: "customers/6350619301/biddingStrategies/10366019292"
id: 10366019292
name: "EUo"
type_: MAXIMIZE_CONVERSION_VALUE
non_removed_campaign_count: 285613
maximize_conversion_value {
target_roas: 1.44
}
}
customer {
resource_name: "customers/6350619301"
id: 6350619301
}
}
results {
bidding_strategy {
resource_name: "customers/6350619301/biddingStrategies/10366019283"
id: 10366019283
name: "EUo_ttd_dsa"
type_: MAXIMIZE_CONVERSION_VALUE
non_removed_campaign_count: 146295
maximize_conversion_value {
target_roas: 1.19
}
}
customer {
resource_name: "customers/6350619301"
id: 6350619301
}
}
results {
bidding_strategy {
resource_name: "customers/6350619301/biddingStrategies/10366019301"
id: 10366019301
name: "FR"
type_: MAXIMIZE_CONVERSION_VALUE
non_removed_campaign_count: 47670
maximize_conversion_value {
target_roas: 1.44
}
}
customer {
resource_name: "customers/6350619301"
id: 6350619301
}
}
results {
bidding_strategy {
resource_name: "customers/6350619301/biddingStrategies/10366019208"
id: 10366019208
name: "FR_ttd"
type_: MAXIMIZE_CONVERSION_VALUE
non_removed_campaign_count: 24619
maximize_conversion_value {
target_roas: 1.2
}
}
customer {
resource_name: "customers/6350619301"
id: 6350619301
}
}
results {
bidding_strategy {
resource_name: "customers/6350619301/biddingStrategies/10366019310"
id: 10366019310
name: "IT"
type_: MAXIMIZE_CONVERSION_VALUE
non_removed_campaign_count: 47654
maximize_conversion_value {
target_roas: 1.39
}
}
customer {
resource_name: "customers/6350619301"
id: 6350619301
}
}
results {
bidding_strategy {
resource_name: "customers/6350619301/biddingStrategies/10367441155"
id: 10367441155
name: "IT_ttd"
type_: MAXIMIZE_CONVERSION_VALUE
non_removed_campaign_count: 21742
maximize_conversion_value {
target_roas: 1.17
}
}
customer {
resource_n... [TRUNCATED HERE]
[2023-03-20 14:48:16,506 - INFO] Request made: ClientCustomerId: 6350619301,
Host: googleads.googleapis.com, Method:
/google.ads.googleads.v13.services.GoogleAdsService/Search, RequestId:
ZE9rB3_i_HljwlbApFNJrQ, IsFault: False, FaultMessage: None
