Hey team I have a big product catalog CSV file with product records, what’s the best way to cross reference a list of companies against my file and output competing products?
Import your product catalog CSV into Clay first. [1] Then create a companies table and use Lookup Rows to cross-reference companies against your product data by matching fields like company name or domain. [2]
For competing products output, use write to table to map matching results to a new table where each row shows company-product relationships. [3]
The workflow: CSV import → company lookup → write to table for organized output.
If you need any more help with cross-referencing your product catalog or setting up the output, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?
No. Won’t be able to do name look up. It has to be AI based matching.
When given a list of companies, I want Claygent or somehow analyze the company and cross reference the catalog and find the top competing products
I understand this is important to you, so I’m routing you to one of our human agents who can assist with AI-based matching and competing product analysis.
Hey Andi, in this case what I recommend is creating a claygent column that searches the web for similar/competing products and returns them to your table. This is really what Claygent is for, let me know if you have any specific questions.