video ads keywords

[frank mcmanus]

We are getting video ad metrics but how can we get the associated keyword metrics with that ad?

[frank mcmanus]

Another way to ask is how can we get video ad metrics from the keyword_view resource? 

We are currently getting ad level performance metrics from the keyword_view resource but video ads are not showing up.

[Google Ads API Forum Advisor Prod]

Hi Frank,

Unfortunately, it is not possible to get these metrics from the keyword view. You can use the Interactive Google Ads Query Builder to test out valid queries.

Regards,
Anthony
Google Ads API Team

ref:_00D1U1174p._5004Q21mq2a:ref

[frank mcmanus]

Thank you. We were able to render a list of video campaigns using this query:

    query = '''

            SELECT

               campaign.id,

               campaign.advertising_channel_type

            FROM campaign

            WHERE campaign.advertising_channel_type = 'VIDEO'

            ORDER BY campaign.id

            '''
So we have a list of video campaigns under one customer_id:

[campaign {

  resource_name: "customers/1234567890/campaigns/987654321"

  id {

    value: 987654321

  }

  advertising_channel_type: VIDEO

}

, campaign {

  resource_name: "customers/1234567890/campaigns/135790864"

  id {

    value: 135790864

  }

  advertising_channel_type: VIDEO

}

, campaign {

  resource_name: "customers/1234567890/campaigns/246809753"

  id {

    value: 246809753

  }

  advertising_channel_type: VIDEO

}

]

So there is no way to use the campaign id for a query like this:

        query = '''

            SELECT

                ad_group_criterion.keyword.text,

                ad_group_criterion.keyword.match_type,

                campaign.name,

                campaign.id,

                metrics.impressions,

                campaign.advertising_channel_type

            FROM keyword_view

            WHERE campaign.id = 246809753

            ORDER BY campaign.id

            '''

We are getting keyword data for all ads that are NOT video ads.

Hoping to get keyword metrics for video ads and campaigns.

Would the query above work in any way? From a different resource possibly or at a different level, ad, ad_group, campaign?

Thank you for your help.

[frank mcmanus]

Also, our query was valid in the query builder tool and does not return any errors back from the api but just no data is coming back

[frank mcmanus]

[Google Ads API Forum Advisor Prod]

Hi Frank,

The query you used looks to be ok. However, when I looked up the campaign 745578195, I saw that it didn't contain any keywords so that is why your report is empty.

[frank mcmanus]

Well that would make sense then. Thank you!