Filtering

Filtering is a huge part of building a solid ICP for your outreach campaigns.

Applying filters in LeadTables is easy; there are two ways you can do it.

1 โ€” Filtering Directly On The Column

To apply filters onto a column directly, just click the little filter icon:

This will open the filter menu. If ever you run into something like the example below, where the filter options arenโ€™t what youโ€™d expect โ€“ i.e. in this case we see text-oriented filters like โ€œcontainsโ€ and no number-oriented filters like โ€œgreater than,โ€ โ€œless than,โ€ etc. โ€“ it means you forgot to map this column to the correct type when uploading.

To rectify, do a fresh โ€œenrichment modeโ€ upload where you just map this column and the unique identifier column, and map it to a new column that you remember to correctly set the type for.

NB: Iโ€™ll eventually allow you to change the data type for existing columns, but at the time of writing, that functionality doesnโ€™t yet exist. (Itโ€™s more complicated to build than you might think)

Filtering In The Filters Tool Panel

If you want more of a โ€œmaster viewโ€ of all your stacked filters, you can go into the Filters tool panel:

You can add, remove, and edit filters all from within here.

(You can also drag the left side edge of the tool panel to resize it if needed)

Clearing Filters

Clearing filters is basically the same as you learned in the sorting lesson.

You canโ€ฆ

  • Clear an individual filter from the column menu
  • Clear an individual filter from the Filters Tool Panel
  • From the โ€œclear all filtersโ€ button in the Action Bar

You can also do the โ€œclear allโ€ from within the column menu, at least as of today. (I might remove it from the column menu though because Iโ€™m not sure itโ€™s great UX to have it in there)

Note: Where LeadTables Filtering Is Currently Weakest

Down the line, I want to develop a more robust filter control for advanced users that allows complex chaining of โ€œANDโ€ and โ€œORโ€ filter conditions.

But right now, thatโ€™s not possible.

Right now, every different column filter you stack functions as an โ€œAND-style filter.โ€

To get around this if you want to stack โ€œOR-style filters,โ€ you can use tags.

So in other words, if you want this ICPโ€ฆ

  1. At least $1m/yr in revenue
  2. OR at least 20k insta followers
  3. OR at least 20 employees

โ€ฆWhat you could do is just apply filter 1, add a โ€œGood ICP Fitโ€ tag to them, then apply filter 2 and add the same tag, etc., then once youโ€™ve done all that, filter by โ€œhas the โ€˜Good ICP Fitโ€™ tagโ€ and youโ€™ll see โ€˜em all there.

Youโ€™ll learn about tags in the โ€˜The LeadTables โ€œAction Barโ€โ€™ module.