Linking Company and Contact Tables for Data Matching in Clay
I’m working on a data-matching issue in Clay and could use some help. I have two separate tables: 1. Company Table → Contains a list of companies and their total ad count (pulled from the Facebook Ads Library). 2. Contact Table → Contains multiple contacts per company, but currently lacks the ad count data. I need to pull the ad count from the Company Table into the Contact Table, ensuring that each contact associated with a company gets the correct ad count value. What’s the best way to link these tables in Clay? Should I use a lookup function, automation, or something else? Would really appreciate any insights!