The Most Powerful Productivity App I Use - Notion

Thomas Frank
30 Sept 201926:20

Summary

TLDRThis video script offers an in-depth exploration of Notion, a versatile all-in-one workspace app. The creator shares personal insights on using Notion for project management, particularly for tracking YouTube video projects. Highlighting advanced features like databases, templates, relations, and roll-ups, the script demonstrates how these can streamline workflows. The video also showcases a custom project tracker template, illustrating Notion's potential to improve productivity and organization in content creation.

Takeaways

  • πŸ“ Notion is a highly versatile all-in-one workspace that can be used for note-taking, creating databases, checklists, and more.
  • πŸ”— Notion's linking feature allows documents to connect with each other, enhancing the organization and accessibility of information.
  • πŸ“ˆ The video project tracker is a template and database that the speaker has developed to streamline the video production process.
  • πŸ“Š Notion's database feature is akin to Excel spreadsheets but offers more flexibility with multiple viewing options like Kanban and calendar views.
  • πŸ“‘ The templating feature in Notion is a powerful tool that, when combined with databases, allows for the creation of unique and efficient workflows.
  • πŸ”„ Relations and roll-ups are advanced Notion features that enable databases to be interconnected, providing a comprehensive view of related data.
  • 🎬 The speaker uses Notion to manage video projects from ideation to publishing, including tracking B-roll, sponsors, and editing tasks.
  • πŸ“ Notion can be used to create and manage detailed checklists for various stages of a project, ensuring nothing is overlooked.
  • πŸ“ The use of filters and sorts in Notion databases allows for dynamic and customized views, tailored to specific needs or queries.
  • πŸ“š The script describes a detailed example of how Notion can be used to organize and execute a video project, from concept to post-production.
  • πŸ’‘ The video also touches on the importance of continuously seeking better ways to do things and the value of learning and adapting new tools and ideas.

Q & A

  • What is the main purpose of Notion according to the video?

    -Notion is described as an all-in-one workspace that defies traditional categorization due to its flexibility and ability to be used for various tasks such as note-taking, creating databases, checklists, and more.

  • How does the video creator use Notion for their YouTube video projects?

    -The creator uses Notion as a project tracker and planner for their YouTube videos, which includes a template and database to keep track of all aspects of video production in one place.

  • What are the three advanced features of Notion discussed in the video?

    -The three advanced features discussed are the database feature with multiple views like Kanban and calendar, the templating feature, and the relations and roll-ups features that allow databases to be connected to each other.

  • How does the database feature in Notion differ from a traditional spreadsheet?

    -In Notion, each row in a database is its own page where you can include various elements like text, other databases, and more. This makes it more flexible than a traditional spreadsheet which is limited to tabular data.

  • What is the benefit of using templates in Notion as highlighted in the video?

    -Templates in Notion allow the creator to standardize the structure of pages, making it efficient to create new pages for different video projects with pre-defined sections and checklists, ensuring consistency and completeness.

  • How does the video creator organize the status of their video projects in Notion?

    -The creator organizes the status of their video projects using different views in Notion, such as an Excel spreadsheet view, a Kanban view for tracking project stages, and a calendar view for editorial planning.

  • What is the role of the 'Relations' feature in Notion as explained in the video?

    -The 'Relations' feature allows the creator to link two databases together, enabling them to associate specific information, such as sponsor details, with individual video projects within the database.

  • How does the 'Roll-ups' feature help in tracking the number of spots done for each sponsor?

    -The 'Roll-ups' feature uses existing relations to perform calculations, such as counting how many times a sponsor is mentioned across different projects, to provide a summary count of video spots done for each sponsor.

  • What is the significance of being able to filter and sort databases in Notion on-the-fly?

    -The ability to filter and sort databases dynamically allows the creator to quickly find and view information relevant to specific needs, such as all videos sponsored by a particular company or those in a certain stage of production.

  • How does the video creator use the B-roll list within Notion to improve video production efficiency?

    -The B-roll list is a nested database within a database that allows the creator to organize, categorize, and track the status of B-roll footage needed for videos, which helps in planning and executing the gathering of B-roll more efficiently.

  • What is the advantage of using Notion over other apps for the video creator's workflow?

    -Notion offers a more integrated and flexible system that combines various features like databases, templates, relations, and roll-ups, which allows the creator to manage all aspects of video production in one place, improving efficiency and organization compared to using multiple separate apps.

Outlines

00:00

πŸ“ Introduction to Notion's Versatility

The speaker introduces Notion as a highly requested app due to its extensive capabilities, describing it as an all-in-one workspace that defies traditional categorization. Notion's flexibility allows users to employ it for various tasks such as note-taking with a markdown system, creating databases, checklists, habit trackers, calendars, and to-do lists. The speaker expresses the challenge of covering Notion's features in a single video, opting to showcase their personal use of Notion, specifically their YouTube video project tracker, a template and database that has streamlined their production process, replacing the previously inefficient use of multiple apps.

05:01

πŸ“š Demonstrating Notion's Advanced Features

The speaker discusses the decision to focus on their YouTube video project tracker within Notion, highlighting three advanced features: databases, templates, and the connectivity between databases through relations and roll-ups. They describe the project tracker as a template and database built over a year, which has become indispensable in their production process. The databases in Notion are likened to Excel spreadsheets but with more flexibility, offering different views like Kanban and calendar views. The speaker also emphasizes the templating feature as their favorite, allowing for unique capabilities when combined with databases.

10:04

πŸ” In-Depth Look at the Video Project Tracker

