LeadOcean + Clay: research and enrich school districts by size and location

You get a Clay table of school districts with headcount, location and website, plus the superintendent and a work email for each. LeadOcean supplies the districts and the people. Clay's own template also pulls average SAT and ACT scores and student-teacher ratio (Clay template, September 2026). LeadOcean holds none of those scores, so add them from a public education dataset.

How it works

1. Size the list first. Call GET /v1/companies/count with an education industry and a country. It is free and returns the exact total with breakdowns by headcount band and HQ state (LeadOcean docs, October 2026).
2. Search the districts. Call POST /v1/companies/search with industry, hqCountry and employeeRange. Each company returned is one record. One search pages to 10,000 rows (LeadOcean docs, September 2026).
3. Import the CSV into Clay. Keep company_domain, company_name, headcount and HQ state.
4. Find the superintendent. Add an HTTP API column that calls POST /v1/people/search with the district domain and the title Superintendent. Gate it with "Only run if" on a filled domain (Clay docs, September 2026). Search returns the name and title, never the address.
5. Get the email. Add a second HTTP API column that calls POST /v1/people/enrich with the row's meta.source_ids.person_id and reveal_email: true. Run it only where step 4 found someone.
6. Add scores from a public source. Join SAT, ACT and student-teacher ratio on the district name or state ID. LeadOcean does not carry these.

Configuration

Step 2. Industry values are exact strings. List them with GET /v1/enums/industry?q=education (free) and pick the ones that fit.

curl -X POST "https://api.leadocean.io/v1/companies/search" \
  -H "x-api-key: $LEADOCEAN_API_KEY" \
  -H "content-type: application/json" \
  -d '{
    "industry": ["Primary and Secondary Education", "Education Administration Programs"],
    "hqCountry": ["US"],
    "employeeRange": ["201-500", "501-1000"],
    "limit": 100
  }'

Steps 4 and 5, Clay's HTTP API columns. Run each once per district.

Method:   POST
URL:      https://api.leadocean.io/v1/people/search
Headers:  x-api-key: <your LeadOcean key>
          content-type: application/json
Body:     { "domain": ["/Domain"], "title": ["Superintendent"], "limit": 1 }

Method:   POST
URL:      https://api.leadocean.io/v1/people/enrich
Body:     { "person_id": "/Person ID", "reveal_email": true }

Test one row before a full table. Add count=true as a query parameter with limit=1 to test it for free.

Field mapping

Cost at 10,000 rows

LeadOcean. 10,000 districts is 10,000 records. Each superintendent found is one search record plus one enrichment, so up to 20,000 more. A search or enrichment that finds nobody costs nothing. Counting is free. Free holds 1,000 records for life at 5 requests a second. Solo is $97 a month and Agency is $497 a month, with a fair-use pace and no per-record price (LeadOcean pricing).

Clay. Each HTTP API call uses one Action, so two columns over 10,000 rows is up to 20,000 Actions. Growth includes 40,000 Actions a month and costs $495 a month billed monthly, or $446 billed yearly (Clay pricing, September 2026). Launch and Free have no HTTP API column.

Troubleshooting

FAQ