Clay Icon

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" ) ) ) ) ) ) ) ) )

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can create complex IF statements using logical operators to classify personas based on multiple conditions. Here's how:1. Use the OR operator (||) for conditions where at least one needs to be true: โ€ข Example: IF({{employee_count}} > 500 || {{location}} == "US") THEN "Enterprise" ELSE "SMB" 2. Best practices for your conditional statements: โ€ข Always include error handling for empty fields โ€ข Test boundary values to avoid misclassification โ€ข Handle unexpected data formats by setting appropriate defaultsFor example, a complete formula might look like:IF({{company_size}} > 100 &amp;&amp; {{location}} == "US") THEN "Primary Target" ELSE IF({{company_size}} > 50) THEN "Secondary Target" ELSE "Not Qualified" Sources: Conditional statements | Clay University Logical operators | Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.