The video script provides an in-depth look at the video project tracker, starting with its appearance similar to an Excel spreadsheet but with the functionality of a database where each row is a separate page. The speaker explains how they use templates to create new video projects with predefined information, and how the status of videos can be tracked using different views. They also detail the customization options available for each view, including filters, sorts, and the ability to show or hide properties, as well as the creation of new fields for additional information.

15:07

πŸŽ₯ Utilizing Templates and Nested Databases for Video Production

The speaker elaborates on the use of templates within Notion, showcasing how they create a comprehensive project template for their videos, which includes a second nested database. They discuss the process of adding new videos to the project tracker using templates, and how they manage the status, editor assignments, and other fields specific to each video project. The script also covers the organization of B-roll ideas and how Notion's system allows for efficient video production by batching similar tasks together.

20:07

πŸ“ Streamlining Video Editing with Notion's Organizational Power

The speaker continues to describe how they use Notion to streamline the video editing process, including the use of a B-roll list that is a database within a database, allowing for efficient gathering and checking of B-roll items. They explain the use of tags and gatherers to categorize and assign tasks, and how different views can be used to filter and sort tasks based on their status, such as items that need to be fixed or those that require editing in Premiere Pro or After Effects.

25:09

πŸ”— Leveraging Relations and Roll-ups for Sponsor Management

The speaker introduces the concepts of relations and roll-ups in Notion, demonstrating how they created a sponsor list database and related it to the video project tracker. This allows for detailed sponsor information to be linked to specific video projects, streamlining the management of sponsor details and talking points. They also show how roll-ups can be used to count the number of video spots done for each sponsor, providing a simple way to track collaboration metrics.

🌟 Embracing Curiosity and Continuous Learning

In the final part of the script, the speaker reflects on their philosophy of always seeking better ways to do things and the importance of continuous learning. They share their experience with Notion as an example of how curiosity and exploration can lead to significant improvements in workflow and productivity. The speaker also promotes CuriosityStream and Nebula as platforms for educational content, highlighting the benefits of ad-free streaming and exclusive series, and encourages viewers to support these platforms.

πŸ“Ί Conclusion and Call to Action

The speaker concludes the video by thanking CuriosityStream for sponsoring the episode and supporting the creation of educational content. They invite viewers to try CuriosityStream and Nebula, and to support the channel by liking the video, subscribing for new content, or downloading a free book on improving grades. The speaker also playfully encourages viewers to interact with the video and look forward to future content.

Mindmap

Keywords

πŸ’‘Notion

Notion is an all-in-one workspace tool designed for note-taking, project management, and database creation. It is highly flexible and defies traditional categorization. In the video, the creator uses Notion as a central hub for their video production process, highlighting its capabilities for organization and efficiency.

πŸ’‘Database

In the context of Notion, a database is a powerful tool that allows users to create and manage structured data, resembling an Excel spreadsheet but with more flexibility. The video demonstrates how databases can be manipulated in various views such as Kanban and calendar view, and used to track video projects.

πŸ’‘Template

Templates in Notion are pre-designed pages that can be used repeatedly to create new pages with the same structure and content. The script mentions the use of templates to streamline the creation of new video projects, ensuring consistency and efficiency in the workflow.

πŸ’‘Kanban view

Kanban view is one of the ways to visualize a Notion database, often used for project management. It allows users to see tasks or projects as cards that can be moved between different stages of completion. In the video, the creator uses the Kanban view to track the status of their video projects.

πŸ’‘Relation

Relations in Notion are used to link entries between two databases, creating a dynamic connection that can be used to reference or aggregate information. The script describes how relations are used to connect video projects with their respective sponsors, centralizing sponsor details for easy access.

πŸ’‘Roll-up

Roll-ups in Notion are a feature that allows users to aggregate data from related entries in another database. The video script uses roll-ups to count the number of video spots done for each sponsor, providing a quick overview of completed projects.

πŸ’‘Hybrid markdown system

Notion's hybrid markdown system refers to its ability to support markdown formatting within the tool, allowing for rich text editing alongside other content. The video mentions this feature as part of Notion's flexibility for note-taking and document creation.

πŸ’‘Checklists

Checklists in Notion are a way to create lists of tasks or items to be completed. The script describes how checklists are used within the video project template to ensure all steps in the video production and publishing process are accounted for.

πŸ’‘Status

Status in the context of the video refers to the progress or current stage of a video project as tracked within the Notion database. The creator uses status to filter and sort their projects, providing visibility into what needs to be done or has been completed.

πŸ’‘CSV merge

Merging with a CSV file in Notion allows users to import data from a comma-separated values file into a Notion database. The script describes using this feature to import B-roll ideas from Frame.io into Notion, streamlining the video production process.

πŸ’‘B-roll

B-roll refers to supplementary footage used in video production, often to provide context or to illustrate points made in the main footage (A-roll). The video script discusses how Notion is used to organize and track B-roll gathering and integration into video projects.

Highlights

Notion is an all-in-one workspace that defies traditional categorization due to its flexibility and wide range of uses.

Notion can be used as a note-taker with a hybrid markdown system and supports linking within documents to other documents.

Users can create databases, checklists, habit trackers, calendars, and to-do lists within Notion.

The presenter's YouTube video project tracker is a template and database built in Notion to streamline video production.

The project tracker consolidates previously disparate apps into a single, efficient tool for video production management.

Notion's database feature is likened to an Excel Spreadsheet but with more flexibility and different viewing options like Kanban and calendar views.

The templating feature in Notion, combined with databases, allows for unique functionalities not found in other apps.

Relations and roll-ups are advanced Notion features that connect databases and summarize data, respectively.

Every row in a Notion database is its own page, allowing for extensive customization and inclusion of other databases.

