Companies

Companies are business entities that represent three types of objects in Intricately's data model:

1. Companies
2. Products
3. Providers

The COMPANIES view contains firmographic and summary data for all three business entities and you’ll join to the COMPANIES view whenever you want firmographic or summary information for any of these 3 business entities.

Join to COMPANIES for firmographic and summary data

Whenever you see a COMPANY_SLUG, PRODUCT_SLUG, or PROVIDER_SLUG - simply join them on the COMPANY_SLUG from the COMPANIES view to get firmographic or summary detail for the Company, Product, or Provider, respectively.

Example 1

Let’s say you want to get the number of employees at the company that owns the nike.com domain:

SELECT 
domains.domain as "Domain", 
companies.name as "Company Name", 
companies.employees_count as "Number of Employees" 
FROM companies 
INNER JOIN domains ON domains.company_slug = companies.company_slug 
WHERE domains.domain = 'nike.com';

Example 2

Let’s say you want to get the name and spend of a Product from the PRODUCT_DEPLOYMENTS view. You would join to the COMPANIES view as follows:

SELECT   
companies.name as "Company Name",   
products.name as "Product Name",  
product_deployments.product_category as "Product Category",  
product_deployments.spend as "Monthly Product Spend" 
FROM companies 
INNER JOIN product_deployments ON product_deployments.company_slug = companies.company_slug 
INNER JOIN companies products ON products.company_slug = product_deployments.product_slug 
INNER JOIN domains ON domains.company_slug = companies.company_slug 
WHERE domains.domain = 'nike.com' 
ORDER BY "Monthly Product Spend" DESC NULLS LAST 
LIMIT 5;

The above query requires access to Detailed Spend!

Note: If you haven't purchased access to Detailed Spend, you can still generate the query above, just use the tiered_spend field value.

Example 3

Let’s say you want to get the name of a Provider and all their Products in the PROVIDERS_PRODUCTS view:

SELECT 
providers.name as "Provider Name", 
products.name as "Product Name" 
FROM providers_products 
INNER JOIN companies providers ON providers.company_slug = providers_products.provider_slug 
INNER JOIN companies products ON products.company_slug = providers_products.product_slug 
WHERE providers_products.provider_slug = 'google-cloud-platform';