Troubleshooting HG Insights Table for Software Renewal Dates and Listings

Steven · 2025-12-08T10:28:14.229Z

Hi folks, rookie question here, I've created a table and used 'HG Insights Verify technology usage' to get data on what Sales and Marketing software a list of companies are using. I have two questions that I can't figure out: • How do I check the likely renewal date the softwares? I added 'Product First Verified' date but nothing populates • How do I get the table to list more than one product. For example when the table returns more than one product the 'Product Names - Products' column only contains the name of one product. I have to click and dig to see the 2nd or 3rd product. • I have tried sending this row to another table but it still does not list the data. It just shows a load of cells with an arrow and the word 'Row" (see screenshot) Thanks!

Troubleshooting HG Insights Table for Software Renewal Dates and Listings | Clay

15 comments

· Sorted by Oldest

Clay Support
APP
·
·
HG Insights doesn't provide renewal dates—only when products were first verified. [1] The "Product First Verified" field shows when Clay first detected the technology, not contract renewal dates. [2]
For multiple products: increase the Max products setting in your enrichment configuration. By default, Clay shows maximum 3 products per company. Set this higher to capture more technologies per company.
The "Row" issue happens when transferring complex data between tables—the array structure doesn't expand automatically.
Clay Support
APP
·
·
Was that helpful?
Steven
·
·
What enrichment can I use to find renewal dates?
Clay Support
APP
·
·
Clay doesn't have a specific enrichment for contract renewal dates. However, you can use Claygent with conversational data to extract renewal information from sources like earnings calls, interviews, or public statements. [1]
Set up Claygent with a JSON schema to capture:
contract_end_date
renewal_timeline (imminent, within 3 months, etc.)
Current spend and satisfaction levels
For existing customers, you can import renewal dates directly from your CRM, billing tools, or data warehouse as part of your account review process. [2]
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you need any more help with finding renewal dates or managing your tables, please let me know. Would you like to provide more details about what you're trying to achieve so I can assist further?
Steven
·
·
Can you write the prompt I need?

Clay Support

APP

Here's a Claygent prompt for extracting renewal dates from conversational data: [1]

Prompt:

Extract contract renewal information from this conversation transcript or earnings call.

OUTPUT SCHEMA:
{
  "contract_end_date": "string or null (format: 'YYYY-MM-DD' or 'Q1-Q4 YYYY')",
  "renewal_timeline": "string or null (options: 'imminent', 'within_3_months', 'within_6_months', 'beyond_6_months', 'unknown')",
  "current_spend": "string or null (format: '$X annually' or '$X/month')",
  "satisfaction_level": "string (options: 'satisfied', 'neutral', 'frustrated', 'actively_looking_to_switch')"
}

INSTRUCTIONS:
- If renewal timeline is vague ("sometime next year"), extract as full year range "Q1-Q4 2024"
- If no budget mentioned, set current_spend to null—don't estimate
- For phrases like "soon" or "coming up" without specifics, use "within_3_months"
- Only mark as "actively_looking_to_switch" if explicitly evaluating alternatives

TRANSCRIPT: [Insert your transcript data here]

Set up column outputs for each field in the schema. [2] Use the 2-credit Claygent model for this complexity level. [3]

Clay Support
APP
·
·
Is that what you were looking for?
Steven
·
·
Will Claygents access enrichments like HG insights?
Clay Support
APP
·
·
No, Claygent can't directly access HG Insights or other enrichment data within Clay. [1]
Claygent works by scraping and analyzing external web content, PDFs, and documents you provide—not internal Clay enrichment data.
For renewal date extraction, you'd need to provide Claygent with external sources like earnings call transcripts, company websites, or documents that contain contract information.
Clay Support
APP
·
·
Was that helpful?
Steven
·
·
So is there no enrichment data that looks at renewal dates?
Clay Support
APP
·
·
No direct enrichment for renewal dates exists in our marketplace. [1]
However, you can connect to contract management tools like Ironclad via HTTP API to pull renewal details from your existing systems. [2]
Most customers import renewal dates from their CRM, billing tools, or data warehouse as part of account review workflows. [3]
Clay Support
APP
·
·
Did that answer your question?

Clay Support
APP
·
·
HG Insights doesn't provide renewal dates—only when products were first verified. [1] The "Product First Verified" field shows when Clay first detected the technology, not contract renewal dates. [2]
For multiple products: increase the Max products setting in your enrichment configuration. By default, Clay shows maximum 3 products per company. Set this higher to capture more technologies per company.
The "Row" issue happens when transferring complex data between tables—the array structure doesn't expand automatically.
Clay Support
APP
·
·
Was that helpful?
Steven
·
·
What enrichment can I use to find renewal dates?
Clay Support
APP
·
·
Clay doesn't have a specific enrichment for contract renewal dates. However, you can use Claygent with conversational data to extract renewal information from sources like earnings calls, interviews, or public statements. [1]
Set up Claygent with a JSON schema to capture:
contract_end_date
renewal_timeline (imminent, within 3 months, etc.)
Current spend and satisfaction levels
For existing customers, you can import renewal dates directly from your CRM, billing tools, or data warehouse as part of your account review process. [2]
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you need any more help with finding renewal dates or managing your tables, please let me know. Would you like to provide more details about what you're trying to achieve so I can assist further?
Steven
·
·
Can you write the prompt I need?

Clay Support

APP

Here's a Claygent prompt for extracting renewal dates from conversational data: [1]

Prompt:

Extract contract renewal information from this conversation transcript or earnings call.

OUTPUT SCHEMA:
{
  "contract_end_date": "string or null (format: 'YYYY-MM-DD' or 'Q1-Q4 YYYY')",
  "renewal_timeline": "string or null (options: 'imminent', 'within_3_months', 'within_6_months', 'beyond_6_months', 'unknown')",
  "current_spend": "string or null (format: '$X annually' or '$X/month')",
  "satisfaction_level": "string (options: 'satisfied', 'neutral', 'frustrated', 'actively_looking_to_switch')"
}

INSTRUCTIONS:
- If renewal timeline is vague ("sometime next year"), extract as full year range "Q1-Q4 2024"
- If no budget mentioned, set current_spend to null—don't estimate
- For phrases like "soon" or "coming up" without specifics, use "within_3_months"
- Only mark as "actively_looking_to_switch" if explicitly evaluating alternatives

TRANSCRIPT: [Insert your transcript data here]

Set up column outputs for each field in the schema. [2] Use the 2-credit Claygent model for this complexity level. [3]

Clay Support
APP
·
·
Is that what you were looking for?
Steven
·
·
Will Claygents access enrichments like HG insights?
Clay Support
APP
·
·
No, Claygent can't directly access HG Insights or other enrichment data within Clay. [1]
Claygent works by scraping and analyzing external web content, PDFs, and documents you provide—not internal Clay enrichment data.
For renewal date extraction, you'd need to provide Claygent with external sources like earnings call transcripts, company websites, or documents that contain contract information.
Clay Support
APP
·
·
Was that helpful?
Steven
·
·
So is there no enrichment data that looks at renewal dates?
Clay Support
APP
·
·
No direct enrichment for renewal dates exists in our marketplace. [1]
However, you can connect to contract management tools like Ironclad via HTTP API to pull renewal details from your existing systems. [2]
Most customers import renewal dates from their CRM, billing tools, or data warehouse as part of account review workflows. [3]
Clay Support
APP
·
·
Did that answer your question?