Importing Apollo Companies List into Clay and Filtering Results

Hi! I have an ICP Companies list in Apollo (exported to CSV) I am hoping there as a way I can import this into clay, then supplement it with any additional companies clay may find: I've currently imported the apollo CSV into a clay table and have our ICP criteria applied to each. How do I:

1.
Have the apollo imported data be in the same format with the same detail level as the clay table? (this is prior to enrichment btw, just purely hoping Clay can fill in some gaps)
2.
Clay has found about 3x the amount Apollo did within our ICP but I can see that it has pulled EVERY branch of each brand for example rather than just pulling 'Abercrombie & Kent' it has pulled 4 variations UK, USA, Destination etc etc

a.
Is there a way to remove the additional branches and just keep the main entity?

1 comment