Templates in Notion can be created and applied to new rows in a database, pre-populating them with necessary information.

Notion's views can be customized with filters, sorts, and groupings, allowing for tailored perspectives on data.

The presenter uses Notion for tracking video project status, including sponsors, publishing dates, and editing assignments.

Notion can be used to organize video B-roll gathering and editing processes, increasing efficiency in video production.

The B-roll list within Notion demonstrates a nested database, showing how complex data structures can be managed.

CSV files can be merged with Notion databases to import and organize data efficiently.

Notion's system has been a significant productivity boost for the presenter's video-making process.

CuriosityStream is highlighted as a sponsor that also uses Notion, integrating their up-to-date talking points within the platform.

The video concludes with a call to action for viewers to try CuriosityStream, supporting the channel and educational content creation.

Transcripts

play00:01

- So, by far, the app that I get the most requests

play00:04

from you guys to cover is Notion.

play00:06

And I would say that that's for a pretty good reason

play00:08

since Notion can do a heck of a lot.

play00:11

So they built Notion as an all-in-one workspace

play00:14

and I would say that that is a pretty accurate description

play00:16

since Notion really defies traditional categorization.

play00:19

That's because you can do so much with this tool.

play00:22

It's incredibly flexible.

play00:24

You can use it as a note-taker,

play00:25

it has this beautiful hybrid markdown system,

play00:27

you can also link within documents to other documents,

play00:31

you can create databases, you can create checklists,

play00:33

people built habit trackers and calendars and to-do lists,

play00:37

all kinds of stuff in Notion.

play00:38

And because of that, I found it challenging

play00:41

to really hone in on what I wanted to cover

play00:44

for my first Notion video

play00:45

because we could have gone into the nitty gritty

play00:47

and I could have showed you how to start creating pages,

play00:50

but a lot of other people have done videos

play00:52

that sort of do that,

play00:53

and I will link to a couple in the description down below

play00:55

if you're curious.

play00:56

So what I wanna do in this video instead

play00:58

is show you how I use Notion.

play01:00

And in particular, I'm gonna show you

play01:02

my YouTube video project tracker.

play01:04

This is a template and database

play01:06

that I've been building over the past year

play01:08

which has become really an indispensable tool

play01:11

in my production process.

play01:12

Before I built this, we were using a hodgepodge

play01:14

of different apps to make sure

play01:15

that everything that needed to be done for a video

play01:17

was actually done, and it was pretty inefficient.

play01:21

But now that we have this project planner and tracker,

play01:24

we are able to do everything in one place

play01:26

and everyone has access to the information that they need,

play01:29

and there are also a lot of efficiency gains

play01:31

because of the different features that Notion offers us.

play01:34

So I'm gonna guide you through

play01:36

how I've built this and how it works,

play01:37

and in the process, you're gonna learn

play01:39

about three of the more advanced

play01:41

and I think more useful features of Notion

play01:44

which are the database feature.

play01:46

And in Notion, databases,

play01:47

by default look like Excel Spreadsheets

play01:50

but they're much more flexible,

play01:51

you can actually look at them in different views

play01:53

such as Kanban view and calendar view.

play01:56

We're also gonna talk about the templating feature

play01:57

which is my favorite feature in Notion,

play02:00

and combined with the database feature,

play02:02

allows Notion to do things that no other app can do,

play02:05

at least that I have come across,

play02:06

and finally, we're gonna talk about a couple of features

play02:09

that allow databases to be connected to each other

play02:11

which are called relations and roll-ups.

play02:14

So let's get into the project tracker

play02:15

and I'll show you how it works.

play02:17

Okay, so here we are looking at my video project tracker.

play02:20

And at first glance,

play02:21

this looks kind of like an Excel spreadsheet.

play02:24

We have columns with different types

play02:25

of information in there,

play02:26

but the cool thing about Notion

play02:28

is that a database here really is a database.

play02:31

It isn't just a spreadsheet of information,

play02:33

though you can do some spreadsheet-y things,

play02:35

but every single row here is actually its own page

play02:41

and within these pages,

play02:42

you can put whatever you want including other databases.

play02:46

So this can get really, really powerful.

play02:48

I'm gonna show you how these pages within databases

play02:52

and how the templates you can create

play02:53

can be really, really powerful in combination.

play02:56

So first, I'll just give you an overview

play02:58

of how this works itself.

play02:59

We have the title of the video.

play03:01

So whenever I come about the video and I'm like,

play03:03

yes, we are going to do this video, it is on the schedule,

play03:06

I will add it to this database here.

play03:09

Now, I could go down here and just add a new video.

play03:14

So How to Tame Llamas.

play03:18

But if I do that, I'm just going to have a blank page.

play03:21

And if I wanted a blank page,

play03:22

that would be great, but I don't.

play03:24

I want all this really cool information.

play03:26

So instead, what I like to do is go up to here

play03:31

and we can choose templates,

play03:32

and we can actually build templates that we can then add

play03:35

as a new row to our database.

play03:37

So I've already created project template,

play03:39

I'll show you how this looks on the inside

play03:41

a little bit later but let's just go ahead and create it,

play03:44

and we'll go with the same exact video: How to Tame Llamas.

play03:48

And now, we have a bunch of interesting stuff in here

play03:50

that I'm gonna get to in a second.

play03:52

But we also have it here.

play03:54

I've also defined the template

play03:56

to automatically give it a video number of 999,

play03:58

so because of the sort of this view on the database

play04:02

which is going by descending and video number,

play04:04

it's going to be immediately at the top

play04:06

and that's very useful

play04:07

since it's most likely going to be

play04:09

the next video that's coming out

play04:11

