Domains, such as nike.com, exist in your CRM and other data sources used by your business operations team.  Domains are the primary way to identify companies in the Intricately dataset.

 

Join DOMAINS to COMPANIES

If you have a domain and want to locate the company which owns that domain, you’ll join the DOMAINS view to the COMPANIES view.

 

Example 1

SELECT 
domains.domain as "Domain", 
companies.name as "Company Name", 
companies.country_code as "Country Code", 
companies.region_code as "Region" 
FROM companies 
INNER JOIN domains ON domains.company_slug = companies.company_slug 
WHERE domains.domain = 'nike.com';

Domain	Company Name	Country Code	Region
nike.com	Nike, Inc	US	NA