HG Insights integration

The HG Insights integration brings enterprise-grade technology intelligence data points, enabling teams to access proprietary data such as:

• Technology Intelligence: In-depth details about a company’s tech stack that typically is hard to find.
• Firmographic Data: Insights into company size, revenue, and more.
• Corporate Hierarchy Data Points: Accurate mapping of parent-child relationships within target companies.

Creating a table with HG Insights

1. In a workbook, click + Add at the bottom.
2. Search for HG Insights and select from the results.
3. In the modal, you will be asked to Select HG Insights account.
   • If you haven't already connected your HG Insights account, click + Add account and go through authentication.

Source Companies by product usage with HG Insights

Build lists of companies based on what technology they use, including "back of house" tools that you won't find on a website.

Inputs

Primary filters — select at least one of the following:

• Products: Find companies that use these products.
• Vendors: Find companies that use products from these vendors.
• Product categories: Find companies that use products in these categories.
• Product attributes: Find companies that use products with these attributes.
• Company IDs (include): Limit results to companies with these HG Insights hex-encoded IDs.
• Company IDs (include corporate relatives): Limit results to these companies and every other company in their corporate hierarchy.

Primary filter modifiers (optional):

• Product inclusion method, Vendor inclusion method, Product category inclusion method, and Product attribute inclusion method: How the matching primary filter is applied — Any present (include), All present (require all), or None present (exclude). Defaults to Any present (include).
• Vendor product count (min) and Vendor product count (max): The minimum and maximum number of distinct products from each vendor.

Firmographic refinements (optional):

• Country codes: Limit results to companies based in these countries.
• Company level: Limit results to a specific level in the corporate hierarchy — All entities, Global headquarters, Corporate parents, or Domestic parents. Defaults to All entities.
• Industry IDs: Filter by HG Insights numeric industry IDs.
• NAICS code IDs and SIC code IDs: Filter by HG Insights hex-encoded NAICS or SIC code IDs.
• Region names: Filter by HG Insights region names, for example AMER, EMEA, or APAC.
• State IDs: Filter by HG Insights hex-encoded state IDs.
• Minimum revenue (USD) and Maximum revenue (USD): Keep companies within a revenue range.
• Minimum employees and Maximum employees: Keep companies within an employee-count range.
• Country codes inclusion method, Industries inclusion method, NAICS codes inclusion method, and SIC codes inclusion method: How the matching filter is applied — Any present (include) or None present (exclude). Defaults to Any present (include).

Runtime controls (optional):

• Max companies: Limit the number of companies returned. Defaults to 100.
• Maximum credit cost per run: Cap the total credits spent on this run. Clay truncates the result list once the cap is reached. This appears when you're using the Clay provided key.

Enriching data with HG Insights

1. While in a Clay table, click Add enrichment and search for HG Insights.
2. Under Integrations, select one of the HG Insights options.
3. In the modal, you will be asked to Select HG Insights account.
   • If you have your own account, click + Add account and go through authentication. Otherwise, use the Clay provided key.

Action Enrich company

Enrich your company records to provide you critical, hard-to-find data, such as parent-child company relationships and revenue numbers, alongside foundational details like the company domain.

Inputs

• Company domain or HG company ID: The domain name, or HG Insights company ID, of the company to enrich.

Outputs

• HG Company Id, Company name, Company domain, and Domain normalized
• Country code, Country name, State name, City name, and Postal code
• Continent name, Subcontinent name, and Geopolitical name
• Industry ID, Industry name, NAICS code, NAICS name, SIC codes, and SIC names
• Revenue total in USD and Revenue band
• Employee count and Employee band
• Forbes 2000 rank and Fortune 500 rank

Action Verify technology usage

Determine whether specific companies use a particular product — for example, whether a company runs Salesforce as its CRM or NetSuite as its ERP.

Inputs

Required:

• Company domain or HG company ID: The domain name, or HG Insights company ID, of the company to enrich.

