Google Ads API V2, video_ad field missing for the ad_group_ad.

[Bruce]

Hi All,

I have some problems when using Google Ads API v2 GAQL to list the ad_group_ad under my account.

According to the document here https://developers.google.com/google-ads/api/reference/rpc/google.ads.googleads.v2.resources#google.ads.googleads.v2.resources.Ad:

Union field ad_data. Details pertinent to the ad type. Exactly one value must be set. ad_data can be only one of the following

If the ad is VIDEO_AD, I should get the video_ad field correctly. But most of the video ads do not have that field. 

Here is the query I used:

SELECT ad_group.id,

          ad_group_ad.ad.id,

          ad_group_ad.ad.video_ad.media_file,

          ad_group_ad.ad.video_ad.in_stream.action_button_label,

          ad_group_ad.ad.video_ad.in_stream.action_headline,

          ad_group_ad.ad.video_ad.in_stream.companion_banner,

          ad_group_ad.ad.video_ad.out_stream.headline,

          ad_group_ad.ad.video_ad.out_stream.description,

          ad_group_ad.status

  FROM ad_group_ad

  WHERE ad_group_ad.ad.type = VIDEO_AD

Here is the logs and result

I, [2019-07-03T11:14:12.619373 #11408]  INFO -- : CID: xxxxxxx, Host: googleads.googleapis.com:443, Method: /google.ads.googleads.v2.services.GoogleAdsService/Search, IsFault: no
D, [2019-07-03T11:14:12.623379 #11408] DEBUG -- : Outgoing request: Headers: {"x-goog-api-client":"gl-ruby/2.6.1 gapic/3.0.0 gax/1.7.0 grpc/1.21.0","developer-token":"xxxx","login-customer-id":"xxxx","x-goog-request-params":"customer_id=xxxx"} Payload: {"customerId":"xxxxx","query":"SELECT ad_group.id,\n        ad_group_ad.ad.id,\n        ad_group_ad.ad.video_ad.media_file,\n        ad_group_ad.ad.video_ad.in_stream.action_button_label,\n        ad_group_ad.ad.video_ad.in_stream.action_headline,\n        ad_group_ad.ad.video_ad.in_stream.companion_banner,\n        ad_group_ad.ad.video_ad.out_stream.headline,\n        ad_group_ad.ad.video_ad.out_stream.description,\n        ad_group_ad.status\nFROM ad_group_ad\nWHERE ad_group_ad.ad.type = VIDEO_AD\n","pageSize":1000}
D, [2019-07-03T11:14:12.625441 #11408] DEBUG -- : Incoming response: Payload: {"results":[{"adGroup":{"resourceName":"customers/6669065449/adGroups/39752825421","id":39752825421},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/39752825421~198103938377","status":"ENABLED","ad":{"id":198103938377,"resourceName":"customers/6669065449/ads/198103938377"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/46439785112","id":46439785112},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/46439785112~219351848580","status":"ENABLED","ad":{"id":219351848580,"resourceName":"customers/6669065449/ads/219351848580"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/49467406027","id":49467406027},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/49467406027~222596086249","status":"ENABLED","ad":{"id":222596086249,"resourceName":"customers/6669065449/ads/222596086249"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/52280806732","id":52280806732},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/52280806732~222596335594","status":"ENABLED","ad":{"id":222596335594,"resourceName":"customers/6669065449/ads/222596335594"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/53361521916","id":53361521916},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/53361521916~258510828464","status":"ENABLED","ad":{"id":258510828464,"resourceName":"customers/6669065449/ads/258510828464"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/56103741754","id":56103741754},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/56103741754~258514955515","status":"ENABLED","ad":{"id":258514955515,"resourceName":"customers/6669065449/ads/258514955515"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/63111279812","id":63111279812},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/63111279812~285159031176","status":"REMOVED","ad":{"id":285159031176,"resourceName":"customers/6669065449/ads/285159031176"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/63111279812","id":63111279812},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/63111279812~285165537099","status":"ENABLED","ad":{"id":285165537099,"resourceName":"customers/6669065449/ads/285165537099"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/63111279812","id":63111279812},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/63111279812~359396103989","status":"REMOVED","ad":{"id":359396103989,"videoAd":{"mediaFile":"customers/6669065449/mediaFiles/12000130234"},"resourceName":"customers/6669065449/ads/359396103989"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/64507409010","id":64507409010},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/64507409010~343376069421","status":"ENABLED","ad":{"id":343376069421,"resourceName":"customers/6669065449/ads/343376069421"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/67676256657","id":67676256657},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/67676256657~346017464546","status":"REMOVED","ad":{"id":346017464546,"resourceName":"customers/6669065449/ads/346017464546"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/68439284377","id":68439284377},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/68439284377~348214373666","status":"ENABLED","ad":{"id":348214373666,"resourceName":"customers/6669065449/ads/348214373666"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/69635535573","id":69635535573},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/69635535573~346912076303","status":"ENABLED","ad":{"id":346912076303,"resourceName":"customers/6669065449/ads/346912076303"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/69794133575","id":69794133575},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/69794133575~345992635918","status":"ENABLED","ad":{"id":345992635918,"resourceName":"customers/6669065449/ads/345992635918"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/70402870693","id":70402870693},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/70402870693~350551799656","status":"ENABLED","ad":{"id":350551799656,"resourceName":"customers/6669065449/ads/350551799656"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/70682506716","id":70682506716},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/70682506716~350377617249","status":"ENABLED","ad":{"id":350377617249,"resourceName":"customers/6669065449/ads/350377617249"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/70932252159","id":70932252159},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/70932252159~355154334915","status":"ENABLED","ad":{"id":355154334915,"videoAd":{"mediaFile":"customers/6669065449/mediaFiles/15286323290"},"resourceName":"customers/6669065449/ads/355154334915"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/71165614993","id":71165614993},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/71165614993~346011589409","status":"REMOVED","ad":{"id":346011589409,"resourceName":"customers/6669065449/ads/346011589409"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/71378093962","id":71378093962},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/71378093962~346012503482","status":"ENABLED","ad":{"id":346012503482,"resourceName":"customers/6669065449/ads/346012503482"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/71428850346","id":71428850346},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/71428850346~355225464863","status":"REMOVED","ad":{"id":355225464863,"videoAd":{"mediaFile":"customers/6669065449/mediaFiles/15286323290"},"resourceName":"customers/6669065449/ads/355225464863"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/71428850346","id":71428850346},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/71428850346~355443964683","status":"ENABLED","ad":{"id":355443964683,"videoAd":{"mediaFile":"customers/6669065449/mediaFiles/15286323290"},"resourceName":"customers/6669065449/ads/355443964683"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/72634143791","id":72634143791},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/72634143791~346913022434","status":"ENABLED","ad":{"id":346913022434,"resourceName":"customers/6669065449/ads/346913022434"}}},{"adGroup":{"resourceName":"customers/6669065449/adGroups/76509862544","id":76509862544},"adGroupAd":{"resourceName":"customers/6669065449/adGroupAds/76509862544~346067437175","status":"ENABLED","ad":{"id":346067437175,"resourceName":"customers/6669065449/ads/346067437175"}}}],"totalResultsCount":23,"fieldMask":"adGroup.id,adGroupAd.ad.id,adGroupAd.ad.videoAd.mediaFile,adGroupAd.ad.videoAd.inStream.actionButtonLabel,adGroupAd.ad.videoAd.inStream.actionHeadline,adGroupAd.ad.videoAd.inStream.companionBanner,adGroupAd.ad.videoAd.outStream.headline,adGroupAd.ad.videoAd.outStream.description,adGroupAd.status"}
video ad with ID 198103938377, status ENABLED, and media file '
video ad with ID 219351848580, status ENABLED, and media file '
video ad with ID 222596086249, status ENABLED, and media file '
video ad with ID 222596335594, status ENABLED, and media file '
video ad with ID 258510828464, status ENABLED, and media file '
video ad with ID 258514955515, status ENABLED, and media file '
video ad with ID 285159031176, status REMOVED, and media file '
video ad with ID 285165537099, status ENABLED, and media file '
video ad with ID 359396103989, status REMOVED, and media file 'customers/6669065449/mediaFiles/12000130234
video ad with ID 343376069421, status ENABLED, and media file '
video ad with ID 346017464546, status REMOVED, and media file '
video ad with ID 348214373666, status ENABLED, and media file '
video ad with ID 346912076303, status ENABLED, and media file '
video ad with ID 345992635918, status ENABLED, and media file '
video ad with ID 350551799656, status ENABLED, and media file '
video ad with ID 350377617249, status ENABLED, and media file '
video ad with ID 355154334915, status ENABLED, and media file 'customers/6669065449/mediaFiles/15286323290
video ad with ID 346011589409, status REMOVED, and media file '
video ad with ID 346012503482, status ENABLED, and media file '
video ad with ID 355225464863, status REMOVED, and media file 'customers/6669065449/mediaFiles/15286323290
video ad with ID 355443964683, status ENABLED, and media file 'customers/6669065449/mediaFiles/15286323290
video ad with ID 346913022434, status ENABLED, and media file '
video ad with ID 346067437175, status ENABLED, and media file '

[Charlie]

I have the same question. No video ad info have been pulled out from the query though the ad type is VIDEO_AD

[Google Ads API Forum Advisor Prod]

Hello Bruce and Charlie, 

Thank you for sharing the additional details. I have shared the details with the team for further investigation. I will keep you posted on the updates.

Regards,
Bharani, Google Ads API Team

ref:_00D1U1174p._5001UCalsY:ref