Severe performance degradation when listing bidding strategies

[Paul]

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

[Google Ads API and AdWords API Forum]

Re-posting the last inquiry (https://groups.google.com/g/adwords-api/c/xXFRLQUeGbM) from the forum as it wasn't routed to our support queue.

Regards,

Google Ads API Team

[Google Ads API and AdWords API Forum]

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 and response logs with request ID and request header 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:

[Paul]

Hello,

I sent the logs in a private message, please let me know if it didn't come through.

Thanks,

Paul

[Paul]

Hello,

is there any update on this? The problem still persists.

Thanks,

Paul

[Google Ads API Forum Advisor]

This is issue is still being investigated. We are unable to produce the same degree of slowdown so we are working with the team that specializes in bidding strategies.

ref:_00D1U1174p._5004Q2k0twb:ref

[Google Ads API Forum Advisor]

Using
 

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 

as the base query, I'd expect either bidding_strategy.non_removed_campaign_count or the ORDER BY to be the slowdown.
Can you replay this query 3 times:

1. without:  non_removed_campaign_count
2. without: ORDER BY
3. without: both 1 and 2 above.

and provide the timings?

ref:_00D1U1174p._5004Q2k0twb:ref