This is an explanation of the system I use to take advantage of that massive game studios list for my own job hunt. I've written it down here so that people will be able to use it as well. If anything's unclear, go ahead and contact me!
On the previous page (the one with the table), use the Duplicate button (top right corner of the screen) to copy the whole page / table into your own Notion account.
Each field will allow you to add specific information onto each entry on the table.
Add these fields with these types:
Preference (multi-select): You'll find it useful to organize the studios depending on how much you'd like to work there. Create these options:
OOL means "Out of my league", and I use it for those studios that I would love to work for but that I don't think will hire me at my current level, whether it is because they only hire really experienced developers or because they're just one or two people making something together and they're unlikely to hire anyone at all.
Status (multi-select): Your application status with each of the companies. Create these options:
I always send two follow-up emails if I don't get any answers: the first one after two weeks (and I change the status to Followed up once), then the second one two weeks later (and I change the status to Never replied).
"Interest" means that the company has shown interest in my application. "Seed planted" means that they can't take me on right now, but they're interested and they'll contact me if something opens up.
Last contact (date): It's very useful to record when you sent that last message to the company, to see how long you should wait until you poke them again.
Follow up (formula): This field looks like a checkbox that will light up when it's been two weeks since the last contact. To set it up, use this formula:
if(prop("Status") == "🙏 Interest" or prop("Status") == "🕒 Application sent" or prop("Status") == "😒 Followed up once", largerEq(dateBetween(now(), prop("Last contact"), "days"), 14), false)
After that, create different views (you can access the different views by clicking the view name at the very top of the table). Views present data differently, through filtering and sorting it so that you're only looking at the companies you want to see right now. These are the views I use (all of them are of the "Table" type):
Let's go through them one by one:
🔍 Active: The companies that I have an active application with, or that require attention.
Filter:
Sort:
💬 Follow up now: Out of the active ones, just the ones that need to be contacted (because two weeks have passed since our last contact)