or at least something that is coming out in the future

play04:13

unlike everything else here.

play04:15

From there, I can change all my values.

play04:17

So let's just say this is video 177.

play04:20

This isn't actually coming out in the channel.

play04:22

I'm sorry if you wanted to see me tame llamas.

play04:24

I don't have access to a llama farm,

play04:25

so get me access to a llama farm and maybe we can talk.

play04:28

We can also come in here and add other things.

play04:30

So status is very interesting.

play04:32

The great thing about Notion databases

play04:34

is that you're not limited to just this one type of view.

play04:37

You can have this Excel spreadsheet type view,

play04:40

or you can have what's called a Kanban view.

play04:43

This is very much like Trello where you can move cards

play04:46

between different stages of a project

play04:48

and this can help you really track the project's status

play04:52

and see where it is and how close it is to completion.

play04:56

Or let's say you're running an editorial calendar,

play04:58

you wanna see when all of your videos are coming out.

play05:01

You can have a calendar view.

play05:03

And the great thing about these views

play05:04

is that they all operate independently

play05:07

in the properties that you can show and not show,

play05:10

and the filters and sorts that you can define.

play05:12

So here on All Videos,

play05:13

we have a filter where if the status is not started,

play05:17

I'm not showing it,

play05:18

and we have a sort where video number is descending.

play05:20

But if we go over to status view,

play05:22

we can actually do different things,

play05:23

where our filter is things

play05:25

that I have not checked the publish box on

play05:27

and then we also have the status filter,

play05:29

and we can also group by status,

play05:30

we can show and hide certain properties.

play05:32

So let's say I wanna see the sponsor on status view,

play05:35

I can do that and it's going to show up here and here.

play05:38

But on status view, I'm just interested in seeing

play05:40

what projects are on the writing stage,

play05:42

what projects are in the A-roll editing stage.

play05:44

The sponsor is not really relevant to that

play05:47

so I can go ahead and disable it there.

play05:49

Same with calendar,

play05:50

I'm only interested in seeing

play05:51

when are these videos scheduled to come out.

play05:54

But on all videos,

play05:55

we can also go through and define things,

play05:57

so let's just say this video is coming out October 4th,

play06:00

the sponsor, I'm like, I have a llama-related sponsor

play06:03

so we will just go with Fender, that would be cool,

play06:07

and then we can set an editor.

play06:08

So usually, Tony edits my videos.

play06:10

He will be editing this one

play06:11

so I'm setting him as the editor here as well.

play06:15

And then we have some other fields that I have created.

play06:17

Now note, you can create any field you want here.

play06:19

So if I wanted to, I can add an extra field.

play06:21

It could be a text, it could be a number,

play06:23

it could be a select,

play06:24

multi-select person for assigning people,

play06:26

we could actually upload pictures or attach files,

play06:30

add check boxes, all kinds of really cool stuff

play06:32

including these relations and roll-ups

play06:34

that I'll tell you about a little bit later.

play06:36

But for now, I have every single field that I want here.

play06:39

And later on, when the video is actually published,

play06:41

we'll have the time to check the publish box,

play06:44

the monetization box, URL box, all those things.

play06:46

But again, this is just the overview here

play06:48

and this allows us to track the status of projects

play06:50

to go back and refer to projects.

play06:52

And the really nice thing

play06:54

is you can create filters and sorts on-the-fly.

play06:56

So let's just say for a second that I've got

play06:59

a video sponsored by CuriosityStream coming up.

play07:01

In fact, this video is sponsored by CuriosityStream.

play07:04

I'll have that at the end.

play07:05

But I want to see

play07:06

how I edited previous CuriosityStream videos

play07:08

or I need to know which folder on my computer

play07:11

might have some special footage I took for that sponsor.

play07:14

Well, I can go and I can create a filter and I can say,

play07:18

and the sponsor contains CuriosityStream.

play07:26

And boom, I've created a filter

play07:27

that only shows in these videos

play07:29

that are sponsored by CuriosityStream.

play07:31

I could do videos that were published only in 2019,

play07:34

videos that are only completed or only filming,

play07:36

videos that only I edited.

play07:37

This can be really, really useful

play07:39

for going back and referring to things.

play07:41

And when I talked about my file organization video,

play07:44

I mentioned that all of my videos

play07:45

are organized by their numbers.

play07:47

So we have like 164-3, "Bad Productivity Tips".

play07:50

That is somewhere in my computer

play07:52

so if I need to remember,

play07:53

all right, I took some footage of a llama or something

play07:56

and I need to remember which folder it's in,

play08:00

okay, I remember I did it

play08:00

in that "3 Bad Productivity Tips" video,

play08:02

I can refer to Notion here and see,

play08:04

oh, that was video 164.

play08:05

It's very easy for me to go

play08:06

and find that folder on my computer.

play08:08

So let's delete this filter here.

play08:12

And let's talk about the actual template here

play08:14

or what's inside.

play08:15

And we're gonna use

play08:16

the "How to Beat the Afternoon Slump" video

play08:18

which was really recently published

play08:20

because it has basically everything I wanna show you here.

play08:23

So the first thing to note is,

play08:24

number one, you can open these as pages.

play08:26

They don't have to just be modals.

play08:28

I also tend to favorite the projects

play08:31

that I'm currently working on so

play08:32

they show up here in my Favorites bar.

play08:34

This one is done so I'm going to unfavorite it.

play08:36

And the first thing you're gonna see here,

play08:38

because this is a page that exists within a database,

play08:41

you're gonna see all the properties

play08:42

that are in the database in the regular view

play08:45

which is kinda nice because if you want to,

play08:46

you can set different things here, but you don't have to.

