Products

Products are a special type of company. Products are companies which deliver services to other companies.

Products are one of the three business entities represented in the COMPANIES view.  The PRODUCT_DEPLOYMENTS view contains all the products in use by a company.

 

Example 1

If you want to generate a list of all the products used by a company, you can do the following:

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;