Seeking confirmation that Video Titles are not in the YouTube Data Transfer to BigQuery

[jf-ii]

Hi,

I've been through the tables from the YouTube Channel Data Transfer and can't find the video titles anywhere. It looks like this is only available for export via the YouTube Data API, which doesn't have a Data Transfer Service option.

I also found a (6 year old) stack overflow post that says you do indeed need to pull the titles separately. https://stackoverflow.com/questions/53162370/get-video-title-in-bigquery

1) So is this really the case, the video titles are nowhere in the export?

2) Is there a way I can set up the calls to the Data API from within Google Cloud Platform to import the data into BigQuery? I'm far from an expert on GCP outside of BQ, but it looks like setting up and scheduling  a Cloud Run job might work?

[marckevin · Accepted solution]

Hi @jf-ii,

Welcome to Google Cloud Community!

Yes you’re correct, YouTube Channel Data transfers to BigQuery does not include video titles by default. Supported channel reports mainly contain metrics and dimensions like channel_id, views, comments, likes, etc.

You need a separate call from the YouTube Data API, which is already outside BigQuery to get the video title. You can use a scheduled process to set up fetching of video titles via Cloud Run and store it on BigQuery but this needs further support on the YouTube Data API product. To further explore YouTube Data API, you can check this documentation on how to get support as they can provide insights and expertise on this product.

I hope the above information is helpful.