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.
If you want to generate a list of all the products used by a company, you can do the following:
companies.name as "Company Name",
products.name as "Product Name",
product_deployments.product_category as "Product Category",
product_deployments.spend as "Monthly Product Spend"
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
|Company Name||Product Name||Product Category||Monthly Product Spend|
|Nike, Inc||Amazon EC2||Cloud Hosting||2000000|
|Nike, Inc||Amazon Cloudfront||Content Delivery||250000|
|Nike, Inc||Akamai CDN||Content Delivery||200000|
|Nike, Inc||ChinaNetCenter||Content Delivery||150000|
|Nike, Inc||Check Point Software Technologies||Security||90000|
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.
Please sign in to leave a comment.