play08:50

And then down here,

play08:52

this is an area that is completely up to you.

play08:54

So this is the project template

play08:57

that I have been working on and honing

play08:58

and perfecting over the past year,

play09:00

and we have a lot of different information here.

play09:02

The most prominent thing

play09:04

is probably the second database here

play09:06

but we're gonna get into that in a second

play09:07

'cause it's pretty complicated.

play09:09

We also have a toggle switch which is pretty cool.

play09:11

So I can put title ideas in here,

play09:13

often bold the one that I think is the best.

play09:15

We can put keywords in here,

play09:17

we can put sponsor information if we needed to,

play09:20

and this is something I really like.

play09:22

So I am defining templates here and I'm generating them

play09:25

every single time I'm making a new video.

play09:26

So every single time I have a new video project,

play09:29

I get new checklists.

play09:30

And for publishing, we have all these checklists.

play09:33

So this just reminds me to do all the little things involved

play09:37

with uploading and publishing a video

play09:38

that I might forget to do

play09:40

if I was just trying to do them from memory,

play09:42

so things like adding resource links to the description,

play09:45

setting the video's recording date,

play09:46

adding the caption file when I order it,

play09:49

post-publishing things like sharing it to Instagram

play09:51

or answering some initial comments.

play09:53

I will always check these things off.

play09:56

It's very, very useful.

play09:58

I also have, so a content area here.

play10:00

We have a page where we can dump research and notes.

play10:03

I will mention that I don't use Notion as a note-taker.

play10:06

I tend to write my videos in Evernote.

play10:09

When Martin writes videos for me,

play10:10

he will write them in Google Drive.

play10:11

So we don't usually have research

play10:13

and notes sitting in Notion,

play10:14

but I do like having this in the template

play10:16

just in case I'm in Notion

play10:18

and I just need to throw something in there

play10:19

really, really quickly

play10:20

and I don't want to gunk up the script area.

play10:24

So the script area is very important.

play10:25

Even though I write videos in Evernote

play10:28

and Martin writes them in Google Drive,

play10:30

we want them in Notion because the video project tracker

play10:33

should be the one resource for editors to go to,

play10:37

for writers to go to.

play10:38

Anybody who's working on the video should know

play10:40

if there's something about a video,

play10:41

whether it's the sponsor or whether it's the script,

play10:44

it's going to be here.

play10:45

So whoever wrote the script,

play10:47

we paste it into the Notion project.

play10:49

And then I actually have a music stand with my iPad

play10:52

and I have Notion open so while I'm filming,

play10:54

I will have the script in Notion next to me.

play10:58

I don't tend to use a teleprompter.

play10:59

I might start using that a little bit more in the future

play11:01

but usually, I just will look at the script on my iPad,

play11:04

memorize a line, say it to the camera,

play11:06

and then go on and on and on until I'm done with the video.

play11:09

So that's useful.

play11:10

I've got some links to some useful resources.

play11:12

So I use this CoSchedule Headline Analyzer

play11:14

to help me brainstorm lots of interesting titles.

play11:18

Thumbs Up is a great tool for making sure

play11:20

that thumbnails look good at small sizes.

play11:22

But the real benefit to this project tracker here

play11:25

is this B-roll list.

play11:27

And again, this is an example

play11:28

of a database within a database

play11:30

and that's incredibly helpful.

play11:31

And, of course, just like with the other database,

play11:33

we can open this as a page.

play11:35

So this is the most advanced part of the template

play11:40

and we've been able to do some really cool stuff up here.

play11:42

So you can see, these are just ideas that we create.

play11:45

So let me give you a bit of background

play11:48

on how we make videos.

play11:49

We will shoot the A-roll,

play11:51

which is the talking head portion,

play11:52

this portion that you're seeing right now,

play11:54

beforehand for most videos.

play11:56

I sit in front of the camera, I talk,

play11:58

it might be half an hour of footage

play11:59

because I mess up lines a lot,

play12:01

and then my editor will cut it down

play12:03

into what we call a draft A-roll cut.

play12:05

So it may not be perfect but it's quite close

play12:08

to what is eventually going to end up on YouTube

play12:10

in terms of the length and the talking head parts.

play12:13

From there, we will upload that to a tool called Frame.io

play12:16

which lets you add comments at specific time stamps

play12:20

for your video.

play12:21

Now, a lot of people just use this for feedback,

play12:23

like, hey, fix this, you left a llama in the shot,

play12:26

we can't have that there,

play12:27

but we use it for B-roll ideas.

play12:29

So Tony and I walk and sit down together,

play12:31

watch the video on Frame.io,

play12:32

and put like, all right, let's have a clock

play12:34

with three o'clock on it at the microwave.

play12:36

How about scrolling through a to-do list on our computer?

play12:38

And we'll get this time-stamped list of B-roll ideas.

play12:43

From there, Frame.io actually lets you export these

play12:46

as what's called a comma-separated values file or CSV file,

play12:49

and the cool thing is in Notion,

play12:51

you can go up here and you can merge with a CSV.

play12:54

So you can merge an existing database with a CSV

play12:58

and that's very, very useful.

play12:59

So it does exactly what we do,

play13:00

we will export the CSV file.

play13:02

I'll actually put it into Google Sheets initially

play13:05

so I can delete some of the more superfluous columns

play13:07

that I don't need.

play13:08

I'd just get the comment with the idea and the timestamp,

play13:11

that's all I want, and then I will merge it here

play13:14

where I have some existing columns

play13:15

that are very, very useful.

play13:17

So this is what comes in,

play13:19

the B-roll description and the timestamp.

play13:20

We also have tags, we have templates, we have gathers,

