Adding Competitors as New Rows in Company Records

Matïss R. · 2025-03-17T15:03:50.861397+00:00

I've identified competitors with the company competitor enrichment. Can I add identified competitors of a company as a new row, instead of a value in a new column without doing it manually?

Yes, you can add identified competitors as new rows instead of values in a new column. Our "write to table" feature allows you to create a new table with competitor data. Here's a brief overview: 1. Use the competitor enrichment to get the data. 2. Create a new table for competitors. 3. Use "write to table" to add each competitor as a new row in this table. 4. Include relevant fields like company name, domain, and similarity score. 5. Consider adding a lookup to link competitors to the original companies. This approach organizes your competitor data more efficiently, allowing for easier analysis and comparison.

Sources: Find Company Lookalikes [Clay 101] - Clay University Get Competitors in Paid Search with Semrush

2 comments