All Articles
Streak Theory: Elements of a Successful Pipeline

Streak Theory: Elements of a Successful Pipeline

min read

Music Theory helps us understand the elements of a catchy tune (there’s a reason so many pop songs sound similar!). The best Streak Pipelines also share common elements, and we’ll use this post to discuss the Streak Theory behind the ‘catchiest’ Pipelines. We also built you this simple Worksheet (‘Make a copy’ from the file menu) to help you craft a Pipeline built from the ground up for powerful reporting, filtering, and sorting.

One Column per Fact

The first Pipeline we help you create is meant to be the minimum you need to get started rather than a finished product. Before you grab your keyboard to start adding columns, take a moment to write down all of the information you want to know about each of your leads, hiring candidates, support tickets, or potential investors…

Have a few data points in mind? Great! Each of those facts deserves a dedicated column, like this:

Clear Notes, Full Columns, Can’t Lose

Our Best Practice recommendation for the ‘Notes’ field is to apply the following test:

  1. Unique to the box (or applies to very few boxes)
  2. ‘Evergreen’ — A piece of information that is always going to be true.

… if your note doesn’t pass both of these tests, a new column should be considered.

There are two main reasons to be mindful before adding Notes:
1) Glance at each of the following screenshots and then try to answer the question: How many widgets does each customer want to purchase?

2) We can create reports based on individual columns like the 2nd example (how many leads are > 100,000 widgets? What is the close rate for a certain size deal?). The computer cannot, however, read and report on free form text entered in the ‘Notes’ field.

Even if you’re not ready to think about team reporting yet, you’ll still want to build a database that’s ready to scale.

Structured Data = Clean Data

Help your users create standardized, easy to report on information by selecting the appropriate format. In the first example above, we added a ‘Dropdown’ column. The most commonly used ‘Structured Data’ columns are:

  • Dropdown: Select only 1 of the pre-filled options.
  • Tag: Choose 1 or more of the pre-filled options.
  • Date: Streak accepts only valid date formats.

Utilizing a Dropdown Column type like this:

…eliminates typos and prevents different people from using different terms to describe the same information.

Magic Columns Mean Less Data Entry

So far, we’ve only discussed the data you can add to Streak. Now is a good time to get to know our automatically updated Magic Columns tracking 50+ different data points. Magic Columns like ‘Date Last Updated’ or ‘Total Emails Sent’ are hard at work, even if your computer is off. Below you’ll see Email magic columns — and this is just one section of our total list!

Final Note: Columns vs Special data types

Because Streak is exceptionally flexible, at times you’ll have multiple possibilities for storing one piece of data. Whenever possible, we want to be in a position to make Magic Columns work for us:

  • Email, Call Logs, and Meeting Notes are special data types in Streak that can be added from inside an individual box.
  • Adding 1 email, for example, gives us access to all of the options shown in the Magic Column above. Although you could manually track the last email you sent in a “Date” column, we get so much more data from the Magic Columns with no effort.

The Worksheet we linked in the beginning will help you think through what which columns you’ll want to add. We can even make automatic suggestions based on your inputs! Note that the link is to a ‘view only’ copy. If you’d like fill out the sheet, make a copy you can edit: Choose ‘File’ -> “Make Copy’.

Questions about building the Perfect Pipeline?

We're hiring

Come build something great with us.