Internal Error - Unable to filter by date for bidding_seasonality_adjustment report

[Rohit (Jay) Lalwani]

Hello,

We are attempting to fetch the bidding_seasonality_adjustment report for a specific date using the following query:

SELECT bidding_seasonality_adjustment.seasonality_adjustment_id, bidding_seasonality_adjustment.advertising_channel_types, bidding_seasonality_adjustment.scope, bidding_seasonality_adjustment.start_date_time, bidding_seasonality_adjustment.end_date_time, bidding_seasonality_adjustment.status, customer.id FROM bidding_seasonality_adjustment WHERE bidding_seasonality_adjustment.start_date_time REGEXP_MATCH '^2023-08-28$'

However, when executing this query, we encounter the following error:

---------------------------------------------

Google.Ads.GoogleAds.V21.Errors.GoogleAdsException

---------------------------------------------

{ "StatusCode": 13, "Details": "Internal error encountered.", "RequestId": "K94cXWp1UF0VX0aYturd0A", "Failure": { "requestId": "K94cXWp1UF0VX0aYturd0A" } }

---------------------------------------------

We have already:

• Validated the query in Google Ads Query Builder.

• Attempted using the LIKE operator instead of REGEXP_MATCH, but the same internal error occurs.

Could you please help us resolve this issue or suggest an alternative approach to fetch bidding_seasonality_adjustment data for specific dates?

Thank you for your support.