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.
domains.domain as "Domain",
companies.name as "Company Name",
companies.country_code as "Country Code",
companies.region_code as "Region"
INNER JOIN domains ON domains.company_slug = companies.company_slug
WHERE domains.domain = 'nike.com';