Copy page

Tutorials

Email Enrichment

Person details (name, position, company, social profiles) for an email. You have emails (sign-ups, inbound leads) and want the person behind each: name, position, company, social profiles.

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

Inputs and options

Input: email (Email address)

This tool has no options.

Try one value

Code
CALL TOMBA.core.email_enrichment('jane.doe@acme.com');

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

Code
{
    "status": "found",
    "credits": 1,
    "results": [
        {
            "EMAIL": "jane.doe@acme.com",
            "FULL_NAME": "Jane Doe",
            "POSITION": "Head of Sales",
            "COMPANY": "Acme",
            "LINKEDIN": "https://www.linkedin.com/in/..."
        }
    ]
}

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.signups (EMAIL STRING);
INSERT INTO my_db.public.signups VALUES
    ('jane.doe@acme.com'),
    ('john@globex.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.signups TO APPLICATION TOMBA;

Run the tool, then read the results:

Code
CALL TOMBA.core.enrich_emails('MY_DB.PUBLIC.SIGNUPS', 'EMAIL', 'SIGNUPS_EMAIL_ENRICHMENT', 100);

SELECT INPUT_EMAIL, FULL_NAME, POSITION, COMPANY, COUNTRY, LINKEDIN
  FROM TOMBA.results.SIGNUPS_EMAIL_ENRICHMENT
 WHERE lookup_status = 'found';

Signature: enrich_emails(input_table STRING, email_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

• Free-mail addresses (gmail.com, …) rarely match: enrichment is for work emails.
• For the person and their company in one call, use Combined Enrichment.

Related

• Person Enrichment
• Combined Enrichment