Creating a Master Company Sheet for Efficient Data Management

Hey has anyone created a master company sheet that they reference to make sure that they don't enrich data on companies that they have already contacted? I am working with a client and we are reaching out to Shopify stores based on what they sell. The thing is we don't reach out to the stores again if they sell multiple things that we are looking for. I would like to filter out all the past searches with a master table. Any advice would be great.

4 comments

Nnabuike O.
·
·
or, you can set an auto-dedupe on the domain cell or the email cell. if the domain, make sure it's the normalized domain
Nathaniel T.
·
·
This would work great if they were all in the same table. I have them separated by what they sell. Example BBQs in one table and saunas in another. I don't want to enrich. The saunas data if it was already enriched and sent in BBQs
Nnabuike O.
·
·
How far have you gone? have you done many tables already? you can set one master table for already-enriched leads. This way, all your new tables start with a "lookup single/multiple row in another table" to see if this new enrichment is already in the backlog table. then conditionally proceed if it isn't and your rows can end with a "Write to other table" where you write the successful new row into the backlog. Just thought this up. Dunno how feasible it might be.
Nathaniel T.
·
·
This sounds amazing. What would be the best way to go about this?