play13:23

and I'll explain these really quick.

play13:24

So the big thing with creating videos

play13:27

is you wanna be as efficient as possible.

play13:29

And when you're making B-roll,

play13:31

there's different types of B-roll, right?

play13:33

There's filmed B-roll,

play13:35

so we might put a camera on a tripod

play13:36

and film something maybe outside or up in the office,

play13:39

we may do something on the overhead setup over there,

play13:42

we might have to go into the computer and record the screen,

play13:45

which I'm literally doing right now on Notion,

play13:48

we might need to go get stock footage

play13:49

from story blocks or a different website,

play13:51

and these are all different kinds of tasks.

play13:53

So when I bring in

play13:54

this chronologically-ordered CSV file into Notion,

play13:57

I'm gonna have things that maybe need to be filmed

play14:00

and then there's gonna be the next thing in the video

play14:02

that maybe needs to be a screen cast.

play14:03

If I gather the B-roll in that order,

play14:06

if I'm gonna go film something and then I get done with that

play14:09

and then I go over to my computer

play14:10

and I record something on the screen

play14:12

and then I run back to my camera and I film that,

play14:14

that's terribly inefficient.

play14:16

Instead, I wanna know, all right,

play14:17

what's every shot in the video that needs to be filmed?

play14:20

Let me do all that first.

play14:22

Then, let me move on to buying stock footage.

play14:24

Then, let me move on to recording the screen.

play14:27

So when this comes in here,

play14:29

and actually, let me just show you how this works

play14:31

'cause I can literally do it,

play14:32

and this will also show you

play14:33

how the templating system works as well

play14:36

'cause this is a completed video.

play14:37

So let's just go back to our YouTube project thing

play14:41

and let's go to our "How to Tame Llamas" video.

play14:43

And in here, we have nothing.

play14:45

It's a blank slate,

play14:46

it's ready for us to add tile ideas, all that good stuff,

play14:48

but the B-roll list is completely empty.

play14:51

So let's open that as a page

play14:54

and then let's merge it with a CSV.

play14:56

And I'm just gonna go ahead and merge it with the CSV

play14:59

from the afternoon slump video

play15:01

since I don't have B-roll ideas for this.

play15:07

So we're merging in, and here we go.

play15:09

So it's good to note that I have created this view

play15:12

with a pre-populated sort criteria

play15:15

which will sort by the timestamp column.

play15:18

Otherwise, it could be in random order.

play15:20

But otherwise, we don't have anything else in here

play15:22

other than our other columns.

play15:24

Now, I do wanna make a quick note here.

play15:26

When you do this CSV merge,

play15:28

you need to have at least one pre-existing row

play15:30

in your database.

play15:32

Otherwise, if you don't have that,

play15:32

it's just an empty database, you bring in the CSV,

play15:36

it is going to bring in its columns

play15:37

and delete all of the other columns you have.

play15:40

So by leaving in, I just have it as example,

play15:42

by leaving this in, it will force the database

play15:44

to keep these other columns

play15:46

even though they don't exist in the CSV file.

play15:49

Once that's done, I can actually delete them

play15:51

and that's totally fine.

play15:52

So here's what I do.

play15:53

I go through all of my ideas, and I say, all right,

play15:55

clock with three o'clock on it, that's film.

play15:58

Various shots of me at the desk feeling tired, that's film.

play16:01

And we would go through here

play16:02

and we would do that for every single B-roll item.

play16:04

So background, videoblocks.com,

play16:06

I know that's stock footage.

play16:07

So cool, stock footage, film these websites on an iPad Pro,

play16:10

that's gonna be an overhead shot on the overhead setup,

play16:13

and for this particular video,

play16:15

if we go back to the actual project,

play16:19

we filmed in many different locations.

play16:21

So even categorizing with just film was not enough

play16:25

because we had some that was gonna be done outside,

play16:27

we had some that needed to be done in the kitchen.

play16:29

So we actually, if we go to gather,

play16:32

'cause like I said,

play16:33

your views can have their own properties,

play16:35

we added a location property.

play16:37

So we had upstairs, office, kitchen, outside, downstairs,

play16:40

and that was really helpful again for batching.

play16:43

So back to our "How to Tame Llamas" example here,

play16:46

I'm tagging things, I can set gatherers.

play16:48

Usually, I only set myself as a gatherer

play16:50

and this is to let my editor Tony know

play16:52

that he cannot gather a specific piece of B-roll,

play16:54

I have to do it myself,

play16:55

and then we also have some check boxes over here.

play16:58

So this is just for status.

play16:59

We can go through and check,

play17:00

this is gathered, this is gathered,

play17:01

this is gathered, we're good to go, it's in the video.

play17:04

So when Tony's editing,

play17:05

he will just go line by line

play17:07

checking things off until it's done.

play17:08

We also have this premiere checkbox.

play17:10

So we actually edit our videos

play17:12

in a combination of Premiere Pro,

play17:14

which is for actually editing video and After Effects

play17:17

which is for doing all the animations and cool quote things

play17:20

that you see coming up in many of our videos,

play17:22

or like when little text box comes up from the bottom,

play17:25

we do that in After Effects.

play17:26

But again, we don't wanna be switching back and forth

play17:28

between different programs.

play17:30

We want to get everything done in one program if possible

play17:32

and then move on to the next stage.

play17:34

So we have a Premiere checkbox.

play17:36

So we can say this needs to be done in Premiere,

play17:38

maybe this doesn't, and that will help later on.

play17:41

Now, again, you can create multiple

play17:43

different database views in Notion.

play17:45

So this one is chronological, it is ordered chronologically.

play17:49

