Skip to content

Getting Started with YouTube

Jakob Jünger edited this page Aug 17, 2021 · 15 revisions
  1. Create a database: Click New Database in the Menu Bar to create a blank database.

  2. Login to YouTube: In the YouTube tab of the Query Setup click on Login to Google and login to get a valid Access Token. Notice: the Access Token is like a password to Google. Since it may be printed in the Status Log and saved in the application settings don't give anyone untrusted access to your computer or to the Status Log. In case the error 404 occurs or the login fails, add a Youtube channel to your Google account and try again.

  3. Add nodes: Add a YouTube username by clicking Add Nodes in the Menu Bar. You find the user name in the last part of the URL, e.g. enter "UniGreifswald" for the user "https://www.youtube.com/user/UniGreifswald" or enter "Oscars" for the user "https://www.youtube.com/user/Oscars".

  4. Setup query: Type https://www.googleapis.com/youtube/v3 into the Base path field of the Query Setup. Type channels into the Resource field. Delete any Parameters. Then add two parameters: 1. the term forUsername goes into the left side, the term <Object ID> goes into the right side. 2. the term part goes into the left side, the term snippet,statistics,contentDetails goes into the right side. See https://developers.google.com/youtube/v3/docs/channels for other possibilities if you like.

  5. Fetch data: select one or more nodes in the Nodes View and click Fetch data. Look at the status log (make sure Log all requests was enabled) to see how the URL is assembled from your settings.

  6. Inspect data: Expand your node or click Expand nodes in the Menu Bar to open all nodes. Select one of the new child nodes. The raw data is shown in the Data View to the right.

  7. Setup columns: Click Clear Column Setup below the "Custom Table Columns" area. Change the Column Setup according to your needs by adding keys found in the raw data into the "Custom Table Columns" area. You can use Add Column after you clicked on the specific key or just use Add All Columns. Don't forget to click Apply Column Setup in the Column Setup to add them in the Nodes View. If the columns don't show up make sure to scroll right or to resize the columns (click between the headers).

  8. Export data: Click Export Data to get a CSV file. Notice the options in the export mode field of the export dialog. You can open CSV files with Excel oder any statistics software you like.

What is next?

Clone this wiki locally