Determining Primary Company Records Using Clay
Hi, I'm trying to determine a primary company record in a company list. For example, we may have:
Acme Inc. | acme.com | Create date: 12/01/2015 | Associated Deals: 5
Acme - North America | acme.com | Create date: 08/05/2018 | Associated Deals: 1
Acme - UK | acme.co.uk | Create date: 09/20/2020 | Associated Deals: 2
Acme | acme.com | Create date: 07/08/2022 | Associated Deals: 0
Right now, I'm just trying to set the earliest created company with the most Deals as the primary company. Note that the list of companies will include many, many other companies where the same thing needs to be determined. I've tried various enrichments, including AI with no luck. How can Clay be used to determine a primary company record?