When it's time to gather B-roll,

play17:51

we go over to Gather View

play17:52

and this will order things by the tags we gave them.

play17:56

So it's very, very easy

play17:58

to just go through everything we need to film,

play18:00

get that done,

play18:01

go over to overhead, get that done, and so on.

play18:04

Some other ones you can see in here, we have fixes.

play18:06

So sometimes, I'll be watching

play18:08

through the Frame.io cut that Tony did

play18:10

and I'll see something that needs to be fixed

play18:13

and all I do there is I'll tell him what to do

play18:15

and then I'll add hashtag fix in the comment.

play18:17

And then here, I have a filter

play18:19

that says anything in the B-roll description

play18:21

that contains hashtag fix will show up here.

play18:23

That way, Tony can efficiently go through,

play18:25

fix any issues we have,

play18:28

and then get on to B-roll gathering.

play18:30

And then we can go into Premiere.

play18:33

So anything that had that Premiere checkbox

play18:34

is going to show up here.

play18:35

Anything that did not will not show up here,

play18:37

so he can efficiently do everything

play18:39

that needs to be done in Premiere all in one chunk

play18:41

and then move on to After Effects

play18:43

which is just filtered

play18:44

by this does not have Premiere checked.

play18:46

It's incredibly efficient.

play18:48

So using this, you can get everything he needs to get done

play18:52

and into the video as efficiently as possible.

play18:55

So it's really, really helpful,

play18:56

and using this entire template

play18:58

has been an absolute boost to our productivity

play19:02

in making videos.

play19:03

So I've showed you

play19:05

the combination of databases here, of templates.

play19:08

If you wanna make your own template,

play19:09

you can go to Templates,

play19:10

you can create a new template.

play19:11

So if you had a different kinda video you wanted to make,

play19:13

one that maybe is a little simpler,

play19:15

you could have a simpler template,

play19:16

I am fine with my one template.

play19:18

But it's very easy to create templates

play19:20

and then add them into databases.

play19:22

So let's talk about the last thing here

play19:23

which is relations and roll-ups.

play19:25

In the past, when I had sponsors on my videos,

play19:28

which is pretty much always,

play19:30

I would just have a tag that said which sponsor it was.

play19:33

So CuriosityStream, Brilliant, it would just be a tag.

play19:35

And that was fine.

play19:36

It would tell me who was sponsoring the video

play19:38

but if I wanted information,

play19:40

what URL do I need to say on screen,

play19:42

or what are the talking points?

play19:44

I would have to go to an external system and refer to them

play19:46

and that wasn't very efficient.

play19:47

So I learned that in Notion,

play19:49

you could do something called a relation

play19:51

where you create a second database

play19:52

and then you can relate it to the first one.

play19:54

So I created a sponsor list.

play19:56

And this is a list of every sponsor I've worked with.

play20:00

This is, again, a database,

play20:01

so I can go in here and I can literally see

play20:04

all of the details for the sponsor.

play20:06

And one of the nice things about Brilliant

play20:07

is they actually use Notion,

play20:09

so they have their most up-to-date talking points in Notion

play20:11

which is pretty nice.

play20:12

But I can grab YouTube description copy

play20:14

for any new video, I can paste it in there,

play20:16

I got the URL down here.

play20:17

That's really, really nice.

play20:18

But the big thing is here,

play20:20

I can see how many spots I've done for every single sponsor

play20:23

and the reason that I can do that

play20:25

and the reason that you see the sponsor listed here

play20:28

in the video project tracker

play20:29

is that these two databases are linked

play20:31

through what's called a relation.

play20:33

So let me show you how you can actually make one.

play20:34

You just create a new column,

play20:36

and you're gonna set this column's type

play20:38

to advanced and relation.

play20:40

Then, you will select a database to work with.

play20:42

So we're gonna go with projects and create the relation.

play20:50

And then, we can actually select the video

play20:55

for each sponsor,

play20:57

or, in the other case, we can go back over to here

play21:01

and now we have a new column that has been added

play21:03

which is our new relation to that other database.

play21:06

So if I have this video here,

play21:09

I can easily add a sponsor onto it.

play21:11

Again, we said it was Fender.

play21:13

Let's just say we have a second sponsor

play21:14

and it's SimpleContacts.

play21:17

If we go back over here to our sponsor list

play21:19

and we look at SimpleContacts, we have this listed.

play21:22

Now, I don't wanna see the individual videos on this view.

play21:27

I wanna see the number of spots I've done

play21:29

and I wanna be able to click in and get the details.

play21:31

So I can go to Properties here

play21:32

and I can just hide that and I'm good to go.

play21:36

So, again, every single view you have,

play21:38

you can go in here and you can customize your properties.

play21:41

And then a roll-up is kind of a simple thing.

play21:43

So instead of creating a relation between two databases,

play21:46

you are instead using a relation that already exists

play21:50

to do something interesting.

play21:51

So this roll-up right here

play21:54

is just looking at the videos table.

play21:57

The property doesn't matter

play21:58

because all we're doing is counting any time

play22:00

that one of these sponsors is mentioned,

play22:02

and that allows us to get

play22:04

the number of video spots we've done,

play22:05

number of podcast spots we've done,

play22:07

'cause we also have a podcast table.

play22:08

It's very similar.

play22:09

And then this is just a formula

play22:11

that is adding these two columns together

play22:13

to see how many spots I've done for each sponsor.

play22:16

Now, one thing that I forgot to mention

play22:18

before I moved on to relations and roll-ups

play22:20

is that it's a good idea

play22:21

to go and look at your templates often

play22:23

to see if they need to be updated.

play22:25

So let's actually do that right now

