Copy page

Tutorials

Similar Domains

Companies similar to a domain (one row per similar company). Grow a target account list with companies similar to your best customers (lookalikes).

Credits: 1 search credit when found. Lookups that find nothing cost nothing. See Pricing and limits.

Inputs and options

Input: domain (Company domain)

This tool has no options.

Try one value

Code
CALL TOMBA.core.similar_finder('acme.com');

The call returns the result as a VARIANT (example values, shortened):

Code
{
    "status": "found",
    "credits": 1,
    "results": [
        {
            "SIMILAR_DOMAIN": "initech.com",
            "NAME": "Initech",
            "INDUSTRIES": "Software Development"
        },
        {
            "SIMILAR_DOMAIN": "globex.com",
            "NAME": "Globex",
            "INDUSTRIES": "Software Development"
        }
    ]
}

status is found, not_found, invalid or error; results holds the output columns and data the complete Tomba record.

Run it over a table

Create a small table to try it (or use one of yours, after granting the app access):

Code
CREATE OR REPLACE TABLE my_db.public.best_customers (WEBSITE STRING);
INSERT INTO my_db.public.best_customers VALUES
    ('acme.com');
GRANT USAGE ON DATABASE my_db TO APPLICATION TOMBA;
GRANT USAGE ON SCHEMA my_db.public TO APPLICATION TOMBA;
GRANT SELECT ON TABLE my_db.public.best_customers TO APPLICATION TOMBA;

Run the tool, then read the results:

Code
CALL TOMBA.core.find_similar_domains('MY_DB.PUBLIC.BEST_CUSTOMERS', 'WEBSITE', 'BEST_CUSTOMERS_SIMILAR_FINDER', 100);

SELECT INPUT_DOMAIN, SIMILAR_DOMAIN, NAME, INDUSTRIES
  FROM TOMBA.results.BEST_CUSTOMERS_SIMILAR_FINDER
 WHERE lookup_status = 'found';

Signature: find_similar_domains(input_table STRING, domain_column STRING, output_table STRING, max_rows INT DEFAULT 100000)

Output columns

Each row has your INPUT_<name> columns, the tool's columns, and the common columns (LOOKUP_STATUS, CREDITS, DATA, …). Every column, with its type and values: Output columns.

Tips

• The output has one row per similar company.
• Chain it: enrich the lookalikes with Company Enrichment, then find people with Domain Search.

Related

• Company Enrichment
• Companies Search
• Domain Search