Defining Business Personas for Startups and SMBs in the USA
IF( AND( OR({{Normalized Title}} = "Founder", {{Normalized Title}} = "Owner"), {{# of Employees}} <= 10, {{2023 Revenue (USD)}} <= 500000, {{Country}} = "USA" ), "Persona #1 | Startup | Founder/Owner", IF( AND( {{Normalized Title}} = "C-Suite", {{# of Employees}} <= 10, {{2023 Revenue (USD)}} <= 500000, {{Country}} = "USA" ), "Persona #2 | Startup | C-Suite", IF( AND( {{Normalized Title}} = "Presidency", {{# of Employees}} <= 10, {{2023 Revenue (USD)}} <= 500000, {{Country}} = "USA" ), "Persona #3 | Startup | Presidency", IF( AND( {{Company Provides SaaS?}} = "No", {{Normalized Title}} = "C-Suite", {{# of Employees}} >= 11, {{# of Employees}} <= 50, {{2023 Revenue (USD)}} >= 1000000, {{2023 Revenue (USD)}} <= 10000000, {{Country}} = "USA" ), "Persona #4 | Non-SaaS SMB | C-Suite/Presidency", IF( AND( {{Company Provides SaaS?}} = "Yes", {{Normalized Title}} = "C-Suite", {{# of Employees}} >= 11, {{# of Employees}} <= 50, {{2023 Revenue (USD)}} > 500000, {{Country}} = "USA" ), "Persona #5 | SaaS SMB | C-Suite/Presidency", IF( AND( {{Company Provides SaaS?}} = "Yes", {{Normalized Title}} = "Manager", {{# of Employees}} >= 11, {{# of Employees}} <= 50, {{2023 Revenue (USD)}} > 500000, {{Country}} = "USA" ), "Persona #6 | SaaS SMB | Manager", IF( AND( {{Normalized Title}} = "C-Suite", {{# of Employees}} >= 51, {{# of Employees}} <= 200, {{2023 Revenue (USD)}} > 10000000, {{Country}} = "USA" ), "Persona #7 | Enterprise | C-Suite", IF( AND( {{Normalized Title}} = "Presidency", {{# of Employees}} >= 51, {{# of Employees}} <= 200, {{2023 Revenue (USD)}} > 10000000, {{Country}} = "USA" ), "Persona #8 | Enterprise | Presidency", IF( AND( {{Normalized Title}} = "Manager", {{# of Employees}} >= 51, {{# of Employees}} <= 200, {{2023 Revenue (USD)}} > 10000000, {{Country}} = "USA" ), "Persona #9 | Enterprise | Manager", "Unclassified" ) ) ) ) ) ) ) ) )