Optional:

• Products: Filter by specific HG Insights products.
• Product names (substring match): An alternative to selecting products by ID, matching case-insensitively on part of a product name. You can provide up to 10 names.
• Vendors and Vendor names (substring match): The same pairing for vendors — select them by ID, or match on part of a vendor name.
• Product categories and Product category names (substring match): The same pairing for product categories.
• Product attributes: Filter by specific HG Insights product attributes.
• Country codes: Filter installs by country.
• Localized installs only: Only match installs in the same country as the company. Setting Country codes overrides this.
• Product last verified date (min) and Product last verified date (max): Keep installs last verified inside a date range, in YYYY-MM-DD format.
• Limit: The maximum number of records to return. Defaults to 10, and the maximum is 100. Credits are charged per record returned.
• Offset: Where to start in the result set, for paging through records.

Outputs

• All product names: Every matching product, as one comma-separated list.
• Installs count: The number of matching installs found.
• Installs: One entry per install, containing:
  • Product ID, Product name, Product description, and Product last verified date
  • Vendor ID, Vendor name, and Vendor domain
  • Country code
  • Product category ID, and Product category level 1 through Product category level 5

Action Get website tech stack

Detect the technologies running on a company's website, based on scans of the site's content and network requests.

Inputs

• Company domain: The domain name of the company whose website technology you want to detect, like walmart.com.

Outputs

• Company name and Company domain
• All product names: Every detected product, as one comma-separated list.
• Installs count: The number of detected technologies.
• Installs: One entry per technology, containing Product name, Vendor name, Product category name, and Product first verified date.

Action Find company corporate structure

Find all corporate parents, domestic parents, and lower level entities managed by a group headquarters company.

Inputs

Required:

• Company domain or HG company ID: The domain name, or HG Insights company ID, of the company to enrich.
• Mode: Which part of the corporate hierarchy to return — Full — entire tree from Group HQ, Children — subtree rooted at the matched company, or Parents — ancestor chain from Group HQ to matched company. Defaults to Full.

Optional:

• Format: How the hierarchy comes back — Tree — nested hierarchy or List — flat array of companies. Defaults to Tree. Your choice here changes which filters are available, as below.
• Max tier: Available with Tree. Restrict the tree to companies at or above this tier — Group HQ, Corporate parent, Domestic parent, or Subsidiary. Use it to limit how deep the tree goes.
• Countries, Regions, and Tiers: Available with List. Restrict results to companies in these countries, in these regions (AMER, EMEA, APAC), or at these hierarchy tiers. Countries and regions combine as an either-or match.
• Selected fields: Restrict which fields are returned for each company in the hierarchy. If you leave it empty, all available fields are returned.

Outputs

• Count: The number of companies in the hierarchy.
• Hierarchy: The nested hierarchy, returned with Tree.
• Companies: The flat list of companies, returned with List.
• Every company in Hierarchy and Companies carries:
  • HG Company ID, Company name, Domain, Domain normalized, and Company level
  • Parent ID, Global HQ ID, Global HQ name, Corporate parent ID, Corporate parent name, Domestic parent ID, and Domestic parent name
  • Country code, Country name, State name, and City name
  • Industry name, NAICS code, NAICS name, SIC codes, and SIC names
  • Revenue total, Revenue band, Employees total, and Employees band
  • Selected, which marks the company you looked up

Action Find company domain

Guess the domain of a company based on their company name.

Inputs

Required:

• Company name: The company name to match.

Optional:

• Country: A country name or two-letter country code to scope the match, for example US or United States.
• Limit: The maximum number of matches to return, sorted by relevance. Defaults to 3, with a minimum of 1 and a maximum of 10.

Outputs

• Matches: One entry per candidate company, containing HG Company ID, Company name, Company domain, Country code, and Matched on.

Run settings

• Auto-update
• Only run if: The enrichment will only run if conditions are met. (Learn more about conditional formulas here!)