Want a guided walkthrough? Schedule a 15-min call.
Extruct AI tables allow you to rank and score companies using customizable criteria defined in natural language. This guide walks through the process of setting up a table with criteria-based ranking to evaluate companies according to your specific needs.

Creating a Criteria Ranking Table

While it’s easier to create tables through the Extruct Dashboard, you can also create them programmatically:
curl -X POST "https://api.extruct.ai/v1/tables" \
  -H "Authorization: Bearer YOUR_API_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Company Evaluation",
    "kind": "company",
    "description": "Evaluating companies based on custom criteria",
    "column_configs": [
      {
        "kind": "input",
        "name": "Company Input",
        "key": "input"
      },
      {
        "kind": "criterion_grade",
        "name": "Market Fit",
        "key": "market_fit",
        "value": {
          "criterion": "Does this company fit well into our target market of B2B SaaS?"
        }
      },
      {
        "kind": "criterion_grade",
        "name": "Revenue Potential",
        "key": "revenue",
        "value": {
          "criterion": "Does this company have high revenue potential (>$100K ARR)?"
        }
      }
    ]
  }'

Column Types for Criteria Ranking

Criterion Grade Columns These columns evaluate companies against specific criteria:
{
  "kind": "criterion_grade",
  "name": "Technical Sophistication",
  "key": "tech_score",
  "value": {
    "criterion": "How technically sophisticated is this company based on their product offerings?"
  }
}
Extruct will analyze company data and provide a grade from 1-5 along with an explanation for each criterion.

Adding Companies to Evaluate

Add companies to evaluate with the run=true flag to trigger immediate analysis:
curl -X POST "https://api.extruct.ai/v1/tables/{table_id}/rows" \
  -H "Authorization: Bearer YOUR_API_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "rows": [
      {
        "data": {
          "input": "Salesforce (https://salesforce.com)"
        }
      },
      {
        "data": {
          "input": "Airtable (https://airtable.com)"
        }
      },
      {
        "data": {
          "input": "Notion (https://notion.so)"
        }
      }
    ],
    "run": true
  }'

Retrieving Ranked Results

Once the analysis is complete, retrieve your ranked results:
curl -X GET "https://api.extruct.ai/v1/tables/{table_id}/data" \
  -H "Authorization: Bearer YOUR_API_TOKEN"
The response will contain the evaluated rows with grades and scores:
{
  "rows": [
    {
      "id": "row_1",
      "data": {
        "input": {
          "value": "Salesforce (https://salesforce.com)", 
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        },
        "market_fit": {
          "value": {
            "answer": 5, 
            "explanation": "Salesforce is a CRM company, which is categorized as B2B SaaS.", 
            "sources": ["https://salesforce.com"]
          }, 
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        },
        "revenue": {
          "value": {
            "answer": 5, 
            "explanation": "Salesforce has annual revenue well above $100K ARR, with billions in annual recurring revenue.", 
            "sources": ["https://investor.salesforce.com"]
          }, 
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        }
      }
    },
    {
      "id": "row_2",
      "data": {
        "input": {
          "value": "Airtable (https://airtable.com)", 
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        },
        "market_fit": {
          "value": {
            "answer": 5, 
            "explanation": "Airtable offers a collaborative database product that serves many B2B SaaS customers.", 
            "sources": ["https://airtable.com/product"]
          }, 
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        },
        "revenue": {
          "value": {
            "answer": 4, 
            "explanation": "As a well-funded startup valued over $1B, Airtable likely exceeds $100K ARR threshold, but specific figures aren't public.", 
            "sources": ["https://airtable.com/about"]
          }, 
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        }
      }
    },
    {
      "id": "row_3",
      "data": {
        "input": {
          "value": "Notion (https://notion.so)", 
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        },
        "market_fit": {
          "value": {
            "answer": 5, 
            "explanation": "Notion provides workspace tools used by many businesses, positioning it in the B2B SaaS category.", 
            "sources": ["https://notion.so/enterprise"]
          }, 
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        },
        "revenue": {
          "value": {
            "answer": 5, 
            "explanation": "As a company valued at over $10B with millions of users, Notion easily surpasses the $100K ARR threshold.", 
            "sources": ["https://notion.so/about"]
          }, 
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        }
      }
    }
  ]
}

Advanced Criteria Configuration

For more detailed evaluation, you can provide additional context in your criteria:
{
  "kind": "criterion_grade",
  "name": "Product-Market Fit",
  "key": "pmf",
  "value": {
    "criterion": "How well does this company's product solve a real pain point for our customer base of mid-sized manufacturing companies? Consider their focus, industry specialization, and customer testimonials."
  }
}

Best Practices

  1. Be Specific: Define criteria that are specific enough to distinguish between companies
  2. Use Multiple Criteria: Include 3-5 criteria that cover different aspects of evaluation
  3. Review Results: The AI rankings are powerful but should be reviewed by human experts
By using multiple criteria, you can create sophisticated evaluation systems that align with your specific business needs.