Join the Community

01 Community General

01 Community General

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

Jacob T.
·
·
Josephine V. Hey! I help folks with things like this, so hopefully I can help out here.
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)
I'm not sure what you mean by this... could you clarify or rephrase the question? Perhaps with a screenshot or a loom for more context? I think once I understand I'll be able to answer your question.
1.
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?
Unfortunately I don't think you can prevent this during the contact search, but since you have location as part of the free data added in the contact table, you can use a super cheap 4o mini GPT prompt to exclude based on location or specific company for next to no $. Should do the trick for now.