Reporting by Video resource is broken

[Sergei Aleinik]

Hello! Reporting by Video resource stopped working around 16, Aug 11:00 UTC.

Google Ads Scripts example

function main() {
  const report = AdsApp.report('SELECT video.id FROM video');
  console.log(report.rows().totalNumEntities());
}

Results with: Could not read from Google Ads

Google Ads API example (PHP)

        /** @var \Google\Ads\GoogleAds\Lib\V17\GoogleAdsServerStreamDecorator $stream */
        $stream = $client->getGoogleAdsServiceClient()->searchStream(
            new SearchGoogleAdsStreamRequest(
                [
                    'query'       => 'SELECT video.id FROM video',
                    'customer_id' => '3816796305'
                ]
            )
        );

        /** @var \Google\Ads\GoogleAds\V17\Services\GoogleAdsRow $row */
        foreach ($stream->iterateAllElements() as $row) {
            $output->writeln($row->serializeToJsonString());
        }

Results with generic error: Internal error encountered.

However, the same examples with "SELECT campaign.id FROM campaign" work fine. So the problem is related to `Video` resource.

Please check ASAP.

[Oksana Sulyma]

We experience the same issue: 'Internal error' with code = 13 on the stage of getting data from video resource. 

The error is permanent, retries don't help and it affects multiple customers of us.

Any info on this issue will be appreciated.

Thanks,

Oksana

[Sergei Aleinik]

Hi Oksana!

As a hotfix we switched from reporting by Video resource to AdGroupAd resource. It doesn't contain YouTube related information however suitable for overall reporting if you can afford statistics grouping on your side. Also, you can fetch some YouTube specific information by Asset. References:

AdGroupAd resource: ad_group_ad.ad.video_ad.video.asset

Asset resource: asset.youtube_video_asset.youtube_video_id, asset.youtube_video_asset.youtube_video_title

It seems like there is a global issue on Ads, even on the UI side.

пятница, 16 августа 2024 г. в 19:03:56 UTC+4, Oksana Sulyma:

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Based on the provided information, I understand that you are getting a "Results with generic error: Internal error encountered" error. I have executed the query that you have provided, and we are unable to reproduce any error at our end. We are getting a successful run on the same request and results are returned. I would recommend you retry the request again and let us know how it goes at your end.

Also, in order to assist you further, please share the uncropped UI screenshot by highlighting the fields that you want to retrieve via the Google Ads API. 

You can send the details via Reply privately to the author option, or direct private reply to this email.

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vF0kO:ref" (ADR-00263673)

Thanks,
 

Google Ads API Team

​​​​​​​