I have the same question. No video ad info have been pulled out from the query though the ad type is VIDEO_AD
On Wednesday, July 3, 2019 at 3:27:27 AM UTC-4, Bruce wrote: > > 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 ' > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/a66c8296-5845-48bd-8768-0738fb6e667a%40googlegroups.com.
