Aaron J.

Jad A. it might take a bit of testing, but Hubspot usually tracks datestamps specific to the stages in your pipeline; you could cohort by created date or last mql and then count where 'date marked SQL' is not blank. Alternatively use formula fields to create the 0/1 boolean for each stage, and use a workflow to stamp those fields (including prior stages in cases of skips)

Muqsit N. I would propose that this is an order of operations issue. You should start with a full data pull from your directory website, then feed that full context into Clay. If you want to follow up via DM I can give you some tips and tools.

I would go with ZoomInfo between the two choices. Zoominfo has been around longer, and has a lot of data gathered via their integration for direct contact info - they also focus 100% on their data. Apollo is an all-in-one prospecting and database app, but they largely use linkedin data and 2nd/3rd party sources, so their direct contact details are probably worse. Its been a while since I used either, but I would suggest creating a test list of known good accounts and having both vendors 'enrich' it with the details you already know. That way to you can see which vendor is a better fit for your data set and market.

Atishay you can push and pull data as needed from Hubspot, including looking up related records.

Luke A. their database is pretty solid as long as the company has a presence on linkedin. I find that it can be very helpful though to think through where your ICP would first appear online and attempt to create additional pipelines of data over time that flow into and through Clay.