play22:27

because I think there is something

play22:28

in this template that I have to update.

play22:30

So whenever you wanna update it,

play22:31

you can edit your template.

play22:33

We'll open it as a page.

play22:34

It tells you you're editing a template in Projects.

play22:36

You're not editing just a regular page in here,

play22:38

and I can go in here and change whatever I want.

play22:40

So one thing I know needs to be changed

play22:41

is here on the publishing checklist,

play22:43

we need to remove mark video as completed in Asana

play22:46

because I don't use Asana anymore, I just use Notion.

play22:48

So let's take that out there.

play22:49

And now, every single time I create a new video project,

play22:52

I'm not gonna have that annoying Asana checkbox,

play22:55

I'm just gonna have everything I need.

play22:56

And if I needed to add something to the process,

play22:58

I would do the exact same thing, add it to my template.

play23:01

Now, I will admit that the system I was using

play23:03

before I started using Notion was pretty workable.

play23:06

We were using a combination of Google Docs and Todoist

play23:08

and we got videos done,

play23:10

but because I got curious about Notion,

play23:13

I started playing around with it, I started building things,

play23:15

I ended up with a system that works a heck of a lot better

play23:18

and that really reflects one of my core philosophies

play23:20

when it comes to tools and learning.

play23:22

I'm always looking for a better way to do things

play23:25

because even if the way

play23:26

I'm doing something now seems to work,

play23:28

there's probably some kind of improvement that I could make

play23:30

that would bring an unforeseen benefit.

play23:32

And the exact same thing goes for just reading widely

play23:35

and constantly exposing myself to new ideas

play23:37

and trying to learn new things on a daily basis.

play23:39

When you do this, you tend to combine ideas in your head

play23:42

and find solutions that you would not

play23:44

have otherwise came across.

play23:46

And one great place to constantly push the boundaries

play23:49

of your knowledge and expose yourself to new topics

play23:51

while also having fun

play23:53

and really enjoying what you're watching is CuriosityStream.

play23:56

They have thousands of high-quality documentaries

play23:58

that you can stream to basically any device you want,

play24:01

be it your Roku device, your iPad,

play24:03

your iPhone, your Android, your TV,

play24:05

your computer, like right here,

play24:07

I could watch a documentary on Stephen Hawking for example,

play24:10

and they have long been

play24:11

one of the best deals in online streaming as well.

play24:14

Not only do they have a library

play24:16

of some of the best educational content you're gonna find,

play24:18

it's also only 20 bucks a year.

play24:21

But now, CuriosityStream is actually

play24:22

a better deal than it's ever been before

play24:24

because when you sign up

play24:25

for a yearly subscription at CuriosityStream

play24:28

by going to CuriosityStream.com/Thomas,

play24:30

you're also gonna get access

play24:31

to a new streaming platform called Nebula for free.

play24:35

And I was actually involved in the building of Nebula

play24:37

and you're gonna find all of my content over there as well.

play24:40

And one of the biggest benefits of Nebula

play24:42

is that you get completely pre-roll

play24:44

advertising-free content,

play24:46

so no ads before you get to watch the content whatsoever,

play24:49

and you're gonna find a ton

play24:50

of your favorite content creators there.

play24:52

From Wendover Productions, to Real Engineering,

play24:53

to PolyMatter, CGP Grey, Lindsay Ellis,

play24:57

and of course, me, and also my friend Devin from LegalEagle.

play25:00

I do wanna give him a shout-out as well.

play25:02

But the really big thing about Nebula

play25:03

is we are doing exclusive series there

play25:06

that probably aren't going to work as well on YouTube,

play25:09

and that's kind of the point of Nebula.

play25:10

It's a place for educational creators

play25:12

to really push the boundaries

play25:13

of the content they're creating

play25:15

and to make things that might not work

play25:17

given YouTube's algorithm.

play25:18

So huge thanks to CuriosityStream

play25:21

for not only sponsoring this episode

play25:22

but also helping to make Nebula a possibility.

play25:26

So if you really wanna support this channel

play25:27

and you wanna support educational content creation,

play25:29

you wanna support them,

play25:30

definitely give CuriosityStream a try.

play25:32

Beyond that, hopefully you enjoyed this video.

play25:34

I know it was kind of a different video

play25:35

and I got into some more advanced topics,

play25:37

but a lot of you guys have been asking me about Notion.

play25:39

Definitely ask me more questions about Notion

play25:41

in the comments down below.

play25:42

I would like to do more videos on it in the future,

play25:44

and I wanna know what you are interested to see,

play25:47

but I just wanted to kinda lead

play25:49

with my favorite thing that I've developed in Notion

play25:52

and the thing that really helps me and my workflow the most.

play25:55

If you enjoyed this video,

play25:56

a like is always appreciated,

play25:57

and you can subscribe right there

play25:58

if you wanna get new videos when they come out,

play26:00

or click right there to get a free copy of my book

play26:02

on how to earn better grades.

play26:04

Last but not least, you can click right over here or here,

play26:06

and they're probably gonna cover my face this time,

play26:07

I don't really know where I am on the camera.

play26:09

But there are gonna be more videos on this channel

play26:11

and you should click them

play26:12

or smash your face into your phone screen with your nose,

play26:14

that also works, to watch them.

play26:16

Anyway, thanks for watching

play26:17

and I'll see you in the next one.

Rate This
β˜…
β˜…
β˜…
β˜…
β˜…

5.0 / 5 (0 votes)

Related Tags
Notion TipsProject TrackerDatabase ManagementWorkflow EfficiencyVideo ProductionContent CreationTemplate CustomizationKanban ViewCalendar ViewSponsor Management