23 templates to automate your CRM in Gmail
Connect to 4,000+ apps and set up automations without using any code or leaving Gmail.
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.
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:
Our Best Practice recommendation for the ‘Notes’ field is to apply the following test:
… 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.
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:
Utilizing a Dropdown Column type like this:
…eliminates typos and prevents different people from using different terms to describe the same information.
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!
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:
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’.