Sharing the Job Hunting Pipeline Blueprint

- 7 mins

There is nothing like some unexpected job hunting to send a reasonably confident person into a spiral of panic. I recounted my own experience with recently in this post.

Thankfully, numbers can be our friends when panic wants to set in. Numbers have a clarifying effect on job hunting, shifting the broad stroke conclusions (“I’m never going to get an interview”) to percentages (“I get an interview 40% of the time, so I better keep trying”). Data reveals patterns, and those patterns can help a job seeker from feeling stuck. Or at least that’s what I’ve found so far. I’m happy to say I’ve helped quite a few people through the process of job searching, and each time this approach made it a better experience. In that way, I hope it could be helpful to you.

I call it the Job Hunting Pipeline Blueprint. It’s designed in an opinionated way to motivate you to see patterns in your application choices and to notice where you’re progressing and where you’re stuck.

Suppose you’re on the lookout for a new role, make a copy and give it a try. This post will be a companion piece, meant to share some guidelines to make the most of it.

A no doesn’t mean what you think it means

If you’re like me and tend to live in the gaps of the org chart, you might find yourself applying to a diverse set of companies for a wide range of job titles. There’s nothing wrong with that. What is a challenge, however, is seeing the pattern in chaos.

Without a system that’s capturing the pattern, each “no” feels like a no to you in totality: as an employee, sure, but it stings more than that. A no feels like its a no to you as a person. With a system, especially one that hinges on different job roles, you can see that a company says no to you in that job at that company at this time.

My trick to avoid the wrong conclusions is to pick three jobs you’re pursuing. I like three because it’s a magic number of sorts, but it also gives you the space to see what applications are working and which are not. You can slice the idea of different job titles in any way you please:

It’s helpful to have distinct roles. Mutual exclusive separation makes the next steps clearer.

Review the stages of job hunting

I think about the job process as a linear funnel. It’s not perfect, but it helps in a lot of ways. The big ones being that you know when you’re making progress and where you’re stalling. Here are my defaults for the Blueprint:

Each stage marks a significant pivot point in what I want to study and how I talk about myself. In that way, I hope it’s helpful to use. The template should let you edit these without issue (without breaking), so you can make it your own. Let me know if you run into any trouble.

Track your applications

It’s not uncommon to apply to dozens of job postings before you land on the perfect mix of skills, role, and the elusive luck of the right timing. My first job out of college didn’t land until well over 70 applications. As recently as my last job hunt, I spoke with people about 30+ opportunities. It’s a lot to keep track of on our own, which is why the essential part of the Job Hunt Blueprint focuses on tracking.

The recommended tracker has all the main details, but then levels it up with the Type of Role and Stage dropdowns. We will see how they power the rest of the Blueprint next.

Example Tracker

I also like to add Lessons to the mix. Maybe I missed out on a role due to a hiring freeze, or perhaps I bombed a specific question. These tidbits help me think about the next rounds more effectively.

Work the percentages in the Pipeline

I call the final tab the Pipeline since we’re following through with the funnel analogy. Here is where the work of this spreadsheet becomes worth it.

Example Tracker

I designed an accumulating percentage funnel; as you succeed in each stage listed in Stages, you see the percentage increase of results. The trick is, the percentages are divided by job title. You have four buckets: the three you set at the start, and Other (since we all end up applying to some randoms along the way).

What I love about the resulting spreadsheet is that I offer little recommendations based on the stage you’re “stuck” in.

And if you make it beyond that stage, you’re in. It’s time to negotiate.

Example insights

Blank spreadsheets don’t tell much of a story. That’s why I included an anonymized example Tracker and Pipeline to follow along. Here are some of the juicier takeaways you can see as you review the data.

Happy job hunting

Job searches can be terrible experiences. I’m sharing the Job Hunting Pipeline Blueprint with you because I’ve found it personally helpful in those moments when I feel most overwhelmed and lost. I hope it’s opinionated workflow and insights help you learn a bit more about yourself.

If you do give it a try, I would love to hear about it. Send a tweet or DM to @mbbroberg, or contact me through my website.

Last but not least, I designed this project based on the work of Lewis C. Lin. If you’re looking to get into Product Management, check out his study sheets.

Matthew Broberg

Matthew Broberg

technical community builder

rss facebook twitter github youtube mail spotify instagram linkedin google google-plus pinterest medium vimeo stackoverflow reddit quora