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!